explain.depesz.com

PostgreSQL's explain analyze made readable

Result: u88E

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 49.750 ↑ 1.0 1 1

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

  • Buffers: shared hit=6 read=299
  • I/O Timings: read=45.226
2. 49.736 49.736 ↑ 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=21.056..49.736 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=6 read=299
  • I/O Timings: read=45.226