You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@age.apache.org by "lyp-bobi (via GitHub)" <gi...@apache.org> on 2024/12/16 12:13:05 UTC
[I] EXPLAIN on cypher DELETE is very slow. [age]
lyp-bobi opened a new issue, #2140:
URL: https://github.com/apache/age/issues/2140
**Describe the bug**
A clear and concise description of what the bug is.
On my graph, the delete of vertex is extremely slow. So I use explain to print its plan. However, the EXPLAIN takes nearly the same time of deletion.
**How are you accessing AGE (Command line, driver, etc.)?**
- [e.g. JDBC]
PostgreSQL 14, psql, AGE 1.5.0
**What data setup do we need to do?**
```pgsql
...
SELECT * from cypher('my_graph_name', $$
CREATE (a:Part {part_num: '123'}),
(b:Part {part_num: '345'}),
(c:Part {part_num: '456'}),
(d:Part {part_num: '789'})
$$) as (a agtype);
...
```
I guess you can reproduce it on any data.
**What is the necessary configuration info needed?**
- [e.g. Installed PostGIS]
**What is the command that caused the error?**
```pgsql
SELECT * from cypher('my_graph_name', $$
MATCH (a:Part {part_num: '123'}), (b:Part {part_num: '345'})
CREATE (a)-[u:used_by { quantity: 1 }]->(b)
$$) as (a agtype);
```
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**
A clear and concise description of what you expected to happen.
**Environment (please complete the following information):**
- Version: [e.g. 0.4.0]
There's two major expectation:
1. The explaination of deletion should not use thank hook to delete the connected edges.
2. The I have build 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 instead of scanning the full table?
**Additional context**
Add any other context about the problem here.
--
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-unsubscribe@age.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] EXPLAIN on cypher DELETE is very slow. [age]
Posted by "jrgemignani (via GitHub)" <gi...@apache.org>.
jrgemignani commented on issue #2140:
URL: https://github.com/apache/age/issues/2140#issuecomment-2661002139
@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);
```
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] EXPLAIN on cypher DELETE is very slow. [age]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #2140: EXPLAIN on cypher DELETE is very slow.
URL: https://github.com/apache/age/issues/2140
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] EXPLAIN on cypher DELETE is very slow. [age]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #2140:
URL: https://github.com/apache/age/issues/2140#issuecomment-2660546277
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.
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] EXPLAIN on cypher DELETE is very slow. [age]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #2140:
URL: https://github.com/apache/age/issues/2140#issuecomment-2846037798
This issue was closed because it has been stalled for further 14 days with no activity.
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] EXPLAIN on cypher DELETE is very slow. [age]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #2140:
URL: https://github.com/apache/age/issues/2140#issuecomment-2814231296
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.
--
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-unsubscribe@age.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org