Выборка текущих запросов с фильтрацией по имени базы данных
select * from pg_stat_activity where datname = 'database_name';
select pid as process_id,
usename as username,
datname as database_name,
client_addr as client_address,
application_name,
backend_start,
state,
state_change
from pg_stat_activity;
Поиск таблиц без PK
SELECT table_schema, table_name
FROM information_schema.tables
WHERE table_schema NOT IN ('pg_catalog', 'information_schema')
AND (table_schema, table_name) NOT IN (
SELECT table_schema, table_name
FROM information_schema.table_constraints
WHERE constraint_type = 'PRIMARY KEY'
);
