explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dhO3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 7.565 ↓ 0.0 0 1

Nested Loop (cost=454.65..1,010.77 rows=177 width=201) (actual time=7.565..7.565 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=7.482
2. 0.001 7.565 ↓ 0.0 0 1

Nested Loop (cost=454.23..795.25 rows=177 width=4) (actual time=7.565..7.565 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=7.482
3. 0.003 7.564 ↓ 0.0 0 1

HashAggregate (cost=453.81..454.01 rows=21 width=4) (actual time=7.564..7.564 rows=0 loops=1)

  • Group Key: namespaces.id
  • Buffers: shared read=4
  • I/O Timings: read=7.482
4. 7.561 7.561 ↓ 0.0 0 1

CTE Scan on base_and_ancestors namespaces (cost=453.12..453.54 rows=21 width=4) (actual time=7.561..7.561 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=7.482
5.          

CTE base_and_ancestors

6. 0.002 7.559 ↓ 0.0 0 1

Recursive Union (cost=0.43..453.12 rows=21 width=325) (actual time=7.559..7.559 rows=0 loops=1)

  • Buffers: shared read=4
  • I/O Timings: read=7.482
7. 7.549 7.549 ↓ 0.0 0 1

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

  • Index Cond: (namespaces_1.id = 675)
  • Filter: ((namespaces_1.type)::text = 'Group'::text)
  • Rows Removed by Filter: 1
  • Buffers: shared read=4
  • I/O Timings: read=7.482
8. 0.002 0.008 ↓ 0.0 0 1

Nested Loop (cost=0.43..44.83 rows=2 width=325) (actual time=0.008..0.008 rows=0 loops=1)

9. 0.006 0.006 ↓ 0.0 0 1

WorkTable Scan on base_and_ancestors (cost=0.00..0.20 rows=10 width=4) (actual time=0.006..0.006 rows=0 loops=1)

10. 0.000 0.000 ↓ 0.0 0 0

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

  • Index Cond: (namespaces_2.id = base_and_ancestors.parent_id)
  • Filter: ((namespaces_2.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
11. 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..16.17 rows=8 width=8) (actual time=0.000..0.000 rows=0 loops=0)

  • Index Cond: (ci_runner_namespaces.namespace_id = namespaces.id)
12. 0.000 0.000 ↓ 0.0 0 0

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

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