Postgres Pro
Downloads
Home   >   mailing lists

How to get no. of commits/rollbacks by application on the database? - Mailing list pgsql-general

From Raghavendra
Subject How to get no. of commits/rollbacks by application on the database?
Date
Msg-id CA+h6AhjaGp+4PwRF9yO7L5Q1KijUjSYjRMuSUzK+FMqN-wfNoA@mail.gmail.com
Whole thread Raw
Responses Re: How to get no. of commits/rollbacks by application on the database?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
Tree view
Hi All,

How can we figure out no. of commit/rollback happend on the database by application ?

As per my testing what I observed, even if your database is idle than in pg_stat_database (xact_commit/xact_rollback) columns keep increasing. This means autovacuum/autoanalyze count also included in these column. 

If am a DBA, how to know exact application or user commits/rollbacks happened on the database without enabling logs.

Please advice.

---
Regards,
Raghavendra
EnterpriseDB Corporation

pgsql-general by date:

Previous
From: aasat
Date:
Subject: SELECT INTO create new table, how to turn off this feature?
Next
From: Raymond O'Donnell
Date:
Subject: Re: SELECT INTO create new table, how to turn off this feature?