explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ChxF

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

Aggregate (cost=10.84..10.85 rows=1 width=8) (actual time=0.135..0.136 rows=1 loops=1)

  • Buffers: shared hit=3 read=2
  • I/O Timings: read=0.088
2. 0.126 0.126 ↑ 29.7 3 1

Index Only Scan using idx_projects_id_disable_overriding_approvers_created_at on public.projects (cost=0.29..10.62 rows=89 width=4) (actual time=0.123..0.126 rows=3 loops=1)

  • Index Cond: ((projects.id >= 0) AND (projects.id <= 99,999))
  • Heap Fetches: 1
  • Buffers: shared hit=3 read=2
  • I/O Timings: read=0.088