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

Re: queries per second script

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: queries per second script
Date: 2009-07-18 14:09:24
Message-ID: h3sl2k$soc$1@reversiblemaps.ath.cx (view raw or flat)
Thread:
Lists: pgsql-novice
On 2009-07-14, MF Hull <penguinfeet77(at)gmail(dot)com> wrote:
> --000e0cd47d7ea2eb4c046ea09154
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Hi,
>
> I am looking for a why to graph the number of postgres queries per second
> using a script. What is the best way to determine the number of queries per
> second?

[generic]
you could turn on statement logging and trawl the logs.

else you could modify the source to write a single character to
a named pipe for every query and measure characters per second at the 
"read" end of the pipe.


In response to

pgsql-novice by date

Next:From: Jasen BettsDate: 2009-07-18 14:11:31
Subject: Re: Rate of increase/decrease for a set of values
Previous:From: Michael WoodDate: 2009-07-18 07:32:58
Subject: Re: Veritas netbackup live backup?

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