de=# SELECT * FROM pg_stat_activity;
 datid | datname  | procpid | usesysid | usename  |      application_name       | client_addr | client_port |       backend_start        |         xact_start         |        query_start         | waiting |              current_query
-------+----------+---------+----------+----------+-----------------------------+-------------+-------------+----------------------------+----------------------------+----------------------------+---------+----------------------------------------
 11874 | postgres |    1968 |       10 | postgres | pgAdmin III - Server Status | ::1         |       49617 | 2011-05-09 20:54:35.377-05 |                            | 2011-05-09 20:58:54.073-05 | f       | <IDLE>
 11874 | postgres |    3904 |       10 | postgres | pgAdmin III - Browser       | ::1         |       49585 | 2011-05-09 20:53:39.473-05 |                            | 2011-05-09 20:53:39.945-05 | f       | <IDLE>
 18801 | de       |    6492 |       10 | postgres | psql                        | ::1         |       49653 | 2011-05-09 20:56:57.678-05 | 2011-05-09 20:58:54.509-05 | 2011-05-09 20:58:54.509-05 | f       | SELECT * FROM pg_stat_activity;
 18801 | de       |    6272 |       10 | postgres |                             | 127.0.0.1   |       49622 | 2011-05-09 20:54:54.97-05  |                            | 2011-05-09 20:58:54.509-05 | f       | <IDLE>
 18801 | de       |    3728 |       10 | postgres |                             | 127.0.0.1   |       49621 | 2011-05-09 20:54:53.459-05 | 2011-05-09 20:54:53.716-05 | 2011-05-09 20:54:53.716-05 | f       | SELECT * FROM "raw"."TxDPS all arrests"
 18801 | de       |    6748 |       10 | postgres | pgAdmin III - Browser       | ::1         |       49588 | 2011-05-09 20:53:51.838-05 |                            | 2011-05-09 20:54:31.131-05 | f       | <IDLE>
(6 rows)