Re: counting transactions

Great deal Keith

Thanks for the info

Armand

On Sep 8, 2015, at 8:48 PM, Keith <keith(at)keithf4(dot)com> wrote:

>
>
> On Tue, Sep 8, 2015 at 9:28 PM, Armand Pirvu (home) <armand(dot)pirvu(at)gmail(dot)com> 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.
>
> http://dalibo.github.io/pgbadger/
>
> Keith
>
>
>
> On Sep 8, 2015, at 7:56 AM, Kevin Grittner <kgrittn(at)ymail(dot)com> wrote:
>
> > Armand Pirvu (gmail) <armand(dot)pirvu(at)gmail(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin