PostgreSQL - check current DB operations Piotr Synowiec ~1 min read February 2, 2022 Categories DEV Tags postgresql How to check current DB operations SELECT pid, age(clock_timestamp(), query_start), usename, query FROM pg_stat_activity WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' ORDER BY query_start desc; Share Tweet LinkedIn Reddit Previous PostgreSQL Doctrine type for serialized compressed object Next PostgreSQL - kill all processes except my own connection