explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GqtM

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 459.617 ↓ 0.0 0 1

Limit (cost=28,216.95..28,216.95 rows=1 width=4) (actual time=459.617..459.617 rows=0 loops=1)

  • Buffers: shared hit=10,793 read=2,017
  • I/O Timings: read=359.025
2. 0.016 459.616 ↓ 0.0 0 1

Sort (cost=28,216.95..28,216.95 rows=2 width=4) (actual time=459.616..459.616 rows=0 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=10,793 read=2,017
  • I/O Timings: read=359.025
3. 0.140 459.600 ↓ 0.0 0 1

Nested Loop Semi Join (cost=9.69..28,216.94 rows=2 width=4) (actual time=459.600..459.600 rows=0 loops=1)

  • Buffers: shared hit=10,793 read=2,017
  • I/O Timings: read=359.025
4. 0.292 4.560 ↑ 1.0 100 1

Nested Loop (cost=8.41..222.09 rows=100 width=8) (actual time=1.509..4.560 rows=100 loops=1)

  • Buffers: shared hit=626 read=22
  • I/O Timings: read=0.324
5. 0.215 1.668 ↑ 1.0 100 1

HashAggregate (cost=7.84..8.84 rows=100 width=4) (actual time=1.484..1.668 rows=100 loops=1)

  • Group Key: ci_pipelines_1.id
  • Buffers: shared hit=126 read=2
  • I/O Timings: read=0.071
6. 1.453 1.453 ↑ 1.0 100 1

Limit (cost=0.57..6.59 rows=100 width=4) (actual time=0.158..1.453 rows=100 loops=1)

  • Buffers: shared hit=126 read=2
  • I/O Timings: read=0.071
  • -> Index Only Scan Backward using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines ci_pipelines_1 (cost=0.57..4691.47 rows=77,867 width=4) (actual time
  • Index Cond: ((project_id = 7,764) AND (ref = 'master'::text) AND (status = 'success'::text))
  • Heap Fetches: 145
  • Buffers: shared hit=126 read=2
  • I/O Timings: read=0.071
7. 2.600 2.600 ↑ 1.0 1 100

Index Only Scan using ci_pipelines_pkey on ci_pipelines (cost=0.57..2.13 rows=1 width=4) (actual time=0.026..0.026 rows=1 loops=100)

  • Index Cond: (id = ci_pipelines_1.id)
  • Heap Fetches: 100
  • Buffers: shared hit=500 read=20
  • I/O Timings: read=0.253
8. 2.660 454.900 ↓ 0.0 0 100

Nested Loop Semi Join (cost=1.27..279.94 rows=1 width=4) (actual time=4.549..4.549 rows=0 loops=100)

  • Buffers: shared hit=10,167 read=1,995
  • I/O Timings: read=358.701
9. 390.200 390.200 ↑ 5.8 21 100

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.70..71.99 rows=121 width=8) (actual time=0.359..3.902 rows=21 loops=100)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((type)::text = 'Ci::Build'::text))
  • Filter: ((retried IS FALSE) OR (retried IS NULL))
  • Buffers: shared hit=1,650 read=1,554
  • I/O Timings: read=331.419
10. 62.040 62.040 ↓ 0.0 0 2,068

Index Only Scan using index_ci_job_artifacts_on_job_id_and_file_type on ci_job_artifacts (cost=0.57..1.72 rows=1 width=4) (actual time=0.030..0.030 rows=0 loops=2,068)

  • 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: 772
  • Buffers: shared hit=8,517 read=441
  • I/O Timings: read=27.282
Planning time : 1.591 ms
Execution time : 459.700 ms