explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fsju

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 0.108 ↓ 0.0 0 1

Delete on m_storage_detail (cost=0.43..8.45 rows=1 width=6) (actual time=0.108..0.108 rows=0 loops=1)

2. 0.087 0.087 ↑ 1.0 1 1

Index Scan using idx_storagedetail_id on m_storage_detail (cost=0.43..8.45 rows=1 width=6) (actual time=0.086..0.087 rows=1 loops=1)

  • Index Cond: ((m_storage_detail_id)::text = 'D445976F89C94FE5BB187775C9D78EAE'::text)
Planning time : 0.109 ms
Execution time : 383.317 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint m_storagedet_mstockproposed 0.276 ms 1 0.276 ms
for constraint m_storagedetail_mstockaux 0.195 ms 1 0.195 ms
for constraint obawo_inventory_prop_m_sd 367.250 ms 1 367.250 ms
for constraint obawo_task_m_storage_detail 15.114 ms 1 15.114 ms
for constraint opxdstk_sdsd_storagedetail 0.340 ms 1 0.340 ms