explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6f5I

Settings
# exclusive inclusive rows x rows loops node
1. 0.322 2.814 ↑ 131.3 6 1

Aggregate (cost=0.57..951.67 rows=788 width=12) (actual time=0.970..2.814 rows=6 loops=1)

  • Group Key: date(ci_pipelines.created_at)
  • Buffers: shared hit=1,218 read=1
  • I/O Timings: read=0.249
2. 2.492 2.492 ↓ 1.6 1,251 1

Index Scan using i1 on public.ci_pipelines (cost=0.57..935.91 rows=788 width=12) (actual time=0.317..2.492 rows=1,251 loops=1)

  • Index Cond: ((ci_pipelines.project_id = 13,083) AND ('2019-09-03'::date > date(ci_pipelines.created_at)) AND (date(ci_pipelines.created_at) > '2019-08-27'::date))
  • Buffers: shared hit=1,218 read=1
  • I/O Timings: read=0.249