On Fri, Feb 7, 2014 at 10:08 AM, Shaun Thomas <sthomas(at)optionshouse(dot)com>wrote:
>
> > 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>