explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wmyB

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

Limit (cost=24.72..402.42 rows=1 width=131) (actual time=7.944..7.944 rows=0 loops=1)

2. 0.009 7.943 ↓ 0.0 0 1

Nested Loop (cost=24.72..402.42 rows=1 width=131) (actual time=7.943..7.943 rows=0 loops=1)

3. 0.007 7.912 ↑ 10.5 11 1

Nested Loop (cost=24.14..147.58 rows=116 width=4) (actual time=7.746..7.912 rows=11 loops=1)

4. 0.001 7.702 ↑ 1.0 1 1

Limit (cost=23.57..23.57 rows=1 width=1,782) (actual time=7.702..7.702 rows=1 loops=1)

5. 0.563 7.701 ↑ 1.0 1 1

Sort (cost=23.57..23.57 rows=1 width=1,782) (actual time=7.701..7.701 rows=1 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
6. 7.138 7.138 ↓ 2,743.0 2,743 1

Index Scan using index_ci_pipelines_on_project_id_and_sha on ci_pipelines (cost=0.70..23.56 rows=1 width=1,782) (actual time=0.040..7.138 rows=2,743 loops=1)

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

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.039..0.203 rows=11 loops=1)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((type)::text = 'Ci::Build'::text))
8. 0.022 0.022 ↓ 0.0 0 11

Index Scan using index_ci_job_artifacts_on_job_id_and_file_type on ci_job_artifacts (cost=0.57..2.20 rows=1 width=131) (actual time=0.002..0.002 rows=0 loops=11)

  • Index Cond: ((job_id = ci_builds.id) AND (file_type = 15))
Planning time : 1.539 ms
Execution time : 8.013 ms