Обсуждение: queries per second script

Поиск
Список
Период
Сортировка

queries per second script

От
MF Hull
Дата:
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?

Thanks!

Re: queries per second script

От
Jasen Betts
Дата:
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.