explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ckbc

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 15,821.416 ↓ 0.0 0 1

GroupAggregate (cost=6,407.31..6,407.36 rows=1 width=552) (actual time=15,821.416..15,821.416 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=451694 read=6242 written=1022
2. 0.008 15,821.414 ↓ 0.0 0 1

Sort (cost=6,407.31..6,407.32 rows=1 width=582) (actual time=15,821.414..15,821.414 rows=0 loops=1)

  • Sort Key: datielabap0_.cod_dest2, datielabap0_.cod_dest5
  • Sort Method: quicksort Memory: 25kB
  • Buffers: local hit=451694 read=6242 written=1022
3. 0.000 15,821.406 ↓ 0.0 0 1

Nested Loop (cost=0.00..6,407.30 rows=1 width=582) (actual time=15,821.406..15,821.406 rows=0 loops=1)

  • Join Filter: ((datielabap0_.cod_conto)::text = (appk1x3_.k1)::text)
  • Buffers: local hit=451694 read=6242 written=1022
4. 0.002 15,821.406 ↓ 0.0 0 1

Nested Loop (cost=0.00..6,396.42 rows=1 width=582) (actual time=15,821.406..15,821.406 rows=0 loops=1)

  • Join Filter: ((datielabap0_.cod_azienda)::text = (appk1x2_.k1)::text)
  • Buffers: local hit=451694 read=6242 written=1022
5. 6,593.068 15,821.404 ↓ 0.0 0 1

Nested Loop (cost=0.00..6,385.53 rows=1 width=582) (actual time=15,821.404..15,821.404 rows=0 loops=1)

  • Join Filter: ((datielabap0_.cod_dest5)::text = (appk1x1_.k1)::text)
  • Rows Removed by Join Filter: 18971148
  • Buffers: local hit=451694 read=6242 written=1022
6. 194.456 194.456 ↓ 225,847.0 225,847 1

Seq Scan on app_consu datielabap0_ (cost=0.00..6,374.64 rows=1 width=582) (actual time=0.047..194.456 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 written=1022
7. 9,033.880 9,033.880 ↓ 84.0 84 225,847

Seq Scan on app_consu_k1 appk1x1_ (cost=0.00..10.88 rows=1 width=516) (actual time=0.002..0.040 rows=84 loops=225,847)

  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC677311293'::text)
  • Rows Removed by Filter: 75
  • Buffers: local hit=451694
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on app_consu_k1 appk1x2_ (cost=0.00..10.88 rows=1 width=516) (never executed)

  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC6A51412D1'::text)
9. 0.000 0.000 ↓ 0.0 0

Seq Scan on app_consu_k1 appk1x3_ (cost=0.00..10.88 rows=1 width=516) (never executed)

  • Filter: ((cid)::text = 'FF8081816B1C9D4F016B1CC6861312A6'::text)
Planning time : 0.244 ms
Execution time : 15,821.504 ms