Download Browse

pg_proctab

This Release
pg_proctab 0.0.1
Date
Status
Testing
Latest Testing
pg_proctab 0.0.13 —
Other Releases
Abstract
Access operating system process table
Released By
markwkm
License
BSD
Resources
Special Files

Extensions

pg_cputime 0.0.1
Processor statitics
pg_loadavg 0.0.1
System load averages
pg_memusage 0.0.1
Memory usage
pg_proctab 0.0.1
Operating system process table

README

Contents

Currently only testing Linux, but support for other platforms will be added.

Install
-------
make
make install
psql -f pg_proctab.sql
psql -f pg_loadavg.sql
psql -f pg_cputime.sql
psql -f pg_memusage.sql

Examples
--------
SELECT procpid
FROM pg_stat_activity;

SELECT *
FROM pg_proctab();

SELECT *
FROM pg_stat_activity, pg_proctab()
WHERE procpid = pid;