Re: stats for network traffic WIP

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: stats for network traffic WIP
Дата
Msg-id CAM-w4HNfUckVnOvwK4-hFu1JTOqOSYUTbLk-tQpu4NtE1_SRXg@mail.gmail.com
обсуждение исходный текст
Ответ на stats for network traffic WIP  (Nigel Heron <nheron@querymetrics.com>)
Ответы Re: stats for network traffic WIP  (Nigel Heron <nheron@querymetrics.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: regclass error reports improperly downcased
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [v9.4] row level security