Perfect Kevin Many thanks. On the same token anyway I can count the number of connects/disconnects for a specific database ? Thanks Armand 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