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 I execute the same command another time, the column xact_commit gives > me > an other number.
I can't reproduce that: test=*# Select sum(xact_commit) from pg_stat_database; sum ------- 73470 (1 row) -- 5 minutes later: test=*# Select sum(xact_commit) from pg_stat_database; sum ------- 73470 (1 row) > > > > Between the first select and the second select I don?t execute any transaction > on my database Autovacuum? Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
