explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9pYf

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 2.739 ↑ 1.0 1 1

Aggregate (cost=767.22..767.23 rows=1 width=8) (actual time=2.739..2.739 rows=1 loops=1)

  • Buffers: shared hit=553
2. 2.641 2.641 ↑ 4.4 496 1

Index Only Scan using index_secure_ci_builds_on_user_id_created_at on public.ci_builds (cost=0.43..761.75 rows=2,190 width=4) (actual time=0.299..2.641 rows=496 loops=1)

  • Index Cond: ((ci_builds.user_id >= 0) AND (ci_builds.user_id <= 9,999) AND (ci_builds.created_at >= '2020-05-27 17:51:53.319709'::timestamp without time zone) AND (ci_builds.created_at <= '2020-06-24 17:51:53.319881'::timestamp without time zone))
  • Heap Fetches: 63
  • Buffers: shared hit=553