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.

Speaking experience


  • Mark Wong



    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.