PgHero
No long running queries
Connections healthy 7
Vacuuming healthy
No columns near integer overflow (43 unreadable sequences)
No invalid indexes or constraints
311 duplicate indexes
No suggested indexes
3 slow queries

Unreadable Sequences

This is likely due to missing privileges. Make sure your user has the SELECT privilege for each sequence.

Column Sequence
impacto_activity_type.id impacto_activity_type_id_seq
impacto_activity_type_of_service.id impacto_activity_type_of_service_id_seq
impacto_activity_type_role.id impacto_activity_type_role_id_seq
impacto_address.id impacto_address_id_seq
impacto_address_owner.id impacto_address_owner_id_seq
impacto_alert_follow_up_action.id impacto_alert_follow_up_action_id_seq
impacto_alert_follow_up.id impacto_alert_follow_up_id_seq
impacto_alert.id impacto_alert_id_seq
impacto_alert_type.id impacto_alert_type_id_seq
impacto_application.id impacto_application_id_seq
impacto_archive_directory.id impacto_archive_directory_id_seq
impacto_archive_file.id impacto_archive_file_id_seq
impacto_archive.id impacto_archive_id_seq
impacto_attendance.id impacto_attendance_id_seq
impacto_attendance_role.id impacto_attendance_role_id_seq
impacto_bond_option.id impacto_bond_option_id_seq
impacto_bond_request.id impacto_bond_request_id_seq
impacto_contact.id impacto_contact_id_seq
impacto_document_draft_access.id impacto_document_draft_access_id_seq
impacto_document_draft.id impacto_document_draft_id_seq
impacto_group.id impacto_group_id_seq
impacto_group_member.id impacto_group_member_id_seq
impacto_organizational_unit.id impacto_organizational_unit_id_seq
impacto_origin_activity.id impacto_origin_activity_id_seq
impacto_origin_person.id impacto_origin_person_id_seq
impacto_person.id impacto_person_id_seq
impacto_person_permission.id impacto_person_permission_id_seq
impacto_person_place.id impacto_person_place_id_seq
impacto_person_role.id impacto_person_role_id_seq
impacto_place.id impacto_place_id_seq
impacto_place_of_service.id impacto_place_of_service_id_seq
impacto_request_log.id impacto_request_log_id_seq
impacto_role.id impacto_role_id_seq
impacto_service.id impacto_service_id_seq
impacto_service_letter.id impacto_service_letter_id_seq
impacto_service_letter_of_service.id impacto_service_letter_of_service_id_seq
impacto_service_subject.id impacto_service_subject_id_seq
impacto_service_target_audience.id impacto_service_target_audience_id_seq
impacto_service_target_audience_of_service.id impacto_service_target_audience_of_service_id_seq
impacto_system.id impacto_system_id_seq
impacto_unified_person.id impacto_unified_person_id_seq
impacto_unified_person_origin_person.id impacto_unified_person_origin_person_id_seq
impacto_visualization.id impacto_visualization_id_seq

Duplicate Indexes

These indexes exist, but aren’t needed. Remove them for faster writes. 

rails generate migration remove_unneeded_indexes

And paste

remove_index :impacto_activity_type, name: "impacto_activity_type_slug_idx", column: :slug
remove_index :impacto_activity_type, name: "impacto_activity_type_slug_idx", column: :slug
remove_index :impacto_activity_type, name: "impacto_activity_type_slug_idx", column: :slug
remove_index :impacto_activity_type, name: "impacto_activity_type_slug_idx", column: :slug
remove_index :impacto_activity_type, name: "impacto_activity_type_slug_idx", column: :slug
remove_index :impacto_activity_type_of_service, name: "impacto_activity_type_of_service_slug_idx", column: :slug
remove_index :impacto_activity_type_of_service, name: "impacto_activity_type_of_service_slug_idx", column: :slug
remove_index :impacto_activity_type_of_service, name: "impacto_activity_type_of_service_slug_idx", column: :slug
remove_index :impacto_activity_type_of_service, name: "impacto_activity_type_of_service_slug_idx", column: :slug
remove_index :impacto_activity_type_of_service, name: "impacto_activity_type_of_service_slug_idx", column: :slug
remove_index :impacto_activity_type_role, name: "impacto_activity_type_role_slug_idx", column: :slug
remove_index :impacto_activity_type_role, name: "impacto_activity_type_role_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address, name: "impacto_address_slug_idx", column: :slug
remove_index :impacto_address_owner, name: "impacto_address_owner_id_idx", column: :id
remove_index :impacto_address_owner, name: "impacto_address_owner_id_idx", column: :id
remove_index :impacto_address_owner, name: "impacto_address_owner_id_idx", column: :id
remove_index :impacto_address_owner, name: "impacto_address_owner_id_idx", column: :id
remove_index :impacto_address_owner, name: "impacto_address_owner_id_idx", column: :id
remove_index :impacto_address_owner, name: "impacto_address_owner_id_idx", column: :id
remove_index :impacto_address_owner, name: "impacto_address_owner_slug_idx", column: :slug
remove_index :impacto_address_owner, name: "impacto_address_owner_slug_idx", column: :slug
remove_index :impacto_address_owner, name: "impacto_address_owner_slug_idx", column: :slug
remove_index :impacto_address_owner, name: "impacto_address_owner_slug_idx", column: :slug
remove_index :impacto_address_owner, name: "impacto_address_owner_slug_idx", column: :slug
remove_index :impacto_alert, name: "impacto_alert_slug_idx", column: :slug
remove_index :impacto_alert, name: "impacto_alert_slug_idx", column: :slug
remove_index :impacto_alert, name: "impacto_alert_slug_idx", column: :slug
remove_index :impacto_alert, name: "impacto_alert_slug_idx", column: :slug
remove_index :impacto_alert, name: "impacto_alert_slug_idx", column: :slug
remove_index :impacto_alert_follow_up, name: "impacto_alert_follow_up_slug_idx", column: :slug
remove_index :impacto_alert_follow_up, name: "impacto_alert_follow_up_slug_idx", column: :slug
remove_index :impacto_alert_follow_up, name: "impacto_alert_follow_up_slug_idx", column: :slug
remove_index :impacto_alert_follow_up, name: "impacto_alert_follow_up_slug_idx", column: :slug
remove_index :impacto_alert_follow_up, name: "impacto_alert_follow_up_slug_idx", column: :slug
remove_index :impacto_alert_follow_up_action, name: "impacto_alert_follow_up_action_slug_idx", column: :slug
remove_index :impacto_alert_follow_up_action, name: "impacto_alert_follow_up_action_slug_idx", column: :slug
remove_index :impacto_alert_follow_up_action, name: "impacto_alert_follow_up_action_slug_idx", column: :slug
remove_index :impacto_alert_follow_up_action, name: "impacto_alert_follow_up_action_slug_idx", column: :slug
remove_index :impacto_alert_follow_up_action, name: "impacto_alert_follow_up_action_slug_idx", column: :slug
remove_index :impacto_alert_type, name: "impacto_alert_type_slug_idx", column: :slug
remove_index :impacto_alert_type, name: "impacto_alert_type_slug_idx", column: :slug
remove_index :impacto_alert_type, name: "impacto_alert_type_slug_idx", column: :slug
remove_index :impacto_alert_type, name: "impacto_alert_type_slug_idx", column: :slug
remove_index :impacto_alert_type, name: "impacto_alert_type_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_key_idx", column: :key
remove_index :impacto_application, name: "impacto_application_key_idx", column: :key
remove_index :impacto_application, name: "impacto_application_key_idx", column: :key
remove_index :impacto_application, name: "impacto_application_key_idx", column: :key
remove_index :impacto_application, name: "impacto_application_key_idx", column: :key
remove_index :impacto_application, name: "impacto_application_key_idx", column: :key
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_application, name: "impacto_application_slug_idx", column: :slug
remove_index :impacto_archive, name: "impacto_archive_slug_idx", column: :slug
remove_index :impacto_archive, name: "impacto_archive_slug_idx", column: :slug
remove_index :impacto_archive, name: "impacto_archive_slug_idx", column: :slug
remove_index :impacto_archive, name: "impacto_archive_slug_idx", column: :slug
remove_index :impacto_archive, name: "impacto_archive_slug_idx", column: :slug
remove_index :impacto_archive_directory, name: "impacto_archive_directory_slug_idx", column: :slug
remove_index :impacto_archive_directory, name: "impacto_archive_directory_slug_idx", column: :slug
remove_index :impacto_archive_directory, name: "impacto_archive_directory_slug_idx", column: :slug
remove_index :impacto_archive_directory, name: "impacto_archive_directory_slug_idx", column: :slug
remove_index :impacto_archive_directory, name: "impacto_archive_directory_slug_idx", column: :slug
remove_index :impacto_archive_file, name: "impacto_archive_file_slug_idx", column: :slug
remove_index :impacto_archive_file, name: "impacto_archive_file_slug_idx", column: :slug
remove_index :impacto_archive_file, name: "impacto_archive_file_slug_idx", column: :slug
remove_index :impacto_archive_file, name: "impacto_archive_file_slug_idx", column: :slug
remove_index :impacto_archive_file, name: "impacto_archive_file_slug_idx", column: :slug
remove_index :impacto_attendance, name: "impacto_attendance_slug_idx", column: :slug
remove_index :impacto_attendance, name: "impacto_attendance_slug_idx", column: :slug
remove_index :impacto_attendance_role, name: "impacto_attendance_role_slug_idx", column: :slug
remove_index :impacto_attendance_role, name: "impacto_attendance_role_slug_idx", column: :slug
remove_index :impacto_bond_option, name: "impacto_bond_option_slug_idx", column: :slug
remove_index :impacto_bond_option, name: "impacto_bond_option_slug_idx", column: :slug
remove_index :impacto_bond_option, name: "impacto_bond_option_slug_idx", column: :slug
remove_index :impacto_bond_option, name: "impacto_bond_option_slug_idx", column: :slug
remove_index :impacto_bond_option, name: "impacto_bond_option_slug_idx", column: :slug
remove_index :impacto_bond_request, name: "impacto_bond_request_id_idx", column: :id
remove_index :impacto_bond_request, name: "impacto_bond_request_id_idx", column: :id
remove_index :impacto_bond_request, name: "impacto_bond_request_id_idx", column: :id
remove_index :impacto_bond_request, name: "impacto_bond_request_id_idx", column: :id
remove_index :impacto_bond_request, name: "impacto_bond_request_id_idx", column: :id
remove_index :impacto_bond_request, name: "impacto_bond_request_id_idx", column: :id
remove_index :impacto_bond_request, name: "impacto_bond_request_slug_idx", column: :slug
remove_index :impacto_bond_request, name: "impacto_bond_request_slug_idx", column: :slug
remove_index :impacto_bond_request, name: "impacto_bond_request_slug_idx", column: :slug
remove_index :impacto_bond_request, name: "impacto_bond_request_slug_idx", column: :slug
remove_index :impacto_bond_request, name: "impacto_bond_request_slug_idx", column: :slug
remove_index :impacto_case, name: "impacto_case_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_communication_model, name: "impacto_communication_model_slug_idx", column: :slug
remove_index :impacto_communication_model, name: "impacto_communication_model_slug_idx", column: :slug
remove_index :impacto_communication_model, name: "impacto_communication_model_slug_idx", column: :slug
remove_index :impacto_contact, name: "impacto_contact_slug_idx", column: :slug
remove_index :impacto_contact, name: "impacto_contact_slug_idx", column: :slug
remove_index :impacto_contact, name: "impacto_contact_slug_idx", column: :slug
remove_index :impacto_contact, name: "impacto_contact_slug_idx", column: :slug
remove_index :impacto_contact, name: "impacto_contact_slug_idx", column: :slug
remove_index :impacto_document_draft, name: "impacto_document_draft_slug_idx", column: :slug
remove_index :impacto_document_draft, name: "impacto_document_draft_slug_idx", column: :slug
remove_index :impacto_document_draft_access, name: "impacto_document_draft_access_slug_idx", column: :slug
remove_index :impacto_document_draft_access, name: "impacto_document_draft_access_slug_idx", column: :slug
remove_index :impacto_exterrnal_schedule_booking, name: "impacto_exterrnal_schedule_booking_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_group, name: "impacto_group_slug_idx", column: :slug
remove_index :impacto_group, name: "impacto_group_slug_idx", column: :slug
remove_index :impacto_group, name: "impacto_group_slug_idx", column: :slug
remove_index :impacto_group, name: "impacto_group_slug_idx", column: :slug
remove_index :impacto_group, name: "impacto_group_slug_idx", column: :slug
remove_index :impacto_group_member, name: "impacto_group_member_slug_idx", column: :slug
remove_index :impacto_group_member, name: "impacto_group_member_slug_idx", column: :slug
remove_index :impacto_group_member, name: "impacto_group_member_slug_idx", column: :slug
remove_index :impacto_group_member, name: "impacto_group_member_slug_idx", column: :slug
remove_index :impacto_group_member, name: "impacto_group_member_slug_idx", column: :slug
remove_index :impacto_organizational_unit, name: "impacto_organizational_unit_slug_idx", column: :slug
remove_index :impacto_organizational_unit, name: "impacto_organizational_unit_slug_idx", column: :slug
remove_index :impacto_organizational_unit, name: "impacto_organizational_unit_slug_idx", column: :slug
remove_index :impacto_organizational_unit, name: "impacto_organizational_unit_slug_idx", column: :slug
remove_index :impacto_organizational_unit, name: "impacto_organizational_unit_slug_idx", column: :slug
remove_index :impacto_origin_activity, name: "impacto_origin_activity_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_activity, name: "impacto_origin_activity_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_activity, name: "impacto_origin_activity_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_activity, name: "impacto_origin_activity_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_activity, name: "impacto_origin_activity_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_activity, name: "impacto_origin_activity_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_activity, name: "impacto_origin_activity_slug_idx", column: :slug
remove_index :impacto_origin_activity, name: "impacto_origin_activity_slug_idx", column: :slug
remove_index :impacto_origin_activity, name: "impacto_origin_activity_slug_idx", column: :slug
remove_index :impacto_origin_activity, name: "impacto_origin_activity_slug_idx", column: :slug
remove_index :impacto_origin_activity, name: "impacto_origin_activity_slug_idx", column: :slug
remove_index :impacto_origin_activity_pre_processing, name: "impacto_origin_activity_pre_processing_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_object, name: "impacto_origin_object_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_origin_person, name: "impacto_origin_person_slug_idx", column: :slug
remove_index :impacto_origin_person, name: "impacto_origin_person_slug_idx", column: :slug
remove_index :impacto_origin_person, name: "impacto_origin_person_slug_idx", column: :slug
remove_index :impacto_origin_person, name: "impacto_origin_person_slug_idx", column: :slug
remove_index :impacto_origin_person, name: "impacto_origin_person_slug_idx", column: :slug
remove_index :impacto_origin_person_pre_processing, name: "impacto_origin_person_pre_processing_import_unique_id_idx", column: :import_unique_id
remove_index :impacto_password_recovery_token, name: "impacto_password_recovery_token_slug_idx", column: :slug
remove_index :impacto_password_recovery_token, name: "impacto_password_recovery_token_slug_idx", column: :slug
remove_index :impacto_password_recovery_token, name: "impacto_password_recovery_token_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cnpj_number_idx", column: :cnpj_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_cpf_number_idx", column: :cpf_number
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_login_idx", column: :login
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person, name: "impacto_person_slug_idx", column: :slug
remove_index :impacto_person_accepted_terms_and_conditions, name: "impacto_person_accepted_terms_and_conditions_slug_idx", column: :slug
remove_index :impacto_person_accepted_terms_and_conditions, name: "impacto_person_accepted_terms_and_conditions_slug_idx", column: :slug
remove_index :impacto_person_avatar, name: "impacto_person_avatar_slug_idx", column: :slug
remove_index :impacto_person_avatar, name: "impacto_person_avatar_slug_idx", column: :slug
remove_index :impacto_person_avatar, name: "impacto_person_avatar_slug_idx", column: :slug
remove_index :impacto_person_document, name: "impacto_person_document_slug_idx", column: :slug
remove_index :impacto_person_document, name: "impacto_person_document_slug_idx", column: :slug
remove_index :impacto_person_document, name: "impacto_person_document_slug_idx", column: :slug
remove_index :impacto_person_generic_document, name: "impacto_person_generic_document_slug_idx", column: :slug
remove_index :impacto_person_generic_document, name: "impacto_person_generic_document_slug_idx", column: :slug
remove_index :impacto_person_generic_document, name: "impacto_person_generic_document_slug_idx", column: :slug
remove_index :impacto_person_permission, name: "impacto_person_permission_slug_idx", column: :slug
remove_index :impacto_person_permission, name: "impacto_person_permission_slug_idx", column: :slug
remove_index :impacto_person_permission, name: "impacto_person_permission_slug_idx", column: :slug
remove_index :impacto_person_permission, name: "impacto_person_permission_slug_idx", column: :slug
remove_index :impacto_person_permission, name: "impacto_person_permission_slug_idx", column: :slug
remove_index :impacto_person_place, name: "impacto_person_place_slug_idx", column: :slug
remove_index :impacto_person_place, name: "impacto_person_place_slug_idx", column: :slug
remove_index :impacto_person_role, name: "impacto_person_role_slug_idx", column: :slug
remove_index :impacto_person_role, name: "impacto_person_role_slug_idx", column: :slug
remove_index :impacto_person_role, name: "impacto_person_role_slug_idx", column: :slug
remove_index :impacto_person_role, name: "impacto_person_role_slug_idx", column: :slug
remove_index :impacto_person_role, name: "impacto_person_role_slug_idx", column: :slug
remove_index :impacto_place, name: "impacto_place_main_address_id_idx", column: :main_address_id
remove_index :impacto_place, name: "impacto_place_main_mail_contact_id_idx", column: :main_mail_contact_id
remove_index :impacto_place, name: "impacto_place_main_phone_contact_id_idx", column: :main_phone_contact_id
remove_index :impacto_place, name: "impacto_place_slug_idx", column: :slug
remove_index :impacto_place, name: "impacto_place_slug_idx", column: :slug
remove_index :impacto_place, name: "impacto_place_slug_idx", column: :slug
remove_index :impacto_place, name: "impacto_place_slug_idx", column: :slug
remove_index :impacto_place, name: "impacto_place_slug_idx", column: :slug
remove_index :impacto_place_of_service, name: "impacto_place_of_service_slug_idx", column: :slug
remove_index :impacto_place_of_service, name: "impacto_place_of_service_slug_idx", column: :slug
remove_index :impacto_place_of_service, name: "impacto_place_of_service_slug_idx", column: :slug
remove_index :impacto_place_of_service, name: "impacto_place_of_service_slug_idx", column: :slug
remove_index :impacto_place_of_service, name: "impacto_place_of_service_slug_idx", column: :slug
remove_index :impacto_private_file, name: "impacto_private_file_slug_idx", column: :slug
remove_index :impacto_private_file, name: "impacto_private_file_slug_idx", column: :slug
remove_index :impacto_private_file, name: "impacto_private_file_slug_idx", column: :slug
remove_index :impacto_public_external_file, name: "impacto_public_external_file_slug_idx", column: :slug
remove_index :impacto_public_external_file, name: "impacto_public_external_file_slug_idx", column: :slug
remove_index :impacto_public_external_file, name: "impacto_public_external_file_slug_idx", column: :slug
remove_index :impacto_public_file, name: "impacto_public_file_slug_idx", column: :slug
remove_index :impacto_public_file, name: "impacto_public_file_slug_idx", column: :slug
remove_index :impacto_public_file, name: "impacto_public_file_slug_idx", column: :slug
remove_index :impacto_request_log, name: "impacto_request_log_slug_idx", column: :slug
remove_index :impacto_request_log, name: "impacto_request_log_slug_idx", column: :slug
remove_index :impacto_request_log, name: "impacto_request_log_slug_idx", column: :slug
remove_index :impacto_request_log, name: "impacto_request_log_slug_idx", column: :slug
remove_index :impacto_request_log, name: "impacto_request_log_slug_idx", column: :slug
remove_index :impacto_role, name: "impacto_role_slug_idx", column: :slug
remove_index :impacto_role, name: "impacto_role_slug_idx", column: :slug
remove_index :impacto_role, name: "impacto_role_slug_idx", column: :slug
remove_index :impacto_role, name: "impacto_role_slug_idx", column: :slug
remove_index :impacto_role, name: "impacto_role_slug_idx", column: :slug
remove_index :impacto_sent_communication, name: "impacto_sent_communication_slug_idx", column: :slug
remove_index :impacto_sent_communication, name: "impacto_sent_communication_slug_idx", column: :slug
remove_index :impacto_sent_communication, name: "impacto_sent_communication_slug_idx", column: :slug
remove_index :impacto_service_letter, name: "impacto_service_letter_slug_idx", column: :slug
remove_index :impacto_service_letter, name: "impacto_service_letter_slug_idx", column: :slug
remove_index :impacto_service_letter, name: "impacto_service_letter_slug_idx", column: :slug
remove_index :impacto_service_letter, name: "impacto_service_letter_slug_idx", column: :slug
remove_index :impacto_service_letter, name: "impacto_service_letter_slug_idx", column: :slug
remove_index :impacto_service_letter_of_service, name: "impacto_service_letter_of_service_slug_idx", column: :slug
remove_index :impacto_service_letter_of_service, name: "impacto_service_letter_of_service_slug_idx", column: :slug
remove_index :impacto_service_letter_of_service, name: "impacto_service_letter_of_service_slug_idx", column: :slug
remove_index :impacto_service_letter_of_service, name: "impacto_service_letter_of_service_slug_idx", column: :slug
remove_index :impacto_service_letter_of_service, name: "impacto_service_letter_of_service_slug_idx", column: :slug
remove_index :impacto_service_subject, name: "impacto_service_subject_slug_idx", column: :slug
remove_index :impacto_service_subject, name: "impacto_service_subject_slug_idx", column: :slug
remove_index :impacto_service_subject, name: "impacto_service_subject_slug_idx", column: :slug
remove_index :impacto_service_subject, name: "impacto_service_subject_slug_idx", column: :slug
remove_index :impacto_service_subject, name: "impacto_service_subject_slug_idx", column: :slug
remove_index :impacto_service_target_audience, name: "impacto_service_target_audience_slug_idx", column: :slug
remove_index :impacto_service_target_audience, name: "impacto_service_target_audience_slug_idx", column: :slug
remove_index :impacto_service_target_audience, name: "impacto_service_target_audience_slug_idx", column: :slug
remove_index :impacto_service_target_audience, name: "impacto_service_target_audience_slug_idx", column: :slug
remove_index :impacto_service_target_audience, name: "impacto_service_target_audience_slug_idx", column: :slug
remove_index :impacto_service_target_audience_of_service, name: "impacto_service_target_audience_of_service_slug_idx", column: :slug
remove_index :impacto_service_target_audience_of_service, name: "impacto_service_target_audience_of_service_slug_idx", column: :slug
remove_index :impacto_service_target_audience_of_service, name: "impacto_service_target_audience_of_service_slug_idx", column: :slug
remove_index :impacto_service_target_audience_of_service, name: "impacto_service_target_audience_of_service_slug_idx", column: :slug
remove_index :impacto_service_target_audience_of_service, name: "impacto_service_target_audience_of_service_slug_idx", column: :slug
remove_index :impacto_simplified_attendance_for_average_time, name: "impacto_simplified_attendance_for_average_time_cd_atendimen_idx", column: :cd_atendimento
remove_index :impacto_system, name: "impacto_system_slug_idx", column: :slug
remove_index :impacto_system, name: "impacto_system_slug_idx", column: :slug
remove_index :impacto_system, name: "impacto_system_slug_idx", column: :slug
remove_index :impacto_system, name: "impacto_system_slug_idx", column: :slug
remove_index :impacto_system, name: "impacto_system_slug_idx", column: :slug
remove_index :impacto_terms_and_conditions, name: "impacto_terms_and_conditions_slug_idx", column: :slug
remove_index :impacto_terms_and_conditions, name: "impacto_terms_and_conditions_slug_idx", column: :slug
remove_index :impacto_terms_and_conditions, name: "impacto_terms_and_conditions_slug_idx", column: :slug
remove_index :impacto_unified_person, name: "impacto_unified_person_impacto_id_idx", column: :impacto_id
remove_index :impacto_unified_person, name: "impacto_unified_person_impacto_id_idx", column: :impacto_id
remove_index :impacto_unified_person, name: "impacto_unified_person_impacto_id_idx", column: :impacto_id
remove_index :impacto_unified_person, name: "impacto_unified_person_impacto_id_idx", column: :impacto_id
remove_index :impacto_unified_person, name: "impacto_unified_person_impacto_id_idx", column: :impacto_id
remove_index :impacto_unified_person, name: "impacto_unified_person_impacto_id_idx", column: :impacto_id
remove_index :impacto_unified_person, name: "impacto_unified_person_main_address_id_idx", column: :main_address_id
remove_index :impacto_unified_person, name: "impacto_unified_person_main_avatar_id_idx", column: :main_avatar_id
remove_index :impacto_unified_person, name: "impacto_unified_person_main_mail_contact_id_idx", column: :main_mail_contact_id
remove_index :impacto_unified_person, name: "impacto_unified_person_main_phone_contact_id_idx", column: :main_phone_contact_id
remove_index :impacto_unified_person, name: "impacto_unified_person_slug_idx", column: :slug
remove_index :impacto_unified_person, name: "impacto_unified_person_slug_idx", column: :slug
remove_index :impacto_unified_person, name: "impacto_unified_person_slug_idx", column: :slug
remove_index :impacto_unified_person, name: "impacto_unified_person_slug_idx", column: :slug
remove_index :impacto_unified_person, name: "impacto_unified_person_slug_idx", column: :slug
remove_index :impacto_visualization, name: "impacto_visualization_slug_idx", column: :slug
remove_index :impacto_visualization, name: "impacto_visualization_slug_idx", column: :slug
remove_index :impacto_visualization, name: "impacto_visualization_slug_idx", column: :slug
remove_index :impacto_visualization, name: "impacto_visualization_slug_idx", column: :slug
remove_index :impacto_visualization, name: "impacto_visualization_slug_idx", column: :slug
remove_index :impacto_white_label, name: "impacto_white_label_slug_idx", column: :slug
remove_index :impacto_white_label, name: "impacto_white_label_slug_idx", column: :slug
remove_index :impacto_white_label, name: "impacto_white_label_slug_idx", column: :slug
remove_index :impacto_white_label_avatar, name: "impacto_white_label_avatar_slug_idx", column: :slug
remove_index :impacto_white_label_avatar, name: "impacto_white_label_avatar_slug_idx", column: :slug
remove_index :impacto_white_label_avatar, name: "impacto_white_label_avatar_slug_idx", column: :slug
remove_index :socialme_holy_see, name: "socialme_holy_see_person_kind_index_2", column: :person_kind
remove_index :socialme_pakistan, name: "socialme_pakistan_slug_index", column: :slug
Details
On impacto_activity_type 
impacto_activity_type_slug_idx (slug)
is covered by 
impacto_activity_type_slug_key (slug)
On impacto_activity_type 
impacto_activity_type_slug_idx (slug)
is covered by 
impacto_activity_type_slug_key (slug)
On impacto_activity_type 
impacto_activity_type_slug_idx (slug)
is covered by 
impacto_activity_type_slug_key (slug)
On impacto_activity_type 
impacto_activity_type_slug_idx (slug)
is covered by 
impacto_activity_type_slug_key (slug)
On impacto_activity_type 
impacto_activity_type_slug_idx (slug)
is covered by 
impacto_activity_type_slug_key (slug)
On impacto_activity_type_of_service 
impacto_activity_type_of_service_slug_idx (slug)
is covered by 
impacto_activity_type_of_service_slug_key (slug)
On impacto_activity_type_of_service 
impacto_activity_type_of_service_slug_idx (slug)
is covered by 
impacto_activity_type_of_service_slug_key (slug)
On impacto_activity_type_of_service 
impacto_activity_type_of_service_slug_idx (slug)
is covered by 
impacto_activity_type_of_service_slug_key (slug)
On impacto_activity_type_of_service 
impacto_activity_type_of_service_slug_idx (slug)
is covered by 
impacto_activity_type_of_service_slug_key (slug)
On impacto_activity_type_of_service 
impacto_activity_type_of_service_slug_idx (slug)
is covered by 
impacto_activity_type_of_service_slug_key (slug)
On impacto_activity_type_role 
impacto_activity_type_role_slug_idx (slug)
is covered by 
impacto_activity_type_role_slug_key (slug)
On impacto_activity_type_role 
impacto_activity_type_role_slug_idx (slug)
is covered by 
impacto_activity_type_role_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address 
impacto_address_slug_idx (slug)
is covered by 
impacto_address_slug_key (slug)
On impacto_address_owner 
impacto_address_owner_id_idx (id)
is covered by 
impacto_address_owner_id_key (id)
On impacto_address_owner 
impacto_address_owner_id_idx (id)
is covered by 
impacto_address_owner_id_key (id)
On impacto_address_owner 
impacto_address_owner_id_idx (id)
is covered by 
impacto_address_owner_pkey (id)
On impacto_address_owner 
impacto_address_owner_id_idx (id)
is covered by 
impacto_address_owner_id_key (id)
On impacto_address_owner 
impacto_address_owner_id_idx (id)
is covered by 
impacto_address_owner_id_key (id)
On impacto_address_owner 
impacto_address_owner_id_idx (id)
is covered by 
impacto_address_owner_pkey (id)
On impacto_address_owner 
impacto_address_owner_slug_idx (slug)
is covered by 
impacto_address_owner_slug_key (slug)
On impacto_address_owner 
impacto_address_owner_slug_idx (slug)
is covered by 
impacto_address_owner_slug_key (slug)
On impacto_address_owner 
impacto_address_owner_slug_idx (slug)
is covered by 
impacto_address_owner_slug_key (slug)
On impacto_address_owner 
impacto_address_owner_slug_idx (slug)
is covered by 
impacto_address_owner_slug_key (slug)
On impacto_address_owner 
impacto_address_owner_slug_idx (slug)
is covered by 
impacto_address_owner_slug_key (slug)
On impacto_alert 
impacto_alert_slug_idx (slug)
is covered by 
impacto_alert_slug_key (slug)
On impacto_alert 
impacto_alert_slug_idx (slug)
is covered by 
impacto_alert_slug_key (slug)
On impacto_alert 
impacto_alert_slug_idx (slug)
is covered by 
impacto_alert_slug_key (slug)
On impacto_alert 
impacto_alert_slug_idx (slug)
is covered by 
impacto_alert_slug_key (slug)
On impacto_alert 
impacto_alert_slug_idx (slug)
is covered by 
impacto_alert_slug_key (slug)
On impacto_alert_follow_up 
impacto_alert_follow_up_slug_idx (slug)
is covered by 
impacto_alert_follow_up_slug_key (slug)
On impacto_alert_follow_up 
impacto_alert_follow_up_slug_idx (slug)
is covered by 
impacto_alert_follow_up_slug_key (slug)
On impacto_alert_follow_up 
impacto_alert_follow_up_slug_idx (slug)
is covered by 
impacto_alert_follow_up_slug_key (slug)
On impacto_alert_follow_up 
impacto_alert_follow_up_slug_idx (slug)
is covered by 
impacto_alert_follow_up_slug_key (slug)
On impacto_alert_follow_up 
impacto_alert_follow_up_slug_idx (slug)
is covered by 
impacto_alert_follow_up_slug_key (slug)
On impacto_alert_follow_up_action 
impacto_alert_follow_up_action_slug_idx (slug)
is covered by 
impacto_alert_follow_up_action_slug_key (slug)
On impacto_alert_follow_up_action 
impacto_alert_follow_up_action_slug_idx (slug)
is covered by 
impacto_alert_follow_up_action_slug_key (slug)
On impacto_alert_follow_up_action 
impacto_alert_follow_up_action_slug_idx (slug)
is covered by 
impacto_alert_follow_up_action_slug_key (slug)
On impacto_alert_follow_up_action 
impacto_alert_follow_up_action_slug_idx (slug)
is covered by 
impacto_alert_follow_up_action_slug_key (slug)
On impacto_alert_follow_up_action 
impacto_alert_follow_up_action_slug_idx (slug)
is covered by 
impacto_alert_follow_up_action_slug_key (slug)
On impacto_alert_type 
impacto_alert_type_slug_idx (slug)
is covered by 
impacto_alert_type_slug_key (slug)
On impacto_alert_type 
impacto_alert_type_slug_idx (slug)
is covered by 
impacto_alert_type_slug_key (slug)
On impacto_alert_type 
impacto_alert_type_slug_idx (slug)
is covered by 
impacto_alert_type_slug_key (slug)
On impacto_alert_type 
impacto_alert_type_slug_idx (slug)
is covered by 
impacto_alert_type_slug_key (slug)
On impacto_alert_type 
impacto_alert_type_slug_idx (slug)
is covered by 
impacto_alert_type_slug_key (slug)
On impacto_application 
impacto_application_key_idx (key)
is covered by 
impacto_application_key_key (key)
On impacto_application 
impacto_application_key_idx (key)
is covered by 
impacto_application_key_key (key)
On impacto_application 
impacto_application_key_idx (key)
is covered by 
impacto_application_key_key (key)
On impacto_application 
impacto_application_key_idx (key)
is covered by 
impacto_application_key_key (key)
On impacto_application 
impacto_application_key_idx (key)
is covered by 
impacto_application_key_key (key)
On impacto_application 
impacto_application_key_idx (key)
is covered by 
impacto_application_key_key (key)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_application 
impacto_application_slug_idx (slug)
is covered by 
impacto_application_slug_key (slug)
On impacto_archive 
impacto_archive_slug_idx (slug)
is covered by 
impacto_archive_slug_key (slug)
On impacto_archive 
impacto_archive_slug_idx (slug)
is covered by 
impacto_archive_slug_key (slug)
On impacto_archive 
impacto_archive_slug_idx (slug)
is covered by 
impacto_archive_slug_key (slug)
On impacto_archive 
impacto_archive_slug_idx (slug)
is covered by 
impacto_archive_slug_key (slug)
On impacto_archive 
impacto_archive_slug_idx (slug)
is covered by 
impacto_archive_slug_key (slug)
On impacto_archive_directory 
impacto_archive_directory_slug_idx (slug)
is covered by 
impacto_archive_directory_slug_key (slug)
On impacto_archive_directory 
impacto_archive_directory_slug_idx (slug)
is covered by 
impacto_archive_directory_slug_key (slug)
On impacto_archive_directory 
impacto_archive_directory_slug_idx (slug)
is covered by 
impacto_archive_directory_slug_key (slug)
On impacto_archive_directory 
impacto_archive_directory_slug_idx (slug)
is covered by 
impacto_archive_directory_slug_key (slug)
On impacto_archive_directory 
impacto_archive_directory_slug_idx (slug)
is covered by 
impacto_archive_directory_slug_key (slug)
On impacto_archive_file 
impacto_archive_file_slug_idx (slug)
is covered by 
impacto_archive_file_slug_key (slug)
On impacto_archive_file 
impacto_archive_file_slug_idx (slug)
is covered by 
impacto_archive_file_slug_key (slug)
On impacto_archive_file 
impacto_archive_file_slug_idx (slug)
is covered by 
impacto_archive_file_slug_key (slug)
On impacto_archive_file 
impacto_archive_file_slug_idx (slug)
is covered by 
impacto_archive_file_slug_key (slug)
On impacto_archive_file 
impacto_archive_file_slug_idx (slug)
is covered by 
impacto_archive_file_slug_key (slug)
On impacto_attendance 
impacto_attendance_slug_idx (slug)
is covered by 
impacto_attendance_slug_key (slug)
On impacto_attendance 
impacto_attendance_slug_idx (slug)
is covered by 
impacto_attendance_slug_key (slug)
On impacto_attendance_role 
impacto_attendance_role_slug_idx (slug)
is covered by 
impacto_attendance_role_slug_key (slug)
On impacto_attendance_role 
impacto_attendance_role_slug_idx (slug)
is covered by 
impacto_attendance_role_slug_key (slug)
On impacto_bond_option 
impacto_bond_option_slug_idx (slug)
is covered by 
impacto_bond_option_slug_key (slug)
On impacto_bond_option 
impacto_bond_option_slug_idx (slug)
is covered by 
impacto_bond_option_slug_key (slug)
On impacto_bond_option 
impacto_bond_option_slug_idx (slug)
is covered by 
impacto_bond_option_slug_key (slug)
On impacto_bond_option 
impacto_bond_option_slug_idx (slug)
is covered by 
impacto_bond_option_slug_key (slug)
On impacto_bond_option 
impacto_bond_option_slug_idx (slug)
is covered by 
impacto_bond_option_slug_key (slug)
On impacto_bond_request 
impacto_bond_request_id_idx (id)
is covered by 
impacto_bond_request_pkey (id)
On impacto_bond_request 
impacto_bond_request_id_idx (id)
is covered by 
impacto_bond_request_id_key (id)
On impacto_bond_request 
impacto_bond_request_id_idx (id)
is covered by 
impacto_bond_request_pkey (id)
On impacto_bond_request 
impacto_bond_request_id_idx (id)
is covered by 
impacto_bond_request_id_key (id)
On impacto_bond_request 
impacto_bond_request_id_idx (id)
is covered by 
impacto_bond_request_id_key (id)
On impacto_bond_request 
impacto_bond_request_id_idx (id)
is covered by 
impacto_bond_request_pkey (id)
On impacto_bond_request 
impacto_bond_request_slug_idx (slug)
is covered by 
impacto_bond_request_slug_key (slug)
On impacto_bond_request 
impacto_bond_request_slug_idx (slug)
is covered by 
impacto_bond_request_slug_key (slug)
On impacto_bond_request 
impacto_bond_request_slug_idx (slug)
is covered by 
impacto_bond_request_slug_key (slug)
On impacto_bond_request 
impacto_bond_request_slug_idx (slug)
is covered by 
impacto_bond_request_slug_key (slug)
On impacto_bond_request 
impacto_bond_request_slug_idx (slug)
is covered by 
impacto_bond_request_slug_key (slug)
On impacto_case 
impacto_case_import_unique_id_idx (import_unique_id)
is covered by 
impacto_case_import_unique_id_key (import_unique_id)
On impacto_communication_model 
impacto_communication_model_slug_idx (slug)
is covered by 
impacto_communication_model_slug_key (slug)
On impacto_communication_model 
impacto_communication_model_slug_idx (slug)
is covered by 
impacto_communication_model_slug_key (slug)
On impacto_communication_model 
impacto_communication_model_slug_idx (slug)
is covered by 
impacto_communication_model_slug_key (slug)
On impacto_contact 
impacto_contact_slug_idx (slug)
is covered by 
impacto_contact_slug_key (slug)
On impacto_contact 
impacto_contact_slug_idx (slug)
is covered by 
impacto_contact_slug_key (slug)
On impacto_contact 
impacto_contact_slug_idx (slug)
is covered by 
impacto_contact_slug_key (slug)
On impacto_contact 
impacto_contact_slug_idx (slug)
is covered by 
impacto_contact_slug_key (slug)
On impacto_contact 
impacto_contact_slug_idx (slug)
is covered by 
impacto_contact_slug_key (slug)
On impacto_document_draft 
impacto_document_draft_slug_idx (slug)
is covered by 
impacto_document_draft_slug_key (slug)
On impacto_document_draft 
impacto_document_draft_slug_idx (slug)
is covered by 
impacto_document_draft_slug_key (slug)
On impacto_document_draft_access 
impacto_document_draft_access_slug_idx (slug)
is covered by 
impacto_document_draft_access_slug_key (slug)
On impacto_document_draft_access 
impacto_document_draft_access_slug_idx (slug)
is covered by 
impacto_document_draft_access_slug_key (slug)
On impacto_exterrnal_schedule_booking 
impacto_exterrnal_schedule_booking_import_unique_id_idx (import_unique_id)
is covered by 
impacto_exterrnal_schedule_booking_import_unique_id_key (import_unique_id)
On impacto_group 
impacto_group_slug_idx (slug)
is covered by 
impacto_group_slug_key (slug)
On impacto_group 
impacto_group_slug_idx (slug)
is covered by 
impacto_group_slug_key (slug)
On impacto_group 
impacto_group_slug_idx (slug)
is covered by 
impacto_group_slug_key (slug)
On impacto_group 
impacto_group_slug_idx (slug)
is covered by 
impacto_group_slug_key (slug)
On impacto_group 
impacto_group_slug_idx (slug)
is covered by 
impacto_group_slug_key (slug)
On impacto_group_member 
impacto_group_member_slug_idx (slug)
is covered by 
impacto_group_member_slug_key (slug)
On impacto_group_member 
impacto_group_member_slug_idx (slug)
is covered by 
impacto_group_member_slug_key (slug)
On impacto_group_member 
impacto_group_member_slug_idx (slug)
is covered by 
impacto_group_member_slug_key (slug)
On impacto_group_member 
impacto_group_member_slug_idx (slug)
is covered by 
impacto_group_member_slug_key (slug)
On impacto_group_member 
impacto_group_member_slug_idx (slug)
is covered by 
impacto_group_member_slug_key (slug)
On impacto_organizational_unit 
impacto_organizational_unit_slug_idx (slug)
is covered by 
impacto_organizational_unit_slug_key (slug)
On impacto_organizational_unit 
impacto_organizational_unit_slug_idx (slug)
is covered by 
impacto_organizational_unit_slug_key (slug)
On impacto_organizational_unit 
impacto_organizational_unit_slug_idx (slug)
is covered by 
impacto_organizational_unit_slug_key (slug)
On impacto_organizational_unit 
impacto_organizational_unit_slug_idx (slug)
is covered by 
impacto_organizational_unit_slug_key (slug)
On impacto_organizational_unit 
impacto_organizational_unit_slug_idx (slug)
is covered by 
impacto_organizational_unit_slug_key (slug)
On impacto_origin_activity 
impacto_origin_activity_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_import_unique_id_key (import_unique_id)
On impacto_origin_activity 
impacto_origin_activity_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_import_unique_id_key (import_unique_id)
On impacto_origin_activity 
impacto_origin_activity_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_import_unique_id_key (import_unique_id)
On impacto_origin_activity 
impacto_origin_activity_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_import_unique_id_key (import_unique_id)
On impacto_origin_activity 
impacto_origin_activity_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_import_unique_id_key (import_unique_id)
On impacto_origin_activity 
impacto_origin_activity_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_import_unique_id_key (import_unique_id)
On impacto_origin_activity 
impacto_origin_activity_slug_idx (slug)
is covered by 
impacto_origin_activity_slug_key (slug)
On impacto_origin_activity 
impacto_origin_activity_slug_idx (slug)
is covered by 
impacto_origin_activity_slug_key (slug)
On impacto_origin_activity 
impacto_origin_activity_slug_idx (slug)
is covered by 
impacto_origin_activity_slug_key (slug)
On impacto_origin_activity 
impacto_origin_activity_slug_idx (slug)
is covered by 
impacto_origin_activity_slug_key (slug)
On impacto_origin_activity 
impacto_origin_activity_slug_idx (slug)
is covered by 
impacto_origin_activity_slug_key (slug)
On impacto_origin_activity_pre_processing 
impacto_origin_activity_pre_processing_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_activity_pre_processing_import_unique_id_key (import_unique_id)
On impacto_origin_object 
impacto_origin_object_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_object_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_import_unique_id_key (import_unique_id)
On impacto_origin_person 
impacto_origin_person_slug_idx (slug)
is covered by 
impacto_origin_person_slug_key (slug)
On impacto_origin_person 
impacto_origin_person_slug_idx (slug)
is covered by 
impacto_origin_person_slug_key (slug)
On impacto_origin_person 
impacto_origin_person_slug_idx (slug)
is covered by 
impacto_origin_person_slug_key (slug)
On impacto_origin_person 
impacto_origin_person_slug_idx (slug)
is covered by 
impacto_origin_person_slug_key (slug)
On impacto_origin_person 
impacto_origin_person_slug_idx (slug)
is covered by 
impacto_origin_person_slug_key (slug)
On impacto_origin_person_pre_processing 
impacto_origin_person_pre_processing_import_unique_id_idx (import_unique_id)
is covered by 
impacto_origin_person_pre_processing_import_unique_id_key (import_unique_id)
On impacto_password_recovery_token 
impacto_password_recovery_token_slug_idx (slug)
is covered by 
impacto_password_recovery_token_slug_key (slug)
On impacto_password_recovery_token 
impacto_password_recovery_token_slug_idx (slug)
is covered by 
impacto_password_recovery_token_slug_key (slug)
On impacto_password_recovery_token 
impacto_password_recovery_token_slug_idx (slug)
is covered by 
impacto_password_recovery_token_slug_key (slug)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cnpj_number_idx (cnpj_number)
is covered by 
impacto_person_cnpj_number_key (cnpj_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_cpf_number_idx (cpf_number)
is covered by 
impacto_person_cpf_number_key (cpf_number)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_login_idx (login)
is covered by 
impacto_person_login_key (login)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person 
impacto_person_slug_idx (slug)
is covered by 
impacto_person_slug_key (slug)
On impacto_person_accepted_terms_and_conditions 
impacto_person_accepted_terms_and_conditions_slug_idx (slug)
is covered by 
impacto_person_accepted_terms_and_conditions_slug_key (slug)
On impacto_person_accepted_terms_and_conditions 
impacto_person_accepted_terms_and_conditions_slug_idx (slug)
is covered by 
impacto_person_accepted_terms_and_conditions_slug_key (slug)
On impacto_person_avatar 
impacto_person_avatar_slug_idx (slug)
is covered by 
impacto_person_avatar_slug_key (slug)
On impacto_person_avatar 
impacto_person_avatar_slug_idx (slug)
is covered by 
impacto_person_avatar_slug_key (slug)
On impacto_person_avatar 
impacto_person_avatar_slug_idx (slug)
is covered by 
impacto_person_avatar_slug_key (slug)
On impacto_person_document 
impacto_person_document_slug_idx (slug)
is covered by 
impacto_person_document_slug_key (slug)
On impacto_person_document 
impacto_person_document_slug_idx (slug)
is covered by 
impacto_person_document_slug_key (slug)
On impacto_person_document 
impacto_person_document_slug_idx (slug)
is covered by 
impacto_person_document_slug_key (slug)
On impacto_person_generic_document 
impacto_person_generic_document_slug_idx (slug)
is covered by 
impacto_person_generic_document_slug_key (slug)
On impacto_person_generic_document 
impacto_person_generic_document_slug_idx (slug)
is covered by 
impacto_person_generic_document_slug_key (slug)
On impacto_person_generic_document 
impacto_person_generic_document_slug_idx (slug)
is covered by 
impacto_person_generic_document_slug_key (slug)
On impacto_person_permission 
impacto_person_permission_slug_idx (slug)
is covered by 
impacto_person_permission_slug_key (slug)
On impacto_person_permission 
impacto_person_permission_slug_idx (slug)
is covered by 
impacto_person_permission_slug_key (slug)
On impacto_person_permission 
impacto_person_permission_slug_idx (slug)
is covered by 
impacto_person_permission_slug_key (slug)
On impacto_person_permission 
impacto_person_permission_slug_idx (slug)
is covered by 
impacto_person_permission_slug_key (slug)
On impacto_person_permission 
impacto_person_permission_slug_idx (slug)
is covered by 
impacto_person_permission_slug_key (slug)
On impacto_person_place 
impacto_person_place_slug_idx (slug)
is covered by 
impacto_person_place_slug_key (slug)
On impacto_person_place 
impacto_person_place_slug_idx (slug)
is covered by 
impacto_person_place_slug_key (slug)
On impacto_person_role 
impacto_person_role_slug_idx (slug)
is covered by 
impacto_person_role_slug_key (slug)
On impacto_person_role 
impacto_person_role_slug_idx (slug)
is covered by 
impacto_person_role_slug_key (slug)
On impacto_person_role 
impacto_person_role_slug_idx (slug)
is covered by 
impacto_person_role_slug_key (slug)
On impacto_person_role 
impacto_person_role_slug_idx (slug)
is covered by 
impacto_person_role_slug_key (slug)
On impacto_person_role 
impacto_person_role_slug_idx (slug)
is covered by 
impacto_person_role_slug_key (slug)
On impacto_place 
impacto_place_main_address_id_idx (main_address_id)
is covered by 
impacto_place_main_address_id_key (main_address_id)
On impacto_place 
impacto_place_main_mail_contact_id_idx (main_mail_contact_id)
is covered by 
impacto_place_main_mail_contact_id_key (main_mail_contact_id)
On impacto_place 
impacto_place_main_phone_contact_id_idx (main_phone_contact_id)
is covered by 
impacto_place_main_phone_contact_id_key (main_phone_contact_id)
On impacto_place 
impacto_place_slug_idx (slug)
is covered by 
impacto_place_slug_key (slug)
On impacto_place 
impacto_place_slug_idx (slug)
is covered by 
impacto_place_slug_key (slug)
On impacto_place 
impacto_place_slug_idx (slug)
is covered by 
impacto_place_slug_key (slug)
On impacto_place 
impacto_place_slug_idx (slug)
is covered by 
impacto_place_slug_key (slug)
On impacto_place 
impacto_place_slug_idx (slug)
is covered by 
impacto_place_slug_key (slug)
On impacto_place_of_service 
impacto_place_of_service_slug_idx (slug)
is covered by 
impacto_place_of_service_slug_key (slug)
On impacto_place_of_service 
impacto_place_of_service_slug_idx (slug)
is covered by 
impacto_place_of_service_slug_key (slug)
On impacto_place_of_service 
impacto_place_of_service_slug_idx (slug)
is covered by 
impacto_place_of_service_slug_key (slug)
On impacto_place_of_service 
impacto_place_of_service_slug_idx (slug)
is covered by 
impacto_place_of_service_slug_key (slug)
On impacto_place_of_service 
impacto_place_of_service_slug_idx (slug)
is covered by 
impacto_place_of_service_slug_key (slug)
On impacto_private_file 
impacto_private_file_slug_idx (slug)
is covered by 
impacto_private_file_slug_key (slug)
On impacto_private_file 
impacto_private_file_slug_idx (slug)
is covered by 
impacto_private_file_slug_key (slug)
On impacto_private_file 
impacto_private_file_slug_idx (slug)
is covered by 
impacto_private_file_slug_key (slug)
On impacto_public_external_file 
impacto_public_external_file_slug_idx (slug)
is covered by 
impacto_public_external_file_slug_key (slug)
On impacto_public_external_file 
impacto_public_external_file_slug_idx (slug)
is covered by 
impacto_public_external_file_slug_key (slug)
On impacto_public_external_file 
impacto_public_external_file_slug_idx (slug)
is covered by 
impacto_public_external_file_slug_key (slug)
On impacto_public_file 
impacto_public_file_slug_idx (slug)
is covered by 
impacto_public_file_slug_key (slug)
On impacto_public_file 
impacto_public_file_slug_idx (slug)
is covered by 
impacto_public_file_slug_key (slug)
On impacto_public_file 
impacto_public_file_slug_idx (slug)
is covered by 
impacto_public_file_slug_key (slug)
On impacto_request_log 
impacto_request_log_slug_idx (slug)
is covered by 
impacto_request_log_slug_key (slug)
On impacto_request_log 
impacto_request_log_slug_idx (slug)
is covered by 
impacto_request_log_slug_key (slug)
On impacto_request_log 
impacto_request_log_slug_idx (slug)
is covered by 
impacto_request_log_slug_key (slug)
On impacto_request_log 
impacto_request_log_slug_idx (slug)
is covered by 
impacto_request_log_slug_key (slug)
On impacto_request_log 
impacto_request_log_slug_idx (slug)
is covered by 
impacto_request_log_slug_key (slug)
On impacto_role 
impacto_role_slug_idx (slug)
is covered by 
impacto_role_slug_key (slug)
On impacto_role 
impacto_role_slug_idx (slug)
is covered by 
impacto_role_slug_key (slug)
On impacto_role 
impacto_role_slug_idx (slug)
is covered by 
impacto_role_slug_key (slug)
On impacto_role 
impacto_role_slug_idx (slug)
is covered by 
impacto_role_slug_key (slug)
On impacto_role 
impacto_role_slug_idx (slug)
is covered by 
impacto_role_slug_key (slug)
On impacto_sent_communication 
impacto_sent_communication_slug_idx (slug)
is covered by 
impacto_sent_communication_slug_key (slug)
On impacto_sent_communication 
impacto_sent_communication_slug_idx (slug)
is covered by 
impacto_sent_communication_slug_key (slug)
On impacto_sent_communication 
impacto_sent_communication_slug_idx (slug)
is covered by 
impacto_sent_communication_slug_key (slug)
On impacto_service_letter 
impacto_service_letter_slug_idx (slug)
is covered by 
impacto_service_letter_slug_key (slug)
On impacto_service_letter 
impacto_service_letter_slug_idx (slug)
is covered by 
impacto_service_letter_slug_key (slug)
On impacto_service_letter 
impacto_service_letter_slug_idx (slug)
is covered by 
impacto_service_letter_slug_key (slug)
On impacto_service_letter 
impacto_service_letter_slug_idx (slug)
is covered by 
impacto_service_letter_slug_key (slug)
On impacto_service_letter 
impacto_service_letter_slug_idx (slug)
is covered by 
impacto_service_letter_slug_key (slug)
On impacto_service_letter_of_service 
impacto_service_letter_of_service_slug_idx (slug)
is covered by 
impacto_service_letter_of_service_slug_key (slug)
On impacto_service_letter_of_service 
impacto_service_letter_of_service_slug_idx (slug)
is covered by 
impacto_service_letter_of_service_slug_key (slug)
On impacto_service_letter_of_service 
impacto_service_letter_of_service_slug_idx (slug)
is covered by 
impacto_service_letter_of_service_slug_key (slug)
On impacto_service_letter_of_service 
impacto_service_letter_of_service_slug_idx (slug)
is covered by 
impacto_service_letter_of_service_slug_key (slug)
On impacto_service_letter_of_service 
impacto_service_letter_of_service_slug_idx (slug)
is covered by 
impacto_service_letter_of_service_slug_key (slug)
On impacto_service_subject 
impacto_service_subject_slug_idx (slug)
is covered by 
impacto_service_subject_slug_key (slug)
On impacto_service_subject 
impacto_service_subject_slug_idx (slug)
is covered by 
impacto_service_subject_slug_key (slug)
On impacto_service_subject 
impacto_service_subject_slug_idx (slug)
is covered by 
impacto_service_subject_slug_key (slug)
On impacto_service_subject 
impacto_service_subject_slug_idx (slug)
is covered by 
impacto_service_subject_slug_key (slug)
On impacto_service_subject 
impacto_service_subject_slug_idx (slug)
is covered by 
impacto_service_subject_slug_key (slug)
On impacto_service_target_audience 
impacto_service_target_audience_slug_idx (slug)
is covered by 
impacto_service_target_audience_slug_key (slug)
On impacto_service_target_audience 
impacto_service_target_audience_slug_idx (slug)
is covered by 
impacto_service_target_audience_slug_key (slug)
On impacto_service_target_audience 
impacto_service_target_audience_slug_idx (slug)
is covered by 
impacto_service_target_audience_slug_key (slug)
On impacto_service_target_audience 
impacto_service_target_audience_slug_idx (slug)
is covered by 
impacto_service_target_audience_slug_key (slug)
On impacto_service_target_audience 
impacto_service_target_audience_slug_idx (slug)
is covered by 
impacto_service_target_audience_slug_key (slug)
On impacto_service_target_audience_of_service 
impacto_service_target_audience_of_service_slug_idx (slug)
is covered by 
impacto_service_target_audience_of_service_slug_key (slug)
On impacto_service_target_audience_of_service 
impacto_service_target_audience_of_service_slug_idx (slug)
is covered by 
impacto_service_target_audience_of_service_slug_key (slug)
On impacto_service_target_audience_of_service 
impacto_service_target_audience_of_service_slug_idx (slug)
is covered by 
impacto_service_target_audience_of_service_slug_key (slug)
On impacto_service_target_audience_of_service 
impacto_service_target_audience_of_service_slug_idx (slug)
is covered by 
impacto_service_target_audience_of_service_slug_key (slug)
On impacto_service_target_audience_of_service 
impacto_service_target_audience_of_service_slug_idx (slug)
is covered by 
impacto_service_target_audience_of_service_slug_key (slug)
On impacto_simplified_attendance_for_average_time 
impacto_simplified_attendance_for_average_time_cd_atendimen_idx (cd_atendimento)
is covered by 
impacto_simplified_attendance_for_average_time_cd_atendimen_key (cd_atendimento)
On impacto_system 
impacto_system_slug_idx (slug)
is covered by 
impacto_system_slug_key (slug)
On impacto_system 
impacto_system_slug_idx (slug)
is covered by 
impacto_system_slug_key (slug)
On impacto_system 
impacto_system_slug_idx (slug)
is covered by 
impacto_system_slug_key (slug)
On impacto_system 
impacto_system_slug_idx (slug)
is covered by 
impacto_system_slug_key (slug)
On impacto_system 
impacto_system_slug_idx (slug)
is covered by 
impacto_system_slug_key (slug)
On impacto_terms_and_conditions 
impacto_terms_and_conditions_slug_idx (slug)
is covered by 
impacto_terms_and_conditions_slug_key (slug)
On impacto_terms_and_conditions 
impacto_terms_and_conditions_slug_idx (slug)
is covered by 
impacto_terms_and_conditions_slug_key (slug)
On impacto_terms_and_conditions 
impacto_terms_and_conditions_slug_idx (slug)
is covered by 
impacto_terms_and_conditions_slug_key (slug)
On impacto_unified_person 
impacto_unified_person_impacto_id_idx (impacto_id)
is covered by 
impacto_unified_person_impacto_id_key (impacto_id)
On impacto_unified_person 
impacto_unified_person_impacto_id_idx (impacto_id)
is covered by 
impacto_unified_person_impacto_id_key (impacto_id)
On impacto_unified_person 
impacto_unified_person_impacto_id_idx (impacto_id)
is covered by 
impacto_unified_person_impacto_id_key (impacto_id)
On impacto_unified_person 
impacto_unified_person_impacto_id_idx (impacto_id)
is covered by 
impacto_unified_person_impacto_id_key (impacto_id)
On impacto_unified_person 
impacto_unified_person_impacto_id_idx (impacto_id)
is covered by 
impacto_unified_person_impacto_id_key (impacto_id)
On impacto_unified_person 
impacto_unified_person_impacto_id_idx (impacto_id)
is covered by 
impacto_unified_person_impacto_id_key (impacto_id)
On impacto_unified_person 
impacto_unified_person_main_address_id_idx (main_address_id)
is covered by 
impacto_unified_person_main_address_id_key (main_address_id)
On impacto_unified_person 
impacto_unified_person_main_avatar_id_idx (main_avatar_id)
is covered by 
impacto_unified_person_main_avatar_id_key (main_avatar_id)
On impacto_unified_person 
impacto_unified_person_main_mail_contact_id_idx (main_mail_contact_id)
is covered by 
impacto_unified_person_main_mail_contact_id_key (main_mail_contact_id)
On impacto_unified_person 
impacto_unified_person_main_phone_contact_id_idx (main_phone_contact_id)
is covered by 
impacto_unified_person_main_phone_contact_id_key (main_phone_contact_id)
On impacto_unified_person 
impacto_unified_person_slug_idx (slug)
is covered by 
impacto_unified_person_slug_key (slug)
On impacto_unified_person 
impacto_unified_person_slug_idx (slug)
is covered by 
impacto_unified_person_slug_key (slug)
On impacto_unified_person 
impacto_unified_person_slug_idx (slug)
is covered by 
impacto_unified_person_slug_key (slug)
On impacto_unified_person 
impacto_unified_person_slug_idx (slug)
is covered by 
impacto_unified_person_slug_key (slug)
On impacto_unified_person 
impacto_unified_person_slug_idx (slug)
is covered by 
impacto_unified_person_slug_key (slug)
On impacto_visualization 
impacto_visualization_slug_idx (slug)
is covered by 
impacto_visualization_slug_key (slug)
On impacto_visualization 
impacto_visualization_slug_idx (slug)
is covered by 
impacto_visualization_slug_key (slug)
On impacto_visualization 
impacto_visualization_slug_idx (slug)
is covered by 
impacto_visualization_slug_key (slug)
On impacto_visualization 
impacto_visualization_slug_idx (slug)
is covered by 
impacto_visualization_slug_key (slug)
On impacto_visualization 
impacto_visualization_slug_idx (slug)
is covered by 
impacto_visualization_slug_key (slug)
On impacto_white_label 
impacto_white_label_slug_idx (slug)
is covered by 
impacto_white_label_slug_key (slug)
On impacto_white_label 
impacto_white_label_slug_idx (slug)
is covered by 
impacto_white_label_slug_key (slug)
On impacto_white_label 
impacto_white_label_slug_idx (slug)
is covered by 
impacto_white_label_slug_key (slug)
On impacto_white_label_avatar 
impacto_white_label_avatar_slug_idx (slug)
is covered by 
impacto_white_label_avatar_slug_key (slug)
On impacto_white_label_avatar 
impacto_white_label_avatar_slug_idx (slug)
is covered by 
impacto_white_label_avatar_slug_key (slug)
On impacto_white_label_avatar 
impacto_white_label_avatar_slug_idx (slug)
is covered by 
impacto_white_label_avatar_slug_key (slug)
On socialme_holy_see 
socialme_holy_see_person_kind_index_2 (person_kind)
is covered by 
socialme_holy_see_person_kind_index (person_kind)
On socialme_pakistan 
socialme_pakistan_slug_index (slug)
is covered by 
socialme_pakistan_slug_uindex (slug)

Slow Queries

Slow queries take 20 ms or more on average and have been called at least 100 times.

Explain queries to see where to add indexes.

Total Time Average Time Calls
107 min 75% 406 ms 15,840 postgres 
SELECT schemaname AS schema, t.relname AS table, ix.relname AS name, regexp_replace(pg_get_indexdef(i.indexrelid), $1, $2) AS columns, regexp_replace(pg_get_indexdef(i.indexrelid), $3, $4) AS using, indisunique AS unique, indisprimary AS primary, indisvalid AS valid, indexprs::text, indpred::text, pg_get_indexdef(i.indexrelid) AS definition FROM pg_index i INNER JOIN pg_class t ON t.oid = i.indrelid INNER JOIN pg_class ix ON ix.oid = i.indexrelid LEFT JOIN pg_stat_user_indexes ui ON ui.indexrelid = i.indexrelid WHERE schemaname IS NOT NULL ORDER BY 1, 2 /*pghero*/
6 min 4% 24 ms 15,839 postgres 
WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, ((total_plan_time + total_exec_time) / $2 / $3) AS total_minutes, ((total_plan_time + total_exec_time) / calls) AS average_time, calls FROM pg_stat_statements INNER JOIN pg_database ON pg_database.oid = pg_stat_statements.dbid INNER JOIN pg_roles ON pg_roles.oid = pg_stat_statements.userid WHERE calls > $4 AND pg_database.datname = current_database() ) SELECT query, query AS explainable_query, query_hash, query_stats.user, total_minutes, average_time, calls, total_minutes * $5 / (SELECT SUM(total_minutes) FROM query_stats) AS total_percent, (SELECT SUM(total_minutes) FROM query_stats) AS all_queries_total_minutes FROM query_stats ORDER BY "total_minutes" DESC LIMIT $6 /*pghero*/
6 min 4% 23 ms 15,659 postgres 
SELECT n.nspname AS table_schema, c.relname AS table, attname AS column, format_type(a.atttypid, a.atttypmod) AS column_type, pg_get_expr(d.adbin, d.adrelid) AS default_value FROM pg_catalog.pg_attribute a INNER JOIN pg_catalog.pg_class c ON c.oid = a.attrelid INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace INNER JOIN pg_catalog.pg_attrdef d ON (a.attrelid, a.attnum) = (d.adrelid, d.adnum) WHERE NOT a.attisdropped AND a.attnum > $1 AND pg_get_expr(d.adbin, d.adrelid) LIKE $2 AND n.nspname NOT LIKE $3 /*pghero*/