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.
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
