Re: monitoring TPS and IOPS

2015-05-27 11:01 GMT+02:00 Pascal Laporte (plaporte) <plaporte(at)cisco(dot)com>:

> 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.
>

Make sure the database files are on a specific partition and it will
definitely be possible with tools like iostat or sysstat/sar.

For TPS we will explore pgBadger.
>

You can also take a look at pg_stat_database (xact_commit and xact_rollback
columns). pgCluu might help you there.

> 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
>

--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com