diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2019-05-21 12:04:07 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2019-05-21 12:04:07 -0700 |
commit | c9c830256315066afdc619eeaba5b234de89468e (patch) | |
tree | 97a41b61aef01b6bb8e99459fba884436a6a52a1 /extra/sql_dumps/stats_row_scan.sql | |
parent | e14e039c4c0ccbc0db3c58cd71c09e8c3146f6fe (diff) | |
download | fatcat-c9c830256315066afdc619eeaba5b234de89468e.tar.gz fatcat-c9c830256315066afdc619eeaba5b234de89468e.zip |
commit SQL table stats scripts
Diffstat (limited to 'extra/sql_dumps/stats_row_scan.sql')
-rw-r--r-- | extra/sql_dumps/stats_row_scan.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/extra/sql_dumps/stats_row_scan.sql b/extra/sql_dumps/stats_row_scan.sql new file mode 100644 index 00000000..c3cfafaa --- /dev/null +++ b/extra/sql_dumps/stats_row_scan.sql @@ -0,0 +1,19 @@ +SELECT + relname, + seq_scan - idx_scan AS too_much_seq, + CASE + WHEN + seq_scan - coalesce(idx_scan, 0) > 0 + THEN + 'Missing Index?' + ELSE + 'OK' + END, + pg_relation_size(relname::regclass) AS rel_size, seq_scan, idx_scan + FROM + pg_stat_all_tables + WHERE + schemaname = 'public' + AND pg_relation_size(relname::regclass) > 80000 + ORDER BY + too_much_seq DESC; |