explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iuag : Optimization for: plan #fqIi

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.044 0.044 ↓ 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.81 rows=1 width=1,476) (actual time=0.044..0.044 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) OR (ci_builds.options ~~ '%:artifacts:%:reports:%:dast:%'::text) OR (ci_builds.options ~~ '%:artifacts:%:reports:%:dependency_scanning:%'::text) OR (ci_builds.options ~~ '%:artifacts:%:reports:%:container_scanning:%'::text))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4