Thread: about pg_stat_get_db_xact_commit

about pg_stat_get_db_xact_commit

From
abdelhak benmohamed
Date:

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


Re: about pg_stat_get_db_xact_commit

From
Alvaro Herrera
Date:
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