SELECT TABLE_NAME,
pg_size_pretty(table_size) AS table_size,
pg_size_pretty(indexes_size) AS indexes_size,
pg_size_pretty(total_size) AS total_size
FROM (
SELECT
TABLE_NAME,
pg_table_size(TABLE_NAME) AS table_size,
pg_indexes_size(TABLE_NAME) AS indexes_size,
pg_total_relation_size(TABLE_NAME) AS total_size
FROM (
SELECT ('"' || table_schema || '"."' || TABLE_NAME || '"') AS TABLE_NAME
FROM information_schema.tables
WHERE table_schema ='edu_power_audit' and TABLE_NAME like '%audit_messages%'
) AS all_tables
ORDER BY TABLE_NAME
) AS pretty_sizes;
под рукой
Автор: talifa, 8 июня, 2023
блокировки кто кого
Автор: talifa, 7 июня, 2023
--------------------- когда нужно снести
select * from pg_stat_activity where datname='......' \gx
select pg_terminate_backend(pid) from pg_stat_activity where datname='.......';
select pid,query from pg_stat_activity where usename='v.koversunov' ;
select pg_terminate_backend(pid) from pg_stat_activity where usename='v.koversunov' ;
pg_cancel_backend(pid): Terminate a query but keep the connection alivepg_terminate_backend(pid): Terminate a query and kill the connection
Автор: talifa, 19 мая, 2023
# Представление активных запросов
SELECT * FROM pg_stat_activity;