http://iret-onsoku.blogspot.jp/2011/07/postgreswaiting.html
PostgreSQL: BUG #7511: 9.2: pg_stat_activity.procpid renamed unnecessarily
9.2 で pg_stat_activity.procpid の名前が pid にかわっている。
SELECT * FROM (SELECT pid FROM pg_locks GROUP BY pid) l,pg_stat_activity a
WHERE l.pid=a.pid ORDER BY query_start;
http://iret-onsoku.blogspot.jp/2011/07/postgreswaiting_25.html
Waiting for 9.2 – split of current_query in pg_stat_activity – select * from depesz;
9.2 で pg_stat_activity.current_query は state と query になった。
SELECT pg_terminate_backend(pid) FROM pg_stat_activity
WHERE state = 'idle in transaction';
