Skip site navigation (1) Skip section navigation (2)

Re: Requests per second ?

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 (view raw or flat)
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


In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2003-03-31 13:43:16
Subject: Re: pg_restore problem
Previous:From: Beatrice YuekselDate: 2003-03-31 10:06:26
Subject: question regarding REFERENCES and INHERITS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group