explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ICp9

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 125.498 ↑ 1.0 100 1

Limit (cost=1.72..503.77 rows=100 width=131) (actual time=124.724..125.498 rows=100 loops=1)

2. 0.084 125.488 ↑ 239,490.9 100 1

Nested Loop (cost=1.72..120,236,089.26 rows=23,949,085 width=131) (actual time=124.723..125.488 rows=100 loops=1)

3. 0.035 125.204 ↑ 239,490.9 100 1

Nested Loop (cost=1.15..87,053,371.57 rows=23,949,085 width=135) (actual time=124.706..125.204 rows=100 loops=1)

4. 124.769 124.769 ↑ 248,193.3 100 1

Index Scan using index_ci_job_artifacts_on_expire_at_and_job_id on ci_job_artifacts (cost=0.57..19,306,585.44 rows=24,819,333 width=131) (actual time=124.675..124.769 rows=100 loops=1)

  • Index Cond: (expire_at < '2020-06-23 11:41:34.895228+00'::timestamp with time zone)
5. 0.400 0.400 ↑ 1.0 1 100

Index Scan using ci_builds_pkey on ci_builds (cost=0.57..2.73 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (id = ci_job_artifacts.job_id)
  • Filter: ((type)::text = 'Ci::Build'::text)
6. 0.200 0.200 ↑ 1.0 1 100

Index Only Scan using ci_pipelines_pkey on ci_pipelines (cost=0.57..1.39 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (id = ci_builds.commit_id)
  • Heap Fetches: 0
Planning time : 1.153 ms
Execution time : 125.565 ms