explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8ryf

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.12..70,918.62 rows=5 width=16) (actual rows= loops=)

  • Join Filter: ((b.id_rgio_safer = (a._id_safer)::numeric) AND (b.id_doss = (a._id_safcom)::numeric))
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..673.61 rows=5 width=20) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Index Scan using idx_bnc_tref_tr_destination__id_safer on tr_destination c (cost=0.28..24.09 rows=561 width=14) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using bnc_doss_cra_id_cra_idx on bnc_doss_cra b (cost=0.29..1.15 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (id_cra = (c._id_safcom)::numeric)
  • Filter: (((cd_table_src)::text = 'dsttfond_notif'::text) AND (bl_prin = '1'::numeric))
5. 0.000 0.000 ↓ 0.0

Index Scan using idx_bnc_regional_operation_unique on operation a (cost=0.56..7,282.94 rows=338,303 width=22) (actual rows= loops=)