use of pg_stat_database

From: abdelhak benmohamed <abdelhak(dot)benmohamed(at)yahoo(dot)fr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: use of pg_stat_database
Date: 2009-06-30 11:13:47
Message-ID: 633560.69013.qm@web24206.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hellow,
 
I like to track the number of committed transaction for my database
So I use the following command
Select * from pg_stat_database;
 
The column xact_commit gives me the number of transaction committed
 
But if I execute the same command another time, the column xact_commit gives me an other number.
 
Between the first select and the second select I don’t execute any transaction on my database
 
Please, can any one help me to understanding the cause of the change?
 
Thanks very much

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-06-30 11:22:14 Re: 8.5 development schedule
Previous Message Lars Kanis 2009-06-30 10:18:42 Re: [PATCH] user mapping extension to pg_ident.conf