explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7MIU

Settings
# exclusive inclusive rows x rows loops node
1. 0.473 4.996 ↑ 1.4 1,668 1

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

2. 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))
3. 4.521 4.521 ↑ 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.017..4.521 rows=1,668 loops=1)

  • Index Cond: (batter_mlb_id = 641355)
  • Filter: (season = 2019)
Planning time : 1.119 ms
Execution time : 5.361 ms