explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dgkO

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 1.299 ↑ 1.0 100 1

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

2. 0.082 1.290 ↑ 239,547.2 100 1

Nested Loop (cost=1.72..120,262,635.51 rows=23,954,718 width=131) (actual time=0.056..1.290 rows=100 loops=1)

3. 0.034 0.808 ↑ 239,547.2 100 1

Nested Loop (cost=1.15..87,069,174.17 rows=23,954,718 width=135) (actual time=0.041..0.808 rows=100 loops=1)

4. 0.174 0.174 ↑ 248,225.1 100 1

Index Scan Backward using index_ci_job_artifacts_on_expire_at_and_job_id on ci_job_artifacts (cost=0.57..19,310,751.03 rows=24,822,512 width=131) (actual time=0.023..0.174 rows=100 loops=1)

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

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

  • Index Cond: (id = ci_builds.commit_id)
  • Heap Fetches: 39
Planning time : 0.989 ms
Execution time : 1.342 ms