explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eyi

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

GroupAggregate (cost=11,618.09..11,618.14 rows=1 width=403) (actual rows= loops=)

  • Group Key: datielabap0_.cod_periodo, datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Filter: (abs(sum(datielabap0_.importo_cambio)) <> '0'::numeric)
2. 0.000 0.000 ↓ 0.0

Sort (cost=11,618.09..11,618.10 rows=1 width=57) (actual rows= loops=)

  • Sort Key: datielabap0_.cod_dest2, datielabap0_.cod_dest5
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.03..11,618.08 rows=1 width=57) (actual rows= loops=)

  • Join Filter: ((datielabap0_.cod_dest5)::text = (appk1x1_.k1)::text)
4. 0.000 0.000 ↓ 0.0

Index Only Scan using "#APP_K1_pkey" on "#APP_K1" appk1x1_ (cost=0.27..2.49 rows=1 width=516) (actual rows= loops=)

  • Index Cond: (cid = 'FF8081816B1C9D4F016B1CC6A51412D1'::text)
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.77..11,615.46 rows=11 width=57) (actual rows= loops=)

  • Join Filter: ((datielabap0_.cod_azienda)::text = (appk1x2_.k1)::text)
6. 0.000 0.000 ↓ 0.0

Index Only Scan using "#APP_K1_pkey" on "#APP_K1" appk1x2_ (cost=0.27..2.49 rows=1 width=516) (actual rows= loops=)

  • Index Cond: (cid = 'FF8081816B1C9D4F016B1CC677311293'::text)
7. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=2.50..11,603.86 rows=729 width=57) (actual rows= loops=)

  • Hash Cond: ((datielabap0_.cod_conto)::text = (appk1x3_.k1)::text)
8. 0.000 0.000 ↓ 0.0

Seq Scan on "#APP_CL_DATI_ELAB" datielabap0_ (cost=0.00..10,999.83 rows=226,067 width=57) (actual rows= loops=)

  • Filter: (((cod_scenario)::text = 'BGT2019NO2'::text) AND ((cod_periodo)::text = '03'::text) AND ((cod_categoria)::text = 'REVENUE'::text) AND ((cod_regola)::text = ANY ('{01R,02,$R$f$}'::text[])))
9. 0.000 0.000 ↓ 0.0

Hash (cost=2.49..2.49 rows=1 width=516) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Only Scan using "#APP_K1_pkey" on "#APP_K1" appk1x3_ (cost=0.27..2.49 rows=1 width=516) (actual rows= loops=)

  • Index Cond: (cid = 'FF8081816B1C9D4F016B1CC6861312A6'::text)