explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7gJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 488.367 ↓ 0.0 0 1

GroupAggregate (cost=12,053.96..12,054.02 rows=1 width=217) (actual time=488.366..488.367 rows=0 loops=1)

  • Group Key: datielabap0_.cod_periodo, datielabap0_.cod_azienda, datielabap0_.cod_conto, datielabap0_.cod_dest1, datielabap0_.cod_dest2, datielabap0_.cod_dest3, datielabap0_.cod_dest4, datielabap0_.cod_dest5, datielabap0_.cod_valuta, datielabap0_.cod_valuta2
  • Filter: ((abs(sum(datielabap0_.importo)) + abs(sum(datielabap0_.importo2))) <> '0'::numeric)
  • Buffers: local hit=3 read=24968 written=9
2. 0.010 488.362 ↓ 0.0 0 1

Sort (cost=12,053.96..12,053.97 rows=1 width=73) (actual time=488.362..488.362 rows=0 loops=1)

  • Sort Key: datielabap0_.cod_azienda, datielabap0_.cod_conto, datielabap0_.cod_dest1, datielabap0_.cod_dest2, datielabap0_.cod_dest3, datielabap0_.cod_dest4, datielabap0_.cod_dest5, datielabap0_.cod_valuta, datielabap0_.cod_valuta2
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=3 read=24968 written=9
3. 0.000 488.352 ↓ 0.0 0 1

Nested Loop (cost=0.81..12,053.95 rows=1 width=73) (actual time=488.352..488.352 rows=0 loops=1)

  • Buffers: local hit=3 read=24968 written=9
4. 0.002 488.352 ↓ 0.0 0 1

Nested Loop (cost=0.54..12,053.65 rows=1 width=73) (actual time=488.351..488.352 rows=0 loops=1)

  • Buffers: local hit=3 read=24968 written=9
5. 7.886 488.350 ↓ 0.0 0 1

Nested Loop (cost=0.27..12,051.81 rows=6 width=73) (actual time=488.350..488.350 rows=0 loops=1)

  • Join Filter: ((datielabap0_.cod_conto)::text = (appk1x3_.k1)::text)
  • Rows Removed by Join Filter: 20516
  • Buffers: local hit=3 read=24968 written=9
6. 0.024 0.024 ↓ 4.0 4 1

Index Only Scan using "#APP_K1_pkey" on "#APP_K1" appk1x3_ (cost=0.27..2.49 rows=1 width=9) (actual time=0.011..0.024 rows=4 loops=1)

  • Index Cond: (cid = 'FF8081816B45CC5B016B45E5B40D1A0C'::text)
  • Heap Fetches: 4
  • Buffers: local hit=3
7. 480.440 480.440 ↓ 2.8 5,129 4

Seq Scan on "#APP_CL_DATI_ELAB" datielabap0_ (cost=0.00..12,026.65 rows=1,814 width=73) (actual time=0.013..120.110 rows=5,129 loops=4)

  • Filter: (((natura_conto)::text = ANY ('{B,E}'::text[])) AND ((cod_periodo)::text = '03'::text) AND ((cod_scenario)::text = 'BGT2019NO2'::text) AND ((cod_regola)::text = ANY ('{01R,02,$R$f$}'::text[])) AND ((cod_categoria)::text = ANY ('{$AMOUNT,ALLOC1,ALLOC}'::text[])))
  • Rows Removed by Filter: 225852
  • Buffers: local read=24968 written=9
8. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "#APP_K1_pkey" on "#APP_K1" appk1x1_ (cost=0.27..0.30 rows=1 width=9) (never executed)

  • Index Cond: ((cid = 'FF8081816B45CC5B016B45E5B5F21A1D'::text) AND (k1 = (datielabap0_.cod_dest5)::text))
  • Heap Fetches: 0
9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "#APP_K1_pkey" on "#APP_K1" appk1x2_ (cost=0.27..0.30 rows=1 width=9) (never executed)

  • Index Cond: ((cid = 'FF8081816B45CC5B016B45E5AA3319EC'::text) AND (k1 = (datielabap0_.cod_azienda)::text))
  • Heap Fetches: 0
Planning time : 0.543 ms
Execution time : 488.620 ms