explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GuKl6

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

Limit (cost=1,001.87..10,270.26 rows=1 width=4) (actual time=90,124.764..90,124.765 rows=1 loops=1)

  • Buffers: shared hit=450,271 read=138,513
  • I/O Timings: read=87,314.020
2. 353.274 90,317.985 ↑ 1,169.0 1 1

Gather Merge (cost=1,001.87..10,835,749.74 rows=1,169 width=4) (actual time=90,124.763..90,317.985 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=1,338,148 read=413,895
  • I/O Timings: read=262,703.477
3. 87.394 89,964.711 ↑ 487.0 1 3 / 3

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

  • Buffers: shared hit=1,338,148 read=413,895
  • I/O Timings: read=262,703.477
  • -> 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=1.179..78.151 rows=7,045
  • Index Cond: ((project_id = $PROJECT_ID) AND (ref = 'master'::text) AND (status = 'success'::text))
  • Heap Fetches: 564
  • Buffers: shared hit=2,943 read=317
  • I/O Timings: read=171.281
4. 176.542 89,877.317 ↓ 0.0 0 21,136 / 3

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

  • Buffers: shared hit=1,335,205 read=413,578
  • I/O Timings: read=262,532.196
5. 78,992.277 78,992.277 ↑ 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=1.786..11.212 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=87,759 read=342,036
  • I/O Timings: read=233,416.818
6. 10,708.498 10,708.498 ↓ 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.103..0.103 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,446
  • Buffers: shared hit=1,247,446 read=71,542
  • I/O Timings: read=29,115.379
Planning time : 13.938 ms
Execution time : 90,318.213 ms