From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | jeanarthur(at)eurovox(dot)fr |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Requests per second ? |
Date: | 2003-03-31 13:38:36 |
Message-ID: | 1049117916.13799.1707.camel@camel |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
#!/bin/bash
while true
do sleep 1; psql -U postgres mydb -c "SELECT age(datfrozenxid) FROM
pg_database where datname='mydb'";
done;
I'm sure you can use this to come up with something more robust.
Robert Treat
On Fri, 2003-03-28 at 05:39, jeanarthur(at)eurovox(dot)fr wrote:
> H,
>
> Is there a simple way to know how many request per second
> (average) my PG database is currently handling ??
>
> thank you !
>
> jean-arthur silve
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Treat | 2003-03-31 13:43:16 | Re: pg_restore problem |
Previous Message | Beatrice Yueksel | 2003-03-31 10:06:26 | question regarding REFERENCES and INHERITS |