Space
Database Size: 197 GB
2 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 :active_storage_attachments, name: "index_active_storage_attachments_on_blob_id"
| Relation | Size |
|---|---|
| upload | 191 GB |
| upload_task_id_idx1 | 978 MB |
| upload_task_id_idx UNUSED | 978 MB |
| files | 768 MB |
| idx_uploads_user_created_at | 701 MB |
| idx_upload_user_created_at | 696 MB |
| files_filename_path_idx | 637 MB |
| upload_pkey | 602 MB |
| files_pkey | 297 MB |
| user | 272 MB |
| user_auth_id_idx | 84.6 MB |
| user_email_idx | 64.5 MB |
| user_pkey | 38.4 MB |
| configuration | 37.6 MB |
| configuration_pkey | 2.59 MB |
| key | 1.16 MB |
| singlepayment | 1.06 MB |
| key_hashed_api_key_unique | 680 KB |
| subscription | 640 KB |
| singlepayment_pkey | 216 KB |
| key_key_id_unique | 152 KB |
| key_pkey | 152 KB |
| subscription_pkey | 96 KB |
| aerich | 32 KB |
| aerich_pkey | 16 KB |
| ar_internal_metadata | 16 KB |
| ar_internal_metadata_pkey | 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 |
| 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 |