pg_proctab: Accessing System Stats in PostgreSQL

Mark Wong

pg_proctab is a collection of PostgreSQL stored functions that provide access to the operating system process table using SQL. We'll show you which functions are available and where they collect the data, and give examples of their use to collect processor and I/O statistics on SQL queries.

pgeast2010-pg_proctab.pdf346.23 KB