# top -c
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
14442 postgres 25 0 47632 46M 44468 R 7.2 1.1 0:03 0 postgres: postgres gudumami 192.168.2.206(45351) SELECT
13834 postgres 16 0 88992 86M 86408 S 1.8 2.1 2:02 0 postgres: postgres gudumami 192.168.2.206(45158) idle
13806 postgres 15 0 88956 86M 86464 S 1.2 2.1 2:58 0 postgres: postgres gudumami 192.168.2.206(45094) idle
25132 postgres 15 0 90656 88M 86972 S 0.4 2.1 1107m 0 postgres: postgres gudumami 192.168.2.206(33654) idle
21720 postgres 15 0 2272 2268 1680 S 0.2 0.0 288:27 1 postgres: stats collector process
21718 postgres 15 0 85660 83M 84944 S 0.1 2.0 363:52 0 postgres: writer process
用explain来看看他的execute plan
gudumami=#explain select * from user_basic where user_id='coffeehan';
ps -ef | grep postgres
SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s;
select * from (SELECT pg_stat_get_backend_pid(s.backendid) AS procpid, pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s) as querystring;
http://www.pgsqldb.org/pgsqldoc-cvs/monitoring-stats.html
http://www.pgsqldb.org/pgsqldoc-cvs/monitoring.html