explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fHGu

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 0.066 ↓ 0.0 0 1

Delete on document (cost=0.56..4.18 rows=1 width=6) (actual time=0.066..0.066 rows=0 loops=1)

2. 0.032 0.032 ↑ 1.0 1 1

Index Scan using pk_document on document (cost=0.56..4.18 rows=1 width=6) (actual time=0.032..0.032 rows=1 loops=1)

  • Index Cond: (id = '1127492496'::numeric)
Planning time : 0.213 ms
Execution time : 77.763 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint fk_acceptorder_document 0.172 ms 1 0.172 ms
for constraint fk_acceptorderdoc_master_doc 0.097 ms 1 0.097 ms
for constraint fk_acceptorderdoc_slave_doc 0.040 ms 1 0.040 ms
for constraint fk_accjournal_document 0.052 ms 1 0.052 ms
for constraint fk_adv_ann_document 0.044 ms 1 0.044 ms
for constraint fk_agreement_document 0.037 ms 1 0.037 ms
for constraint fk_announcement_document 0.040 ms 1 0.040 ms
for constraint fk_anydoc_document 0.040 ms 1 0.040 ms
for constraint fk_assetact_document 0.041 ms 1 0.041 ms
for constraint fk_aubuinccharge_document 0.039 ms 1 0.039 ms
for constraint fk_backorder_document 0.046 ms 1 0.046 ms
for constraint fk_budgetcodesref_document 0.038 ms 1 0.038 ms
for constraint fk_budgetcodesrefdoc_md 0.038 ms 1 0.038 ms
for constraint fk_budgetcodesrefdoc_sd 0.016 ms 1 0.016 ms
for constraint fk_budgorderlinkdoc_master 0.033 ms 1 0.033 ms
for constraint fk_budgorderlinkdoc_slave 0.032 ms 1 0.032 ms
for constraint fk_cancelreqorder_document 0.084 ms 1 0.084 ms
for constraint fk_cancelreqorder_paydoc 0.038 ms 1 0.038 ms
for constraint fk_cashdeposit_document 0.039 ms 1 0.039 ms
for constraint fk_cashopersummary_document 1.084 ms 1 1.084 ms
for constraint fk_cashorder_document 0.048 ms 1 0.048 ms
for constraint fk_cashplanprogexec_document 0.037 ms 1 0.037 ms
for constraint fk_certicreq_document 0.035 ms 1 0.035 ms
for constraint fk_certreq_document 0.083 ms 1 0.083 ms
for constraint fk_certrevokereq_document 0.090 ms 1 0.090 ms
for constraint fk_chequeorder_document 0.048 ms 1 0.048 ms
for constraint fk_chequeorderdoc_master 0.034 ms 1 0.034 ms
for constraint fk_chequeorderdoc_slave 0.031 ms 1 0.031 ms
for constraint fk_chequeregister_document 0.035 ms 1 0.035 ms
for constraint fk_chequeregisterdoc_master 0.036 ms 1 0.036 ms
for constraint fk_chequeregisterdoc_slave 0.032 ms 1 0.032 ms
for constraint fk_ci_buildact_document 0.035 ms 1 0.035 ms
for constraint fk_ci_contractact_document 0.036 ms 1 0.036 ms
for constraint fk_ci_costorder_document 0.040 ms 1 0.040 ms
for constraint fk_ci_estcalc_document 0.037 ms 1 0.037 ms
for constraint fk_ci_estimate_document 0.037 ms 1 0.037 ms
for constraint fk_ci_judgement_document 0.037 ms 1 0.037 ms
for constraint fk_ci_letter_document 0.035 ms 1 0.035 ms
for constraint fk_ci_measureact_document 0.035 ms 1 0.035 ms
for constraint fk_ci_object_document 0.039 ms 1 0.039 ms
for constraint fk_ci_programobject_document 0.039 ms 1 0.039 ms
for constraint fk_cinf_lines_document 0.038 ms 1 0.038 ms
for constraint fk_clreq_document 0.038 ms 1 0.038 ms
for constraint fk_conregister_document 0.042 ms 1 0.042 ms
for constraint fk_conregisterdoc_document 0.037 ms 1 0.037 ms
for constraint fk_conregistergoods_document 0.035 ms 1 0.035 ms
for constraint fk_conregistertran_document 0.035 ms 1 0.035 ms
for constraint fk_cons_becc_72n_exp_document 0.036 ms 1 0.036 ms
for constraint fk_cons_becc_72n_inc_document 0.034 ms 1 0.034 ms
for constraint fk_cons_becc_72n_ref_document 0.033 ms 1 0.033 ms
for constraint fk_cons_becc_72n_src_document 0.035 ms 1 0.035 ms
for constraint fk_cons_debt_document 0.037 ms 1 0.037 ms
for constraint fk_cons_expbudget_document 0.035 ms 1 0.035 ms
for constraint fk_cons_guarantee_document 0.035 ms 1 0.035 ms
for constraint fk_cons_incbudget_document 0.037 ms 1 0.037 ms
for constraint fk_cons_loan_document 0.035 ms 1 0.035 ms
for constraint fk_cons_rro_document 0.034 ms 1 0.034 ms
for constraint fk_cons_srcbudget_document 0.034 ms 1 0.034 ms
for constraint fk_cons_static_active_doc 0.034 ms 1 0.034 ms
for constraint fk_cons_static_passive_doc 0.037 ms 1 0.037 ms
for constraint fk_cons_static_sprav_doc 0.037 ms 1 0.037 ms
for constraint fk_cons_uni_document 0.036 ms 1 0.036 ms
for constraint fk_consrep_document 0.034 ms 1 0.034 ms
for constraint fk_consreptpl_document 0.035 ms 1 0.035 ms
for constraint fk_contract_contractinfo_docid 0.041 ms 1 0.041 ms
for constraint fk_contract_document 0.040 ms 1 0.040 ms
for constraint fk_contractinfo_document 0.084 ms 1 0.084 ms
for constraint fk_contractinfolinkdoc_master 0.044 ms 1 0.044 ms
for constraint fk_contractinfolinkdoc_slave 0.032 ms 1 0.032 ms
for constraint fk_cpn_document 0.042 ms 1 0.042 ms
for constraint fk_cpncontroldoc_document 0.035 ms 1 0.035 ms
for constraint fk_cpndoc_master 0.034 ms 1 0.034 ms
for constraint fk_cpndoc_slave 0.032 ms 1 0.032 ms
for constraint fk_cpninfodoc_document 0.034 ms 1 0.034 ms
for constraint fk_custdoc_document 0.036 ms 1 0.036 ms
for constraint fk_debitcards_document 0.038 ms 1 0.038 ms
for constraint fk_deliveryfact_document 0.034 ms 1 0.034 ms
for constraint fk_dictchangereq_document 0.036 ms 1 0.036 ms
for constraint fk_digest_document 0.042 ms 1 0.042 ms
for constraint fk_digestsign_doc_id 0.044 ms 1 0.044 ms
for constraint fk_direction_sums_document 0.023 ms 1 0.023 ms
for constraint fk_dirorder_document 0.048 ms 1 0.048 ms
for constraint fk_dlvr_bo_master 0.038 ms 1 0.038 ms
for constraint fk_dlvr_bo_slave 0.033 ms 1 0.033 ms
for constraint fk_dlvr_docs_master 0.036 ms 1 0.036 ms
for constraint fk_dlvr_docs_slave 0.032 ms 1 0.032 ms
for constraint fk_dlvr_outerdocs_master 0.037 ms 1 0.037 ms
for constraint fk_dlvr_outerdocs_slave 0.032 ms 1 0.032 ms
for constraint fk_docattachex_doc 0.042 ms 1 0.042 ms
for constraint fk_doccstmfldvalues_docid 0.037 ms 1 0.037 ms
for constraint fk_doceverrlog_document 0.029 ms 1 0.029 ms
for constraint fk_docrestatitms_doc 0.035 ms 1 0.035 ms
for constraint fk_docrestatus_doc 0.032 ms 1 0.032 ms
for constraint fk_docsums_document 0.040 ms 1 0.040 ms
for constraint fk_document_parent 0.039 ms 1 0.039 ms
for constraint fk_entprocres_document 0.038 ms 1 0.038 ms
for constraint fk_exchdocument_document 0.047 ms 1 0.047 ms
for constraint fk_exdoc_document 0.038 ms 1 0.038 ms
for constraint fk_execdoc_document 0.042 ms 1 0.042 ms
for constraint fk_execnotice_document 0.036 ms 1 0.036 ms
for constraint fk_expadvice_document 0.038 ms 1 0.038 ms
for constraint fk_expassignment_document 0.046 ms 1 0.046 ms
for constraint fk_expcashplan_document 0.044 ms 1 0.044 ms
for constraint fk_explainreq_document 0.043 ms 1 0.043 ms
for constraint fk_explainreq_paydoc_id 0.044 ms 1 0.044 ms
for constraint fk_exporder_document 0.043 ms 1 0.043 ms
for constraint fk_exporder_paydoc 0.038 ms 1 0.038 ms
for constraint fk_exporderdoc_master_doc 0.036 ms 1 0.036 ms
for constraint fk_exporderdoc_slave_doc 0.032 ms 1 0.032 ms
for constraint fk_expschedule_document 0.044 ms 1 0.044 ms
for constraint fk_expschreg_document 0.038 ms 1 0.038 ms
for constraint fk_fhdplan_document 0.041 ms 1 0.041 ms
for constraint fk_forep_document 0.035 ms 1 0.035 ms
for constraint fk_foreptpl_document 0.037 ms 1 0.037 ms
for constraint fk_fundstranordercard_slave 0.035 ms 1 0.035 ms
for constraint fk_fundstranorderdoc_master 0.033 ms 1 0.033 ms
for constraint fk_fundstranorderdoc_slave 0.031 ms 1 0.031 ms
for constraint fk_fundstranorderline_slave 0.036 ms 1 0.036 ms
for constraint fk_fundstransdec_document 0.036 ms 1 0.036 ms
for constraint fk_fundstransferorder_document 0.037 ms 1 0.037 ms
for constraint fk_gg_charge_document 0.036 ms 1 0.036 ms
for constraint fk_gg_payment_document 0.039 ms 1 0.039 ms
for constraint fk_gg_quit_document 0.033 ms 1 0.033 ms
for constraint fk_ground_doc_document 0.041 ms 1 0.041 ms
for constraint fk_ib_measuredoc_document 0.033 ms 1 0.033 ms
for constraint fk_ibsfd_document 0.039 ms 1 0.039 ms
for constraint fk_inccashplan_document 0.041 ms 1 0.041 ms
for constraint fk_inccharge_document 0.039 ms 1 0.039 ms
for constraint fk_inccharge_parent 0.032 ms 1 0.032 ms
for constraint fk_incchargelinkdoc_master 0.038 ms 1 0.038 ms
for constraint fk_incchargelinkdoc_slave 0.032 ms 1 0.032 ms
for constraint fk_incorder_document 0.046 ms 1 0.046 ms
for constraint fk_incorder_paydoc 0.041 ms 1 0.041 ms
for constraint fk_indoc_document 0.041 ms 1 0.041 ms
for constraint fk_inprogdoc_document 0.037 ms 1 0.037 ms
for constraint fk_inreorder_document 0.036 ms 1 0.036 ms
for constraint fk_interbudget_document 0.095 ms 1 0.095 ms
for constraint fk_kbkdetail_document 0.048 ms 1 0.048 ms
for constraint fk_kbkdetail_paydoc 0.034 ms 1 0.034 ms
for constraint fk_kbkdetaildoc_master_doc 0.036 ms 1 0.036 ms
for constraint fk_kbkdetaildoc_slave_doc 0.033 ms 1 0.033 ms
for constraint fk_lboi_document 0.035 ms 1 0.035 ms
for constraint fk_limdoc_document 0.036 ms 1 0.036 ms
for constraint fk_limitinfo_document 0.036 ms 1 0.036 ms
for constraint fk_ln_paydoc_document 0.045 ms 1 0.045 ms
for constraint fk_loandoc_document 0.040 ms 1 0.040 ms
for constraint fk_memorder_document 0.049 ms 1 0.049 ms
for constraint fk_aubucashrequest_dlvyfact 0.044 ms 1 0.044 ms
for constraint fk_aubucashrequest_document 0.041 ms 1 0.041 ms
for constraint fk_moneytransferorder_dlvyfact 0.038 ms 1 0.038 ms
for constraint fk_moneytransorder_aubu 0.038 ms 1 0.038 ms
for constraint fk_moneytransorder_document 0.035 ms 1 0.035 ms
for constraint fk_moneytransorder_paydoc 0.335 ms 1 0.335 ms
for constraint fk_mrexpense_document 0.305 ms 1 0.305 ms
for constraint fk_mrincome_document 0.306 ms 1 0.306 ms
for constraint fk_mrsource_document 0.266 ms 1 0.266 ms
for constraint fk_mtolinkdoc_master 0.270 ms 1 0.270 ms
for constraint fk_mtolinkdoc_slave 0.167 ms 1 0.167 ms
for constraint fk_nmsgdoc_document 0.222 ms 1 0.222 ms
for constraint fk_nonbankoper_document 1.662 ms 1 1.662 ms
for constraint fk_nonbankoper_paydoc 0.358 ms 1 0.358 ms
for constraint fk_orgreport_document 0.506 ms 1 0.506 ms
for constraint fk_outerattach_document 0.416 ms 1 0.416 ms
for constraint fk_outerattachd_document 0.353 ms 1 0.353 ms
for constraint fk_outerdoc_document 0.561 ms 1 0.561 ms
for constraint fk_outerdocreq_document 0.315 ms 1 0.315 ms
for constraint fk_paydetail_document 1.888 ms 1 1.888 ms
for constraint fk_paydetail_regpassingfk 0.500 ms 1 0.500 ms
for constraint fk_paydetaildoc_master_doc 0.335 ms 1 0.335 ms
for constraint fk_paydetaildoc_slave_doc 0.397 ms 1 0.397 ms
for constraint fk_paydetailline_dlvyfact 1.845 ms 1 1.845 ms
for constraint fk_paydetailline_document 0.442 ms 1 0.442 ms
for constraint fk_payincorder_document 1.746 ms 1 1.746 ms
for constraint fk_payinforeqlinkdoc_master 0.413 ms 1 0.413 ms
for constraint fk_payinforeqlinkdoc_slave 0.160 ms 1 0.160 ms
for constraint fk_paymentadminreg_document 0.743 ms 1 0.743 ms
for constraint fk_paymentadminreg_parent 0.185 ms 1 0.185 ms
for constraint fk_paymentinfo_document 1.350 ms 1 1.350 ms
for constraint fk_paymentinfo_parent 0.358 ms 1 0.358 ms
for constraint fk_paymentinforeq_document 0.695 ms 1 0.695 ms
for constraint fk_payref_document 2.268 ms 1 2.268 ms
for constraint fk_payref_paydoc 0.330 ms 1 0.330 ms
for constraint fk_payrequest_document 2.811 ms 1 2.811 ms
for constraint fk_payroll_document 0.536 ms 1 0.536 ms
for constraint fk_pbsrep_document 0.620 ms 1 0.620 ms
for constraint fk_pbsrepdocs_document 0.441 ms 1 0.441 ms
for constraint fk_pbsreptpl_document 0.569 ms 1 0.569 ms
for constraint fk_permission_document 0.637 ms 1 0.637 ms
for constraint fk_pg_sums_document 0.297 ms 1 0.297 ms
for constraint fk_pl_dir_other_document 0.882 ms 1 0.882 ms
for constraint fk_pl_directiondoc_document 0.576 ms 1 0.576 ms
for constraint fk_pl_exec_progdoc_document 0.580 ms 1 0.580 ms
for constraint fk_pl_execstatetask_document 0.528 ms 1 0.528 ms
for constraint fk_pl_inccashplan_document 0.987 ms 1 0.987 ms
for constraint fk_pl_progdoc_document 0.710 ms 1 0.710 ms
for constraint fk_pl_statetask_document 0.748 ms 1 0.748 ms
for constraint fk_planassdoc_document 0.816 ms 1 0.816 ms
for constraint fk_planassdocprogdoc_master_do 0.314 ms 1 0.314 ms
for constraint fk_planassdocprogdoc_slave_do 0.185 ms 1 0.185 ms
for constraint fk_planassdocsum_document 1.272 ms 1 1.272 ms
for constraint fk_planassdocsumdoc_master_do 0.276 ms 1 0.276 ms
for constraint fk_planassdocsumdoc_slave_do 0.135 ms 1 0.135 ms
for constraint fk_planindoc_document 1.030 ms 1 1.030 ms
for constraint fk_planinprogdoc_doc 0.866 ms 1 0.866 ms
for constraint fk_planlog_document 0.786 ms 1 0.786 ms
for constraint fk_pplanorder_contractdoc 2.020 ms 1 2.020 ms
for constraint fk_pplanorder_document 0.311 ms 1 0.311 ms
for constraint fk_protocol_document 1.442 ms 1 1.442 ms
for constraint fk_protocoldoc_master_document 0.325 ms 1 0.325 ms
for constraint fk_protocoldoc_slave_document 0.164 ms 1 0.164 ms
for constraint fk_refdoc_document 0.346 ms 1 0.346 ms
for constraint fk_refdoc_ref 0.160 ms 1 0.160 ms
for constraint fk_regdoc_document 0.660 ms 1 0.660 ms
for constraint fk_regentry_document 0.523 ms 1 0.523 ms
for constraint fk_registerdoc_master_document 0.300 ms 1 0.300 ms
for constraint fk_registerdoc_slave_document 0.172 ms 1 0.172 ms
for constraint fk_regpassingfk_document 0.634 ms 1 0.634 ms
for constraint fk_regpassingfkdoc_master_doc 0.336 ms 1 0.336 ms
for constraint fk_regpassingfkdoc_slave_doc 0.147 ms 1 0.147 ms
for constraint fk_repdata121_document 0.283 ms 1 0.283 ms
for constraint fk_repdata130_document 0.326 ms 1 0.326 ms
for constraint fk_reqroll_document 0.657 ms 1 0.657 ms
for constraint fk_reqrolldoc_master 0.343 ms 1 0.343 ms
for constraint fk_reqrolldoc_slave 0.155 ms 1 0.155 ms
for constraint fk_reststransorder_document 1.109 ms 1 1.109 ms
for constraint fk_roleregister_document 0.580 ms 1 0.580 ms
for constraint fk_rp_doc_document 0.860 ms 1 0.860 ms
for constraint fk_sofitdoc_document 0.558 ms 1 0.558 ms
for constraint fk_sp_plansrcdoc_document 0.704 ms 1 0.704 ms
for constraint fk_srcadvice_document 1.204 ms 1 1.204 ms
for constraint fk_srccashplan_document 0.788 ms 1 0.788 ms
for constraint fk_srcdoc_document 0.570 ms 1 0.570 ms
for constraint fk_srcorder_document 2.430 ms 1 2.430 ms
for constraint fk_srcorder_paydoc 0.785 ms 1 0.785 ms
for constraint fk_srcprogdoc_document 0.497 ms 1 0.497 ms
for constraint fk_srcrequest_document 1.224 ms 1 1.224 ms
for constraint fk_subservrequest_document 0.820 ms 1 0.820 ms
for constraint fk_symbcashline_document 0.464 ms 1 0.464 ms
for constraint fk_tfs_document 0.835 ms 1 0.835 ms
for constraint fk_tgoper_document 0.792 ms 1 0.792 ms
for constraint fk_tgoper_fhdplan 0.213 ms 1 0.213 ms
for constraint fk_unidoc_document 0.503 ms 1 0.503 ms
for constraint fk_unspentfundsdec_document 2.043 ms 1 2.043 ms
for constraint fk_zhkupayinfo_document 0.751 ms 1 0.751 ms
for constraint fk_zhkupayrecreq_document 0.434 ms 1 0.434 ms
for constraint fk_budgorder_dlvyfact 2.943 ms 1 2.943 ms
for constraint fk_budgorder_document 0.436 ms 1 0.436 ms
for constraint fk_budgorder_register 0.347 ms 1 0.347 ms
for constraint fk_pay_parent_document 1.873 ms 1 1.873 ms
for constraint fk_payorder_document 0.297 ms 1 0.297 ms
for constraint fk_payorder_register 0.253 ms 1 0.253 ms
rpl$document 0.250 ms 1 0.250 ms