panosfol commented on issue #983:
URL: https://github.com/apache/age/issues/983#issuecomment-1625730750
After making some minor fixes here is the query plan trees for my version
and for the current version :
Query: ```MATCH (charlie {name: 'Charlie
Sheen'})-[:ACTED_IN*1..3]-(movie:Movie)
RETURN movie.title```
My plan: ```Nested Loop (cost=0.01..150165.77 rows=2853333 width=32)```
Current Plan: ```Nested Loop (cost=0.01..168381.05 rows=3200000 width=32)```
Query: ```MATCH p = (actor {name: 'Charlie Sheen'})-[:ACTED_IN*2]-(co_actor)
RETURN relationships(p)```
My plan: ```Nested Loop (cost=0.01..1199103.45 rows=19975998 width=32)```
Current Plan: ```Nested Loop (cost=0.01..1344732.01 rows=22402664
width=32)```
Query: ```MATCH (wallstreet:Movie {title: 'Wall Street'})-[*0..1]-(x)
RETURN x```
My plan: ```Nested Loop (cost=0.01..125080.91 rows=2497000 width=32)```
Current plan: ```Nested Loop (cost=0.01..140263.18 rows=2800333 width=32)```
Query: ```MATCH p = (michael {name: 'Michael Douglas'})-->()
RETURN p```
My plan: ```Hash Join (cost=264.38..677.64 rows=3970 width=32)```
Current plan: ```Hash Join (cost=283.32..760.35 rows=4873 width=32)```
Its worth noting that none of this `MATCH` clauses go through
`entity_exists`, `get_label_name` or `filter_vertices_on_label_id`.
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
