explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rq7R

Settings
# exclusive inclusive rows x rows loops node
1. 0.271 10.392 ↑ 1.0 1 1

Aggregate (cost=6,675.03..6,675.04 rows=1 width=8) (actual time=10.392..10.392 rows=1 loops=1)

  • Buffers: shared hit=9 read=3
  • I/O Timings: read=10.021
2. 10.121 10.121 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_user_id on public.ci_builds (cost=0.57..6,674.39 rows=256 width=4) (actual time=10.121..10.121 rows=0 loops=1)

  • Index Cond: ((ci_builds.user_id >= 1000000) AND (ci_builds.user_id <= 1001250))
  • Filter: ((ci_builds.created_at >= '2020-02-24 07:25:33.436925'::timestamp without time zone) AND (ci_builds.created_at <= '2020-03-23 07:25:33.436996'::timestamp without time zone) AND ((ci_builds.type)::text = 'Ci::Build'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1 read=3
  • I/O Timings: read=10.021