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$ (view raw or whole 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?

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-2015 The PostgreSQL Global Development Group