Re: Better Connection Statistics - Mailing list pgsql-general

From Michael Paquier
Subject Re: Better Connection Statistics
Date
Msg-id CAB7nPqSVSpX+nCi_DQyzrT9U1TE1xawuCHqGc_qEbGY0NRwphg@mail.gmail.com
Whole thread Raw
In response to Re: Better Connection Statistics  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general
On Sun, Feb 9, 2014 at 4:52 AM, Greg Sabino Mullane <greg@turnstep.com> wrote:
>> For instance, I want the number of transactions a specific connection has submitted.
>> The number of queries. Total amount of CPU time consumed, etc. So far as I know,
>> there is no module, statistic, or view that provides any of this.
>
> For the basic connection information, you could parse the Postgres logs, assuming
> you are being verbose enough to capture everything.
In this case, a log parser like pgbadger would help for sure.
--
Michael


pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: WAL archive on slave
Next
From: "Tsubasa Sakamoto"
Date:
Subject: Re: client encoding that psql command sets