jrgemignani commented on issue #64:
URL: https://github.com/apache/incubator-age/issues/64#issuecomment-837188655
EXPLAIN has been added to the master repository. It is available by pulling
the latest source down - not the latest release.
In order to use it, you will need to put the EXPLAIN inside of the cypher
function. For example -
```
psql-11.5-5432-pgsql=# SELECT * FROM cypher('G', $$EXPLAIN MATCH (u)-[]->()
RETURN u $$) AS (u agtype);
QUERY PLAN
--------------------------------------------------------------------------------------------------------------
Gather (cost=1000.00..245939.57 rows=69877 width=32)
Workers Planned: 2
-> Nested Loop (cost=0.00..237951.87 rows=29115 width=32)
Join Filter: (graphid_to_agtype(_age_default_alias_0_1.start_id) =
graphid_to_agtype(u.id))
-> Parallel Append (cost=0.00..70.91 rows=1617 width=8)
-> Parallel Seq Scan on edge1 _age_default_alias_0_1
(cost=0.00..15.71 rows=571 width=8)
-> Parallel Seq Scan on edge2 _age_default_alias_0_2
(cost=0.00..15.71 rows=571 width=8)
-> Parallel Seq Scan on edge3 _age_default_alias_0_3
(cost=0.00..15.71 rows=571 width=8)
-> Parallel Seq Scan on edge4 _age_default_alias_0_4
(cost=0.00..15.71 rows=571 width=8)
-> Parallel Seq Scan on _ag_label_edge _age_default_alias_0
(cost=0.00..0.00 rows=1 width=8)
-> Append (cost=0.00..84.00 rows=3601 width=40)
-> Seq Scan on _ag_label_vertex u (cost=0.00..0.00 rows=1
width=40)
-> Seq Scan on begin u_1 (cost=0.00..22.00 rows=1200
width=40)
-> Seq Scan on middle u_2 (cost=0.00..22.00 rows=1200
width=40)
-> Seq Scan on "end" u_3 (cost=0.00..22.00 rows=1200
width=40)
(15 rows)
psql-11.5-5432-pgsql=#
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
