explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZOUk

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize Aggregate (cost=16,144,635.34..16,144,635.35 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Gather (cost=16,144,635.02..16,144,635.33 rows=3 width=8) (actual rows= loops=)

  • Workers Planned: 3
3. 0.000 0.000 ↓ 0.0

Partial Aggregate (cost=16,143,635.02..16,143,635.03 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5,838.91..16,143,582.63 rows=20,957 width=8) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,838.48..16,106,414.49 rows=4,430 width=12) (actual rows= loops=)

  • Hash Cond: ((a.vorgaenger_knot_nr = c.von_knoten) AND (a.knot_nr = c.nach_knoten))
6. 0.000 0.000 ↓ 0.0

Append (cost=0.00..9,147,903.26 rows=115,877,141 width=12) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on zuglaufmeldungen_2015 a (cost=0.00..9,147,903.26 rows=115,877,141 width=12) (actual rows= loops=)

  • Filter: (fahrplanjahr = 2015)
8. 0.000 0.000 ↓ 0.0

Hash (cost=4,205.12..4,205.12 rows=108,890 width=16) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append (cost=0.00..4,205.12 rows=108,890 width=16) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on visum_strecken_2015 c (cost=0.00..4,205.12 rows=108,890 width=16) (actual rows= loops=)

  • Filter: (fahrplanjahr = 2015)
11. 0.000 0.000 ↓ 0.0

Append (cost=0.43..8.38 rows=1 width=4) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Only Scan using zuglauf_2015_pkey on zuglauf_2015 b (cost=0.43..8.38 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((fahrplanjahr = 2015) AND (zuglauf_id = a.zuglauf_id))