explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IUK6

Settings
# exclusive inclusive rows x rows loops node
1. 0.216 3.777 ↓ 0.0 0 1

Delete on ru_itm_sl a (cost=4,553.08..6,617.74 rows=817 width=12) (actual time=3.777..3.777 rows=0 loops=1)

2. 0.032 3.561 ↑ 12.4 66 1

Nested Loop (cost=4,553.08..6,617.74 rows=817 width=12) (actual time=3.214..3.561 rows=66 loops=1)

3. 0.025 3.199 ↑ 12.4 66 1

HashAggregate (cost=4,552.65..4,577.16 rows=817 width=10) (actual time=3.191..3.199 rows=66 loops=1)

  • Group Key: b.id_ru_itm_sl
4. 3.174 3.174 ↑ 12.4 66 1

Index Scan using tsc_stage_ru_itm_sl_pkey on tsc_stage_ru_itm_sl b (cost=0.42..4,550.60 rows=817 width=10) (actual time=0.317..3.174 rows=66 loops=1)

  • Index Cond: (id_bsngp = 1)
  • Filter: (event_type = 'D'::bpchar)
  • Rows Removed by Filter: 10248
5. 0.330 0.330 ↑ 1.0 1 66

Index Scan using ru_itm_sl_pkey on ru_itm_sl a (cost=0.44..2.47 rows=1 width=10) (actual time=0.005..0.005 rows=1 loops=66)

  • Index Cond: (id_ru_itm_sl = b.id_ru_itm_sl)
Planning time : 0.200 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
for constraint as_itm_is_assigned_to_4 2,075.286 ms 66 31.444 ms
for constraint co_mrhrc_gp_is_assigned_to_10 7.749 ms 66 0.117 ms
for constraint id_bsngp_dpt_ps_is_assigned_to_12 81.994 ms 66 1.242 ms
for constraint id_dpt_ps_is_default_setting_for_all_items_in 3.439 ms 66 0.052 ms
for constraint id_ps_is_assigned_to_14 186,219.099 ms 66 2,821.501 ms
for constraint ru_itm_sl_ext_id_ru_itm_sl_fkey 6.433 ms 66 0.097 ms
sym_on_d_for_r_tm_sl_srvr_srvr 26.898 ms 66 0.408 ms