Space
Database Size: 8.4 MB
13 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :sessions, name: "sessions_last_activity_index" remove_index :sessions, name: "sessions_user_id_index" remove_index :categories, name: "categories_merchant_id_index" remove_index :courses, name: "courses_merchant_id_index" remove_index :customers, name: "customers_merchant_id_index" remove_index :enrolments, name: "enrolments_merchant_id_index" remove_index :jobs, name: "jobs_queue_index" remove_index :lessons, name: "lessons_merchant_id_index" remove_index :personal_access_tokens, name: "personal_access_tokens_tokenable_type_tokenable_id_index" remove_index :product_course_mappings, name: "product_course_mappings_merchant_id_index" remove_index :resource_files, name: "resource_files_lesson_id_index" remove_index :resource_files, name: "resource_files_merchant_id_index" remove_index :sections, name: "sections_merchant_id_index"
| Relation | Size |
|---|---|
| ai_job_results | 16 KB |
| ai_job_results_pkey | 16 KB |
| api_clients | 16 KB |
| api_clients_api_key_unique | 16 KB |
| api_clients_pkey | 16 KB |
| migrations_pkey | 16 KB |
| sessions | 16 KB |
| sessions_last_activity_index UNUSED | 16 KB |
| sessions_pkey | 16 KB |
| sessions_user_id_index UNUSED | 16 KB |
| users | 16 KB |
| users_email_unique | 16 KB |
| users_pkey | 16 KB |
| cache | 8 KB |
| cache_locks | 8 KB |
| cache_locks_pkey | 8 KB |
| cache_pkey | 8 KB |
| categories | 8 KB |
| categories_merchant_id_index UNUSED | 8 KB |
| categories_pkey | 8 KB |
| courses | 8 KB |
| courses_merchant_id_index UNUSED | 8 KB |
| courses_pkey | 8 KB |
| customers | 8 KB |
| customers_merchant_id_index UNUSED | 8 KB |
| customers_pkey | 8 KB |
| customers_shopify_customer_id_unique | 8 KB |
| enrolments_merchant_id_index UNUSED | 8 KB |
| enrolments_pkey | 8 KB |
| failed_jobs | 8 KB |
| failed_jobs_pkey | 8 KB |
| failed_jobs_uuid_unique | 8 KB |
| job_batches | 8 KB |
| job_batches_pkey | 8 KB |
| jobs | 8 KB |
| jobs_pkey | 8 KB |
| jobs_queue_index UNUSED | 8 KB |
| lessons | 8 KB |
| lessons_merchant_id_index UNUSED | 8 KB |
| lessons_pkey | 8 KB |
| merchants | 8 KB |
| merchants_pkey | 8 KB |
| merchants_shopify_domain_unique | 8 KB |
| merchants_shopify_shop_id_unique | 8 KB |
| migrations | 8 KB |
| password_reset_tokens | 8 KB |
| password_reset_tokens_pkey | 8 KB |
| personal_access_tokens | 8 KB |
| personal_access_tokens_pkey | 8 KB |
| personal_access_tokens_token_unique | 8 KB |
| personal_access_tokens_tokenable_type_tokenable_id_index UNUSED | 8 KB |
| product_course_mappings | 8 KB |
| product_course_mappings_merchant_id_index UNUSED | 8 KB |
| product_course_mappings_pkey | 8 KB |
| product_course_unique | 8 KB |
| resource_files | 8 KB |
| resource_files_lesson_id_index UNUSED | 8 KB |
| resource_files_merchant_id_index UNUSED | 8 KB |
| resource_files_pkey | 8 KB |
| sections | 8 KB |
| sections_merchant_id_index UNUSED | 8 KB |
| sections_pkey | 8 KB |
| test_pkey | 8 KB |
| enrolments | 0 Bytes |
| test | 0 Bytes |