explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 01MM

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 13.590 ↓ 0.0 0 1

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

2. 13.564 13.564 ↑ 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=13.563..13.564 rows=1 loops=1)

  • Index Cond: ((m_storage_detail_id)::text = '1BF99E9387E54A808B8C89684FF4F705'::text)
Planning time : 0.088 ms
Execution time : 390.489 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint m_storagedet_mstockproposed 0.295 ms 1 0.295 ms
for constraint m_storagedetail_mstockaux 0.132 ms 1 0.132 ms
for constraint obawo_inventory_prop_m_sd 347.084 ms 1 347.084 ms
for constraint obawo_task_m_storage_detail 11.885 ms 1 11.885 ms
for constraint opxdstk_sdsd_storagedetail 17.471 ms 1 17.471 ms