Space
Database Size: 271 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 | 111 GB |
| upload_task_id_idx UNUSED | 1.06 GB |
| upload_task_id_idx1 | 1.06 GB |
| files | 917 MB |
| files_filename_path_idx | 703 MB |
| upload_pkey | 609 MB |
| upload_cleanup_idx | 499 MB |
| idx_upload_user_created_at | 453 MB |
| idx_uploads_user_created_at | 432 MB |
| files_pkey | 323 MB |
| user | 254 MB |
| user_auth_id_idx | 99.5 MB |
| user_email_idx | 69 MB |
| configuration | 42.6 MB |
| user_pkey | 27.1 MB |
| configuration_pkey | 1.88 MB |
| key | 1.24 MB |
| singlepayment | 1.13 MB |
| key_hashed_api_key_unique | 784 KB |
| subscription | 704 KB |
| singlepayment_pkey | 232 KB |
| key_key_id_unique | 184 KB |
| key_pkey | 168 KB |
| subscription_pkey | 104 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 |