Space
Database Size: 273 GB
3 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :upload, name: "upload_task_id_idx" remove_index :hdb_cron_event_invocation_logs, name: "hdb_cron_event_invocation_event_id" remove_index :active_storage_attachments, name: "index_active_storage_attachments_on_blob_id"
| Relation | Size |
|---|---|
| upload | 112 GB |
| files | 1.35 GB |
| upload_task_id_idx UNUSED | 1.31 GB |
| upload_task_id_idx1 | 1.31 GB |
| files_filename_path_idx | 770 MB |
| upload_pkey | 716 MB |
| upload_cleanup_idx | 708 MB |
| idx_upload_user_created_at | 563 MB |
| idx_uploads_user_created_at | 524 MB |
| user | 366 MB |
| files_pkey | 359 MB |
| user_auth_id_idx | 111 MB |
| user_email_idx | 97.3 MB |
| configuration | 49.7 MB |
| user_pkey | 29.9 MB |
| configuration_pkey | 2.09 MB |
| key | 1.41 MB |
| singlepayment | 1.21 MB |
| key_hashed_api_key_unique | 920 KB |
| subscription | 768 KB |
| singlepayment_pkey | 248 KB |
| key_key_id_unique | 208 KB |
| key_pkey | 168 KB |
| subscription_pkey | 112 KB |
| aerich | 32 KB |
| aerich_pkey | 16 KB |
| ar_internal_metadata | 16 KB |
| ar_internal_metadata_pkey | 16 KB |
| hdb_metadata hdb_catalog | 16 KB |
| hdb_metadata_pkey hdb_catalog | 16 KB |
| hdb_metadata_resource_version_key hdb_catalog | 16 KB |
| hdb_version hdb_catalog | 16 KB |
| hdb_version_one_row hdb_catalog | 16 KB |
| hdb_version_pkey hdb_catalog | 16 KB |
| schema_migrations | 16 KB |
| schema_migrations_pkey | 16 KB |
| active_storage_attachments | 8 KB |
| active_storage_attachments_pkey | 8 KB |
| active_storage_blobs | 8 KB |
| active_storage_blobs_pkey | 8 KB |
| active_storage_variant_records | 8 KB |
| active_storage_variant_records_pkey | 8 KB |
| hdb_action_log hdb_catalog | 8 KB |
| hdb_action_log_pkey hdb_catalog | 8 KB |
| hdb_cron_event_invocation_event_id hdb_catalog UNUSED | 8 KB |
| hdb_cron_event_invocation_logs hdb_catalog | 8 KB |
| hdb_cron_event_invocation_logs_pkey hdb_catalog | 8 KB |
| hdb_cron_event_status hdb_catalog | 8 KB |
| hdb_cron_events hdb_catalog | 8 KB |
| hdb_cron_events_pkey hdb_catalog | 8 KB |
| hdb_cron_events_unique_scheduled hdb_catalog | 8 KB |
| hdb_scheduled_event_invocation_logs hdb_catalog | 8 KB |
| hdb_scheduled_event_invocation_logs_pkey hdb_catalog | 8 KB |
| hdb_scheduled_event_status hdb_catalog | 8 KB |
| hdb_scheduled_events hdb_catalog | 8 KB |
| hdb_scheduled_events_pkey hdb_catalog | 8 KB |
| hdb_schema_notifications hdb_catalog | 8 KB |
| hdb_schema_notifications_pkey hdb_catalog | 8 KB |
| index_active_storage_attachments_on_blob_id UNUSED | 8 KB |
| index_active_storage_attachments_uniqueness | 8 KB |
| index_active_storage_blobs_on_key | 8 KB |
| index_active_storage_variant_records_uniqueness | 8 KB |