Re: monitoring TPS and IOPS

Laurenz. Thank you.
For IOPS when doing load testing we would like to tell if the IO requests made by the DB can be handled by the server.
In oracle this information is stored in tables and so wondering if similar data can be found in PG as well.
I’m not sure how feasible it will be using OS tools.
For TPS we will explore pgBadger.
Regards,
__
Pascal

On 27/05/15 10:43, "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:

>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