[I] how to optimise this sql, its execution is extremely slow. [age]

[via GitHub]

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

   SELECT
     * 
   FROM
     ag_catalog.cypher (
       'chunk_entity_relation', $$ MATCH ( n ) OPTIONAL MATCH ( n ) -[ r ]- ( ) 
WITH n,
       COUNT ( r ) AS DEGREE RETURN n,
       DEGREE 
       ORDER BY
       DEGREE DESC 
     LIMIT 1000 $$ 
     ) AS ( n agtype, DEGREE agtype );
   
   


-- 
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