Re: monitoring TPS and IOPS

For benchmarking TPS, have a look at pgbench if you haven't already done so.
http://www.postgresql.org/docs/devel/static/pgbench.html
Kieren

> From: plaporte(at)cisco(dot)com
> To: laurenz(dot)albe(at)wien(dot)gv(dot)at;
> Subject: Re: [ADMIN] monitoring TPS and IOPS
> Date: Wed, 27 May 2015 09:01:33 +0000
>
> 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
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin