Re: queries per second script - Mailing list pgsql-novice

From Jasen Betts
Subject Re: queries per second script
Date
Msg-id h3sl2k$soc$1@reversiblemaps.ath.cx
Whole thread Raw
In response to queries per second script  (MF Hull <penguinfeet77@gmail.com>)
List pgsql-novice
On 2009-07-14, MF Hull <penguinfeet77@gmail.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.


pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Veritas netbackup live backup?
Next
From: Jasen Betts
Date:
Subject: Re: Rate of increase/decrease for a set of values