explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rEdT

Settings
# exclusive inclusive rows x rows loops node
1. 0.079 0.526 ↑ 1.0 1 1

Aggregate (cost=44.33..44.34 rows=1 width=8) (actual time=0.526..0.526 rows=1 loops=1)

  • Buffers: shared hit=19
2. 0.447 0.447 ↑ 39.0 3 1

Index Only Scan using ci_builds_user_id_created_at_idx on public.ci_builds (cost=0.42..44.04 rows=117 width=4) (actual time=0.364..0.447 rows=3 loops=1)

  • Index Cond: ((ci_builds.user_id >= 20,000) AND (ci_builds.user_id <= 30,000) AND (ci_builds.created_at >= '2020-05-26 05:25:26.510804'::timestamp without time zone) AND (ci_builds.created_at <= '2020-06-23 05:25:26.510907'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=11