Re: monitoring TPS and IOPS

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: monitoring TPS and IOPS
Дата
Msg-id A737B7A37273E048B164557ADEF4A58B36616933@ntex2010i.host.magwien.gv.at
обсуждение исходный текст
Ответ на monitoring TPS and IOPS  ("Pascal Laporte (plaporte)" <plaporte@cisco.com>)
Ответы Re: monitoring TPS and IOPS  ("Pascal Laporte (plaporte)" <plaporte@cisco.com>)
Список pgsql-admin
Pascal Laporte wrote:
> In what ways are we able to pull information about transactions and I/O per second ?
> For things like load testing we need this type of information.
> In Oracle we retrieve it from the AWR reports.
> Are PG admins also looking at this data, and how is that collected/presented?

For operating system parameters like I/O and CPU load you have to use operating
system tools, like "sar" on UNIX.

For measuring things like TPS during a test run, I'd recommend pgBadger
(http://dalibo.github.io/pgbadger/).

Yours,
Laurenz Albe

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

Предыдущее
От: "Pascal Laporte (plaporte)"
Дата:
Сообщение: monitoring TPS and IOPS
Следующее
От: "Pascal Laporte (plaporte)"
Дата:
Сообщение: Re: monitoring TPS and IOPS