Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group