# | 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)
|
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)
|
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)
|
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)
|
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)
|