explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TraQ

Settings

Optimization(s) for this plan:

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

Append (cost=12,245.09..12,319.13 rows=804 width=134) (actual rows= loops=)

  • -> Seq Scan on property_graph (cost=0.00..18.00 rows=4 width=134)" Filter: (edges_property IS NULL)
2.          

CTE cte

3. 0.000 0.000 ↓ 0.0

Seq Scan on property_graph property_graph_1 (cost=0.00..22.00 rows=800 width=102) (actual rows= loops=)

4.          

CTE cte1

5. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=11,414.09..12,216.59 rows=200 width=70) (actual rows= loops=)

  • Group Key: cte.node
6. 0.000 0.000 ↓ 0.0

Sort (cost=11,414.09..11,614.09 rows=80,000 width=70) (actual rows= loops=)

  • Sort Key: cte.node
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..1,616.00 rows=80,000 width=70) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

CTE Scan on cte (cost=0.00..16.00 rows=800 width=70) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Function Scan on json_array_elements j1 (cost=0.00..1.00 rows=100 width=32) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=6.50..54.50 rows=800 width=134) (actual rows= loops=)

  • Hash Cond: ((c.node)::text = (a.node)::text)
11. 0.000 0.000 ↓ 0.0

CTE Scan on cte c (cost=0.00..16.00 rows=800 width=102) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=4.00..4.00 rows=200 width=70) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

CTE Scan on cte1 a (cost=0.00..4.00 rows=200 width=70) (actual rows= loops=)