explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hpRU

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 5.986 ↑ 1.0 1 1

Result (cost=0.49..0.50 rows=1 width=4) (actual time=5.985..5.986 rows=1 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=5.907
2.          

Initplan (for Result)

3. 0.001 5.981 ↑ 1.0 1 1

Limit (cost=0.43..0.49 rows=1 width=4) (actual time=5.981..5.981 rows=1 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=5.907
4. 5.980 5.980 ↑ 12,714,736.0 1 1

Index Scan using project_features_pkey on public.project_features (cost=0.43..661,552.34 rows=12,714,736 width=4) (actual time=5.979..5.980 rows=1 loops=1)

  • Index Cond: (project_features.id IS NOT NULL)
  • Filter: (project_features.repository_access_level > 0)
  • Rows Removed by Filter: 0
  • Buffers: shared read=4
  • I/O Timings: read=5.907