jrgemignani commented on issue #1235: URL: https://github.com/apache/age/issues/1235#issuecomment-1769582013
@vladiksun When I run it against the current master I get the following - ``` QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------- Bitmap Heap Scan on profile any_profile (cost=20.08..52.32 rows=1 width=32) (actual time=1.832..26.179 rows=3311 loops=1) Recheck Cond: (properties @> '{"hidden": false}'::agtype) Filter: (agtype_access_operator(VARIADIC ARRAY[properties, '"pet"'::agtype]) = ANY ('{"\"dog\"","\"cat\""}'::agtype[])) Rows Removed by Filter: 1674 Heap Blocks: exact=143 -> Bitmap Index Scan on profile_gin_idx (cost=0.00..20.07 rows=10 width=0) (actual time=1.742..1.742 rows=4985 loops=1) Index Cond: (properties @> '{"hidden": false}'::agtype) Planning Time: 2.057 ms Execution Time: 26.598 ms (9 rows) psql-15.4-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: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org