explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y7Iu

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

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

2. 0.065 1.203 ↑ 239,557.6 100 1

Nested Loop (cost=1.72..120,267,890.90 rows=23,955,757 width=131) (actual time=0.051..1.203 rows=100 loops=1)

3. 0.090 0.738 ↑ 239,557.6 100 1

Nested Loop (cost=1.15..87,072,939.63 rows=23,955,757 width=135) (actual time=0.036..0.738 rows=100 loops=1)

4. 0.148 0.148 ↑ 248,235.9 100 1

Index Scan Backward using index_ci_job_artifacts_on_expire_at_and_job_id on ci_job_artifacts (cost=0.57..19,311,652.68 rows=24,823,589 width=131) (actual time=0.020..0.148 rows=100 loops=1)

  • Index Cond: (expire_at < '2020-06-23 11:41:34.895228+00'::timestamp with time zone)
5. 0.500 0.500 ↑ 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.005..0.005 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 : 1.127 ms
Execution time : 1.256 ms