| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'Pascal Laporte (plaporte) *EXTERN*'" <plaporte(at)cisco(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: monitoring TPS and IOPS |
| Date: | 2015-05-27 08:43:51 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B36616933@ntex2010i.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pascal Laporte (plaporte) | 2015-05-27 09:01:33 | Re: monitoring TPS and IOPS |
| Previous Message | Pascal Laporte (plaporte) | 2015-05-27 08:30:57 | monitoring TPS and IOPS |