explain.depesz.com

PostgreSQL's explain analyze made readable

Result: isGQ

Settings
# exclusive inclusive rows x rows loops node
1. 390.837 391.001 ↓ 0.0 0 1

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

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

  • Index Cond: ((m_storage_detail_id)::text = 'AA93AD700D6844C3B096D8FDAA650789'::text)
Planning time : 0.102 ms
Execution time : 906.613 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint m_storagedet_mstockproposed 1.067 ms 1 1.067 ms
for constraint m_storagedetail_mstockaux 0.812 ms 1 0.812 ms
for constraint obawo_inventory_prop_m_sd 510.765 ms 1 510.765 ms
for constraint obawo_task_m_storage_detail 2.663 ms 1 2.663 ms
for constraint opxdstk_sdsd_storagedetail 0.273 ms 1 0.273 ms
opxdstk_storage_detail_del_trg 389.775 ms 1 389.775 ms