PostgreSQL pg_proctab: Using SQL to Query System Statistics

*

Excerpt

Use SQL to get operating system statistics when using PostgreSQL.

Description

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

Speaker

  • Mark Wong

    PostgreSQL

    Biography

    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.