explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r4Y5

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.080 ↓ 0.0 0 1

Delete on c_bpartner_location (cost=0.56..8.58 rows=1 width=6) (actual time=0.080..0.080 rows=0 loops=1)

  • Buffers: shared hit=7 dirtied=1
2. 0.069 0.069 ↑ 1.0 1 1

Index Scan using c_bpartner_location_key on c_bpartner_location (cost=0.56..8.58 rows=1 width=6) (actual time=0.068..0.069 rows=1 loops=1)

  • Index Cond: ((c_bpartner_location_id)::text = 'B78935B1603E4364826DE9C1B70A2E4E'::text)
  • Buffers: shared hit=5 dirtied=1
Planning time : 0.508 ms
Execution time : 1,909,150.902 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint a_asset_c_bpartner_location 0.911 ms 1 0.911 ms
for constraint ad_user_c_bpartner_location 66,426.706 ms 1 66,426.706 ms
for constraint c_bplocation_cinvoice 17,188.984 ms 1 17,188.984 ms
for constraint c_project_billto 0.856 ms 1 0.856 ms
for constraint c_project_c_bpartner_location 0.206 ms 1 0.206 ms
for constraint c_projectproposal_c_bpartner_l 0.364 ms 1 0.364 ms
for constraint em_obretco_org_bplocation 1.423 ms 1 1.423 ms
for constraint obpos_c_bpartner_loc 1.359 ms 1 1.359 ms
for constraint m_inout_c_bpartner_location 144,729.193 ms 1 144,729.193 ms
for constraint m_inout_c_bpartner_location1 137,287.247 ms 1 137,287.247 ms
for constraint c_order_billto 234,943.268 ms 1 234,943.268 ms
for constraint c_order_c_bpartner_location 238,272.683 ms 1 238,272.683 ms
for constraint c_order_c_bpartner_location1 243,899.511 ms 1 243,899.511 ms
for constraint c_order_dropship_location 236,089.182 ms 1 236,089.182 ms
for constraint c_orderline_c_bpartner_locatio 287,510.266 ms 1 287,510.266 ms
for constraint em_obrcifp_ol_location 302,770.409 ms 1 302,770.409 ms
aa_sym_c_bpartner_location_d 28.201 ms 1 28.201 ms