explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A4YW

Settings
# exclusive inclusive rows x rows loops node
1. 12.267 1,032.891 ↑ 1.0 1 1

Aggregate (cost=115,238.35..115,238.36 rows=1 width=8) (actual time=1,032.891..1,032.891 rows=1 loops=1)

  • Buffers: shared hit=9752 read=2084 dirtied=23
  • I/O Timings: read=957.857
2. 1,020.624 1,020.624 ↑ 1.0 83,280 1

Index Scan using project_features_pkey on public.project_features (cost=0.43..115,027.78 rows=84,229 width=4) (actual time=0.023..1,020.624 rows=83,280 loops=1)

  • Index Cond: ((project_features.id >= 1) AND (project_features.id <= 100000))
  • Filter: (project_features.repository_access_level > 0)
  • Rows Removed by Filter: 8
  • Buffers: shared hit=9752 read=2084 dirtied=23
  • I/O Timings: read=957.857