explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xxix

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 12,967.942 ↑ 1.0 1 1

Limit (cost=1.84..22,619.11 rows=1 width=4) (actual time=12,967.942..12,967.942 rows=1 loops=1)

2. 2.650 12,967.940 ↑ 50.0 1 1

Nested Loop Semi Join (cost=1.84..1,130,865.23 rows=50 width=4) (actual time=12,967.940..12,967.940 rows=1 loops=1)

3. 27.925 27.925 ↑ 2.4 1,407 1

Index Only Scan Backward using index_ci_pipelines_on_project_id_and_ref_and_status_and_id on ci_pipelines (cost=0.57..298.00 rows=3,342 width=4) (actual time=1.079..27.925 rows=1,407 loops=1)

  • Index Cond: ((project_id = 10,186,686) AND (ref = 'master'::text) AND (status = 'success'::text))
  • Heap Fetches: 92
4. 33.054 12,937.365 ↓ 0.0 0 1,407

Nested Loop Semi Join (cost=1.27..338.28 rows=1 width=4) (actual time=9.195..9.195 rows=0 loops=1,407)

5. 10,964.751 10,964.751 ↑ 11.8 10 1,407

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.70..109.96 rows=118 width=8) (actual time=2.207..7.793 rows=10 loops=1,407)

  • 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. 1,939.560 1,939.560 ↓ 0.0 0 13,854

Index Only Scan using index_ci_job_artifacts_on_job_id_and_file_type on ci_job_artifacts (cost=0.57..1.92 rows=1 width=4) (actual time=0.140..0.140 rows=0 loops=13,854)

  • 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: 1,140
Planning time : 14.386 ms
Execution time : 12,968.050 ms