diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2020-01-15 14:02:35 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2020-01-15 14:02:38 -0800 |
| commit | ec445720e768d3f0cc56c03052833b86d5068547 (patch) | |
| tree | 3c87c248b44f4c77da07374822506d15fe16ff92 /extra/sql_dumps/stats_table_size.sql | |
| parent | 5235b034058f9c0cf8a418a4854ba1491fa347c7 (diff) | |
| download | fatcat-ec445720e768d3f0cc56c03052833b86d5068547.tar.gz fatcat-ec445720e768d3f0cc56c03052833b86d5068547.zip | |
sql table size script: shorter output
This skips postgres-internal tables in size output
Diffstat (limited to 'extra/sql_dumps/stats_table_size.sql')
| -rw-r--r-- | extra/sql_dumps/stats_table_size.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/extra/sql_dumps/stats_table_size.sql b/extra/sql_dumps/stats_table_size.sql index cb8da26d..7b6b7f8d 100644 --- a/extra/sql_dumps/stats_table_size.sql +++ b/extra/sql_dumps/stats_table_size.sql @@ -12,6 +12,7 @@ SELECT FROM ( SELECT ('"' || table_schema || '"."' || table_name || '"') AS table_name FROM information_schema.tables + WHERE table_schema = 'public' ) AS all_tables ORDER BY total_size DESC ) AS pretty_sizes; |