vvitad

Delete PostgreSQL 12, 13

dpkg -l | grep postgres

sudo apt-get --purge remove pgdg-keyring postgresql-12 postgresql-client-12 postgresql-client-common postgresql-common sudo apt-get --purge remove pgdg-keyring postgresql-13 postgresql-client-13 postgresql-client-common postgresql-common

vvitad

Useful PostgreSQL Queries & Commands

All sizes in MB.

Running queries

SELECT pid, age(clock_timestamp(), query_start), datname, usename, query, state
FROM pg_stat_activity
WHERE state NOT LIKE 'idle%' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;