explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uqpM

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 167.528 ↑ 1.0 1 1

Finalize Aggregate (cost=29,270.83..29,270.84 rows=1 width=8) (actual time=167.528..167.528 rows=1 loops=1)

2. 61.281 223.551 ↓ 1.5 3 1

Gather (cost=29,270.61..29,270.82 rows=2 width=8) (actual time=165.915..223.551 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.004 162.270 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=28,270.61..28,270.62 rows=1 width=8) (actual time=162.270..162.270 rows=1 loops=3)

4. 2.975 162.266 ↓ 0.0 0 3 / 3

Nested Loop (cost=1.13..28,270.46 rows=61 width=0) (actual time=162.266..162.266 rows=0 loops=3)

5. 33.191 33.191 ↑ 1.2 11,464 3 / 3

Parallel Index Only Scan using index_merge_requests_on_tp_id_and_merge_commit_sha_and_id on merge_requests (cost=0.56..1,043.53 rows=13,262 width=4) (actual time=0.055..33.191 rows=11,464 loops=3)

  • Index Cond: (target_project_id = 278,964)
  • Heap Fetches: 5,593
6. 126.100 126.100 ↓ 0.0 0 34,391 / 3

Index Only Scan using index_merge_request_metrics_on_merge_request_id_and_merged_at on merge_request_metrics (cost=0.56..2.05 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=34,391)

  • Index Cond: ((merge_request_id = merge_requests.id) AND (merged_at >= '2020-08-02 22:00:00'::timestamp without time zone) AND (merged_at <= '2020-07-02 22:00:00'::timestamp without time zone))
  • Heap Fetches: 0
Planning time : 0.669 ms
Execution time : 223.613 ms