Re: [HACKERS] use of pg_stat_database

2009-06-30 Thread Merlin Moncure
On Tue, Jun 30, 2009 at 7:13 AM, abdelhak benmohamed 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 > > >

Re: [HACKERS] use of pg_stat_database

2009-06-30 Thread A. Kretschmer
In response to abdelhak benmohamed : > 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

[HACKERS] use of pg_stat_database

2009-06-30 Thread abdelhak benmohamed
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 o