explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iLFd

Settings
# exclusive inclusive rows x rows loops node
1. 3.213 21.340 ↑ 45.2 28 1

Aggregate (cost=0.57..1,527.41 rows=1,266 width=12) (actual time=0.134..21.340 rows=28 loops=1)

  • Group Key: date(ci_pipelines.created_at)
  • Buffers: shared hit=12,884
2. 18.127 18.127 ↓ 10.4 13,169 1

Index Scan using i1 on public.ci_pipelines (cost=0.57..1,502.09 rows=1,266 width=12) (actual time=0.040..18.127 rows=13,169 loops=1)

  • Index Cond: ((ci_pipelines.project_id = 278,964) AND ('2020-03-01'::date > date(ci_pipelines.created_at)) AND (date(ci_pipelines.created_at) > '2020-02-01'::date))
  • Buffers: shared hit=12,884