explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tjwZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.210 ↑ 1.0 1 1

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

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

Index Only Scan using idx_projects_id_disable_overriding_approvers_created_2 on public.projects (cost=0.29..10.62 rows=89 width=4) (actual time=0.200..0.202 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.152