| From: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | [pgAdmin4][Patch]: Allow user to cancel long running queries from dashboard |
| Date: | 2017-07-13 13:53:02 |
| Message-ID: | CAKKotZRY9u9BPsczLvx50aFzeG=5BUofrp4FUeT-nYhexv_5Zw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
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"
--
Regards,
Murtuza Zabuawala
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| Attachment | Content-Type | Size |
|---|---|---|
| RM_1812.diff | text/plain | 6.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2017-07-13 14:42:37 | pgAdmin 4 commit: Tag REL-1_6 has been created. |
| Previous Message | Murtuza Zabuawala | 2017-07-13 11:20:39 | [pgAdmin4][Patch] Not to display PID comma separated in statistics panel |