jrgemignani commented on issue #1000:
URL: https://github.com/apache/age/issues/1000#issuecomment-1670371029
@vladiksun Is this more of what you were expecting?
```
psql-14.8-5432-pgsql=# select
any_profile
from
ag_catalog.cypher('test_graph',$$
EXPLAIN ANALYZE MATCH (any_profile:`profile` { hidden: false })
WHERE any_profile.pet = 'dog'
RETURN any_profile
$$
) as (any_profile ag_catalog.agtype);
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------
------------------------
Bitmap Heap Scan on profile any_profile (cost=20.08..52.37 rows=1
width=32) (actual time=3.729..41.533 rows=1673 loops=1)
Recheck Cond: (properties @> '{"hidden": false}'::agtype)
Filter: (agtype_access_operator(VARIADIC ARRAY[_agtype_build_vertex(id,
_label_name('16950'::oid, id), properties), '"pet"'::agty
pe]) = '"dog"'::agtype)
Rows Removed by Filter: 3378
Heap Blocks: exact=143
-> Bitmap Index Scan on profile_gin_idx (cost=0.00..20.07 rows=10
width=0) (actual time=3.647..3.647 rows=5051 loops=1)
Index Cond: (properties @> '{"hidden": false}'::agtype)
Planning Time: 1.352 ms
Execution Time: 41.703 ms
(9 rows)
```
--
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]
