Difference between revisions of "Template:Pg stat activity"
Jump to navigation
Jump to search
(Created page with " SELECT * FROM pg_stat_activity; SELECT * FROM pg_stat_activity WHERE datname = 'dbname'; SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active';") |
|||
Line 1: | Line 1: | ||
− | + | SELECT * FROM [[pg_stat_activity;]] | |
SELECT * FROM pg_stat_activity WHERE datname = 'dbname'; | SELECT * FROM pg_stat_activity WHERE datname = 'dbname'; | ||
SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active'; | SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active'; |
Revision as of 13:14, 6 February 2023
SELECT * FROM pg_stat_activity; SELECT * FROM pg_stat_activity WHERE datname = 'dbname'; SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active';
Advertising: