How to get no. of commits/rollbacks by application on the database?

Поиск
Список
Период
Сортировка
От Raghavendra
Тема How to get no. of commits/rollbacks by application on the database?
Дата
Msg-id CA+h6AhjaGp+4PwRF9yO7L5Q1KijUjSYjRMuSUzK+FMqN-wfNoA@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to get no. of commits/rollbacks by application on the database?  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: aasat
Дата:
Сообщение: SELECT INTO create new table, how to turn off this feature?
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: SELECT INTO create new table, how to turn off this feature?