explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cYxe

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 32,299.143 ↑ 1.0 1 1

Limit (cost=1.84..22,424.23 rows=1 width=4) (actual time=32,299.143..32,299.143 rows=1 loops=1)

2. 4.503 32,299.141 ↑ 58.0 1 1

Nested Loop Semi Join (cost=1.84..1,300,500.26 rows=58 width=4) (actual time=32,299.141..32,299.141 rows=1 loops=1)

3. 175.518 175.518 ↑ 3.0 1,360 1

Index Only Scan Backward using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines (cost=0.57..179.56 rows=4,073 width=4) (actual time=5.684..175.518 rows=1,360 loops=1)

  • Index Cond: ((project_id = 10,186,686) AND (ref = 'master'::text) AND (status = 'success'::text))
  • Heap Fetches: 53
4. 59.724 32,119.120 ↓ 0.0 0 1,360

Nested Loop Semi Join (cost=1.27..319.24 rows=1 width=4) (actual time=23.617..23.617 rows=0 loops=1,360)

5. 27,504.640 27,504.640 ↑ 12.0 10 1,360

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.70..112.08 rows=120 width=8) (actual time=5.901..20.224 rows=10 loops=1,360)

  • 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
6. 4,554.756 4,554.756 ↓ 0.0 0 13,318

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.342..0.342 rows=0 loops=13,318)

  • Index Cond: (job_id = ci_builds.id)
  • Filter: (file_type = ANY ('{5,6,7,8,21,23}'::integer[]))
  • Rows Removed by Filter: 1
  • Heap Fetches: 953
Planning time : 371.910 ms
Execution time : 32,299.270 ms