explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KFHz

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 3,408.085 ↑ 1.0 1 1

Aggregate (cost=121,656.17..121,656.18 rows=1 width=8) (actual time=3,408.085..3,408.085 rows=1 loops=1)

  • Buffers: shared hit=6782 read=20769
2. 0.005 3,408.081 ↑ 313.0 1 1

HashAggregate (cost=121,649.13..121,652.26 rows=313 width=56) (actual time=3,408.081..3,408.081 rows=1 loops=1)

  • Group Key: t_rechenlauf_ergebnisse_part_07.jahr, (NULL::text), (count(*)), t_rechenlauf_ergebnisse_part_07.id_rechenlauf
  • Buffers: shared hit=6782 read=20769
3. 0.002 3,408.076 ↑ 313.0 1 1

Append (cost=121,556.52..121,646.00 rows=313 width=56) (actual time=3,408.047..3,408.076 rows=1 loops=1)

  • Buffers: shared hit=6782 read=20769
4. 0.000 3,408.046 ↑ 312.0 1 1

Finalize GroupAggregate (cost=121,556.52..121,637.13 rows=312 width=56) (actual time=3,408.046..3,408.046 rows=1 loops=1)

  • Group Key: t_rechenlauf_ergebnisse_part_07.id_rechenlauf, t_rechenlauf_ergebnisse_part_07.jahr
  • Buffers: shared hit=6781 read=20769
5. 0.000 3,457.908 ↑ 208.0 3 1

Gather Merge (cost=121,556.52..121,629.33 rows=624 width=24) (actual time=3,408.039..3,457.908 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=21643 read=57189
6. 0.108 10,018.485 ↑ 312.0 1 3

Sort (cost=120,556.50..120,557.28 rows=312 width=24) (actual time=3,339.494..3,339.495 rows=1 loops=3)

  • Sort Key: t_rechenlauf_ergebnisse_part_07.jahr
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=21643 read=57189
7. 541.344 10,018.377 ↑ 312.0 1 3

Partial HashAggregate (cost=120,540.45..120,543.57 rows=312 width=24) (actual time=3,339.457..3,339.459 rows=1 loops=3)

  • Group Key: t_rechenlauf_ergebnisse_part_07.id_rechenlauf, t_rechenlauf_ergebnisse_part_07.jahr
  • Buffers: shared hit=21629 read=57189
8. 131.109 9,477.033 ↑ 1.2 764,246 3

Parallel Append (cost=0.56..113,383.01 rows=954,326 width=16) (actual time=26.230..3,159.011 rows=764,246 loops=3)

  • Buffers: shared hit=21629 read=57189
9. 9,345.924 9,345.924 ↑ 1.2 764,246 3

Parallel Index Scan using t_rechenlauf_ergebnisse_part_07_id_rechenlauf_idx on t_rechenlauf_ergebnisse_part_07 (cost=0.56..108,611.38 rows=954,326 width=16) (actual time=26.225..3,115.308 rows=764,246 loops=3)

  • Index Cond: (id_rechenlauf = 308)
  • Filter: (jahr IS NOT NULL)
  • Buffers: shared hit=21629 read=57189
10. 0.000 0.028 ↓ 0.0 0 1

GroupAggregate (cost=4.16..4.18 rows=1 width=56) (actual time=0.028..0.028 rows=0 loops=1)

  • Group Key: t_rechenlauf_ergebnisse_part_07_1.id_rechenlauf, t_rechenlauf_ergebnisse_part_07_1.bilanz_zeitraum
  • Buffers: shared hit=1
11. 0.015 0.028 ↓ 0.0 0 1

Sort (cost=4.16..4.16 rows=1 width=40) (actual time=0.028..0.028 rows=0 loops=1)

  • Sort Key: t_rechenlauf_ergebnisse_part_07_1.bilanz_zeitraum
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
12. 0.001 0.013 ↓ 0.0 0 1

Append (cost=0.13..4.15 rows=1 width=40) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=1
13. 0.012 0.012 ↓ 0.0 0 1

Index Only Scan using t_rechenlauf_ergebnisse_part__id_rechenlauf_id_var_bilanz__idx6 on t_rechenlauf_ergebnisse_part_07 t_rechenlauf_ergebnisse_part_07_1 (cost=0.13..4.14 rows=1 width=40) (actual time=0.012..0.012 rows=0 loops=1)

  • Index Cond: (id_rechenlauf = 308)
  • Heap Fetches: 0
  • Buffers: shared hit=1
Planning time : 2.756 ms
Execution time : 3,458.246 ms