about pg_stat_get_db_xact_commit - Mailing list pgsql-general

From abdelhak benmohamed
Subject about pg_stat_get_db_xact_commit
Date
Msg-id 483228.71600.qm@web24208.mail.ird.yahoo.com
Whole thread Raw
Responses Re: about pg_stat_get_db_xact_commit
List pgsql-general

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


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: REINDEX "is not a btree"
Next
From: Gurjeet Singh
Date:
Subject: Re: Start automatically a function at startup of postgresql server