pg_proctab: Accessing System Stats in PostgreSQL

Mark Wong & Gabrielle Roth

From PostgreSQL Conference West Speakers

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. These stored functions currently only work on Linux-based systems.

lfnw2009-pg-091018010107-phpapp02.pdf322.58 KB