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;
Monday, October 8, 2012
Get current queries executing on PostgreSQL
at 8:11 AM
Labels: DBA Tasks, PostgreSQL, SQL Tips
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment