explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zc5o

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 155.358 ↑ 1.0 100 1

Limit (cost=1.72..503.76 rows=100 width=131) (actual time=125.071..155.358 rows=100 loops=1)

2. 0.074 155.343 ↑ 239,547.9 100 1

Nested Loop (cost=1.72..120,262,985.26 rows=23,954,787 width=131) (actual time=125.070..155.343 rows=100 loops=1)

3. 0.134 154.169 ↑ 239,547.9 100 1

Nested Loop (cost=1.15..87,069,428.31 rows=23,954,787 width=135) (actual time=125.049..154.169 rows=100 loops=1)

4. 130.135 130.135 ↑ 248,225.8 100 1

Index Scan using index_ci_job_artifacts_on_expire_at_and_job_id on ci_job_artifacts (cost=0.57..19,310,809.33 rows=24,822,584 width=131) (actual time=125.013..130.135 rows=100 loops=1)

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

  • Index Cond: (id = ci_job_artifacts.job_id)
  • Filter: ((type)::text = 'Ci::Build'::text)
6. 1.100 1.100 ↑ 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.011..0.011 rows=1 loops=100)

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