explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n0NY

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 432.138 ↑ 1.0 100 1

Limit (cost=240,416.72..240,417.72 rows=100 width=8) (actual time=432.119..432.138 rows=100 loops=1)

  • Buffers: shared hit=160,360
2. 77.196 432.128 ↑ 1.9 100 1

HashAggregate (cost=240,416.72..240,418.57 rows=185 width=8) (actual time=432.118..432.128 rows=100 loops=1)

  • Group Key: site_id
  • Buffers: shared hit=160,360
3. 354.932 354.932 ↑ 1.0 354,579 1

Index Scan using user_pkey on "user" (cost=0.44..239,518.28 rows=359,378 width=8) (actual time=0.017..354.932 rows=354,579 loops=1)

  • Index Cond: ((id >= 20,273,520) AND (id <= 20,665,298))
  • Buffers: shared hit=160,360
Planning time : 0.083 ms
Execution time : 432.178 ms