Re: stats for network traffic WIP - Mailing list pgsql-hackers

From Greg Stark
Subject Re: stats for network traffic WIP
Date
Msg-id CAM-w4HNfUckVnOvwK4-hFu1JTOqOSYUTbLk-tQpu4NtE1_SRXg@mail.gmail.com
Whole thread Raw
In response to stats for network traffic WIP  (Nigel Heron <nheron@querymetrics.com>)
Responses Re: stats for network traffic WIP  (Nigel Heron <nheron@querymetrics.com>)
List pgsql-hackers

On Mon, Oct 21, 2013 at 5:14 AM, Nigel Heron <nheron@querymetrics.com> wrote:
- can be used to find misbehaving connections.
- can be used in multi-user/multi-database clusters for resource usage tracking.
- competing databases have such metrics.

The most interesting thing that I could see calculating from these stats would require also knowing how much time was spent waiting on writes and reads on the network. With the cumulative time spent as well as the count of syscalls you can calculate the average latency over any time period between two snapshots. However that would involve adding two gettimeofday calls which would be quite likely to cause a noticeable impact on some architectures. Unless there's already a pair of gettimeofday calls you can piggy back onto?


--
greg

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: regclass error reports improperly downcased
Next
From: Craig Ringer
Date:
Subject: Re: [v9.4] row level security