explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pF5X

Settings
# exclusive inclusive rows x rows loops node
1. 11.404 2,432.362 ↑ 2.6 23 1

Subquery Scan on t (cost=354,495.19..358,325.19 rows=60 width=47) (actual time=2,308.046..2,432.362 rows=23 loops=1)

  • Filter: (t.player_mlbam_id = ANY ('{592518,608369}'::integer[]))
  • Rows Removed by Filter: 49940
2. 109.218 2,420.958 ↑ 1.9 49,963 1

WindowAgg (cost=354,495.19..357,128.31 rows=95,750 width=47) (actual time=2,290.510..2,420.958 rows=49,963 loops=1)

3. 239.070 2,311.740 ↑ 1.9 49,963 1

Sort (cost=354,495.19..354,734.56 rows=95,750 width=39) (actual time=2,290.420..2,311.740 rows=49,963 loops=1)

  • Sort Key: pro_player_ytd_batting.sport_code, pro_player_ytd_batting.game_type, pro_player_ytd_batting.slg
  • Sort Method: quicksort Memory: 5440kB
4. 100.350 2,072.670 ↑ 1.9 49,963 1

WindowAgg (cost=343,940.20..346,573.32 rows=95,750 width=39) (actual time=1,942.207..2,072.670 rows=49,963 loops=1)

5. 379.560 1,972.320 ↑ 1.9 49,963 1

Sort (cost=343,940.20..344,179.57 rows=95,750 width=31) (actual time=1,941.992..1,972.320 rows=49,963 loops=1)

  • Sort Key: pro_player_ytd_batting.sport_code, pro_player_ytd_batting.game_type, pro_player_ytd_batting.obp
  • Sort Method: quicksort Memory: 5440kB
6. 467.123 1,592.760 ↑ 1.9 49,963 1

Bitmap Heap Scan on pro_player_ytd_batting (cost=77,890.00..336,018.33 rows=95,750 width=31) (actual time=1,127.358..1,592.760 rows=49,963 loops=1)

  • Recheck Cond: ((year = 2018) AND (split = 'all'::text))
  • Heap Blocks: exact=4746
7. 1,125.637 1,125.637 ↑ 1.9 49,963 1

Bitmap Index Scan on pk_fortytwo_pro_player_ytd_batting (cost=0.00..77,866.06 rows=95,750 width=0) (actual time=1,125.637..1,125.637 rows=49,963 loops=1)

  • Index Cond: ((year = 2018) AND (split = 'all'::text))
Planning time : 4.876 ms
Execution time : 2,436.183 ms