explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iQqh

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

Nested Loop (cost=1.28..19.69 rows=2 width=201) (actual time=0.023..0.023 rows=0 loops=1)

  • Buffers: shared hit=4
2. 0.021 0.021 ↓ 0.0 0 1

Index Scan using namespaces_pkey on public.namespaces (cost=0.43..4.45 rows=1 width=4) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: (namespaces.id = 675)
  • Filter: ((namespaces.type)::text = 'Group'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=4
3. 0.000 0.000 ↓ 0.0 0 0

Nested Loop (cost=0.84..15.22 rows=2 width=205) (actual time=0.000..0.000 rows=0 loops=0)

4. 0.000 0.000 ↓ 0.0 0 0

Index Scan using index_ci_runner_namespaces_on_namespace_id on public.ci_runner_namespaces (cost=0.42..6.32 rows=2 width=8) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_runner_namespaces.namespace_id = 675)
5. 0.000 0.000 ↓ 0.0 0 0

Index Scan using ci_runners_pkey on public.ci_runners (cost=0.42..4.44 rows=1 width=201) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_runners.id = ci_runner_namespaces.runner_id)