pg stat activity

From wikieduonline
Revision as of 10:22, 5 May 2023 by Welcome (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;
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: