Difference between revisions of "Template:Pg stat activity"

From wikieduonline
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;]]
 
  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: