PgHero

Space

Database Size: 29.9 MB

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

Relation Size 7d Growth
pghero_query_stats 16.9 MB 7.23 MB
index_pghero_query_stats_on_database_and_captured_at 2.33 MB 1.01 MB
pghero_query_stats_pkey 1.66 MB 728 KB
searchjoy_searches 168 KB 0 Bytes
index_searchjoy_searches_on_search_type_and_created_at 88 KB 0 Bytes
index_searchjoy_searches_on_search_type_query 88 KB 0 Bytes
pghero_space_stats 88 KB 32 KB
index_searchjoy_searches_on_convertable UNUSED 64 KB 0 Bytes
index_searchjoy_searches_on_user_id UNUSED 64 KB 0 Bytes
searchjoy_searches_pkey 56 KB 8 KB
index_searchjoy_searches_on_created_at 48 KB 0 Bytes
index_pghero_space_stats_on_database_and_captured_at 32 KB 16 KB
pghero_space_stats_pkey 32 KB 16 KB
ar_internal_metadata 16 KB 0 Bytes
ar_internal_metadata_pkey 16 KB 0 Bytes
blazer_checks 16 KB 0 Bytes
blazer_checks_pkey 16 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 16 KB 0 Bytes
blazer_queries_pkey 16 KB 0 Bytes
field_test_memberships 16 KB 0 Bytes
field_test_memberships_pkey 16 KB 0 Bytes
index_blazer_checks_on_creator_id UNUSED 16 KB 0 Bytes
index_blazer_checks_on_query_id 16 KB 0 Bytes
index_blazer_dashboard_queries_on_dashboard_id 16 KB 0 Bytes
index_blazer_dashboard_queries_on_query_id 16 KB 0 Bytes
index_blazer_dashboards_on_creator_id UNUSED 16 KB 0 Bytes
index_blazer_queries_on_creator_id 16 KB 0 Bytes
index_field_test_memberships_on_experiment_and_created_at 16 KB 0 Bytes
index_field_test_memberships_on_participant 16 KB 0 Bytes
schema_migrations 16 KB 0 Bytes
schema_migrations_pkey 16 KB 0 Bytes
users 16 KB 0 Bytes
users_pkey 16 KB 0 Bytes
blazer_audits 8 KB 0 Bytes
blazer_audits_pkey 8 KB 0 Bytes
blazer_dashboard_queries 8 KB 0 Bytes
index_blazer_audits_on_query_id UNUSED 8 KB 0 Bytes
index_blazer_audits_on_user_id UNUSED 8 KB 0 Bytes