Monday, October 8, 2012

Get current queries executing on PostgreSQL

SELECT datname "Database Name"
 , usename "User Name"
 , procpid "Process ID"
 , client_addr "Client IP Address"
 , waiting "Is waiting"
 , query_start "Start Time"
 , current_query "Query Text"
FROM pg_stat_activity;

No comments:

Post a Comment