Difference between revisions of "Pg stat activity"

From wikieduonline
Jump to navigation Jump to search
Line 13: Line 13:
  
 
== Related terms ==
 
== Related terms ==
 +
  select pg_terminate_backend(procpid) from pg_stat_activity where datname = 'your-db';
 
* <code>[[DataFileRead]]</code>
 
* <code>[[DataFileRead]]</code>
 
* [[PostgreSQL statistics collector]]
 
* [[PostgreSQL statistics collector]]

Revision as of 11:44, 16 December 2022

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 pg_terminate_backend(__pid__) from pg_stat_activity;

Related terms

 select pg_terminate_backend(procpid) from pg_stat_activity where datname = 'your-db';

See also

Advertising: