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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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 



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-2017 The PostgreSQL Global Development Group