explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CvFk

Settings
# exclusive inclusive rows x rows loops node
1. 27.285 1,677,746.929 ↓ 31.0 31 1

GroupAggregate (cost=12,043.24..12,043.28 rows=1 width=403) (actual time=1,677,711.351..1,677,746.929 rows=31 loops=1)

  • Group Key: datielabap0_.cod_periodo, datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Filter: (abs(sum(datielabap0_.importo_cambio)) <> '0'::numeric)
  • Rows Removed by Filter: 1
  • Buffers: local hit=174 read=38800524
2. 30.043 1,677,719.644 ↓ 26,032.0 26,032 1

Sort (cost=12,043.24..12,043.24 rows=1 width=57) (actual time=1,677,711.292..1,677,719.644 rows=26,032 loops=1)

  • Sort Key: datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Sort Method: quicksort Memory: 4429kB
  • Buffers: local hit=174 read=38800524
3. 864.735 1,677,689.601 ↓ 26,032.0 26,032 1

Nested Loop (cost=3.03..12,043.23 rows=1 width=57) (actual time=1,205,806.335..1,677,689.601 rows=26,032 loops=1)

  • Join Filter: ((datielabap0_.cod_azienda)::text = (appk1x2_.k1)::text)
  • Rows Removed by Join Filter: 2160656
  • Buffers: local hit=174 read=38800524
4. 0.234 0.234 ↓ 84.0 84 1

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

  • Index Cond: (cid = 'FF8081816B40EE8A016B4114323C4278'::text)
  • Heap Fetches: 84
  • Buffers: local hit=2 read=1
5. 56,838.432 1,676,824.632 ↓ 2,366.5 26,032 84

Nested Loop (cost=2.77..12,040.60 rows=11 width=57) (actual time=7,006.218..19,962.198 rows=26,032 loops=84)

  • Join Filter: ((datielabap0_.cod_dest5)::text = (appk1x1_.k1)::text)
  • Rows Removed by Join Filter: 1900336
  • Buffers: local hit=172 read=38800523
6. 22.008 22.008 ↓ 74.0 74 84

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

  • Index Cond: (cid = 'FF8081816B40EE8A016B41145DD842B6'::text)
  • Heap Fetches: 6216
  • Buffers: local hit=169 read=251
7. 547,617.161 1,619,964.192 ↓ 35.2 26,032 6,216

Hash Join (cost=2.50..12,028.87 rows=740 width=57) (actual time=0.007..260.612 rows=26,032 loops=6,216)

  • Hash Cond: ((datielabap0_.cod_conto)::text = (appk1x3_.k1)::text)
  • Buffers: local hit=3 read=38800272
8. 1,072,347.024 1,072,347.024 ↑ 1.0 225,847 6,216

Seq Scan on "#APP_CL_DATI_ELAB" datielabap0_ (cost=0.00..11,158.95 rows=229,338 width=57) (actual time=0.005..172.514 rows=225,847 loops=6,216)

  • Filter: (((cod_periodo)::text = '03'::text) AND ((cod_scenario)::text = 'BGT2019NO2'::text) AND ((cod_categoria)::text = 'REVENUE'::text) AND ((cod_regola)::text = ANY ('{01R,02,$R$f$}'::text[])))
  • Rows Removed by Filter: 5134
  • Buffers: local read=38800272
9. 0.003 0.007 ↑ 1.0 1 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: local hit=3
10. 0.004 0.004 ↑ 1.0 1 1

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

  • Index Cond: (cid = 'FF8081816B40EE8A016B41143F92428B'::text)
  • Heap Fetches: 1
  • Buffers: local hit=3