explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4vvJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 67.104 ↓ 0.0 0 1

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

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

  • Index Cond: ((m_storage_detail_id)::text = '56E2ACD1A7C241A8B59F1ADC423AF9CB'::text)
Planning time : 0.081 ms
Execution time : 486.031 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint m_storagedet_mstockproposed 0.087 ms 1 0.087 ms
for constraint m_storagedetail_mstockaux 0.033 ms 1 0.033 ms
for constraint obawo_inventory_prop_m_sd 361.601 ms 1 361.601 ms
for constraint obawo_task_m_storage_detail 56.864 ms 1 56.864 ms
for constraint opxdstk_sdsd_storagedetail 0.307 ms 1 0.307 ms