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 Blog: http://raghavt.blogspot.com/