explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yPBv

Settings
# exclusive inclusive rows x rows loops node
1. 71,549.582 71,549.582 ↓ 1.0 4,980,887 1

Index Scan using _ix_bluemedia_42pro_pitch_year on pitch (cost=0.56..277,028.78 rows=4,911,096 width=666) (actual time=0.024..71,549.582 rows=4,980,887 loops=1)

  • Index Cond: (year = 2,019)
Planning time : 0.164 ms
Execution time : 71,796.001 ms