Re: Requests per second ?

Поиск
Список
Период
Сортировка
От Robert Treat
Тема Re: Requests per second ?
Дата
Msg-id 1049117916.13799.1707.camel@camel
обсуждение исходный текст
Ответ на Requests per second ?  (jeanarthur@eurovox.fr)
Список pgsql-admin
Don't remember what I wrote this for, but IIRC it outputs the current
transaction counter every 1 sec, which you can then use to determine the
number of transactions per second.

#!/bin/bash

while true
do sleep 1; psql -U postgres mydb -c "SELECT age(datfrozenxid) FROM
pg_database where datname='mydb'";
done;

I'm sure you can use this to come up with something more robust.

Robert Treat


On Fri, 2003-03-28 at 05:39, jeanarthur@eurovox.fr wrote:
> H,
>
> Is there a simple way to know how many request per second
> (average) my PG database is currently handling ??
>
> thank you !
>
> jean-arthur silve


В списке pgsql-admin по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Realistic upper bounds on table size
Следующее
От: Robert Treat
Дата:
Сообщение: Re: pg_restore problem