launchpad_dev=# select  * from pg_stat_activity
;
 datid |         datname          | procpid | usesysid | usename  |                                    current_query                                     | waiting |          query_start          |         backend_start         | client_addr | client_port 
-------+--------------------------+---------+----------+----------+--------------------------------------------------------------------------------------+---------+-------------------------------+-------------------------------+-------------+-------------
 21607 | launchpad_empty          |   22674 |       10 | postgres | VACUUM ANALYZE pg_catalog.pg_shdepend                                                | f       |                               | 2007-03-19 10:11:09.726424+00 |             |            
 16385 | launchpad_ftest_template |   23170 |    16384 | mark     | CREATE DATABASE launchpad_ftest TEMPLATE=launchpad_ftest_template ENCODING='UNICODE' | f       | 2007-03-19 10:19:29.897004+00 | 2007-03-19 10:19:29.89496+00  |             |          -1
 21744 | launchpad_dev            |   23268 |    16384 | mark     | select  * from pg_stat_activity                                                      | f       | 2007-03-19 10:24:05.036089+00 | 2007-03-19 10:21:52.304164+00 |             |          -1
                                                                  : ;                                                                                                                                                                              
(3 rows)