Re: counting transactions - Mailing list pgsql-admin

From Armand Pirvu (home)
Subject Re: counting transactions
Date
Msg-id DEC8D5BA-399B-411D-BAB6-6687B0C84497@gmail.com
Whole thread Raw
In response to Re: counting transactions  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: counting transactions  (Keith <keith@keithf4.com>)
List pgsql-admin
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@ymail.com> wrote:

> Armand Pirvu (gmail) <armand.pirvu@gmail.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



pgsql-admin by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: counting transactions
Next
From: Keith
Date:
Subject: Re: counting transactions