explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nhr2

Settings
# exclusive inclusive rows x rows loops node
1. 11.497 798.355 ↑ 1.0 1 1

Aggregate (cost=79,728.02..79,728.03 rows=1 width=8) (actual time=798.354..798.355 rows=1 loops=1)

  • Buffers: shared hit=24,944 read=29,280
  • I/O Timings: read=609.335
2. 786.858 786.858 ↑ 1.0 60,658 1

Index Scan using projects_pkey on public.projects (cost=0.43..79,572.07 rows=62,381 width=4) (actual time=0.061..786.858 rows=60,658 loops=1)

  • Index Cond: ((projects.id >= 1) AND (projects.id <= 100,000))
  • Filter: ((NOT projects.disable_overriding_approvers_per_merge_request) OR (projects.disable_overriding_approvers_per_merge_request IS NULL))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=24,944 read=29,280
  • I/O Timings: read=609.335