explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Coq

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 322.924 ↓ 0.0 0 1

GroupAggregate (cost=12,186.77..12,195.17 rows=177 width=403) (actual time=322.924..322.924 rows=0 loops=1)

  • Group Key: datielabap0_.cod_periodo, datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Filter: (abs(sum(datielabap0_.importo_cambio)) <> '0'::numeric)
  • Buffers: local hit=52065 read=6244
2. 0.007 322.921 ↓ 0.0 0 1

Sort (cost=12,186.77..12,187.21 rows=177 width=57) (actual time=322.921..322.921 rows=0 loops=1)

  • Sort Key: datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=52065 read=6244
3. 0.001 322.914 ↓ 0.0 0 1

Nested Loop (cost=2.79..12,180.16 rows=177 width=57) (actual time=322.914..322.914 rows=0 loops=1)

  • Buffers: local hit=52065 read=6244
4. 26.277 322.913 ↓ 0.0 0 1

Nested Loop (cost=2.65..12,121.53 rows=335 width=57) (actual time=322.913..322.913 rows=0 loops=1)

  • Buffers: local hit=52065 read=6244
5. 92.015 270.604 ↓ 36.2 26,032 1

Hash Join (cost=2.50..11,995.69 rows=719 width=57) (actual time=0.043..270.604 rows=26,032 loops=1)

  • Hash Cond: ((datielabap0_.cod_conto)::text = (appk1x3_.k1)::text)
  • Buffers: local hit=1 read=6244
6. 178.571 178.571 ↓ 1.0 225,847 1

Seq Scan on "#lore" datielabap0_ (cost=0.00..11,150.35 rows=222,840 width=57) (actual time=0.016..178.571 rows=225,847 loops=1)

  • 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=6242
7. 0.002 0.018 ↑ 1.0 1 1

Hash (cost=2.49..2.49 rows=1 width=9) (actual time=0.018..0.018 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: local hit=1 read=2
8. 0.016 0.016 ↑ 1.0 1 1

Index Only Scan using "KKK" on "#lore_k1" appk1x3_ (cost=0.27..2.49 rows=1 width=9) (actual time=0.014..0.016 rows=1 loops=1)

  • Index Cond: (cid = 'FF8081816B1C9D4F016B1CC6861312A6'::text)
  • Heap Fetches: 1
  • Buffers: local hit=1 read=2
9. 26.032 26.032 ↓ 0.0 0 26,032

Index Scan using "PK_INDEX" on "#lore_k1" appk1x2_ (cost=0.14..0.17 rows=1 width=9) (actual time=0.001..0.001 rows=0 loops=26,032)

  • Index Cond: ((k1)::text = (datielabap0_.cod_azienda)::text)
  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC6A51412D1'::text)
  • Rows Removed by Filter: 1
  • Buffers: local hit=52064
10. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_INDEX" on "#lore_k1" appk1x1_ (cost=0.14..0.17 rows=1 width=9) (never executed)

  • Index Cond: ((k1)::text = (datielabap0_.cod_dest5)::text)
  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC677311293'::text)
Planning time : 0.716 ms
Execution time : 323.021 ms