explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tgaA

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

Hash Right Join (cost=251,305.60..263,202.24 rows=200,920 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=119,671.33..174,229.36 rows=177,415 width=27) (actual rows= loops=)

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

Gather Merge (cost=119,671.33..169,793.98 rows=354,830 width=27) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=118,671.31..127,837.77 rows=177,415 width=27) (actual rows= loops=)

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

Sort (cost=118,671.31..120,519.39 rows=739,231 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,923.31 rows=739,231 width=27) (actual rows= loops=)

8.          

CTE w_flags

9. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.42..51,941.96 rows=200,920 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,476.44 rows=790,804 width=11) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

CTE Scan on w_playerwins pw (cost=0.00..3,548.30 rows=177,415 width=72) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=20,856.78..20,856.78 rows=200,920 width=41) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,766.73..20,856.78 rows=200,920 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..4,018.40 rows=200,920 width=64) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=5239.77..5239.77 rows=202877 width=9)" -> Seq Scan on ""Tournaments"" t (cost=0.00..5,239.77 rows=202,877 width=9) (actual rows= loops=)