From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
---|---|
To: | 'rob stone' <floriparob(at)gmail(dot)com> |
Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Better Connection Statistics |
Date: | 2014-02-07 18:08:51 |
Message-ID: | 0683F5F5A5C7FE419A752A034B4A0B97976F94BA@sswchi5pmbx2.peak6.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice |
> Perhaps this might be of use.
>
> http://www.postgresql.org/docs/current/static/pgstatstatements.html
Nope. As 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.
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Van Dyk | 2014-02-07 19:08:02 | roles inheriting configuration values |
Previous Message | rob stone | 2014-02-07 18:02:27 | Re: Better Connection Statistics |
From | Date | Subject | |
---|---|---|---|
Next Message | bricklen | 2014-02-07 22:24:58 | Re: Better Connection Statistics |
Previous Message | rob stone | 2014-02-07 18:02:27 | Re: Better Connection Statistics |