| From: | "Armand Pirvu (home)" <armand(dot)pirvu(at)gmail(dot)com> |
|---|---|
| To: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: counting transactions |
| Date: | 2015-09-09 01:28:23 |
| Message-ID: | DEC8D5BA-399B-411D-BAB6-6687B0C84497@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith | 2015-09-09 01:48:07 | Re: counting transactions |
| Previous Message | Kevin Grittner | 2015-09-08 12:56:05 | Re: counting transactions |