Difference between revisions of "Pg stat activity"

From wikieduonline
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 7: Line 7:
  
 
  {{pg_stat_activity}}
 
  {{pg_stat_activity}}
 
 
 
  
  
Line 15: Line 12:
  
 
== Related terms ==
 
== Related terms ==
  select [[pg_terminate_backend]](procpid) from pg_stat_activity where datname = 'your-db';
+
* <code>select [[pg_terminate_backend]](procpid) from pg_stat_activity where datname = 'your-db';</code>
 
* <code>[[DataFileRead]]</code>
 
* <code>[[DataFileRead]]</code>
 
* [[PostgreSQL statistics collector]]
 
* [[PostgreSQL statistics collector]]

Latest revision as of 10:22, 5 May 2023

select count(*) from pg_stat_activity where query like 'autovacuum:%';
count
-------
     0
(1 row)
 SELECT * FROM pg_stat_activity;
SELECT * FROM pg_stat_activity WHERE datname = 'dbname';
SELECT * FROM pg_stat_activity WHERE datname = 'dbname' and state = 'active';
SELECT usename, application_name, client_addr, client_hostname, state FROM pg_stat_activity;
SELECT pg_terminate_backend(__pid__) from pg_stat_activity;


SELECT pg_terminate_backend(__pid__) from pg_stat_activity;

Related terms[edit]

See also[edit]

Advertising: