On Fri, Feb 7, 2014 at 10:08 AM, Shaun Thomas <stho...@optionshouse.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
