PgHero
No long running queries
Connections healthy 330
Vacuuming healthy
No columns near integer overflow
No invalid indexes or constraints
139 duplicate indexes
5 suggested indexes
31 slow queries

Duplicate Indexes

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

Details
On account_account
account_account_code_index (code)
is covered by
account_account_code_company_uniq (code, company_id)
On account_account_account_tag
account_account_account_tag_account_account_id_idx (account_account_id)
is covered by
account_account_account_tag_account_account_id_account_acco_key (account_account_id, account_account_tag_id)
On account_account_tag_account_tax_template_rel
account_account_tag_account_tax_tem_account_tax_template_id_idx (account_tax_template_id)
is covered by
account_account_tag_account_t_account_tax_template_id_accou_key (account_tax_template_id, account_account_tag_id)
On account_account_tax_default_rel
account_account_tax_default_rel_account_id_idx (account_id)
is covered by
account_account_tax_default_rel_account_id_tax_id_key (account_id, tax_id)
On account_account_template_account_tag
account_account_template_accoun_account_account_template_id_idx (account_account_template_id)
is covered by
account_account_template_acco_account_account_template_id_a_key (account_account_template_id, account_account_tag_id)
On account_account_template_tax_rel
account_account_template_tax_rel_account_id_idx (account_id)
is covered by
account_account_template_tax_rel_account_id_tax_id_key (account_id, tax_id)
On account_account_type_rel
account_account_type_rel_journal_id_idx (journal_id)
is covered by
account_account_type_rel_journal_id_account_id_key (journal_id, account_id)
On account_analytic_line_tag_rel
account_analytic_line_tag_rel_line_id_idx (line_id)
is covered by
account_analytic_line_tag_rel_line_id_tag_id_key (line_id, tag_id)
On account_analytic_tag_account_invoice_line_rel
account_analytic_tag_account_invoic_account_invoice_line_id_idx (account_invoice_line_id)
is covered by
account_analytic_tag_account__account_invoice_line_id_accou_key (account_invoice_line_id, account_analytic_tag_id)
On account_analytic_tag_account_invoice_tax_rel
account_analytic_tag_account_invoice_account_invoice_tax_id_idx (account_invoice_tax_id)
is covered by
account_analytic_tag_account__account_invoice_tax_id_accoun_key (account_invoice_tax_id, account_analytic_tag_id)
On account_analytic_tag_account_move_line_rel
account_analytic_tag_account_move_line_account_move_line_id_idx (account_move_line_id)
is covered by
account_analytic_tag_account__account_move_line_id_account__key (account_move_line_id, account_analytic_tag_id)
On account_analytic_tag_account_reconcile_model_rel
account_analytic_tag_account_rec_account_reconcile_model_id_idx (account_reconcile_model_id)
is covered by
account_analytic_tag_account__account_reconcile_model_id_ac_key (account_reconcile_model_id, account_analytic_tag_id)
On account_balance_view_rel
account_balance_view_rel_search_account_balance_id_idx (search_account_balance_id)
is covered by
account_balance_view_rel_search_account_balance_id_account__key (search_account_balance_id, account_balance_view_id)
On account_common_journal_report_account_journal_rel
account_common_journal_report_account_common_journal_report_idx (account_common_journal_report_id)
is covered by
account_common_journal_report_account_common_journal_report_key (account_common_journal_report_id, account_journal_id)
On account_common_report_account_journal_rel
account_common_report_account_jour_account_common_report_id_idx (account_common_report_id)
is covered by
account_common_report_account_account_common_report_id_acco_key (account_common_report_id, account_journal_id)
On account_fiscal_position_res_country_state_rel
account_fiscal_position_res_coun_account_fiscal_position_id_idx (account_fiscal_position_id)
is covered by
account_fiscal_position_res_c_account_fiscal_position_id_re_key (account_fiscal_position_id, res_country_state_id)
On account_fiscal_position_template_res_country_state_rel
account_fiscal_position_templ_account_fiscal_position_templ_idx (account_fiscal_position_template_id)
is covered by
account_fiscal_position_templ_account_fiscal_position_templ_key (account_fiscal_position_template_id, res_country_state_id)
On account_invoice_account_invoice_send_rel
account_invoice_account_invoice_sen_account_invoice_send_id_idx (account_invoice_send_id)
is covered by
account_invoice_account_invoi_account_invoice_send_id_accou_key (account_invoice_send_id, account_invoice_id)
On account_invoice_account_move_line_rel
account_invoice_account_move_line_rel_account_invoice_id_idx (account_invoice_id)
is covered by
account_invoice_account_move__account_invoice_id_account_mo_key (account_invoice_id, account_move_line_id)
On account_invoice_account_register_payments_rel
account_invoice_account_regist_account_register_payments_id_idx (account_register_payments_id)
is covered by
account_invoice_account_regis_account_register_payments_id__key (account_register_payments_id, account_invoice_id)
On account_invoice_import_wizard_ir_attachment_rel
account_invoice_import_wizard_account_invoice_import_wizard_idx (account_invoice_import_wizard_id)
is covered by
account_invoice_import_wizard_account_invoice_import_wizard_key (account_invoice_import_wizard_id, ir_attachment_id)
On account_invoice_line_tax
account_invoice_line_tax_invoice_line_id_idx (invoice_line_id)
is covered by
account_invoice_line_tax_invoice_line_id_tax_id_key (invoice_line_id, tax_id)
On account_invoice_payment_rel
account_invoice_payment_rel_payment_id_idx (payment_id)
is covered by
account_invoice_payment_rel_payment_id_invoice_id_key (payment_id, invoice_id)
On account_invoice_transaction_rel
account_invoice_transaction_rel_transaction_id_idx (transaction_id)
is covered by
account_invoice_transaction_rel_transaction_id_invoice_id_key (transaction_id, invoice_id)
On account_journal_account_print_journal_rel
account_journal_account_print_jour_account_print_journal_id_idx (account_print_journal_id)
is covered by
account_journal_account_print_account_print_journal_id_acco_key (account_print_journal_id, account_journal_id)
On account_journal_account_reconcile_model_rel
account_journal_account_reconcil_account_reconcile_model_id_idx (account_reconcile_model_id)
is covered by
account_journal_account_recon_account_reconcile_model_id_ac_key (account_reconcile_model_id, account_journal_id)
On account_journal_account_reconcile_model_template_rel
account_journal_account_recon_account_reconcile_model_templ_idx (account_reconcile_model_template_id)
is covered by
account_journal_account_recon_account_reconcile_model_templ_key (account_reconcile_model_template_id, account_journal_id)
On account_journal_inbound_payment_method_rel
account_journal_inbound_payment_method_rel_journal_id_idx (journal_id)
is covered by
account_journal_inbound_payme_journal_id_inbound_payment_me_key (journal_id, inbound_payment_method)
On account_journal_outbound_payment_method_rel
account_journal_outbound_payment_method_rel_journal_id_idx (journal_id)
is covered by
account_journal_outbound_paym_journal_id_outbound_payment_m_key (journal_id, outbound_payment_method)
On account_journal_type_rel
account_journal_type_rel_journal_id_idx (journal_id)
is covered by
account_journal_type_rel_journal_id_type_id_key (journal_id, type_id)
On account_move_line_account_tax_rel
account_move_line_account_tax_rel_account_move_line_id_idx (account_move_line_id)
is covered by
account_move_line_account_tax_account_move_line_id_account__key (account_move_line_id, account_tax_id)
On account_reconcile_model_res_partner_category_rel
account_reconcile_model_res_par_account_reconcile_model_id_idx1 (account_reconcile_model_id)
is covered by
account_reconcile_model_res_p_account_reconcile_model_id_r_key1 (account_reconcile_model_id, res_partner_category_id)
On account_reconcile_model_res_partner_rel
account_reconcile_model_res_part_account_reconcile_model_id_idx (account_reconcile_model_id)
is covered by
account_reconcile_model_res_p_account_reconcile_model_id_re_key (account_reconcile_model_id, res_partner_id)
On account_reconcile_model_template_res_partner_category_rel
account_reconcile_model_templ_account_reconcile_model_temp_idx1 (account_reconcile_model_template_id)
is covered by
account_reconcile_model_templ_account_reconcile_model_temp_key1 (account_reconcile_model_template_id, res_partner_category_id)
On account_reconcile_model_template_res_partner_rel
account_reconcile_model_templ_account_reconcile_model_templ_idx (account_reconcile_model_template_id)
is covered by
account_reconcile_model_templ_account_reconcile_model_templ_key (account_reconcile_model_template_id, res_partner_id)
On account_tax_account_tag
account_tax_account_tag_account_tax_id_idx (account_tax_id)
is covered by
account_tax_account_tag_account_tax_id_account_account_tag__key (account_tax_id, account_account_tag_id)
On account_tax_filiation_rel
account_tax_filiation_rel_parent_tax_idx (parent_tax)
is covered by
account_tax_filiation_rel_parent_tax_child_tax_key (parent_tax, child_tax)
On account_tax_template_filiation_rel
account_tax_template_filiation_rel_parent_tax_idx (parent_tax)
is covered by
account_tax_template_filiation_rel_parent_tax_child_tax_key (parent_tax, child_tax)
On afx_ringi_manager_hr_department_rel
afx_ringi_manager_hr_department_rel_afx_ringi_manager_id_idx (afx_ringi_manager_id)
is covered by
afx_ringi_manager_hr_departme_afx_ringi_manager_id_hr_depar_key (afx_ringi_manager_id, hr_department_id)
On afx_ringi_manager_hr_employee_rel
afx_ringi_manager_hr_employee_rel_afx_ringi_manager_id_idx (afx_ringi_manager_id)
is covered by
afx_ringi_manager_hr_employee_afx_ringi_manager_id_hr_emplo_key (afx_ringi_manager_id, hr_employee_id)
On afx_ringi_manager_res_users_rel
afx_ringi_manager_res_users_rel_afx_ringi_manager_id_idx (afx_ringi_manager_id)
is covered by
afx_ringi_manager_res_users_r_afx_ringi_manager_id_res_user_key (afx_ringi_manager_id, res_users_id)
On audittail_rules_users
audittail_rules_users_user_id_idx (user_id)
is covered by
audittail_rules_users_user_id_rule_id_key (user_id, rule_id)
On base_language_install_website_rel
base_language_install_website_rel_base_language_install_id_idx (base_language_install_id)
is covered by
base_language_install_website_base_language_install_id_webs_key (base_language_install_id, website_id)
On base_partner_merge_automatic_wizard_res_partner_rel
base_partner_merge_automatic__base_partner_merge_automatic__idx (base_partner_merge_automatic_wizard_id)
is covered by
base_partner_merge_automatic__base_partner_merge_automatic__key (base_partner_merge_automatic_wizard_id, res_partner_id)
On bus_presence
bus_presence_user_id_index (user_id)
is covered by
bus_presence_bus_user_presence_unique (user_id)
On calendar_alarm_calendar_event_rel
calendar_alarm_calendar_event_rel_calendar_event_id_idx (calendar_event_id)
is covered by
calendar_alarm_calendar_event_calendar_event_id_calendar_al_key (calendar_event_id, calendar_alarm_id)
On calendar_event_res_partner_rel
calendar_event_res_partner_rel_calendar_event_id_idx (calendar_event_id)
is covered by
calendar_event_res_partner_re_calendar_event_id_res_partner_key (calendar_event_id, res_partner_id)
On crm_lead2opportunity_partner_mass_res_users_rel
crm_lead2opportunity_partner__crm_lead2opportunity_partner__idx (crm_lead2opportunity_partner_mass_id)
is covered by
crm_lead2opportunity_partner__crm_lead2opportunity_partner__key (crm_lead2opportunity_partner_mass_id, res_users_id)
On crm_lead_crm_lead2opportunity_partner_mass_rel
crm_lead_crm_lead2opportunity_crm_lead2opportunity_partner_idx1 (crm_lead2opportunity_partner_mass_id)
is covered by
crm_lead_crm_lead2opportunity_crm_lead2opportunity_partner_key1 (crm_lead2opportunity_partner_mass_id, crm_lead_id)
On crm_lead_crm_lead2opportunity_partner_rel
crm_lead_crm_lead2opportunity_crm_lead2opportunity_partner__idx (crm_lead2opportunity_partner_id)
is covered by
crm_lead_crm_lead2opportunity_crm_lead2opportunity_partner__key (crm_lead2opportunity_partner_id, crm_lead_id)
On crm_lead_tag_rel
crm_lead_tag_rel_lead_id_idx (lead_id)
is covered by
crm_lead_tag_rel_lead_id_tag_id_key (lead_id, tag_id)
On customer_statement_report_view_rel
customer_statement_report_view_rel_download_pdf_report_id_idx (download_pdf_report_id)
is covered by
customer_statement_report_vie_download_pdf_report_id_view_p_key (download_pdf_report_id, view_pdf_report_id)
On decimal_precision
decimal_precision_name_index (name)
is covered by
decimal_precision_name_uniq (name)
On digest_digest_res_users_rel
digest_digest_res_users_rel_digest_digest_id_idx (digest_digest_id)
is covered by
digest_digest_res_users_rel_digest_digest_id_res_users_id_key (digest_digest_id, res_users_id)
On digest_tip_res_users_rel
digest_tip_res_users_rel_digest_tip_id_idx (digest_tip_id)
is covered by
digest_tip_res_users_rel_digest_tip_id_res_users_id_key (digest_tip_id, res_users_id)
On email_template_attachment_rel
email_template_attachment_rel_email_template_id_idx (email_template_id)
is covered by
email_template_attachment_rel_email_template_id_attachment__key (email_template_id, attachment_id)
On email_template_preview_res_partner_rel
email_template_preview_res_partne_email_template_preview_id_idx (email_template_preview_id)
is covered by
email_template_preview_res_pa_email_template_preview_id_res_key (email_template_preview_id, res_partner_id)
On employee_category_rel
employee_category_rel_category_id_idx (category_id)
is covered by
employee_category_rel_category_id_emp_id_key (category_id, emp_id)
On fx_group_mapping_fx_group_mapping_transient_rel
fx_group_mapping_fx_group_map_fx_group_mapping_transient_id_idx (fx_group_mapping_transient_id)
is covered by
fx_group_mapping_fx_group_map_fx_group_mapping_transient_id_key (fx_group_mapping_transient_id, fx_group_mapping_id)
On fx_mt5_log_search_fx_mt5_log_year_rel
fx_mt5_log_search_fx_mt5_log_year_rel_fx_mt5_log_search_id_idx (fx_mt5_log_search_id)
is covered by
fx_mt5_log_search_fx_mt5_log__fx_mt5_log_search_id_fx_mt5_l_key (fx_mt5_log_search_id, fx_mt5_log_year_id)
On fx_report_groups_symbols_daily
index_fx_report_groups_symbols_daily_group_id (Group_ID)
is covered by
IDX_fx_report_symbols_group_id (Group_ID)
On hr_department_mail_channel_rel
hr_department_mail_channel_rel_mail_channel_id_idx (mail_channel_id)
is covered by
hr_department_mail_channel_re_mail_channel_id_hr_department_key (mail_channel_id, hr_department_id)
On hr_job
hr_job_name_index (name)
is covered by
hr_job_name_company_uniq (name, company_id, department_id)
On ir_act_server_mail_channel_rel
ir_act_server_mail_channel_rel_ir_act_server_id_idx (ir_act_server_id)
is covered by
ir_act_server_mail_channel_re_ir_act_server_id_mail_channel_key (ir_act_server_id, mail_channel_id)
On ir_act_server_res_partner_rel
ir_act_server_res_partner_rel_ir_act_server_id_idx (ir_act_server_id)
is covered by
ir_act_server_res_partner_rel_ir_act_server_id_res_partner__key (ir_act_server_id, res_partner_id)
On ir_act_window_group_rel
ir_act_window_group_rel_act_id_idx (act_id)
is covered by
ir_act_window_group_rel_act_id_gid_key (act_id, gid)
On ir_config_parameter
ir_config_parameter_key_index (key)
is covered by
ir_config_parameter_key_uniq (key)
On ir_model
ir_model_model_index (model)
is covered by
ir_model_obj_name_uniq (model)
On ir_model_constraint
ir_model_constraint_name_index (name)
is covered by
ir_model_constraint_module_name_uniq (name, module)
On ir_model_fields
ir_model_fields_model_index (model)
is covered by
ir_model_fields_name_unique (model, name)
On ir_model_fields_group_rel
ir_model_fields_group_rel_field_id_idx (field_id)
is covered by
ir_model_fields_group_rel_field_id_group_id_key (field_id, group_id)
On ir_module_module
ir_module_module_name_index (name)
is covered by
name_uniq (name)
On ir_ui_menu_group_rel
ir_ui_menu_group_rel_menu_id_idx (menu_id)
is covered by
ir_ui_menu_group_rel_menu_id_gid_key (menu_id, gid)
On ir_ui_view
ir_ui_view_model_index (model)
is covered by
ir_ui_view_model_type_inherit_id (model, inherit_id)
On ir_ui_view_custom
ir_ui_view_custom_user_id_index (user_id)
is covered by
ir_ui_view_custom_user_id_ref_id (user_id, ref_id)
On ir_ui_view_group_rel
ir_ui_view_group_rel_view_id_idx (view_id)
is covered by
ir_ui_view_group_rel_view_id_group_id_key (view_id, group_id)
On mail_activity_rel
mail_activity_rel_activity_id_idx (activity_id)
is covered by
mail_activity_rel_activity_id_recommended_id_key (activity_id, recommended_id)
On mail_activity_type_mail_template_rel
mail_activity_type_mail_template_rel_mail_activity_type_id_idx (mail_activity_type_id)
is covered by
mail_activity_type_mail_templ_mail_activity_type_id_mail_te_key (mail_activity_type_id, mail_template_id)
On mail_blacklist
mail_blacklist_email_index (email)
is covered by
mail_blacklist_unique_email (email)
On mail_channel_mail_wizard_invite_rel
mail_channel_mail_wizard_invite_rel_mail_wizard_invite_id_idx (mail_wizard_invite_id)
is covered by
mail_channel_mail_wizard_invi_mail_wizard_invite_id_mail_ch_key (mail_wizard_invite_id, mail_channel_id)
On mail_channel_moderator_rel
mail_channel_moderator_rel_mail_channel_id_idx (mail_channel_id)
is covered by
mail_channel_moderator_rel_mail_channel_id_res_users_id_key (mail_channel_id, res_users_id)
On mail_channel_res_groups_rel
mail_channel_res_groups_rel_mail_channel_id_idx (mail_channel_id)
is covered by
mail_channel_res_groups_rel_mail_channel_id_res_groups_id_key (mail_channel_id, res_groups_id)
On mail_compose_message_ir_attachments_rel
mail_compose_message_ir_attachments_rel_wizard_id_idx (wizard_id)
is covered by
mail_compose_message_ir_attachments_wizard_id_attachment_id_key (wizard_id, attachment_id)
On mail_compose_message_mail_mass_mailing_list_rel
mail_compose_message_mail_mass_mail_mail_compose_message_id_idx (mail_compose_message_id)
is covered by
mail_compose_message_mail_mas_mail_compose_message_id_mail__key (mail_compose_message_id, mail_mass_mailing_list_id)
On mail_compose_message_res_partner_rel
mail_compose_message_res_partner_rel_wizard_id_idx (wizard_id)
is covered by
mail_compose_message_res_partner_rel_wizard_id_partner_id_key (wizard_id, partner_id)
On mail_followers
mail_followers_res_model_index (res_model)
is covered by
mail_followers_mail_followers_res_channel_res_model_id_uniq (res_model, res_id, channel_id)
On mail_followers_mail_message_subtype_rel
mail_followers_mail_message_subtype_rel_mail_followers_id_idx (mail_followers_id)
is covered by
mail_followers_mail_message_s_mail_followers_id_mail_messag_key (mail_followers_id, mail_message_subtype_id)
On mail_mail_res_partner_rel
mail_mail_res_partner_rel_mail_mail_id_idx (mail_mail_id)
is covered by
mail_mail_res_partner_rel_mail_mail_id_res_partner_id_key (mail_mail_id, res_partner_id)
On mail_mass_mailing_contact_res_partner_category_rel
mail_mass_mailing_contact_res__mail_mass_mailing_contact_id_idx (mail_mass_mailing_contact_id)
is covered by
mail_mass_mailing_contact_res_mail_mass_mailing_contact_id__key (mail_mass_mailing_contact_id, res_partner_category_id)
On mail_mass_mailing_list_mass_mailing_list_merge_rel
mail_mass_mailing_list_mass_mail_mass_mailing_list_merge_id_idx (mass_mailing_list_merge_id)
is covered by
mail_mass_mailing_list_mass_m_mass_mailing_list_merge_id_ma_key (mass_mailing_list_merge_id, mail_mass_mailing_list_id)
On mail_mass_mailing_list_rel
mail_mass_mailing_list_rel_mail_mass_mailing_id_idx (mail_mass_mailing_id)
is covered by
mail_mass_mailing_list_rel_mail_mass_mailing_id_mail_mass_m_key (mail_mass_mailing_id, mail_mass_mailing_list_id)
On mail_mass_mailing_list_survey_mail_compose_message_rel
mail_mass_mailing_list_survey_survey_mail_compose_message_i_idx (survey_mail_compose_message_id)
is covered by
mail_mass_mailing_list_survey_survey_mail_compose_message_i_key (survey_mail_compose_message_id, mail_mass_mailing_list_id)
On mail_mass_mailing_tag_rel
mail_mass_mailing_tag_rel_tag_id_idx (tag_id)
is covered by
mail_mass_mailing_tag_rel_tag_id_campaign_id_key (tag_id, campaign_id)
On mail_message
mail_message_model_index (model)
is covered by
mail_message_model_res_id_idx (model, res_id)
On mail_message_mail_channel_rel
mail_message_mail_channel_rel_mail_message_id_idx (mail_message_id)
is covered by
mail_message_mail_channel_rel_mail_message_id_mail_channel__key (mail_message_id, mail_channel_id)
On mail_message_res_partner_needaction_rel
mail_message_res_partner_needaction_rel_res_partner_id_index (res_partner_id)
is covered by
mail_notification_res_partner_id_is_read_email_status_mail_mess (res_partner_id, is_read, email_status, mail_message_id)
On mail_message_res_partner_needaction_rel_mail_resend_message_rel
mail_message_res_partner_needaction__mail_resend_message_id_idx (mail_resend_message_id)
is covered by
mail_message_res_partner_need_mail_resend_message_id_mail_m_key (mail_resend_message_id, mail_message_res_partner_needaction_rel_id)
On mail_message_res_partner_rel
mail_message_res_partner_rel_mail_message_id_idx (mail_message_id)
is covered by
mail_message_res_partner_rel_mail_message_id_res_partner_id_key (mail_message_id, res_partner_id)
On mail_message_res_partner_starred_rel
mail_message_res_partner_starred_rel_mail_message_id_idx (mail_message_id)
is covered by
mail_message_res_partner_star_mail_message_id_res_partner_i_key (mail_message_id, res_partner_id)
On mail_moderation
mail_moderation_email_index (email)
is covered by
mail_moderation_channel_email_uniq (email, channel_id)
On mail_wizard_invite_res_partner_rel
mail_wizard_invite_res_partner_rel_mail_wizard_invite_id_idx (mail_wizard_invite_id)
is covered by
mail_wizard_invite_res_partne_mail_wizard_invite_id_res_par_key (mail_wizard_invite_id, res_partner_id)
On mass_mailing_ir_attachments_rel
mass_mailing_ir_attachments_rel_mass_mailing_id_idx (mass_mailing_id)
is covered by
mass_mailing_ir_attachments_r_mass_mailing_id_attachment_id_key (mass_mailing_id, attachment_id)
On meeting_category_rel
meeting_category_rel_event_id_idx (event_id)
is covered by
meeting_category_rel_event_id_type_id_key (event_id, type_id)
On merge_opportunity_rel
merge_opportunity_rel_merge_id_idx (merge_id)
is covered by
merge_opportunity_rel_merge_id_opportunity_id_key (merge_id, opportunity_id)
On message_attachment_rel
message_attachment_rel_message_id_idx (message_id)
is covered by
message_attachment_rel_message_id_attachment_id_key (message_id, attachment_id)
On mt5_users
index_mt5_users_login (Login)
is covered by
PK_mt5_users (Login)
On mts_order_history_group_mts_order_revision_rel
mts_order_history_group_mts_orde_mts_order_history_group_id_idx (mts_order_history_group_id)
is covered by
mts_order_history_group_mts_o_mts_order_history_group_id_mt_key (mts_order_history_group_id, mts_order_revision_id)
On mts_orders_mts_orders_group_rel
mts_orders_mts_orders_group_rel_mts_orders_group_id_idx (mts_orders_group_id)
is covered by
mts_orders_mts_orders_group_r_mts_orders_group_id_mts_order_key (mts_orders_group_id, mts_orders_id)
On mts_portfolio_st_sec_transfer_rel
mts_portfolio_st_sec_transfer_rel_st_sec_transfer_id_idx (st_sec_transfer_id)
is covered by
mts_portfolio_st_sec_transfer_st_sec_transfer_id_mts_portfo_key (st_sec_transfer_id, mts_portfolio_id)
On payment_acquirer_payment_icon_rel
payment_acquirer_payment_icon_rel_payment_acquirer_id_idx (payment_acquirer_id)
is covered by
payment_acquirer_payment_icon_payment_acquirer_id_payment_i_key (payment_acquirer_id, payment_icon_id)
On payment_country_rel
payment_country_rel_payment_id_idx (payment_id)
is covered by
payment_country_rel_payment_id_country_id_key (payment_id, country_id)
On payment_transaction
payment_transaction_reference_index (reference)
is covered by
payment_transaction_reference_uniq (reference)
On portal_share_res_partner_rel
portal_share_res_partner_rel_portal_share_id_idx (portal_share_id)
is covered by
portal_share_res_partner_rel_portal_share_id_res_partner_id_key (portal_share_id, res_partner_id)
On product_attr_exclusion_value_ids_rel
product_attr_exclusion_value__product_template_attribute_ex_idx (product_template_attribute_exclusion_id)
is covered by
product_attr_exclusion_value__product_template_attribute_ex_key (product_template_attribute_exclusion_id, product_template_attribute_value_id)
On product_attribute_value_product_product_rel
product_attribute_value_product_product__product_product_id_idx (product_product_id)
is covered by
product_attribute_value_produ_product_product_id_product_at_key (product_product_id, product_attribute_value_id)
On product_attribute_value_product_template_attribute_line_rel
product_attribute_value_produ_product_template_attribute_li_idx (product_template_attribute_line_id)
is covered by
product_attribute_value_produ_product_template_attribute_li_key (product_template_attribute_line_id, product_attribute_value_id)
On product_supplier_taxes_rel
product_supplier_taxes_rel_prod_id_idx (prod_id)
is covered by
product_supplier_taxes_rel_prod_id_tax_id_key (prod_id, tax_id)
On product_taxes_rel
product_taxes_rel_prod_id_idx (prod_id)
is covered by
product_taxes_rel_prod_id_tax_id_key (prod_id, tax_id)
On rel_modules_langexport
rel_modules_langexport_wiz_id_idx (wiz_id)
is covered by
rel_modules_langexport_wiz_id_module_id_key (wiz_id, module_id)
On rel_server_actions
rel_server_actions_server_id_idx (server_id)
is covered by
rel_server_actions_server_id_action_id_key (server_id, action_id)
On res_company_users_rel
res_company_users_rel_cid_idx (cid)
is covered by
res_company_users_rel_cid_user_id_key (cid, user_id)
On res_country_group_pricelist_rel
res_country_group_pricelist_rel_pricelist_id_idx (pricelist_id)
is covered by
res_country_group_pricelist_r_pricelist_id_res_country_grou_key (pricelist_id, res_country_group_id)
On res_country_res_country_group_rel
res_country_res_country_group_rel_res_country_id_idx (res_country_id)
is covered by
res_country_res_country_group_res_country_id_res_country_gr_key (res_country_id, res_country_group_id)
On res_currency_rate
res_currency_rate_name_index (name)
is covered by
res_currency_rate_unique_name_per_day (name, currency_id, company_id)
On res_groups
res_groups_category_id_index (category_id)
is covered by
res_groups_name_uniq (category_id, name)
On res_groups_implied_rel
res_groups_implied_rel_gid_idx (gid)
is covered by
res_groups_implied_rel_gid_hid_key (gid, hid)
On res_groups_report_rel
res_groups_report_rel_uid_idx (uid)
is covered by
res_groups_report_rel_uid_gid_key (uid, gid)
On res_groups_users_rel
res_groups_users_rel_gid_idx (gid)
is covered by
res_groups_users_rel_gid_uid_key (gid, uid)
On res_partner_category_res_partner_pass_rel
res_partner_category_res_partner_pass_rel_partner_id_idx (partner_id)
is covered by
res_partner_category_res_partner_pas_partner_id_category_id_key (partner_id, category_id)
On res_partner_res_partner_category_rel
res_partner_res_partner_category_rel_category_id_idx (category_id)
is covered by
res_partner_res_partner_category_rel_category_id_partner_id_key (category_id, partner_id)
On rule_group_rel
rule_group_rel_rule_group_id_idx (rule_group_id)
is covered by
rule_group_rel_rule_group_id_group_id_key (rule_group_id, group_id)
On snailmail_letter_account_invoice_send_rel
snailmail_letter_account_invoice_se_account_invoice_send_id_idx (account_invoice_send_id)
is covered by
snailmail_letter_account_invo_account_invoice_send_id_snail_key (account_invoice_send_id, snailmail_letter_id)
On survey_mail_compose_message_ir_attachments_rel
survey_mail_compose_message_ir_attachments_rel_wizard_id_idx (wizard_id)
is covered by
survey_mail_compose_message_ir_atta_wizard_id_attachment_id_key (wizard_id, attachment_id)
On survey_mail_compose_message_res_partner_rel
survey_mail_compose_message_res_partner_rel_wizard_id_idx (wizard_id)
is covered by
survey_mail_compose_message_res_partne_wizard_id_partner_id_key (wizard_id, partner_id)
On survey_user_input_line_survey_user_input_line_transient_rel
survey_user_input_line_survey_survey_user_input_line_transi_idx (survey_user_input_line_transient_id)
is covered by
survey_user_input_line_survey_survey_user_input_line_transi_key (survey_user_input_line_transient_id, survey_user_input_line_id)
On team_favorite_user_rel
team_favorite_user_rel_team_id_idx (team_id)
is covered by
team_favorite_user_rel_team_id_user_id_key (team_id, user_id)
On view_assignee_user_ringi
view_assignee_user_ringi_afx_ringi_manager_id_idx (afx_ringi_manager_id)
is covered by
view_assignee_user_ringi_afx_ringi_manager_id_res_users_id_key (afx_ringi_manager_id, res_users_id)
On website_country_group_rel
website_country_group_rel_website_id_idx (website_id)
is covered by
website_country_group_rel_website_id_country_group_id_key (website_id, country_group_id)
On website_lang_rel
website_lang_rel_website_id_idx (website_id)
is covered by
website_lang_rel_website_id_lang_id_key (website_id, lang_id)

Suggested Indexes

Add indexes to speed up queries.


Details
CREATE INDEX CONCURRENTLY ON fx_market_news (content_id)

to speed up

Total Time Average Time Calls
41 min 1.0% 35 ms 70,893 afxprodapiusr
select content_id, category, subject, body
                        from fx_market_news
                        where news_id < $1 and content_id = $2
                        and category = $3 and subject = $4
                        and body = $5 and push_flg = $6

Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)

to speed up

Total Time Average Time Calls
239 min 6% 34 ms 424,214 afxprodapiusr
select news_id, content_id, publish_date, category, subject, body, status 
            from fx_market_news where news_id > $1 and push_flg = $2 order by news_id desc
63 min 1% 58 ms 65,019 afxprodapiusr
update fx_market_news
                        set push_flg = $1 
                        where news_id = $2

Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)

to speed up

Total Time Average Time Calls
16 min 0.4% 114 ms 8,600 afxprodapiusr
UPDATE "fx_news_trace" SET "read_flg" = $1 WHERE ("fx_news_trace"."active" = $2 AND "fx_news_trace"."news_id" = $3 AND "fx_news_trace"."partner_id" = $4)
6 min 0.1% 43 ms 8,290 afxprodapiusr
SELECT "fx_news_trace"."id", "fx_news_trace"."news_id", "fx_news_trace"."partner_id", "fx_news_trace"."active", "fx_news_trace"."read_flg", "fx_news_trace"."agree_flg", "fx_news_trace"."create_date", "fx_news_trace"."write_date", "fx_news_trace"."create_uid", "fx_news_trace"."write_uid", "fx_news_trace"."agree_date" FROM "fx_news_trace" WHERE ("fx_news_trace"."active" = $1 AND "fx_news_trace"."news_id" = $2 AND "fx_news_trace"."partner_id" = $3) ORDER BY "fx_news_trace"."id" ASC LIMIT $4

Details
CREATE INDEX CONCURRENTLY ON fx_report_company (account_type)

to speed up

Total Time Average Time Calls
8 min 0.2% 200 ms 2,378 odoo
SELECT count($1) FROM "fx_report_company" WHERE ("fx_report_company"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_company"."company_id" in ($6))

Details
CREATE INDEX CONCURRENTLY ON fx_report_partner (account_type)

to speed up

Total Time Average Time Calls
13 min 0.3% 214 ms 3,604 odoo
SELECT count($1) FROM "fx_report_partner" WHERE ("fx_report_partner"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_partner"."company_id" in ($6))

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
239 min 6% 34 ms 424,214 afxprodapiusr
select news_id, content_id, publish_date, category, subject, body, status 
            from fx_market_news where news_id > $1 and push_flg = $2 order by news_id desc
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
182 min 4% 26 ms 424,214 afxprodapiusr
select MAX(news_id) from fx_market_news
63 min 1% 58 ms 65,019 afxprodapiusr
update fx_market_news
                        set push_flg = $1 
                        where news_id = $2
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (news_id)
41 min 1.0% 35 ms 70,893 afxprodapiusr
select content_id, category, subject, body
                        from fx_market_news
                        where news_id < $1 and content_id = $2
                        and category = $3 and subject = $4
                        and body = $5 and push_flg = $6
Details
CREATE INDEX CONCURRENTLY ON fx_market_news (content_id)
20 min 0.5% 948 ms 1,285 odoo
SELECT count($1) FROM "fx_report_company" WHERE (("fx_report_company"."account_type" in ($2,$3,$4,$5))  AND  ("fx_report_company"."file_name"::text ilike $6)) AND ("fx_report_company"."company_id" in ($7))
16 min 0.4% 114 ms 8,600 afxprodapiusr
UPDATE "fx_news_trace" SET "read_flg" = $1 WHERE ("fx_news_trace"."active" = $2 AND "fx_news_trace"."news_id" = $3 AND "fx_news_trace"."partner_id" = $4)
Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)
13 min 0.3% 222 ms 3,533 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
13 min 0.3% 214 ms 3,604 odoo
SELECT count($1) FROM "fx_report_partner" WHERE ("fx_report_partner"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_partner"."company_id" in ($6))
Details
CREATE INDEX CONCURRENTLY ON fx_report_partner (account_type)
11 min 0.3% 225 ms 2,969 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
10 min 0.2% 60 ms 10,100 afxprodbakusr
SELECT  SE.STEP_EXECUTION_ID, SE.STEP_NAME, SE.START_TIME, SE.END_TIME, SE.STATUS, SE.COMMIT_COUNT, SE.READ_COUNT, SE.FILTER_COUNT, SE.WRITE_COUNT, SE.EXIT_CODE, SE.EXIT_MESSAGE, SE.READ_SKIP_COUNT, SE.WRITE_SKIP_COUNT, SE.PROCESS_SKIP_COUNT, SE.ROLLBACK_COUNT, SE.LAST_UPDATED, SE.VERSION, JE.JOB_EXECUTION_ID, JE.START_TIME, JE.END_TIME, JE.STATUS, JE.EXIT_CODE, JE.EXIT_MESSAGE, JE.CREATE_TIME, JE.LAST_UPDATED, JE.VERSION from BATCH_JOB_EXECUTION JE, BATCH_STEP_EXECUTION SE where       SE.JOB_EXECUTION_ID in (SELECT JOB_EXECUTION_ID from BATCH_JOB_EXECUTION where JE.JOB_INSTANCE_ID = $1)      and SE.JOB_EXECUTION_ID = JE.JOB_EXECUTION_ID       and SE.STEP_NAME = $2 order by SE.START_TIME desc, SE.STEP_EXECUTION_ID desc
8 min 0.2% 200 ms 2,378 odoo
SELECT count($1) FROM "fx_report_company" WHERE ("fx_report_company"."account_type" in ($2,$3,$4,$5)) AND ("fx_report_company"."company_id" in ($6))
Details
CREATE INDEX CONCURRENTLY ON fx_report_company (account_type)
6 min 0.1% 43 ms 8,290 afxprodapiusr
SELECT "fx_news_trace"."id", "fx_news_trace"."news_id", "fx_news_trace"."partner_id", "fx_news_trace"."active", "fx_news_trace"."read_flg", "fx_news_trace"."agree_flg", "fx_news_trace"."create_date", "fx_news_trace"."write_date", "fx_news_trace"."create_uid", "fx_news_trace"."write_uid", "fx_news_trace"."agree_date" FROM "fx_news_trace" WHERE ("fx_news_trace"."active" = $1 AND "fx_news_trace"."news_id" = $2 AND "fx_news_trace"."partner_id" = $3) ORDER BY "fx_news_trace"."id" ASC LIMIT $4
Details
CREATE INDEX CONCURRENTLY ON fx_news_trace (partner_id, news_id)
5 min 0.1% 108 ms 2,699 afxprodapiusr
SELECT * FROM (SELECT n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull OR (t.typtype = $1 AND t.typnotnull) AS attnotnull,a.atttypmod,a.attlen,t.typtypmod,row_number() OVER (PARTITION BY a.attrelid ORDER BY a.attnum) AS attnum, nullif(a.attidentity, $2) as attidentity,nullif(a.attgenerated, $3) as attgenerated,pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS adsrc,dsc.description,t.typbasetype,t.typtype  FROM pg_catalog.pg_namespace n  JOIN pg_catalog.pg_class c ON (c.relnamespace = n.oid)  JOIN pg_catalog.pg_attribute a ON (a.attrelid=c.oid)  JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid)  LEFT JOIN pg_catalog.pg_attrdef def ON (a.attrelid=def.adrelid AND a.attnum = def.adnum)  LEFT JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)  LEFT JOIN pg_catalog.pg_class dc ON (dc.oid=dsc.classoid AND dc.relname=$4)  LEFT JOIN pg_catalog.pg_namespace dn ON (dc.relnamespace=dn.oid AND dn.nspname=$5)  WHERE c.relkind in ($6,$7,$8,$9,$10) and a.attnum > $11 AND NOT a.attisdropped  AND n.nspname LIKE $12) c WHERE $13  AND attname LIKE $14 ORDER BY nspname,c.relname,attnum
3 min < 0.1% 243 ms 840 afxprodbakusr
INSERT INTO fx_report_positions_daily (report_date, "Position_ID", "Position", "ExternalID", "Login", "Dealer", "Timestamp", "Symbol", "Action", "Digits", "DigitsCurrency", "Reason", "ContractSize", "TimeCreate", "TimeUpdate", "TimeCreateMsc", "TimeUpdateMsc", "PriceOpen", "PriceCurrent", "PriceSL", "PriceTP", "VolumeExt", "Profit", "Storage", "RateProfit", "RateMargin", "ExpertID", "ExpertPositionID", "Comment", "ActivationMode", "ActivationTime", "ActivationPrice", "ActivationFlags", "Volume", "ApiData", "timing", company_id) SELECT $1 as report_date, mp."Position_ID" as position_id, mp."Position" as position, mp."ExternalID" as externalId, mp."Login" as login, mp."Dealer" as dealer, mp."Timestamp" as timestamp, mp."Symbol" as symbol, mp."Action" as action, mp."Digits" as digits, mp."DigitsCurrency" as digits_currency, mp."Reason" as reason, mp."ContractSize" as contract_size, mp."TimeCreate" as time_create, mp."TimeUpdate" as time_update, mp."TimeCreateMsc" as time_create_msc, mp."TimeUpdateMsc" as time_update_msc, mp."PriceOpen" as price_open, mp."PriceCurrent" as price_current, mp."PriceSL" as priceSl, mp."PriceTP" as priceTp, mp."VolumeExt" as volume_ext, mp."Profit" as profit, mp."Storage" as storage, mp."RateProfit" as rate_profit, mp."RateMargin" as rate_margin, mp."ExpertID" as expertId, mp."ExpertPositionID" as expert_positionId, mp."Comment" as comment, mp."ActivationMode" as activation_mode, mp."ActivationTime" as activation_time, mp."ActivationPrice" as activation_price, mp."ActivationFlags" as activation_flags, mp."Volume" as volume, mp."ApiData" as api_data, $2 as timing, $3 as company_id FROM mt5_positions as mp WHERE FLOOR(mp."Login" / $5) = $4
3 min < 0.1% 64 ms 3,094 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96)
3 min < 0.1% 146 ms 1,311 odoo
SELECT "fx_report_company".id FROM "fx_report_company" WHERE (("fx_report_company"."account_type" in ($1,$2,$3,$4))  AND  ("fx_report_company"."file_name"::text ilike $5)) AND ("fx_report_company"."company_id" in ($6)) ORDER BY "fx_report_company"."report_date" DESC,"fx_report_company"."file_name"   limit $7
3 min < 0.1% 65 ms 2,628 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96)
3 min < 0.1% 217 ms 780 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
3 min < 0.1% 221 ms 730 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."write_uid" as "write_uid","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."relation_field_id" as "relation_field_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."model_id" as "model_id","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."create_uid" as "create_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63, $64, $65, $66, $67, $68, $69, $70, $71, $72, $73, $74, $75, $76, $77, $78, $79, $80, $81, $82, $83, $84, $85, $86, $87, $88, $89, $90, $91, $92, $93, $94, $95, $96, $97, $98, $99, $100, $101, $102, $103, $104, $105, $106, $107, $108, $109, $110, $111, $112, $113, $114, $115, $116, $117, $118, $119, $120, $121, $122, $123, $124, $125, $126, $127, $128, $129, $130, $131, $132, $133, $134, $135, $136, $137, $138, $139, $140, $141, $142, $143, $144, $145, $146, $147, $148, $149, $150, $151, $152, $153, $154, $155, $156, $157, $158, $159, $160, $161, $162, $163, $164, $165, $166, $167, $168, $169, $170, $171, $172, $173, $174, $175, $176, $177, $178, $179, $180, $181, $182, $183, $184, $185, $186, $187, $188, $189, $190, $191, $192, $193, $194, $195, $196, $197, $198, $199, $200, $201, $202, $203, $204, $205, $206, $207, $208, $209, $210, $211, $212, $213, $214, $215, $216, $217, $218, $219, $220, $221, $222, $223, $224, $225, $226, $227, $228, $229, $230, $231, $232, $233, $234, $235, $236, $237, $238, $239, $240, $241, $242, $243, $244, $245, $246, $247, $248, $249, $250, $251, $252, $253, $254, $255, $256, $257, $258, $259, $260, $261, $262, $263, $264, $265, $266, $267, $268, $269, $270, $271, $272, $273, $274, $275, $276, $277, $278, $279, $280, $281, $282, $283, $284, $285, $286, $287, $288, $289, $290, $291, $292, $293, $294, $295, $296, $297, $298, $299, $300, $301, $302, $303, $304, $305, $306, $307, $308, $309, $310, $311, $312, $313, $314, $315, $316, $317, $318, $319, $320, $321, $322, $323, $324, $325, $326, $327, $328, $329, $330, $331, $332, $333, $334, $335, $336, $337, $338, $339, $340, $341, $342, $343, $344, $345, $346, $347, $348, $349, $350)
2 min < 0.1% 56 ms 2,331 stoprodbakusr
SELECT  SE.STEP_EXECUTION_ID, SE.STEP_NAME, SE.START_TIME, SE.END_TIME, SE.STATUS, SE.COMMIT_COUNT, SE.READ_COUNT, SE.FILTER_COUNT, SE.WRITE_COUNT, SE.EXIT_CODE, SE.EXIT_MESSAGE, SE.READ_SKIP_COUNT, SE.WRITE_SKIP_COUNT, SE.PROCESS_SKIP_COUNT, SE.ROLLBACK_COUNT, SE.LAST_UPDATED, SE.VERSION, JE.JOB_EXECUTION_ID, JE.START_TIME, JE.END_TIME, JE.STATUS, JE.EXIT_CODE, JE.EXIT_MESSAGE, JE.CREATE_TIME, JE.LAST_UPDATED, JE.VERSION from BATCH_JOB_EXECUTION JE, BATCH_STEP_EXECUTION SE where       SE.JOB_EXECUTION_ID in (SELECT JOB_EXECUTION_ID from BATCH_JOB_EXECUTION where JE.JOB_INSTANCE_ID = $1)      and SE.JOB_EXECUTION_ID = JE.JOB_EXECUTION_ID       and SE.STEP_NAME = $2 order by SE.START_TIME desc, SE.STEP_EXECUTION_ID desc
2 min < 0.1% 23 ms 5,219 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31)
2 min < 0.1% 44 ms 2,614 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63)
2 min < 0.1% 42 ms 2,604 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61)
2 min < 0.1% 23 ms 4,514 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31)
2 min < 0.1% 44 ms 2,258 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61, $62, $63)
2 min < 0.1% 36 ms 2,663 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related" as "related","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51)
2 min < 0.1% 42 ms 2,253 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51, $52, $53, $54, $55, $56, $57, $58, $59, $60, $61)
1 min < 0.1% 37 ms 2,291 odoo
SELECT "ir_model_fields"."id" as "id","ir_model_fields"."complete_name" as "complete_name",COALESCE("ir_model_fields__help"."value", "ir_model_fields"."help") as "help","ir_model_fields"."create_date" as "create_date","ir_model_fields"."size" as "size","ir_model_fields"."selection" as "selection","ir_model_fields"."model_id" as "model_id","ir_model_fields"."copied" as "copied","ir_model_fields"."model" as "model","ir_model_fields"."relation_table" as "relation_table","ir_model_fields"."write_date" as "write_date","ir_model_fields"."selectable" as "selectable","ir_model_fields"."related" as "related","ir_model_fields"."track_visibility" as "track_visibility","ir_model_fields"."related_field_id" as "related_field_id","ir_model_fields"."required" as "required","ir_model_fields"."relation" as "relation","ir_model_fields"."column1" as "column1","ir_model_fields"."compute" as "compute","ir_model_fields"."state" as "state","ir_model_fields"."create_uid" as "create_uid","ir_model_fields"."readonly" as "readonly","ir_model_fields"."relation_field" as "relation_field","ir_model_fields"."column2" as "column2","ir_model_fields"."store" as "store","ir_model_fields"."on_delete" as "on_delete","ir_model_fields"."index" as "index","ir_model_fields"."write_uid" as "write_uid",COALESCE("ir_model_fields__field_description"."value", "ir_model_fields"."field_description") as "field_description","ir_model_fields"."depends" as "depends","ir_model_fields"."name" as "name","ir_model_fields"."domain" as "domain","ir_model_fields"."translate" as "translate","ir_model_fields"."ttype" as "ttype","ir_model_fields"."relation_field_id" as "relation_field_id" FROM "ir_model_fields" LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$1 AND name=$2 AND lang=$3 AND value!=$4)
             as "ir_model_fields__help" ON ("ir_model_fields"."id" = "ir_model_fields__help"."res_id") LEFT JOIN 
                (SELECT res_id, value FROM "ir_translation"
                 WHERE type=$5 AND name=$6 AND lang=$7 AND value!=$8)
             as "ir_model_fields__field_description" ON ("ir_model_fields"."id" = "ir_model_fields__field_description"."res_id") WHERE "ir_model_fields".id IN ($9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40, $41, $42, $43, $44, $45, $46, $47, $48, $49, $50, $51)
1 min < 0.1% 114 ms 628 hero
WITH query_stats AS ( SELECT LEFT(query, $1) AS query, queryid AS query_hash, rolname AS user, (total_time / $2 / $3) AS total_minutes, (total_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_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*/
1 min < 0.1% 94 ms 669 hero
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*/
1 min < 0.1% 57 ms 998 pspprodbakusr
SELECT  SE.STEP_EXECUTION_ID, SE.STEP_NAME, SE.START_TIME, SE.END_TIME, SE.STATUS, SE.COMMIT_COUNT, SE.READ_COUNT, SE.FILTER_COUNT, SE.WRITE_COUNT, SE.EXIT_CODE, SE.EXIT_MESSAGE, SE.READ_SKIP_COUNT, SE.WRITE_SKIP_COUNT, SE.PROCESS_SKIP_COUNT, SE.ROLLBACK_COUNT, SE.LAST_UPDATED, SE.VERSION, JE.JOB_EXECUTION_ID, JE.START_TIME, JE.END_TIME, JE.STATUS, JE.EXIT_CODE, JE.EXIT_MESSAGE, JE.CREATE_TIME, JE.LAST_UPDATED, JE.VERSION from BATCH_JOB_EXECUTION JE, BATCH_STEP_EXECUTION SE where       SE.JOB_EXECUTION_ID in (SELECT JOB_EXECUTION_ID from BATCH_JOB_EXECUTION where JE.JOB_INSTANCE_ID = $1)      and SE.JOB_EXECUTION_ID = JE.JOB_EXECUTION_ID       and SE.STEP_NAME = $2 order by SE.START_TIME desc, SE.STEP_EXECUTION_ID desc