explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Sq2u

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.383 ↑ 1.0 1 1

Result (cost=0.37..0.38 rows=1 width=4) (actual time=0.383..0.383 rows=1 loops=1)

  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.264
2.          

Initplan (for Result)

3. 0.001 0.377 ↑ 1.0 1 1

Limit (cost=0.29..0.37 rows=1 width=4) (actual time=0.377..0.377 rows=1 loops=1)

  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.264
4. 0.376 0.376 ↑ 21,472.0 1 1

Index Only Scan using idx_projects_id_disable_overriding_approvers_created_at on public.projects (cost=0.29..1,860.82 rows=21,472 width=4) (actual time=0.375..0.376 rows=1 loops=1)

  • Index Cond: (projects.id IS NOT NULL)
  • Heap Fetches: 1
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=0.264