git.postgresql.org Git - pg_proctab.git/commit

author	Mark Wong <markwkm@gmail.com>
	Wed, 21 May 2008 03:35:24 +0000 (20:35 -0700)
committer	Mark Wong <markwkm@gmail.com>
	Wed, 21 May 2008 03:35:24 +0000 (20:35 -0700)
commit	e3e1e73058e5bf647c692d43b192e6aba96464e1
tree	3b2265ed7574b7bdc25babdb3333f5311d10a851	tree
parent	aa1564b2d14ffcf0995a7883e71ab5c37095a6e0	commit \| diff

Changed the C stored function to return data for all procpid's in the
pg_stat_activity table. Now you can join with other tables. For example:

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

README		diff \| blob \| blame \| history
pg_proctab.c		diff \| blob \| blame \| history
pg_proctab.sql.in		diff \| blob \| blame \| history

pg_proctab

RSS Atom