explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZRHm

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 2.831 ↑ 1.0 100 1

Limit (cost=1.72..1,165.00 rows=100 width=131) (actual time=1.636..2.831 rows=100 loops=1)

  • Buffers: shared hit=1,640
2. 0.083 2.809 ↑ 121,174.5 100 1

Nested Loop (cost=1.72..140,959,623.60 rows=12,117,446 width=131) (actual time=1.635..2.809 rows=100 loops=1)

  • Buffers: shared hit=1,640
3. 0.115 2.326 ↑ 242,348.9 100 1

Nested Loop (cost=1.15..88,083,059.63 rows=24,234,893 width=135) (actual time=1.616..2.326 rows=100 loops=1)

  • Buffers: shared hit=1,140
4. 1.711 1.711 ↑ 251,156.1 100 1

Index Scan using index_ci_job_artifacts_on_expire_at_and_job_id on public.ci_job_artifacts (cost=0.57..19,625,551.30 rows=25,115,614 width=131) (actual time=1.587..1.711 rows=100 loops=1)

  • Index Cond: (ci_job_artifacts.expire_at < '2020-06-23 11:41:34.895228+00'::timestamp with time zone)
  • Buffers: shared hit=640
5. 0.500 0.500 ↑ 1.0 1 100

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

  • Index Cond: (ci_builds.id = ci_job_artifacts.job_id)
  • Filter: ((ci_builds.type)::text = 'Ci::Build'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=500
6. 0.400 0.400 ↑ 1.0 1 100

Index Scan using ci_pipelines_pkey on public.ci_pipelines (cost=0.57..2.18 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (ci_pipelines.id = ci_builds.commit_id)
  • Filter: (NOT ci_pipelines.artifacts_locked)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=500