explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XJdO

Settings
# exclusive inclusive rows x rows loops node
1. 10.487 423.729 ↑ 1.0 1 1

Aggregate (cost=3,243.70..3,243.71 rows=1 width=8) (actual time=423.728..423.729 rows=1 loops=1)

  • Buffers: shared hit=208 read=462
  • I/O Timings: read=393.124
2. 413.242 413.242 ↑ 1.0 88,598 1

Index Only Scan using deployments_pkey on public.deployments (cost=0.57..3,020.78 rows=89,165 width=4) (actual time=7.603..413.242 rows=88,598 loops=1)

  • Index Cond: ((deployments.id >= 1) AND (deployments.id <= 100,000))
  • Heap Fetches: 1,391
  • Buffers: shared hit=208 read=462
  • I/O Timings: read=393.124