PgHero

Space

Database Size: 42.3 MB

Loading...

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

rails generate migration remove_unused_indexes

And paste

remove_index :searchjoy_searches, name: "index_searchjoy_searches_on_user_id"
remove_index :searchjoy_conversions, name: "index_searchjoy_conversions_on_convertable"
remove_index :blazer_checks, name: "index_blazer_checks_on_creator_id"
remove_index :blazer_checks, name: "index_blazer_checks_on_query_id"
remove_index :blazer_dashboard_queries, name: "index_blazer_dashboard_queries_on_dashboard_id"
remove_index :blazer_dashboard_queries, name: "index_blazer_dashboard_queries_on_query_id"
remove_index :blazer_dashboards, name: "index_blazer_dashboards_on_creator_id"
remove_index :blazer_queries, name: "index_blazer_queries_on_creator_id"
remove_index :blazer_uploads, name: "index_blazer_uploads_on_creator_id"
remove_index :genres_movies, name: "genres_movies_movie_id_idx"
remove_index :blazer_audits, name: "index_blazer_audits_on_query_id"
remove_index :blazer_audits, name: "index_blazer_audits_on_user_id"
remove_index :ratings, name: "ratings_movie_id_idx"
remove_index :ratings, name: "ratings_rated_at_idx"
Relation Size 7d Growth
pghero_space_stats 9.23 MB Unknown
searchjoy_searches 7.27 MB Unknown
index_searchjoy_searches_on_search_type_query 4 MB Unknown
index_searchjoy_searches_on_search_type_and_created_at 2.91 MB Unknown
index_searchjoy_searches_on_created_at 2.06 MB Unknown
searchjoy_searches_pkey 2.06 MB Unknown
pghero_space_stats_pkey 2.02 MB Unknown
searchjoy_conversions 1.14 MB Unknown
index_pghero_space_stats_on_database_and_captured_at 680 KB Unknown
index_searchjoy_searches_on_user_id UNUSED 672 KB Unknown
searchjoy_conversions_pkey 496 KB Unknown
index_searchjoy_conversions_on_search_id 464 KB Unknown
pghero_query_stats 320 KB Unknown
users 256 KB Unknown
index_searchjoy_conversions_on_convertable UNUSED 168 KB Unknown
field_test_memberships 112 KB Unknown
users_pkey 112 KB Unknown
index_field_test_memberships_on_participant 72 KB Unknown
index_field_test_memberships_on_experiment_and_created_at 48 KB Unknown
field_test_memberships_pkey 32 KB Unknown
pghero_query_stats_pkey 32 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 16 KB Unknown
blazer_queries_pkey 16 KB Unknown
blazer_uploads 16 KB Unknown
blazer_uploads_pkey 16 KB Unknown
index_blazer_checks_on_creator_id UNUSED 16 KB Unknown
index_blazer_checks_on_query_id UNUSED 16 KB Unknown
index_blazer_dashboard_queries_on_dashboard_id UNUSED 16 KB Unknown
index_blazer_dashboard_queries_on_query_id UNUSED 16 KB Unknown
index_blazer_dashboards_on_creator_id UNUSED 16 KB Unknown
index_blazer_queries_on_creator_id UNUSED 16 KB Unknown
index_blazer_uploads_on_creator_id UNUSED 16 KB Unknown
index_pghero_query_stats_on_database_and_captured_at 16 KB Unknown
schema_migrations 16 KB Unknown
schema_migrations_pkey 16 KB Unknown
blazer_audits 8 KB Unknown
blazer_audits_pkey 8 KB Unknown
blazer_dashboard_queries 8 KB Unknown
genres_movies_movie_id_idx UNUSED 8 KB Unknown
genres_movies_pkey 8 KB Unknown
genres_pkey 8 KB Unknown
index_blazer_audits_on_query_id UNUSED 8 KB Unknown
index_blazer_audits_on_user_id UNUSED 8 KB Unknown
index_mailkick_subscriptions_on_subscriber_and_list 8 KB Unknown
mailkick_subscriptions 8 KB Unknown
mailkick_subscriptions_pkey 8 KB Unknown
movies_pkey 8 KB Unknown
occupations_pkey 8 KB Unknown
ratings_movie_id_idx UNUSED 8 KB Unknown
ratings_pkey 8 KB Unknown
ratings_rated_at_idx UNUSED 8 KB Unknown
genres 0 Bytes Unknown
genres_movies 0 Bytes Unknown
movies 0 Bytes Unknown
occupations 0 Bytes Unknown
ratings 0 Bytes Unknown