apache / apache/age

Query node by graphid slow

Open
#2,152 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.