jrgemignani commented on issue #1522:
URL: https://github.com/apache/age/issues/1522#issuecomment-1960352971
@alteck45 I'm not sure why it is expanding the query out with `ap.id` and
`ap.properties`. I have a feeling this is not allowing some of the indexes to
work. I will look at the GIN indexes next.
```
psql-16.1-5432-pgsql=# SELECT * FROM cypher(
'test-graph', $$ EXPLAIN
MATCH (ap:AccessPoint)
RETURN ap ORDER BY id(ap)
$$) as (value agtype);
QUERY PLAN
----------------------------------------------------------------------------------------------------------
Subquery Scan on _ (cost=1.49..1.64 rows=12 width=32)
-> Sort (cost=1.49..1.52 rows=12 width=64)
Sort Key: (age_id(_agtype_build_vertex(ap.id,
_label_name('16979'::oid, ap.id), ap.properties)))
-> Seq Scan on "AccessPoint" ap (cost=0.00..1.27 rows=12 width=64)
(4 rows)
psql-16.1-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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
