explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z1dx

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

Limit (cost=156.59..156.60 rows=1 width=131) (actual time=1,181.012..1,181.012 rows=0 loops=1)

2. 0.077 1,181.011 ↓ 0.0 0 1

Sort (cost=156.59..156.60 rows=1 width=131) (actual time=1,181.011..1,181.011 rows=0 loops=1)

  • Sort Key: ci_job_artifacts.id DESC
  • Sort Method: quicksort Memory: 25kB
3. 9.729 1,180.934 ↓ 0.0 0 1

Nested Loop (cost=1.84..156.58 rows=1 width=131) (actual time=1,180.934..1,180.934 rows=0 loops=1)

4. 6.738 960.141 ↓ 7,538.0 30,152 1

Nested Loop (cost=1.27..147.55 rows=4 width=4) (actual time=0.150..960.141 rows=30,152 loops=1)

5. 100.641 100.641 ↓ 2,742.0 2,742 1

Index Scan using index_ci_pipelines_on_project_id_and_sha on ci_pipelines (cost=0.70..23.56 rows=1 width=4) (actual time=0.101..100.641 rows=2,742 loops=1)

  • Index Cond: ((project_id = 9,209,370) AND ((sha)::text = ANY ('{d63bc690cee4ecbfcfeab2eb73437bb1d0fd6f79,1b211f10c0b190d28258d5c870c080c4a3ec7186,99e9e1bda801f296480dc42ca20090bb9cfbc9b5,bb31f6db7754d16148f431d17fb301273ed37951,888c42c250b33f86c92776d6ca5d91697e7129d7,b2f6a184b5da0155a2bc86a62277e9114e250fec,2cadbb84d118edef8141df204179b9dc2eba9705,9c81378711729f027a6a284300d2918b101236d1,efc6bc52de42cb6791d3dfc905e90222eb122d9d,f22559497722451b248af1b201d04ede6a9158ff}'::text[])))
6. 852.762 852.762 ↑ 10.5 11 2,742

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on ci_builds (cost=0.57..122.83 rows=116 width=8) (actual time=0.064..0.311 rows=11 loops=2,742)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((type)::text = 'Ci::Build'::text))
7. 211.064 211.064 ↓ 0.0 0 30,152

Index Scan using index_ci_job_artifacts_on_job_id_and_file_type on ci_job_artifacts (cost=0.57..2.26 rows=1 width=131) (actual time=0.007..0.007 rows=0 loops=30,152)

  • Index Cond: ((job_id = ci_builds.id) AND (file_type = 15))
Planning time : 10.734 ms
Execution time : 1,181.167 ms