apache / apache/shardingsphere
Support SHOW PROCESSLIST/KILL-like feature for PostgreSQL/openGauss databases
- Dominant language
- Java
- Stars
- 20.8k
- Forks
- 6.9k
- Avg merge
- 11h 35m
- Merged PRs (30d)
- 326
Description
## Feature Request
### Is your feature request related to a problem?
https://github.com/apache/shardingsphere/issues/20299
https://github.com/apache/shardingsphere/issues/19606
https://github.com/apache/shardingsphere/issues/9568
### Describe the feature you would like.
In version 5.2.0, ShardingSphere supports MySQL `SHOW PROCESSLIST` and `KILL` statements, which makes it more convenient for users to manage SQL.
The following figure shows the execution process of the current `SHOW PROCESSLIST` statement. It can be seen that it is a general process that can support different types of databases.
So we need to investigate whether PostgreSQL and openGauss databases have statements similar to MySQL SHOW PROCESSLIST/KILL, and then adapt these statements for PostgreSQL and openGauss databases.
- [ ] investigate whether the PostgreSQL database has a statement similar to MySQL SHOW PROCESSLIST/KILL and support it @ICannerxy ——https://stackoverflow.com/questions/35319597/how-to-stop-kill-a-query-in-postgresql
- [ ] investigate whether the openGauss database has a statement similar to MySQL SHOW PROCESSLIST/KILL and support it
Contributor guide
Assessment
This issue has not been assessed yet.