explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kIK9

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

Limit (cost=1,001.87..10,270.37 rows=1 width=4) (actual time=1,174.436..1,174.437 rows=1 loops=1)

  • Buffers: shared hit=817,221
2. 414.382 1,578.098 ↑ 1,169.0 1 1

Gather Merge (cost=1,001.87..10,835,878.03 rows=1,169 width=4) (actual time=1,174.435..1,578.098 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,752,022
3. 8.281 1,163.716 ↑ 487.0 1 3 / 3

Nested Loop Semi Join (cost=1.84..10,834,743.08 rows=487 width=4) (actual time=1,163.716..1,163.716 rows=1 loops=3)

  • Buffers: shared hit=1,752,022
  • -> Parallel Index Only Scan Backward using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines (cost=0.57..2391.49 rows=31,280 width=4) (actual time=0.100..6.538 rows=7,045
  • Index Cond: ((project_id = 7,764) AND (ref = 'master'::text) AND (status = 'success'::text))
  • Heap Fetches: 566
  • Buffers: shared hit=3,254
4. 35.037 1,155.435 ↓ 0.0 0 21,136 / 3

Nested Loop Semi Join (cost=1.27..346.29 rows=1 width=4) (actual time=0.164..0.164 rows=0 loops=21,136)

  • Buffers: shared hit=1,748,768
5. 704.533 704.533 ↑ 7.9 15 21,136 / 3

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.70..107.71 rows=119 width=8) (actual time=0.020..0.100 rows=15 loops=21,136)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((type)::text = 'Ci::Build'::text))
  • Filter: ((retried IS FALSE) OR (retried IS NULL))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=429,795
6. 415.864 415.864 ↓ 0.0 0 311,898 / 3

Index Only Scan using index_ci_job_artifacts_on_job_id_and_file_type on ci_job_artifacts (cost=0.57..2.00 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=311,898)

  • Index Cond: (job_id = ci_builds.id)
  • Filter: (file_type = ANY ('{5,6,7,8,21,23}'::integer[]))
  • Rows Removed by Filter: 2
  • Heap Fetches: 69,454
  • Buffers: shared hit=1,318,973
Planning time : 1.278 ms
Execution time : 1,578.157 ms