jrgemignani commented on issue #2194:
URL: https://github.com/apache/age/issues/2194#issuecomment-3097359401
@serdarmicrosoft Could you add in the output of explain for this. Both for
the sql and for the cypher -
```
EXPLAIN select count(*), u.id from "User" u, "HAS_INTERACTION" h, "Book" b
where u.id = h.start_id and b.id = h.end_id GROUP BY u.id ORDER BY 1 DESC LIMIT
10;
SELECT * FROM cypher('goodreads_graph', $$ EXPLAIN MATCH
(u:User)-[:HAS_INTERACTION]->() RETURN u.user_id, count(*) ORDER BY count(*)
DESC LIMIT 10 $$) AS (user_id agtype, interaction_count agtype);
```
Also, if there are any indexes used, could you do this both before and after
the index is added. That would be helpful.
--
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: dev-unsubscr...@age.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
