PgHero

Space

Database Size: 546 MB

13 unused indices. Remove them with a migration for faster writes.

Relation Size 7d Growth
notable_requests 185 MB Unknown
ahoy_visits 111 MB Unknown
ahoy_events 59.5 MB Unknown
index_ahoy_events_on_name_and_time 29.9 MB Unknown
index_ahoy_visits_on_visit_token 20.7 MB Unknown
index_ahoy_events_on_user_id_and_name UNUSED 20.6 MB Unknown
index_ahoy_events_on_user_id UNUSED 14.6 MB Unknown
index_ahoy_events_on_visit_id_and_name 14.4 MB Unknown
index_ahoy_events_on_visit_id UNUSED 10.2 MB Unknown
ahoy_events_pkey 9.95 MB Unknown
notable_requests_pkey 8.86 MB Unknown
ahoy_visits_pkey 7.29 MB Unknown
index_notable_requests_on_user_id_and_user_type UNUSED 7.19 MB Unknown
index_ahoy_events_on_properties_jsonb_path_ops UNUSED 6.27 MB Unknown
csp_reports 5.13 MB Unknown
users 4.98 MB Unknown
searchjoy_searches 3.38 MB Unknown
blazer_audits 3.19 MB Unknown
index_searchjoy_searches_on_search_type_and_normalized_query_an UNUSED 1.97 MB Unknown
revisions 1.85 MB Unknown
index_searchjoy_searches_on_search_type_and_created_at UNUSED 1.52 MB Unknown
index_users_on_encrypted_email_bidx 1.22 MB Unknown
index_searchjoy_searches_on_convertable_id_and_convertable_type UNUSED 1.08 MB Unknown
index_searchjoy_searches_on_created_at 1.05 MB Unknown
searchjoy_searches_pkey 1.05 MB Unknown
items 704 KB Unknown
index_users_on_authentication_token 688 KB Unknown
hiccups 672 KB Unknown
index_users_on_username 560 KB Unknown
index_users_on_reset_password_token 464 KB Unknown
csp_reports_pkey 384 KB Unknown
users_pkey 352 KB Unknown
index_items_on_gtin 264 KB Unknown
index_revisions_on_user_id 240 KB Unknown
revisions_pkey 224 KB Unknown
blazer_audits_pkey 216 KB Unknown
items_pkey 200 KB Unknown
images 168 KB Unknown
index_hiccups_on_user_id_and_user_type UNUSED 88 KB Unknown
hiccups_pkey 72 KB Unknown
blazer_queries 64 KB Unknown
images_pkey 32 KB Unknown
login_activities 24 KB Unknown
ar_internal_metadata 16 KB Unknown
ar_internal_metadata_pkey 16 KB Unknown
blazer_checks 16 KB Unknown
blazer_checks_pkey 16 KB Unknown
blazer_dashboard_queries_pkey 16 KB Unknown
blazer_dashboards 16 KB Unknown
blazer_dashboards_pkey 16 KB Unknown
blazer_queries_pkey 16 KB Unknown
index_login_activities_on_identity UNUSED 16 KB Unknown
index_login_activities_on_ip UNUSED 16 KB Unknown
index_login_activities_on_user_id UNUSED 16 KB Unknown
index_login_activities_on_user_type_and_user_id UNUSED 16 KB Unknown
login_activities_pkey 16 KB Unknown
unique_schema_migrations 16 KB Unknown
blazer_dashboard_queries 8 KB Unknown
images_revisions 8 KB Unknown
ip_blocks_pkey 8 KB Unknown
notable_jobs 8 KB Unknown
notable_jobs_pkey 8 KB Unknown
schema_migrations 8 KB Unknown
ip_blocks 0 Bytes Unknown