3,035
edits
Breakpad/WorkWeek: Difference between revisions
Jump to navigation
Jump to search
→Indexes to Remove
| Line 94: | Line 94: | ||
* reports_########.reports_########_product_version_key | * reports_########.reports_########_product_version_key | ||
* topcrashers.idx_topcrashers_total | * topcrashers.idx_topcrashers_total | ||
* urldims.urldims_pkay | |||
* drop urldims.id altogether | |||
= Notable Queries = | = Notable Queries = | ||
* select * from pg_stat_user_tables where seq_scan > 100; | * select * from pg_stat_user_tables where seq_scan > 100; | ||
* select * from pg_stat_user_tables where seq_scan > 100 and pg_relation_size(relname) > 800000; | * select * from pg_stat_user_tables where seq_scan > 100 and pg_relation_size(relname) > 800000; | ||