explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jb1J

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

Hash Right Join (cost=246,637.00..258,292.77 rows=199,122 width=81) (actual rows= loops=)

  • Hash Cond: (pw.""TournamentNumber"" = t.""TournamentNumber"")
2.          

CTE w_playerwins

3. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=116,897.15..170,233.99 rows=173,444 width=27) (actual rows= loops=)

  • Group Key: pw_1.""TournamentNumber"", pw_1.""Username"
4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=116,897.15..165,897.89 rows=346,888 width=27) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=115,897.12..124,858.38 rows=173,444 width=27) (actual rows= loops=)

  • Group Key: pw_1.""TournamentNumber"", pw_1.""Username"
6. 0.000 0.000 ↓ 0.0

Sort (cost=115,897.12..117,703.83 rows=722,682 width=27) (actual rows= loops=)

  • Sort Key: pw_1.""TournamentNumber"", pw_1.""Username"
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on ""PlayerWins"" pw_1 (cost=0.00..28,275.82 rows=722,682 width=27) (actual rows= loops=)

8.          

CTE w_flags

9. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.42..51,502.36 rows=199,122 width=41) (actual rows= loops=)

  • Group Key: f_1.""TournamentNumber"
10. 0.000 0.000 ↓ 0.0

Index Only Scan using ""IX_Flags_TournamentNumber_Value"" on ""Flags"" f_1 (cost=0.42..45,094.69 rows=783,730 width=11) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

CTE Scan on w_playerwins pw (cost=0.00..3,468.88 rows=173,444 width=72) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=20,660.63..20,660.63 rows=199,122 width=41) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,679.26..20,660.63 rows=199,122 width=41) (actual rows= loops=)

  • Hash Cond: (f.""TournamentNumber"" = t.""TournamentNumber"")
14. 0.000 0.000 ↓ 0.0

CTE Scan on w_flags f (cost=0.00..3,982.44 rows=199,122 width=64) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=5187.56..5187.56 rows=200856 width=9)" -> Seq Scan on ""Tournaments"" t (cost=0.00..5,187.56 rows=200,856 width=9) (actual rows= loops=)