[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [HACKERS] use of pg_stat_database
From: Merlin Moncure <mmoncure () gmail ! com>
Date: 2009-06-30 13:26:23
Message-ID: b42b73150906300626w3c6355b9pef9a046e2e0354c9 () mail ! gmail ! com
[Download RAW message or body]
On Tue, Jun 30, 2009 at 7:13 AM, abdelhak
benmohamed<abdelhak.benmohamed@yahoo.fr> wrote:
> 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?
try turning on statement logging (log_statement='all'). please post
q&a time questions to -general.
merlin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic