Re: monitoring TPS and IOPS

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2015-05-27 11:01 GMT+02:00 Pascal Laporte (plaporte) <plaporte@xxxxxxxxx>:
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.albe@xxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



--

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux