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.