explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 98vE

Settings
# exclusive inclusive rows x rows loops node
1. 0.916 39.890 ↑ 1.0 1 1

Aggregate (cost=7,839.38..7,839.39 rows=1 width=8) (actual time=39.890..39.890 rows=1 loops=1)

  • Buffers: shared hit=24,647
2. 3.178 38.974 ↓ 1.3 4,843 1

Nested Loop (cost=1.13..7,830.13 rows=3,700 width=4) (actual time=0.075..38.974 rows=4,843 loops=1)

  • Buffers: shared hit=24,647
3. 1.895 1.895 ↓ 1.3 4,843 1

Index Only Scan using i1 on public.merge_request_metrics (cost=0.56..111.38 rows=3,700 width=4) (actual time=0.034..1.895 rows=4,843 loops=1)

  • Index Cond: ((merge_request_metrics.target_project_id = ANY ('{278964,7764}'::integer[])) AND (merge_request_metrics.merged_at > '2020-05-01 00:00:00'::timestamp without time zone) AND (merge_request_metrics.merged_at < '2020-05-31 23:59:00'::timestamp without time zone))
  • Heap Fetches: 0
  • Buffers: shared hit=939
4. 33.901 33.901 ↑ 1.0 1 4,843

Index Only Scan using merge_requests_pkey on public.merge_requests (cost=0.56..2.09 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=4,843)

  • Index Cond: (merge_requests.id = merge_request_metrics.merge_request_id)
  • Heap Fetches: 398
  • Buffers: shared hit=23,708