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