explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9gIw

Settings
# exclusive inclusive rows x rows loops node
1. 0.025 52.656 ↑ 1.0 1 1

Aggregate (cost=1,182.20..1,182.21 rows=1 width=8) (actual time=52.655..52.656 rows=1 loops=1)

  • Buffers: shared hit=7 read=298
  • I/O Timings: read=47.498
2. 52.631 52.631 ↑ 29.7 3 1

Index Only Scan using idx_projects_id_disable_overriding_approvers_created_at on public.projects (cost=0.56..1,181.98 rows=89 width=4) (actual time=22.163..52.631 rows=3 loops=1)

  • Index Cond: ((projects.id >= 0) AND (projects.id <= 99,999) AND (projects.disable_overriding_approvers_per_merge_request = true))
  • Heap Fetches: 1
  • Filter: projects.disable_overriding_approvers_per_merge_request
  • Rows Removed by Filter: 0
  • Buffers: shared hit=7 read=298
  • I/O Timings: read=47.498