explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rT7T

Settings
# exclusive inclusive rows x rows loops node
1. 23.025 23.025 ↓ 1.0 50,000 1

Index Only Scan using t2_i_idx on t2 (cost=0.42..1,388.03 rows=48,663 width=4) (actual time=0.069..23.025 rows=50,000 loops=1)

  • Index Cond: (i > 950000)
  • Heap Fetches: 0
  • Buffers: shared hit=141
Planning time : 0.210 ms
Execution time : 32.870 ms