explain.depesz.com

PostgreSQL's explain analyze made readable

Result: llZz

Settings
# exclusive inclusive rows x rows loops node
1. 8.256 8.369 ↓ 0.0 0 1

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

2. 0.113 0.113 ↑ 1.0 1 1

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

Planning time : 0.155 ms
Execution time : 9.931 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.002 ms 1 0.002 ms
for constraint em_prawo_img_loca_fk 0.003 ms 1 0.003 ms
for constraint em_prawo_task_ad_image 0.001 ms 1 0.001 ms
for constraint obawo_task_ad_client 0.127 ms 1 0.127 ms
for constraint obawo_task_ad_org 0.066 ms 1 0.066 ms
for constraint obawo_task_batchtasks_fk 0.087 ms 1 0.087 ms
for constraint obawo_task_c_aum 0.003 ms 1 0.003 ms
for constraint obawo_task_c_orderline 0.002 ms 1 0.002 ms
for constraint obawo_task_conf_attribute 0.069 ms 1 0.069 ms
for constraint obawo_task_conf_locator_to 0.093 ms 1 0.093 ms
for constraint obawo_task_conf_refinv_fk 0.058 ms 1 0.058 ms
for constraint obawo_task_exp_attribute 0.053 ms 1 0.053 ms
for constraint obawo_task_exp_loc_from 0.065 ms 1 0.065 ms
for constraint obawo_task_exp_loc_to 0.061 ms 1 0.061 ms
for constraint obawo_task_exp_locator_to 0.096 ms 1 0.096 ms
for constraint obawo_task_exp_refinv_fk 0.050 ms 1 0.050 ms
for constraint obawo_task_int_routing 0.062 ms 1 0.062 ms
for constraint obawo_task_int_routingassig 0.082 ms 1 0.082 ms
for constraint obawo_task_inv_list 0.003 ms 1 0.003 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.057 ms 1 0.057 ms
for constraint obawo_task_m_inoutline 0.002 ms 1 0.002 ms
for constraint obawo_task_m_movementline 0.002 ms 1 0.002 ms
for constraint obawo_task_m_storage_detail 0.083 ms 1 0.083 ms
for constraint obawo_task_pickinglist 0.002 ms 1 0.002 ms
for constraint obawo_task_product 0.139 ms 1 0.139 ms
for constraint obawo_task_receptionlist 0.002 ms 1 0.002 ms
for constraint obawo_task_reservation_stock 0.002 ms 1 0.002 ms
for constraint obawo_task_task_fk 0.001 ms 1 0.001 ms
for constraint obawo_task_type_fk 0.044 ms 1 0.044 ms
for constraint obawo_task_user 0.052 ms 1 0.052 ms
for constraint obawo_task_warehouse 0.041 ms 1 0.041 ms
for constraint obawo_task_wh_pa_alg 0.003 ms 1 0.003 ms
for constraint obawo_task_wh_pk_alg 0.001 ms 1 0.001 ms