explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JoZa

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 605.657 ↓ 0.0 0 1

GroupAggregate (cost=12.85..12.90 rows=1 width=552) (actual time=605.657..605.657 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=451698 read=7385 written=1020
2. 0.008 605.655 ↓ 0.0 0 1

Sort (cost=12.85..12.85 rows=1 width=582) (actual time=605.654..605.655 rows=0 loops=1)

  • Sort Key: datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=451698 read=7385 written=1020
3. 0.001 605.647 ↓ 0.0 0 1

Nested Loop (cost=0.85..12.84 rows=1 width=582) (actual time=605.647..605.647 rows=0 loops=1)

  • Buffers: local hit=451698 read=7385 written=1020
4. 0.001 605.646 ↓ 0.0 0 1

Nested Loop (cost=0.71..10.46 rows=1 width=582) (actual time=605.646..605.646 rows=0 loops=1)

  • Buffers: local hit=451698 read=7385 written=1020
5. 205.722 605.645 ↓ 0.0 0 1

Nested Loop (cost=0.56..8.09 rows=1 width=582) (actual time=605.645..605.645 rows=0 loops=1)

  • Buffers: local hit=451698 read=7385 written=1020
6. 174.076 174.076 ↓ 225,847.0 225,847 1

Index Scan using "BASE_INDEX" on "#lore" datielabap0_ (cost=0.42..5.71 rows=1 width=582) (actual time=0.070..174.076 rows=225,847 loops=1)

  • Index Cond: (((cod_scenario)::text = 'BGT2019NO2'::text) AND ((cod_periodo)::text = '03'::text) AND ((cod_regola)::text = ANY ('{01R,02,$R$f$}'::text[])))
  • Filter: ((cod_categoria)::text = 'REVENUE'::text)
  • Rows Removed by Filter: 5134
  • Buffers: local hit=5 read=7384 written=1019
7. 225.847 225.847 ↓ 0.0 0 225,847

Index Scan using "PK_INDEX" on "#lore_k1" appk1x1_ (cost=0.14..2.37 rows=1 width=516) (actual time=0.001..0.001 rows=0 loops=225,847)

  • Index Cond: ((k1)::text = (datielabap0_.cod_dest5)::text)
  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC677311293'::text)
  • Rows Removed by Filter: 1
  • Buffers: local hit=451693 read=1 written=1
8. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_INDEX" on "#lore_k1" appk1x2_ (cost=0.14..2.37 rows=1 width=516) (never executed)

  • Index Cond: ((k1)::text = (datielabap0_.cod_azienda)::text)
  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC6A51412D1'::text)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_INDEX" on "#lore_k1" appk1x3_ (cost=0.14..2.37 rows=1 width=516) (never executed)

  • Index Cond: ((k1)::text = (datielabap0_.cod_conto)::text)
  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC6861312A6'::text)
Planning time : 0.545 ms
Execution time : 605.770 ms