Add session statistics to pg_stat_database

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Add session statistics to pg_stat_database
Дата
Msg-id b07e1f9953701b90c66ed368656f2aef40cac4fb.camel@cybertec.at
обсуждение исходный текст
Ответы Re: Add session statistics to pg_stat_database  (Ahsan Hadi <ahsan.hadi@gmail.com>)
Список pgsql-hackers
Here is a patch that adds the following to pg_stat_database:
- number of connections
- number of sessions that were not disconnected regularly
- total time spent in database sessions
- total time spent executing queries
- total idle in transaction time

This is useful to check if connection pooling is working.
It also helps to estimate the size of the connection pool
required to keep the database busy, which depends on the
percentage of the transaction time that is spent idling.

Yours,
Laurenz Albe

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: Quick doc patch
Следующее
От: Rémi Lapeyre
Дата:
Сообщение: [PATCH v2] Allow COPY "text" to output a header and add header matching mode to COPY FROM