OpenSource BLOG OpenSource BLOG

SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze FROM pg_stat_user_tables ORDER BY relname;

SELECT i.relname AS indname, i.relowner AS indowner, idx.indrelid::regclass, am.amname AS indam, idx.indkey, ARRAY( SELECT pg_get_indexdef(idx.indexrelid, k + 1, TRUE) FROM generate_subscripts(idx.indkey, 1) AS k ORDER BY k ) AS indkey_names, idx.indexprs IS NOT NULL AS indexprs, idx.indpred IS NOT NULL AS indpredFROM pg_index AS idxJOIN pg_class AS iON i.oid = idx.indexrelidJOIN pg_am AS amON i..

- 테이블 사이즈 확인SELECT relname AS "relation", pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"FROM pg_class CLEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname NOT IN ('pg_catalog', 'information_schema') AND C.relkind 'i'AND nspname !~ '^pg_toast'ORDER BY pg_total_relation_size(C.oid) DESC LIMIT 20;