explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aGZo

Settings
# exclusive inclusive rows x rows loops node
1. 0.084 0.084 ↑ 5.2 4 1

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

  • Buffers: shared hit=16
2.          

CTE base_and_ancestors

3. 0.021 0.071 ↑ 5.2 4 1

Recursive Union (cost=0.43..453.12 rows=21 width=322) (actual time=0.029..0.071 rows=4 loops=1)

  • Buffers: shared hit=16
4. 0.018 0.018 ↑ 1.0 1 1

Index Scan using namespaces_pkey on public.namespaces namespaces_1 (cost=0.43..4.45 rows=1 width=322) (actual time=0.017..0.018 rows=1 loops=1)

  • Index Cond: (namespaces_1.id = 5755264)
  • Filter: ((namespaces_1.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4
5. 0.000 0.032 ↑ 2.0 1 4

Nested Loop (cost=0.43..44.83 rows=2 width=322) (actual time=0.007..0.008 rows=1 loops=4)

  • Buffers: shared hit=12
6. 0.004 0.004 ↑ 10.0 1 4

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

7. 0.028 0.028 ↑ 1.0 1 4

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

  • Index Cond: (namespaces_2.id = base_and_ancestors.parent_id)
  • Filter: ((namespaces_2.type)::text = 'Group'::text)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=12