CHAT2DB usage experience

1 EXPLAIN SQL

2 OPTIMIZATION SQL

select sum(total),pg_size_pretty(sum(total)) from (SELECT relname,pg_size_pretty(pg_relation_size(relname::text)) as tableSize,pg_size_pretty(pg_total_relation_size(relname::text)) as tableTotalSize,pg_total_relation_size(relname::text) as total, FROM pg_class\nwhere relname like ‘partition_table_name_%’ and reltype>0 order by total desc) t