Re: queries per second script

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: queries per second script
Дата
Msg-id h3sl2k$soc$1@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на queries per second script  (MF Hull <penguinfeet77@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Wood
Дата:
Сообщение: Re: Veritas netbackup live backup?
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Rate of increase/decrease for a set of values