EXPLAIN on cypher DELETE is very slow.

[lyp-bobi]

Describe the bug

On my graph, the deletion of vertex is extremely slow. So I use EXPLAIN to print its plan. However, the EXPLAIN takes nearly the same time as of the original deletion.

How are you accessing AGE (Command line, driver, etc.)?

PostgreSQL 14, psql, AGE 1.5.0

What data setup do we need to do?

I guess you can reproduce it on any data.

What is the necessary configuration info needed?

What is the command that caused the error?

My SQL is:

explain SELECT *
        FROM cypher('ldbc_graph', $$
            MATCH (person:Person {id: 111})-[l:LIKES]->(post:Post {id: 222})
            DELETE l
        $$) AS (res1 agtype);

I pstack it and see it is working on 'end_cypher_delete->check_for_connected_edges'

Expected behavior

There are two major expectation:

1. The EXPLAIN command on deletion should not use that hook to delete the connected edges.
2. I have built btree index on (start_id, end_id) to accelerate my MATCH cyphers. I guess it is also possible to delete the connected edges through that index, to make it faster, instead of scanning the full table?

Environment (please complete the following information):

• Version: [e.g. 0.4.0]

1.5.0

Additional context
Add any other context about the problem here.

[github-actions]

This issue is stale because it has been open 60 days with no activity. Remove "Abondoned" label or comment or this will be closed in 14 days.

[jrgemignani]

@lyp-bobi The EXPLAIN command, for openCypher commands, needs to be inside the cypher function -

SELECT *
        FROM cypher('ldbc_graph', $$ EXPLAIN
            MATCH (person:Person {id: 111})-[l:LIKES]->(post:Post {id: 222})
            DELETE l
        $$) AS (res1 agtype);

Additionally, EXPLAIN, by itself, will only stop execution of the command, not anything that is part of parsing and optimizing.