explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tvsZ

Settings
# exclusive inclusive rows x rows loops node
1. 9.677 29.017 ↑ 1.0 1 1

Aggregate (cost=3,475.03..3,475.04 rows=1 width=8) (actual time=29.016..29.017 rows=1 loops=1)

  • Buffers: shared hit=767
2. 19.340 19.340 ↓ 2.5 88,597 1

Index Only Scan using index_deployments_on_id_and_status_and_created_at on public.deployments (cost=0.57..3,387.17 rows=35,145 width=4) (actual time=0.040..19.340 rows=88,597 loops=1)

  • Index Cond: ((deployments.id >= 1) AND (deployments.id <= 99,999) AND (deployments.status = 2))
  • Heap Fetches: 1,391
  • Buffers: shared hit=767