explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XKIM

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

Nested Loop (cost=1.14..428.24 rows=1 width=1,476) (actual time=3.456..3.456 rows=0 loops=1)

  • Buffers: shared hit=2 read=2
2. 3.455 3.455 ↓ 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.08 rows=73 width=1,476) (actual time=3.455..3.455 rows=0 loops=1)

  • Index Cond: ((ci_builds.commit_id = 86460650) AND ((ci_builds.type)::text = 'Ci::Build'::text))
  • Buffers: shared hit=2 read=2
3. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_ci_builds_metadata_on_build_id on public.ci_builds_metadata (cost=0.57..4.59 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_builds_metadata.build_id = ci_builds.id)
  • Filter: (((ci_builds_metadata.config_options -> 'artifacts'::text) -> 'reports'::text) ?| '{sast,dast,dependency_scanning,container_scanning}'::text[])
  • Rows Removed by Filter: 0