explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jCyJ

Settings
# exclusive inclusive rows x rows loops node
1. 10.788 76,715.302 ↑ 1.0 1 1

Aggregate (cost=176,236.80..176,236.81 rows=1 width=8) (actual time=76,715.302..76,715.302 rows=1 loops=1)

  • Buffers: shared hit=1189 read=93231 dirtied=555
  • I/O Timings: read=75750.050
2. 76,704.514 76,704.514 ↓ 1.3 9,005 1

Index Scan using index_ci_builds_on_user_id on public.ci_builds (cost=0.57..176,219.90 rows=6,761 width=4) (actual time=56.505..76,704.514 rows=9,005 loops=1)

  • Index Cond: ((ci_builds.user_id >= 4409000) AND (ci_builds.user_id <= 4410250))
  • 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: 88912
  • Buffers: shared hit=1182 read=93230 dirtied=555
  • I/O Timings: read=75750.005