On Tue, Sep 8, 2015 at 9:28 PM, Armand Pirvu (home) <armand.pirvu@xxxxxxxxx> wrote:
Perfect Kevin
Many thanks.
On the same token anyway I can count the number of connects/disconnects for a specific database ?
Thanks
Armand
Set connections and disconnections to be logged in postgresql.conf and then use pg_badger on the logs. Nothing in the database itself that I'm aware of.
You may also want to look into the pg_stat_statements extension. Be aware that it does add some overhead to your DB load, but it can provide a wealth of query statistics for you. pgbadger gives you a lot of that same data as well, though, just delayed until log analysis runs and limited to the top 20 or so such statements.
Keith
On Sep 8, 2015, at 7:56 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote:
> Armand Pirvu (gmail) <armand.pirvu@xxxxxxxxx> wrote:
>
>> is there any way to really count the transactions ? In Ingres for
>> example I can look in logdump output or in imadb
>
> If you only care about transactions that modify the database, you
> could look at the output of the pg_controldata utility and pick off
> the NextXID value.
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
