PgHero

Space

Database Size: 891 MB

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

Relation Size 7d Growth
ahoy_events 131 MB 6.48 MB
ahoy_events_pkey 22.7 MB 1.16 MB
ahoy_visits 172 MB 5.2 MB
ahoy_visits_pkey 10.9 MB 312 KB
ar_internal_metadata 16 KB 0 Bytes
ar_internal_metadata_pkey 16 KB 0 Bytes
blazer_audits 4.13 MB 0 Bytes
blazer_audits_pkey 280 KB 0 Bytes
blazer_checks 16 KB 0 Bytes
blazer_checks_pkey 16 KB 0 Bytes
blazer_dashboard_queries 40 KB 0 Bytes
blazer_dashboard_queries_pkey 16 KB 0 Bytes
blazer_dashboards 16 KB 0 Bytes
blazer_dashboards_pkey 16 KB 0 Bytes
blazer_queries 72 KB 0 Bytes
blazer_queries_pkey 16 KB 0 Bytes
csp_reports 5.13 MB 0 Bytes
csp_reports_pkey 384 KB 0 Bytes
hiccups 672 KB 0 Bytes
hiccups_pkey 72 KB 0 Bytes
images 168 KB 0 Bytes
images_pkey 32 KB 0 Bytes
images_revisions 8 KB 0 Bytes
index_ahoy_events_on_name_and_time UNUSED 72.1 MB 3.99 MB
index_ahoy_events_on_properties_jsonb_path_ops UNUSED 13.5 MB 0 Bytes
index_ahoy_events_on_user_id UNUSED 36.7 MB 2.1 MB
index_ahoy_events_on_user_id_and_name UNUSED 50.5 MB 2.84 MB
index_ahoy_events_on_visit_id UNUSED 23 MB 1.17 MB
index_ahoy_events_on_visit_id_and_name UNUSED 32.4 MB 1.66 MB
index_ahoy_visits_on_visit_token 32.2 MB 936 KB
index_hiccups_on_user_id_and_user_type UNUSED 88 KB 0 Bytes
index_items_on_gtin 272 KB 0 Bytes
index_login_activities_on_identity UNUSED 16 KB 0 Bytes
index_login_activities_on_ip UNUSED 16 KB 0 Bytes
index_login_activities_on_user_id UNUSED 16 KB 0 Bytes
index_login_activities_on_user_type_and_user_id UNUSED 16 KB 0 Bytes
index_notable_requests_on_user_id_and_user_type UNUSED 7.19 MB 0 Bytes
index_revisions_on_user_id 272 KB 0 Bytes
index_searchjoy_searches_on_convertable_id_and_convertable_type UNUSED 1.21 MB 8 KB
index_searchjoy_searches_on_created_at UNUSED 1.14 MB 8 KB
index_searchjoy_searches_on_search_type_and_created_at UNUSED 1.65 MB 8 KB
index_searchjoy_searches_on_search_type_and_normalized_query_an UNUSED 2.26 MB 24 KB
index_users_on_authentication_token 5.13 MB 448 KB
index_users_on_encrypted_email_bidx 8.92 MB 864 KB
index_users_on_reset_password_token 2.91 MB 272 KB
index_users_on_username 4.09 MB 488 KB
ip_blocks 0 Bytes 0 Bytes
ip_blocks_pkey 8 KB 0 Bytes
items 824 KB 0 Bytes
items_pkey 216 KB 0 Bytes
login_activities 24 KB 0 Bytes
login_activities_pkey 16 KB 0 Bytes
notable_jobs 8 KB 0 Bytes
notable_jobs_pkey 8 KB 0 Bytes
notable_requests 185 MB 0 Bytes
notable_requests_pkey 8.86 MB 0 Bytes
revisions 2.17 MB 24 KB
revisions_pkey 240 KB 0 Bytes
schema_migrations 8 KB 0 Bytes
searchjoy_searches 3.88 MB 40 KB
searchjoy_searches_pkey 1.14 MB 8 KB
unique_schema_migrations 16 KB 0 Bytes
users 34.6 MB 3.28 MB
users_pkey 2.26 MB 216 KB