[I] Query node by graphid slow [age]

[via GitHub]

xuan2orange opened a new issue, #2152:
URL: https://github.com/apache/age/issues/2152

   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.
   


-- 
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.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org