explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3w0O

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

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

2. 0.005 7.571 ↓ 0.0 0 1

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

3. 0.004 7.533 ↑ 10.5 11 1

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

4. 0.001 7.465 ↑ 1.0 1 1

Limit (cost=23.57..23.57 rows=1 width=4) (actual time=7.464..7.465 rows=1 loops=1)

5. 0.318 7.464 ↑ 1.0 1 1

Sort (cost=23.57..23.57 rows=1 width=4) (actual time=7.464..7.464 rows=1 loops=1)

  • Sort Key: ci_pipelines.id DESC
  • Sort Method: top-N heapsort Memory: 25kB
6. 7.146 7.146 ↓ 2,746.0 2,746 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.034..7.146 rows=2,746 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.064 0.064 ↑ 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.026..0.064 rows=11 loops=1)

  • Index Cond: ((commit_id = ci_pipelines.id) AND ((type)::text = 'Ci::Build'::text))
8. 0.033 0.033 ↓ 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.003..0.003 rows=0 loops=11)

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