센스쟁이 프로그래머, 비트센스

postgres=# select * from pg_stat_activity;

-------+----------+---------+----------+----------+---------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+-----------------+-------------
datid | datname  | procpid | usesysid | usename  |          current_query          | waiting |          xact_start           |          query_start          |         backend_start         |   client_addr   | client_port
-------+----------+---------+----------+----------+---------------------------------+---------+-------------------------------+-------------------------------+-------------------------------+-----------------+-------------
16386 | shop     |    7933 |    16384 | shopcafe | <IDLE>                          | f       |                               | 2009-01-13 16:58:25.424858+09 | 2009-01-13 16:58:25.354049+09 | 118.219.233.56  |       39856
16386 | shop     |    7811 |    16384 | shopcafe |
    SELECT * from members where id='test'
                                   | f       | 2009-01-13 16:58:25.874498+09 | 2009-01-13 16:58:25.874498+09 | 2009-01-13

select f1, f2, f3, f4, "1" as f5
from table1
where f1='aaa'
UNION
select a as f1, b as f2, c as f3, d as f4, "2" as f5
from table2
where a='bbb'

pgsql> select datname from pg_datebase;