explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qvHy

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

XN Limit (cost=1,501,566,058,247.81..1,501,566,058,247.94 rows=50 width=688) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Merge (cost=1,501,566,058,247.81..1,501,566,059,778.80 rows=612,394 width=688) (actual rows= loops=)

  • Merge Key: x.games
3. 0.000 0.000 ↓ 0.0

XN Network (cost=1,501,566,058,247.81..1,501,566,059,778.80 rows=612,394 width=688) (actual rows= loops=)

  • Send to leader
4. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,501,566,058,247.81..1,501,566,059,778.80 rows=612,394 width=688) (actual rows= loops=)

  • Sort Key: x.games
5. 0.000 0.000 ↓ 0.0

XN Window (cost=19,918.46..501,565,999,384.20 rows=612,394 width=688) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Network (cost=19,918.46..501,565,902,932.14 rows=612,394 width=688) (actual rows= loops=)

  • Send to slice 0
7. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=19,918.46..501,565,902,932.14 rows=612,394 width=688) (actual rows= loops=)

  • Hash Cond: ("outer".player_id = "inner".player_id)
8. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_BCAST_INNER (cost=17,799.06..467,655,492,373.47 rows=612,394 width=684) (actual rows= loops=)

  • Hash Cond: ("outer".player_id = ("inner".player_id)::bigint)
9. 0.000 0.000 ↓ 0.0

XN Hash Left Join DS_DIST_ALL_NONE (cost=16,548.30..423,628,618,509.15 rows=612,394 width=652) (actual rows= loops=)

  • Hash Cond: ("outer".season_id = "inner".season_id)
10. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=16,547.98..423,628,610,469.18 rows=612,394 width=630) (actual rows= loops=)

  • Hash Cond: (("outer".playerid)::bigint = "inner".player_id)
11. 0.000 0.000 ↓ 0.0

XN Seq Scan on calc_lol_player_season_stats x (cost=0.00..413,992.05 rows=613,565 width=612) (actual rows= loops=)

  • Filter: (((stat_group)::text = 'lol_stats:player_region*_season*_position*_role*_champion*_queue*_map*_mode*_type*_group'::text) AND ((match_group)::text = 'ALL'::text) AND (playerid IS NOT NULL))
12. 0.000 0.000 ↓ 0.0

XN Hash (cost=13,238.38..13,238.38 rows=1,323,838 width=22) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

XN Seq Scan on core_player p (cost=0.00..13,238.38 rows=1,323,838 width=22) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.26..0.26 rows=26 width=26) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

XN Seq Scan on core_season s (cost=0.00..0.26 rows=26 width=26) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,000.61..1,000.61 rows=100,061 width=36) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

XN Seq Scan on calc_player_ranking rx (cost=0.00..1,000.61 rows=100,061 width=36) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,695.52..1,695.52 rows=169,552 width=12) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Seq Scan on lol_player_profile pr (cost=0.00..1,695.52 rows=169,552 width=12) (actual rows= loops=)