PgHero

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