Re: Better Connection Statistics
| От | bricklen |
|---|---|
| Тема | Re: Better Connection Statistics |
| Дата | |
| Msg-id | CAGrpgQ8vSN8PYPPMmMJONkP4FpyDbKob19koqBOgdJSP=tRZ4A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Better Connection Statistics (bricklen <bricklen@gmail.com>) |
| Ответы |
Re: Better Connection Statistics
|
| Список | pgsql-general |
On Fri, Feb 7, 2014 at 2:24 PM, bricklen <bricklen@gmail.com> wrote:
On Fri, Feb 7, 2014 at 10:08 AM, Shaun Thomas <sthomas@optionshouse.com> wrote:s I said in the original message, pg_stat_statements only gives query stats for the whole database. What I want to know, is information about each client. Say there's a specific connection from 192.168.1.20. I want to know:
* How many queries that connection has executed.
* How much CPU time that connection has used since it connected.
* How much data was sent to that connection.
* How much data that connection sent to the database.
And so on. I don't believe that's currently possible. Effectively, it would just be adding a few more columns to pg_stat_activity to track cumulative totals, since it always has the status of all connections.
I don't know any tools off-hand, but you might be able to generate partial statistics from the log files with a descriptive log_line_prefix like "%m [%p] (user=%u) (db=%d) (rhost=%h) [vxid:%v txid:%x] [%i] ". Using the %p and vxi/txid might help to group the queries executed for easier consumption. I don't think that helps much with individual connections though.
В списке pgsql-general по дате отправления: