Space
Database Size: 19.1 MB
8 unused indices. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :audit_records, name: "audit_records_record_id" remove_index :audit_records, name: "audit_records_created_at" remove_index :audit_records, name: "audit_records_table_oid" remove_index :availability, name: "availability_time_range_index" remove_index :request, name: "request_time_range_index" remove_index :match, name: "unique_match_not_invalid" remove_index :offer, name: "unique_offer_not_invalid" remove_index :rating, name: "unique_ratings"
| Relation | Size |
|---|---|
| spatial_ref_sys | 6.77 MB |
| audit_records | 296 KB |
| spatial_ref_sys_pkey | 208 KB |
| contractor | 96 KB |
| account | 72 KB |
| verifier_jobs | 64 KB |
| address | 56 KB |
| contractor_task | 56 KB |
| office | 56 KB |
| session | 56 KB |
| audit_records_created_at UNUSED | 48 KB |
| email_verification | 48 KB |
| license | 48 KB |
| phone_verification | 48 KB |
| account_state | 40 KB |
| audit_records_record_id UNUSED | 40 KB |
| contractor_jobs | 40 KB |
| contractor_task_contractor_id_task_id_key | 40 KB |
| office_jobs | 40 KB |
| audit_records_pkey | 32 KB |
| account_email_key | 16 KB |
| account_licenses | 16 KB |
| account_licenses_name_key | 16 KB |
| account_pkey | 16 KB |
| account_state_pkey | 16 KB |
| address_account_id_type_id_key | 16 KB |
| address_pkey | 16 KB |
| address_types | 16 KB |
| address_types_name_key | 16 KB |
| address_types_pkey | 16 KB |
| audit_records_table_oid UNUSED | 16 KB |
| contractor_jobs_pkey | 16 KB |
| contractor_pkey | 16 KB |
| email_verification_pkey | 16 KB |
| frequency_types | 16 KB |
| frequency_types_name_key | 16 KB |
| frequency_types_pkey | 16 KB |
| license_pkey | 16 KB |
| license_types | 16 KB |
| license_types_name_key | 16 KB |
| license_types_pkey | 16 KB |
| licensed_tasks | 16 KB |
| licensed_tasks_name_key | 16 KB |
| notification_preferences_pkey | 16 KB |
| office_jobs_pkey | 16 KB |
| office_payment_office_id_payment_id_key | 16 KB |
| office_pkey | 16 KB |
| office_software_office_id_software_id_key | 16 KB |
| payment_types | 16 KB |
| payment_types_name_key | 16 KB |
| payment_types_pkey | 16 KB |
| phone_verification_pkey | 16 KB |
| roles | 16 KB |
| roles_name_key | 16 KB |
| roles_pkey | 16 KB |
| session_pkey | 16 KB |
| software_types | 16 KB |
| software_types_name_key | 16 KB |
| software_types_pkey | 16 KB |
| task_types | 16 KB |
| task_types_name_key | 16 KB |
| task_types_pkey | 16 KB |
| verifier_jobs_pkey | 16 KB |
| availability | 8 KB |
| availability_pkey | 8 KB |
| availability_repeat | 8 KB |
| availability_repeat_pkey | 8 KB |
| availability_repeat_series_repeat_id_availability_id_key | 8 KB |
| availability_repeat_task_repeat_id_task_id_key | 8 KB |
| availability_task_availability_id_task_id_key | 8 KB |
| availability_time_range_index UNUSED | 8 KB |
| contractor_location_idx | 8 KB |
| license_photo | 8 KB |
| license_photo_pkey | 8 KB |
| match_contract | 8 KB |
| match_contract_pkey | 8 KB |
| match_pkey | 8 KB |
| message | 8 KB |
| message_pkey | 8 KB |
| no_overlapping_availability | 8 KB |
| no_overlapping_requests | 8 KB |
| notification_preferences | 8 KB |
| notification_records | 8 KB |
| notification_times_pkey | 8 KB |
| offer | 8 KB |
| offer_pkey | 8 KB |
| office_location_idx | 8 KB |
| office_payment | 8 KB |
| office_software | 8 KB |
| password_reset | 8 KB |
| password_reset_pkey | 8 KB |
| profile_photo | 8 KB |
| profile_photo_pkey | 8 KB |
| rating_pkey | 8 KB |
| request | 8 KB |
| request_payment_type_request_id_payment_id_key | 8 KB |
| request_pkey | 8 KB |
| request_repeat | 8 KB |
| request_repeat_payment_type_repeat_id_payment_id_key | 8 KB |
| request_repeat_pkey | 8 KB |
| request_repeat_series_repeat_id_request_id_key | 8 KB |
| request_repeat_task_repeat_id_task_id_key | 8 KB |
| request_task_request_id_task_id_key | 8 KB |
| request_time_range_index UNUSED | 8 KB |
| unique_match_not_invalid UNUSED | 8 KB |
| unique_offer_not_invalid UNUSED | 8 KB |
| unique_ratings UNUSED | 8 KB |
| work_pkey | 8 KB |
| availability_repeat_series | 0 Bytes |
| availability_repeat_task | 0 Bytes |
| availability_task | 0 Bytes |
| match | 0 Bytes |
| notification_times | 0 Bytes |
| rating | 0 Bytes |
| request_payment_type | 0 Bytes |
| request_repeat_payment_type | 0 Bytes |
| request_repeat_series | 0 Bytes |
| request_repeat_task | 0 Bytes |
| request_task | 0 Bytes |
| work | 0 Bytes |