hiHi,
PFA patch to add functionality which will allow super user to cancel long running queries from dashboard.
RM#1812
Steps used to test:
1) Open psql session, Connect to 'test' database on respective server
2) Execute "select pg_sleep(1000);"
3) Open pgAdmin4
4) Connect to respective server
5) Click on Dashboard
6) Check "Sessions" tab under "Server activity" section then look for active sessions for test database.
7) Click on cancel button and cancel the active session
8) Check psql session now, you will see "ERROR: canceling statement due to user request"