explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nu68

Settings
# exclusive inclusive rows x rows loops node
1. 8.215 507.635 ↑ 1.0 1 1

Aggregate (cost=20,901.63..20,901.64 rows=1 width=8) (actual time=507.635..507.635 rows=1 loops=1)

  • Buffers: shared hit=193 read=539 dirtied=206
  • I/O Timings: read=438.963
2. 499.420 499.420 ↑ 1.0 65,490 1

Index Only Scan using protected_branches_pkey on public.protected_branches (cost=0.43..20,737.77 rows=65,543 width=4) (actual time=1.853..499.420 rows=65,490 loops=1)

  • Index Cond: ((protected_branches.id >= 1) AND (protected_branches.id <= 100000))
  • Heap Fetches: 31971
  • Buffers: shared hit=193 read=539 dirtied=206
  • I/O Timings: read=438.963