explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cqYv

Settings
# exclusive inclusive rows x rows loops node
1. 1.683 39.026 ↑ 545.9 7 1

HashAggregate (cost=251.16..298.92 rows=3,821 width=12) (actual time=38.994..39.026 rows=7 loops=1)

  • Group Key: date(ci_pipelines.created_at)
  • Buffers: shared hit=2,659 read=18
  • I/O Timings: read=30.217
2. 37.343 37.343 ↑ 1.0 3,675 1

Index Only Scan using index_dosuken_test on public.ci_pipelines (cost=0.57..232.05 rows=3,821 width=12) (actual time=0.701..37.343 rows=3,675 loops=1)

  • Index Cond: ((ci_pipelines.project_id = 278,964) AND (ci_pipelines.created_at < '2020-07-29 23:59:59.999999'::timestamp without time zone) AND (ci_pipelines.created_at > '2020-07-22 00:00:00'::timestamp without time zone))
  • Heap Fetches: 2,399
  • Buffers: shared hit=2,659 read=18
  • I/O Timings: read=30.217