Thread: about pg_stat_get_db_xact_commit
Hellow I like to track the number of committed transaction for my database So I use the following command Select pg_stat_get_db_xact_commit(16384)
(16384 is the oid of my database)
It gives me 35
But if I execute the same command another time, it gives me more than 35.
Between the first select and the second select I don’t execute transaction on my database
Please, can any one help me to understanding the cause of the change? Thanks very much |
abdelhak benmohamed wrote: > Hellow > I like to track the number of committed transaction for my database > So I use the following command > Select pg_stat_get_db_xact_commit(16384) > > (16384 is the oid of my database) > > It gives me 35 > > But if I execute the same command another time, it gives me more than 35. > > Between the first select and the second select I don’t execute transaction on my database > > Please, can any one help me to understanding the cause of the change? Maybe autovacuum running underneath committed some transactions. (Also, each time you call the function it starts and commit a new transaction). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support