Don't remember what I wrote this for, but IIRC it outputs the current
transaction counter every 1 sec, which you can then use to determine the
number of transactions per second.
do sleep 1; psql -U postgres mydb -c "SELECT age(datfrozenxid) FROM
pg_database where datname='mydb'";
I'm sure you can use this to come up with something more robust.
On Fri, 2003-03-28 at 05:39, jeanarthur(at)eurovox(dot)fr wrote:
> Is there a simple way to know how many request per second
> (average) my PG database is currently handling ??
> thank you !
> jean-arthur silve
In response to
pgsql-admin by date
|Next:||From: Robert Treat||Date: 2003-03-31 13:43:16|
|Subject: Re: pg_restore problem|
|Previous:||From: Beatrice Yueksel||Date: 2003-03-31 10:06:26|
|Subject: question regarding REFERENCES and INHERITS|