explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oBZL

Settings
# exclusive inclusive rows x rows loops node
1. 2,037.619 1,040,987.520 ↑ 1.0 1 1

Aggregate (cost=1,967,858.49..1,967,858.50 rows=1 width=8) (actual time=1,040,987.519..1,040,987.520 rows=1 loops=1)

  • Buffers: shared hit=12,692 read=972,397 dirtied=2,604 written=4
  • I/O Timings: read=1,023,615.644 write=0.622
2. 1,038,949.901 1,038,949.901 ↑ 1.0 1,071,073 1

Index Scan using index_ci_builds_on_user_id on public.ci_builds (cost=0.57..1,965,102.53 rows=1,102,385 width=4) (actual time=0.048..1,038,949.901 rows=1,071,073 loops=1)

  • Index Cond: ((ci_builds.user_id >= 1) AND (ci_builds.user_id <= 1,250))
  • Filter: ((ci_builds.type)::text = 'Ci::Build'::text)
  • Rows Removed by Filter: 5,516
  • Buffers: shared hit=12,689 read=972,397 dirtied=2,604 written=4
  • I/O Timings: read=1,023,615.644 write=0.622