Query node by graphid slow
Open
question
- Dominant language
- C
- Stars
- 4.8k
- Forks
- 523
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 9
Description
Hi,
I have a query like this:
> `EXPLAIN ANALYZE SELECT * FROM cypher('graph_name', $$
MATCH (V:Nodetype)
WHERE id(V)=1036234240758848
RETURN V
$$) as (V agtype);`
it costs 1 second.
> `Parallel Seq Scan on "Nodetype" "V_2" (cost=0.00..44406.69 rows=1758 width=321) (actual time=1225.284..1225.284 rows=0 loops=3)
Filter: (age_id(_agtype_build_vertex(id, _label_name('78689'::oid, id), properties)) = '1036234240758848'::agtype)
Rows Removed by Filter: 281228
Planning Time: 0.404 ms
Execution Time: 1241.129 ms
`
What can i do to make this query fast?
Thanks.
Contributor guide
Assessment
This issue has not been assessed yet.