explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HqUx

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 111.220 ↑ 1.0 20 1

Limit (cost=64,405.13..64,405.18 rows=20 width=79) (actual time=111.213..111.220 rows=20 loops=1)

2. 0.930 111.217 ↑ 183.2 20 1

Sort (cost=64,405.13..64,414.28 rows=3,663 width=79) (actual time=111.211..111.217 rows=20 loops=1)

  • Sort Key: merge_request_metrics.merged_at DESC
  • Sort Method: top-N heapsort Memory: 28kB
3. 0.726 110.287 ↑ 1.2 3,035 1

Nested Loop (cost=1.12..64,307.65 rows=3,663 width=79) (actual time=41.753..110.287 rows=3,035 loops=1)

4. 48.681 48.681 ↑ 1.3 3,044 1

Index Scan using index_merge_requests_on_target_project_id_and_iid on merge_requests (cost=0.56..53,290.77 rows=3,999 width=63) (actual time=41.469..48.681 rows=3,044 loops=1)

  • Index Cond: (target_project_id = 13083)
  • Filter: (created_at >= '2019-06-07 08:10:33.441201+00'::timestamp with time zone)
  • Rows Removed by Filter: 28430
5. 60.880 60.880 ↑ 1.0 1 3,044

Index Only Scan using merge_request_metrics_merge_request_id_merged_at_first_depl_idx on merge_request_metrics (cost=0.56..2.74 rows=1 width=12) (actual time=0.019..0.020 rows=1 loops=3,044)

  • Index Cond: (merge_request_id = merge_requests.id)
  • Heap Fetches: 1136
Planning time : 1.531 ms
Execution time : 111.264 ms