explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c2zO

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 16,304.464 ↑ 1.0 100 1

Limit (cost=1.72..503.76 rows=100 width=131) (actual time=16,241.161..16,304.464 rows=100 loops=1)

2. 7.402 16,304.444 ↑ 239,489.5 100 1

Nested Loop (cost=1.72..120,234,901.45 rows=23,948,949 width=131) (actual time=16,241.160..16,304.444 rows=100 loops=1)

  • -> Index Only Scan using ci_pipelines_pkey on ci_pipelines (cost=0.57..1.39 rows=1 width=4) (actual time=0.072..0.072 rows=1loops=100)
3. 0.251 16,297.042 ↑ 239,489.5 100 1

Nested Loop (cost=1.15..87,052,559.34 rows=23,948,949 width=135) (actual time=16,240.999..16,297.042 rows=100 loops=1)

  • Index Cond: (id = ci_builds.commit_id)
  • Heap Fetches: 0
4. 16,248.591 16,248.591 ↑ 248,191.9 100 1

Index Scan using index_ci_job_artifacts_on_expire_at_and_job_id on ci_job_artifacts (cost=0.57..19,306,362.60 rows=24,819,192 width=131) (actual time=16,239.007..16,248.591 rows=100 loops=1)

  • Index Cond: (expire_at < '2020-06-23 11:41:34.895228+00'::timestamp with time zone)
5. 48.200 48.200 ↑ 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.482..0.482 rows=1 loops=100)

  • Index Cond: (id = ci_job_artifacts.job_id)
  • Filter: ((type)::text = 'Ci::Build'::text)
Planning time : 1.225 ms
Execution time : 16,304.640 ms