explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fqIi

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.060 ↓ 0.0 0 1

HashAggregate (cost=369.56..369.60 rows=4 width=4,108) (actual time=0.060..0.060 rows=0 loops=1)

  • Group Key: ci_builds.id, ci_builds.status, ci_builds.finished_at, ci_builds.trace, ci_builds.created_at, ci_builds.updated_at, ci_builds.started_at, ci_builds.runner_id, ci_builds.coverage, ci_builds.commit_id, ci_builds.commands, ci_builds.name, ci_builds.options, ci_builds.allow_failure, ci_builds.stage, ci_builds.trigger_request_id, ci_builds.stage_idx, ci_builds.tag, ci_builds.ref, ci_builds.user_id, ci_builds.type, ci_builds.target_url, ci_builds.description, ci_builds.artifacts_file, ci_builds.project_id, ci_builds.artifacts_metadata, ci_builds.erased_by_id, ci_builds.erased_at, ci_builds.artifacts_expire_at, ci_builds.environment, ci_builds.artifacts_size, ci_builds."when", ci_builds.yaml_variables, ci_builds.queued_at, ci_builds.token, ci_builds.lock_version, ci_builds.coverage_regex, ci_builds.auto_canceled_by_id, ci_builds.retried, ci_builds.stage_id, ci_builds.artifacts_file_store, ci_builds.artifacts_metadata_store, ci_builds.protected, ci_builds.failure_reason, ci_builds.scheduled_at, ci_builds.token_encrypted, ci_builds.upstream_pipeline_id
  • Buffers: shared hit=16
2. 0.001 0.058 ↓ 0.0 0 1

Append (cost=0.57..369.09 rows=4 width=4,108) (actual time=0.058..0.058 rows=0 loops=1)

  • Buffers: shared hit=16
3. 0.051 0.051 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on public.ci_builds (cost=0.57..92.26 rows=1 width=1,476) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: ((ci_builds.commit_id = 86460650) AND ((ci_builds.type)::text = 'Ci::Build'::text))
  • Filter: (ci_builds.options ~~ '%:artifacts:%:reports:%:sast:%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4
4. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on public.ci_builds ci_builds_1 (cost=0.57..92.26 rows=1 width=1,476) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((ci_builds_1.commit_id = 86460650) AND ((ci_builds_1.type)::text = 'Ci::Build'::text))
  • Filter: (ci_builds_1.options ~~ '%:artifacts:%:reports:%:dast:%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4
5. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on public.ci_builds ci_builds_2 (cost=0.57..92.26 rows=1 width=1,476) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((ci_builds_2.commit_id = 86460650) AND ((ci_builds_2.type)::text = 'Ci::Build'::text))
  • Filter: (ci_builds_2.options ~~ '%:artifacts:%:reports:%:dependency_scanning:%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4
6. 0.002 0.002 ↓ 0.0 0 1

Index Scan using index_ci_builds_on_commit_id_and_status_and_type on public.ci_builds ci_builds_3 (cost=0.57..92.26 rows=1 width=1,476) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: ((ci_builds_3.commit_id = 86460650) AND ((ci_builds_3.type)::text = 'Ci::Build'::text))
  • Filter: (ci_builds_3.options ~~ '%:artifacts:%:reports:%:container_scanning:%'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4