explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dXvn

Settings
# exclusive inclusive rows x rows loops node
1. 0.279 0.281 ↓ 0.0 0 1

Insert on obawo_task (cost=0.00..0.01 rows=1 width=3,426) (actual time=0.281..0.281 rows=0 loops=1)

2. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=3,426) (actual time=0.002..0.002 rows=1 loops=1)

Planning time : 0.102 ms
Execution time : 14.410 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint em_awobg_orderline 0.550 ms 1 0.550 ms
for constraint em_obdoa_task_doline_fk 0.106 ms 1 0.106 ms
for constraint em_prawo_img_loca_fk 0.143 ms 1 0.143 ms
for constraint em_prawo_task_ad_image 0.007 ms 1 0.007 ms
for constraint obawo_task_ad_client 1.574 ms 1 1.574 ms
for constraint obawo_task_ad_org 1.325 ms 1 1.325 ms
for constraint obawo_task_batchtasks_fk 0.511 ms 1 0.511 ms
for constraint obawo_task_c_aum 0.149 ms 1 0.149 ms
for constraint obawo_task_c_orderline 0.010 ms 1 0.010 ms
for constraint obawo_task_conf_attribute 0.480 ms 1 0.480 ms
for constraint obawo_task_conf_locator_to 1.130 ms 1 1.130 ms
for constraint obawo_task_conf_refinv_fk 0.644 ms 1 0.644 ms
for constraint obawo_task_exp_attribute 0.286 ms 1 0.286 ms
for constraint obawo_task_exp_loc_from 0.238 ms 1 0.238 ms
for constraint obawo_task_exp_loc_to 0.253 ms 1 0.253 ms
for constraint obawo_task_exp_locator_to 0.206 ms 1 0.206 ms
for constraint obawo_task_exp_refinv_fk 0.179 ms 1 0.179 ms
for constraint obawo_task_int_routing 0.644 ms 1 0.644 ms
for constraint obawo_task_int_routingassig 0.790 ms 1 0.790 ms
for constraint obawo_task_inv_list 0.087 ms 1 0.087 ms
for constraint obawo_task_inventoryline 0.120 ms 1 0.120 ms
for constraint obawo_task_inventorypropline 0.076 ms 1 0.076 ms
for constraint obawo_task_invtrantype 0.476 ms 1 0.476 ms
for constraint obawo_task_m_inoutline 0.183 ms 1 0.183 ms
for constraint obawo_task_m_movementline 0.102 ms 1 0.102 ms
for constraint obawo_task_m_storage_detail 0.870 ms 1 0.870 ms
for constraint obawo_task_pickinglist 0.089 ms 1 0.089 ms
for constraint obawo_task_product 1.538 ms 1 1.538 ms
for constraint obawo_task_receptionlist 0.068 ms 1 0.068 ms
for constraint obawo_task_reservation_stock 0.068 ms 1 0.068 ms
for constraint obawo_task_task_fk 0.002 ms 1 0.002 ms
for constraint obawo_task_type_fk 0.248 ms 1 0.248 ms
for constraint obawo_task_user 0.487 ms 1 0.487 ms
for constraint obawo_task_warehouse 0.325 ms 1 0.325 ms
for constraint obawo_task_wh_pa_alg 0.041 ms 1 0.041 ms
for constraint obawo_task_wh_pk_alg 0.005 ms 1 0.005 ms