You can find out exactly what you're waiting for by correlating this to the pg_locks table. Grab the 'procpid' of your waiting query and run: select * from pg_locks where pid=<thepid> and granted='f'; Notice, in the pg_locks table, the logic works slightly different... if you're 'waiting' (pg_stat_activity), then you haven't been 'granted' (pg_locks).
I do think that we need per-column documentation of the Standard Statistics Views. Would it be considered for the documentation if i give describing them a try? If so, where do i send it ?
Cheers,
WBL
-- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw
