activity
| /dev/dim > news > activity

PostgreSQL activity

The pg_stat_acticity is nice and all, but sometimes I like it when the activity is presented following this view definition:

SELECT extract(epoch FROM (now() - query_start))::numeric(5,2) AS age,
       procpid, usename, client_addr, current_query
  FROM pg_stat_activity
 WHERE pg_stat_activity.current_query <> '<IDLE>'::text
ORDER BY 1;
Return to Top     Page last modified Fri Feb 1 17:14:15 2008.     Created by Dimitri Fontaine with rest2web