explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KcHf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 3.510 ↓ 0.0 0 1

Nested Loop (cost=1.27..1,217.33 rows=1 width=131) (actual time=3.510..3.510 rows=0 loops=1)

  • Buffers: shared hit=3 read=2
  • I/O Timings: read=3.480
2. 3.509 3.509 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on public.ci_builds (cost=0.70..129.25 rows=115 width=4) (actual time=3.509..3.509 rows=0 loops=1)

  • Index Cond: ((ci_builds.commit_id = 177,652,417) AND ((ci_builds.type)::text = 'Ci::Build'::text))
  • Filter: ((ci_builds.retried IS FALSE) OR (ci_builds.retried IS NULL))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=3 read=2
  • I/O Timings: read=3.480
3. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_ci_job_artifacts_on_job_id_and_file_type on public.ci_job_artifacts (cost=0.57..9.45 rows=1 width=131) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_job_artifacts.job_id = ci_builds.id)
  • Filter: (ci_job_artifacts.file_type = ANY ('{5,6,7,8,21,23}'::integer[]))
  • Rows Removed by Filter: 0