You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by GitBox <gi...@apache.org> on 2022/11/22 09:39:45 UTC
[GitHub] [age] Hyundong-Seo commented on issue #359: [Bitnine Tech Team] - It is not applied property index according to position of condition
Hyundong-Seo commented on issue #359:
URL: https://github.com/apache/age/issues/359#issuecomment-1323375402
@pdpotter
I tried the method in the link you sent, but the index is not applied.(#45)
```
select create_vlabel('test', 'comment');
CREATE UNIQUE INDEX test_comment_id_idx ON test.comment (properties);
```
```
SELECT * FROM cypher('test', $$ EXPLAIN ANALYZE MATCH (v:comment {content: 'thanks'}) RETURN v $$) AS (v agtype);
QUERY PLAN
------------------------------------------------------------------------------------------------------------------
Seq Scan on comment v (cost=0.00..98778.79 rows=2052 width=32) (actual time=0.118..2765.764 rows=85559 loops=1)
Filter: (properties @> agtype_build_map('content'::text, '"thanks"'::agtype))
Rows Removed by Filter: 1966610
Planning Time: 0.642 ms
Execution Time: 2773.867 ms
(5 rows)
```
```
SELECT * FROM cypher('test', $$ EXPLAIN ANALYZE MATCH (v:comment) where v.content = 'thanks' RETURN v $$) AS (v agtype);
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Seq Scan on comment v (cost=0.00..109080.68 rows=10261 width=32) (actual time=0.414..9792.321 rows=85559 loops=1)
Filter: (agtype_access_operator(VARIADIC ARRAY[_agtype_build_vertex(id, _label_name('25129'::oid, id), properties), '"content"'::agtype]) = '"thanks"'::agtype)
Rows Removed by Filter: 1966610
Planning Time: 0.130 ms
Execution Time: 9802.126 ms
(5 rows)
```
Could you tell me how to execute it works in the WHERE clause as well?
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org