PgHero

Space

Database Size: 1.73 GB

22 unused indices. Remove them for faster writes. 

rails generate migration remove_unused_indexes

And paste

remove_index :business_reconciliation, name: "business_id_idx"
remove_index :business_reconciliation, name: "idx_business_recon_audit_has_changes"
remove_index :business_reconciliation, name: "idx_business_recon_mailable"
remove_index :business_reconciliation, name: "idx_business_recon_mailable_reason"
remove_index :business_campaign_touch_events, name: "bcte_business_occurred_idx"
remove_index :business_campaign_touches, name: "bct_business_id_text_idx"
remove_index :business_campaign_touches, name: "bct_campaign_lasttouch_idx"
remove_index :business_campaign_touch_events, name: "bcte_campaign_occurred_idx"
remove_index :payment, name: "payment_business_fk_paidat_idx"
remove_index :payment, name: "payment_brand_id_paidat_idx"
remove_index :payment, name: "payment_campaign_code_paidat_idx"
remove_index :campaign_metrics_daily, name: "cmd_campaign_day_idx"
remove_index :campaign_metrics_daily, name: "cmd_brand_day_idx"
remove_index :business_campaign_payment_rollup, name: "bcpr_campaign_lastpay_idx"
remove_index :business_payment_rollup, name: "bpr_last_payment_idx"
remove_index :brand_pattern, name: "brand_pattern_priority_idx"
remove_index :business_audit_log, name: "idx_business_audit_log_applied_at"
remove_index :business_audit_log, name: "idx_business_audit_log_business_id"
remove_index :business_audit_log, name: "idx_business_audit_log_field_name"
remove_index :staging_business, name: "staging_business_address_city_address_state_address_zip_idx"
remove_index :staging_business, name: "staging_business_src_agb_id_idx"
remove_index :staging_business, name: "staging_business_website_normalized_idx"
Relation Size
id_lookup 810 MB
id_lookup_pkey 528 MB
business_reconciliation 235 MB
business_reconciliation_agb_doc_id_key 41.5 MB
business_id_idx UNUSED 40.1 MB
business_reconciliation_pkey 19.7 MB
unmatched_payment 9.95 MB
business_campaign_touch_events 9.38 MB
business 8.44 MB
idx_business_recon_audit_has_changes UNUSED 8.42 MB
idx_business_recon_mailable UNUSED 8.08 MB
idx_business_recon_validation_state 6.8 MB
business_campaign_touches 6.75 MB
idx_business_recon_mailable_reason UNUSED 5.7 MB
payment 5.66 MB
bcte_dedupe_uniq 2.63 MB
business_business_id_key 2.29 MB
business_business_sequence_key 2.29 MB
business_campaign_touches_uniq 1.73 MB
bct_business_lasttouch_idx 1.45 MB
business_pkey 1.31 MB
bcte_business_occurred_idx UNUSED 1.23 MB
business_campaign_touches_pkey 992 KB
business_campaign_touch_events_pkey 904 KB
bct_business_id_text_idx UNUSED 848 KB
unmatched_payment_source_bubble_uniq 504 KB
bct_brand_campaign_lasttouch_idx 480 KB
bct_campaign_lasttouch_idx UNUSED 472 KB
bcte_campaign_occurred_idx UNUSED 472 KB
brand 472 KB
payment_source_bubble_idx 456 KB
payment_source_bubble_uniq 456 KB
unmatched_payment_source_bubble_full_uniq 432 KB
business_agb_primary_id_key 400 KB
campaign_metrics_daily 296 KB
brand_key_key 248 KB
payment_business_fk_paidat_idx UNUSED 240 KB
payment_brand_id_paidat_idx UNUSED 232 KB
payment_campaign_code_paidat_idx UNUSED 232 KB
unmatched_payment_pkey 208 KB
business_campaign_payment_rollup 184 KB
payment_pkey 184 KB
campaign_metrics_daily_pkey 176 KB
brand_pkey 168 KB
campaign 168 KB
business_payment_rollup 160 KB
cmd_campaign_day_idx UNUSED 128 KB
cmd_brand_day_idx UNUSED 120 KB
bcpr_campaign_lastpay_idx UNUSED 96 KB
business_campaign_payment_rollup_pkey 88 KB
business_payment_rollup_pkey 80 KB
bpr_last_payment_idx UNUSED 72 KB
campaign_code_key 64 KB
campaign_pkey 56 KB
brand_group 16 KB
brand_group_key_key 16 KB
brand_group_pkey 16 KB
brand_override 16 KB
brand_override_domain_key 16 KB
brand_override_pkey 16 KB
brand_pattern 16 KB
brand_pattern_pkey 16 KB
brand_pattern_priority_idx UNUSED 16 KB
business_audit_log 8 KB
business_audit_log_pkey 8 KB
idx_business_audit_log_applied_at UNUSED 8 KB
idx_business_audit_log_business_id UNUSED 8 KB
idx_business_audit_log_field_name UNUSED 8 KB
staging_business 8 KB
staging_business_address_city_address_state_address_zip_idx UNUSED 8 KB
staging_business_pkey 8 KB
staging_business_src_agb_id_idx UNUSED 8 KB
staging_business_website_normalized_idx UNUSED 8 KB
validator_log 8 KB
validator_log_pkey 8 KB