PostgreSQL pg_proctab: Using SQL to Query System Statistics*
Use SQL to get operating system statistics when using PostgreSQL.
pg_proctab is a collection of PostgreSQL stored functions that allows the use of SQL to access the operating system process table to collect processor and I/O statistics. See examples on how to use these stored functions to measure the system resources used when executing various SQL statements and tranactions.
Mark Wong develops and runs performance tests and tools for database systems. He also helps manage one of the labs of equipment donated to the PostgreSQL community.