explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UEHL

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 19.417 ↓ 0.0 0 1

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

2. 19.394 19.394 ↑ 1.0 1 1

Index Scan using m_storage_detail_key on m_storage_detail (cost=0.43..8.45 rows=1 width=6) (actual time=19.393..19.394 rows=1 loops=1)

  • Index Cond: ((m_storage_detail_id)::text = 'A085E613ADA341509EA09468FF4FBD8B'::text)
Planning time : 0.169 ms
Execution time : 397.134 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint m_storagedet_mstockproposed 0.225 ms 1 0.225 ms
for constraint m_storagedetail_mstockaux 0.130 ms 1 0.130 ms
for constraint obawo_inventory_prop_m_sd 368.839 ms 1 368.839 ms
for constraint obawo_task_m_storage_detail 8.205 ms 1 8.205 ms
for constraint opxdstk_sdsd_storagedetail 0.278 ms 1 0.278 ms