How can I find whic开发者_StackOverflowh client process is connected to a server process?
SELECT *
FROM pg_stat_activity
More details in the manual:
http://www.postgresql.org/docs/9.0/static/monitoring-stats.html#MONITORING-STATS-VIEWS
http://www.postgresql.org/docs/9.0/static/monitoring.html
精彩评论