explain.depesz.com

PostgreSQL's explain analyze made readable

Result: joET

Settings
# exclusive inclusive rows x rows loops node
1. 15.974 16.064 ↓ 0.0 0 1

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

2. 0.090 0.090 ↑ 1.0 1 1

Result (cost=0.00..0.27 rows=1 width=3,426) (actual time=0.089..0.090 rows=1 loops=1)

Planning time : 0.113 ms
Execution time : 17.619 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint em_awobg_orderline 0.012 ms 1 0.012 ms
for constraint em_obdoa_task_doline_fk 0.003 ms 1 0.003 ms
for constraint em_prawo_img_loca_fk 0.002 ms 1 0.002 ms
for constraint em_prawo_task_ad_image 0.001 ms 1 0.001 ms
for constraint obawo_task_ad_client 0.129 ms 1 0.129 ms
for constraint obawo_task_ad_org 0.072 ms 1 0.072 ms
for constraint obawo_task_batchtasks_fk 0.093 ms 1 0.093 ms
for constraint obawo_task_c_aum 0.003 ms 1 0.003 ms
for constraint obawo_task_c_orderline 0.001 ms 1 0.001 ms
for constraint obawo_task_conf_attribute 0.080 ms 1 0.080 ms
for constraint obawo_task_conf_locator_to 0.106 ms 1 0.106 ms
for constraint obawo_task_conf_refinv_fk 0.069 ms 1 0.069 ms
for constraint obawo_task_exp_attribute 0.055 ms 1 0.055 ms
for constraint obawo_task_exp_loc_from 0.066 ms 1 0.066 ms
for constraint obawo_task_exp_loc_to 0.059 ms 1 0.059 ms
for constraint obawo_task_exp_locator_to 0.058 ms 1 0.058 ms
for constraint obawo_task_exp_refinv_fk 0.046 ms 1 0.046 ms
for constraint obawo_task_int_routing 0.070 ms 1 0.070 ms
for constraint obawo_task_int_routingassig 0.093 ms 1 0.093 ms
for constraint obawo_task_inv_list 0.004 ms 1 0.004 ms
for constraint obawo_task_inventoryline 0.002 ms 1 0.002 ms
for constraint obawo_task_inventorypropline 0.002 ms 1 0.002 ms
for constraint obawo_task_invtrantype 0.056 ms 1 0.056 ms
for constraint obawo_task_m_inoutline 0.003 ms 1 0.003 ms
for constraint obawo_task_m_movementline 0.003 ms 1 0.003 ms
for constraint obawo_task_m_storage_detail 0.084 ms 1 0.084 ms
for constraint obawo_task_pickinglist 0.003 ms 1 0.003 ms
for constraint obawo_task_product 0.127 ms 1 0.127 ms
for constraint obawo_task_receptionlist 0.002 ms 1 0.002 ms
for constraint obawo_task_reservation_stock 0.001 ms 1 0.001 ms
for constraint obawo_task_task_fk 0.001 ms 1 0.001 ms
for constraint obawo_task_type_fk 0.040 ms 1 0.040 ms
for constraint obawo_task_user 0.059 ms 1 0.059 ms
for constraint obawo_task_warehouse 0.043 ms 1 0.043 ms
for constraint obawo_task_wh_pa_alg 0.002 ms 1 0.002 ms
for constraint obawo_task_wh_pk_alg 0.001 ms 1 0.001 ms