explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kKG2

Settings
# exclusive inclusive rows x rows loops node
1. 407.440 977.961 ↓ 39,458.4 434,042 1

Nested Loop (cost=0.56..20,208.77 rows=11 width=2,295) (actual time=1.809..977.961 rows=434,042 loops=1)

2. 0.597 5.069 ↑ 1.4 1,668 1

Append (cost=0.00..48.95 rows=2,351 width=2,028) (actual time=0.022..5.069 rows=1,668 loops=1)

3. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on aggregated_pitches pitch (cost=0.00..0.00 rows=1 width=2,846) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((season = 2019) AND (batter_mlb_id = 641355))
4. 4.470 4.470 ↑ 1.4 1,668 1

Index Scan using aggregated_pitches_2019_batter_mlb_id_idx on aggregated_pitches_2019 pitch_1 (cost=0.43..48.95 rows=2,350 width=2,028) (actual time=0.020..4.470 rows=1,668 loops=1)

  • Index Cond: (batter_mlb_id = 641355)
  • Filter: (season = 2019)
5. 565.452 565.452 ↓ 260.0 260 1,668

Index Scan using pk_secret_pitch_value_v5_0 on pitch_value_v5_0 pv (cost=0.56..8.56 rows=1 width=267) (actual time=0.067..0.339 rows=260 loops=1,668)

  • Index Cond: (game_id = pitch.mlbam_pbp_game_id)
  • Filter: ((atbat_per_game = atbat_per_game) AND (pitch_per_atbat = pitch_per_atbat))
Planning time : 1.990 ms
Execution time : 1,035.645 ms