explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yVeu

Settings
# exclusive inclusive rows x rows loops node
1. 88.541 945.120 ↓ 1.1 58,414 1

WindowAgg (cost=22,526.33..23,441.75 rows=52,310 width=48) (actual time=828.001..945.120 rows=58,414 loops=1)

2.          

CTE finished_matches

3. 134.300 246.194 ↓ 1.1 58,414 1

Sort (cost=6,565.40..6,696.17 rows=52,310 width=24) (actual time=216.829..246.194 rows=58,414 loops=1)

  • Sort Key: dota2."gameStartTime
  • Sort Method: external merge Disk: 1936kB
4. 111.894 111.894 ↓ 1.1 58,414 1

Seq Scan on dota2 (cost=0.00..2,465.65 rows=52,310 width=24) (actual time=0.035..111.894 rows=58,414 loops=1)

  • Filter: (("gameStartTime" IS NOT NULL) AND settled)
  • Rows Removed by Filter: 7019
5.          

CTE match_windows

6. 136.902 669.609 ↓ 1.1 58,414 1

Sort (cost=10,553.44..10,684.21 rows=52,310 width=44) (actual time=639.677..669.609 rows=58,414 loops=1)

  • Sort Key: finished_matches."gameStartTime
  • Sort Method: external sort Disk: 3088kB
7. 109.438 532.707 ↓ 1.1 58,414 1

WindowAgg (cost=5,145.94..6,453.69 rows=52,310 width=44) (actual time=395.589..532.707 rows=58,414 loops=1)

8. 127.556 423.269 ↓ 1.1 58,414 1

Sort (cost=5,145.94..5,276.72 rows=52,310 width=24) (actual time=395.564..423.269 rows=58,414 loops=1)

  • Sort Key: finished_matches."gameEndTime
  • Sort Method: external sort Disk: 1944kB
9. 295.713 295.713 ↓ 1.1 58,414 1

CTE Scan on finished_matches (cost=0.00..1,046.20 rows=52,310 width=24) (actual time=216.834..295.713 rows=58,414 loops=1)

10. 132.666 856.579 ↓ 1.1 58,414 1

Sort (cost=5,145.94..5,276.72 rows=52,310 width=44) (actual time=827.979..856.579 rows=58,414 loops=1)

  • Sort Key: match_windows."gameEndTime
  • Sort Method: external sort Disk: 3088kB
11. 723.913 723.913 ↓ 1.1 58,414 1

CTE Scan on match_windows (cost=0.00..1,046.20 rows=52,310 width=44) (actual time=639.683..723.913 rows=58,414 loops=1)