explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LFMo

Settings
# exclusive inclusive rows x rows loops node
1. 2.380 596.490 ↑ 1.0 1 1

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

  • Buffers: shared hit=24,624 read=26
  • I/O Timings: read=102.460
2. 5.956 594.110 ↓ 1.3 4,843 1

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

  • Buffers: shared hit=24,624 read=26
  • I/O Timings: read=102.460
3. 108.697 108.697 ↓ 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=7.877..108.697 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=916 read=26
  • I/O Timings: read=102.460
4. 479.457 479.457 ↑ 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.099..0.099 rows=1 loops=4,843)

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