Re: monitoring TPS and IOPS - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: monitoring TPS and IOPS
Date
Msg-id A737B7A37273E048B164557ADEF4A58B36616933@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to monitoring TPS and IOPS  ("Pascal Laporte (plaporte)" <plaporte@cisco.com>)
Responses Re: monitoring TPS and IOPS
List 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 by date:

Previous
From: "Pascal Laporte (plaporte)"
Date:
Subject: monitoring TPS and IOPS
Next
From: "Pascal Laporte (plaporte)"
Date:
Subject: Re: monitoring TPS and IOPS