Re: Better Connection Statistics - Mailing list pgsql-general

From bricklen
Subject Re: Better Connection Statistics
Date
Msg-id CAGrpgQ8V5e-OvMVpC9swv3RTKojSNQz8MK55uBoytObaSPHn8w@mail.gmail.com
Whole thread Raw
In response to Re: Better Connection Statistics  (Shaun Thomas <sthomas@optionshouse.com>)
Responses Re: Better Connection Statistics  (bricklen <bricklen@gmail.com>)
List pgsql-general



On Fri, Feb 7, 2014 at 10:08 AM, Shaun Thomas <sthomas@optionshouse.com> wrote:
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: roles inheriting configuration values
Next
From: bricklen
Date:
Subject: Re: Better Connection Statistics