explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 49B3

Settings
# exclusive inclusive rows x rows loops node
1. 0.065 1.055 ↑ 1.0 1 1

Aggregate (cost=9,765.47..9,765.48 rows=1 width=8) (actual time=1.055..1.055 rows=1 loops=1)

2. 0.021 0.990 ↓ 0.0 0 1

Hash Join (cost=1,788.53..9,762.59 rows=1,152 width=4) (actual time=0.990..0.990 rows=0 loops=1)

  • Hash Cond: (projects.namespace_id = namespaces.id)
3. 0.003 0.963 ↑ 2,304.0 1 1

Nested Loop (cost=0.72..7,966.12 rows=2,304 width=8) (actual time=0.963..0.963 rows=1 loops=1)

4. 0.850 0.850 ↑ 2,304.0 1 1

Index Only Scan using index_design_management_designs_on_project_id on design_management_designs (cost=0.28..72.52 rows=2,304 width=4) (actual time=0.850..0.850 rows=1 loops=1)

  • Heap Fetches: 0
5. 0.110 0.110 ↑ 1.0 1 1

Index Scan using projects_pkey on projects (cost=0.43..3.42 rows=1 width=8) (actual time=0.110..0.110 rows=1 loops=1)

  • Index Cond: (id = design_management_designs.project_id)
6. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=1,785.32..1,785.32 rows=200 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
7. 0.002 0.006 ↓ 0.0 0 1

HashAggregate (cost=1,783.32..1,785.32 rows=200 width=4) (actual time=0.006..0.006 rows=0 loops=1)

  • Group Key: namespaces.id
8. 0.004 0.004 ↓ 0.0 0 1

CTE Scan on base_and_descendants namespaces (cost=1,624.82..1,722.36 rows=4,877 width=4) (actual time=0.004..0.004 rows=0 loops=1)

9.          

CTE base_and_descendants

10. 0.000 0.004 ↓ 0.0 0 1

Recursive Union (cost=0.15..1,624.82 rows=4,877 width=4) (actual time=0.004..0.004 rows=0 loops=1)

11. 0.003 0.003 ↓ 0.0 0 1

Index Only Scan using index_geo_node_namespace_links_on_geo_node_id_and_namespace_id on geo_node_namespace_links (cost=0.15..10.78 rows=7 width=4) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (geo_node_id = 2)
  • Heap Fetches: 0
12. 0.001 0.001 ↓ 0.0 0 1

Nested Loop (cost=0.43..151.65 rows=487 width=4) (actual time=0.001..0.001 rows=0 loops=1)

13. 0.000 0.000 ↓ 0.0 0 1

WorkTable Scan on base_and_descendants (cost=0.00..1.40 rows=70 width=4) (actual time=0.000..0.000 rows=0 loops=1)

14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using index_namespaces_on_parent_id_and_id on namespaces namespaces_1 (cost=0.43..2.08 rows=7 width=8) (never executed)

  • Index Cond: (parent_id = base_and_descendants.id)
  • Heap Fetches: 0
Planning time : 10.500 ms
Execution time : 1.333 ms