Postgres数据清理过程
查看数据量大的表 SELECT table_schema || '.' || table_name AS table_full_name, pg_size_pretty(pg_total_relation_size('"' || table_schema || '"."' || table_name || '"')) AS size FROM information_schema.tables ORDER BY pg_total_relation_size('"' || table_schema || '"."' || table_name || '"') DESC limit 100 查看数据量大的字段 select sum(pg_column_size(path_analyze_result)) as path, sum(pg_column_size(object_analyze_result)) as object, sum(pg_column_size(correlation_analyze_result)) as correlation from nap_pol....
