pg stat activity

From wikieduonline
Revision as of 11:39, 16 December 2022 by Ant (talk | contribs)
Jump to navigation Jump to search

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

Related terms

See also

Advertising: