Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity - Mailing list pgadmin-support
From | Doug Easterbrook |
---|---|
Subject | Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity |
Date | |
Msg-id | BCBA628F-A63E-49ED-A7E8-81E03AD9B9BC@artsman.com Whole thread Raw |
Responses |
Re: Pgadmin4: ability to terminate the backend
process from the list of processes and highlight activity
|
List | pgadmin-support |
<div class="">hi dave:</div><div class=""><br class="" /></div><div class="">A feature we used in pg admin 3 a fair bit wasto terminate a rogue process — it was easy enough looking at the list of processes and clicking on one and hitting theterminate button.</div><div class=""><br class="" /></div><div class="">why do we have rogue processes or things we wantto kill — sometimes a customer may throw off a long running process a bunch of times which would kill performance oftheir machine … and it was highlighted in the list of processes with a different colour based on active, blocked, or whathave you.</div><div class=""><br class="" /></div><div class=""><br class="" /></div><div class="">in pgAdmin4, we haveto refresh the list of sessions (curiously enough, thats ok .. in fact sometimes better than pgadmin 3 because the autorefresh could slow things down).</div><div class=""><br class="" /></div><div class=""><br class="" /></div><div class="">whatis missing are a couple of helpful things:</div><div class="">- the state change and/or query start columnsas options</div><div class="">- and/or .. some sort of colour code on the row that shows long running queries</div><divclass=""><br class="" /></div><div class="">- and the key request — a context menu item that would allowtermination of the pid via pg_terminate_backend</div><div class=""><br class="" /></div><div class=""><br class="" /></div><divclass="">it would let us have a monitor on activity (the graphs are great) .. and a refresh to see who’s takingthe cpu … and a way to kill the process — all on the dashboard.</div><div class=""><br class="" /></div><div class=""><brclass="" /></div><div class=""><br class="" /></div><div class="">thanks again. and truly, the more I play,the more I appreciate what you have done.</div><br class="" /><div class=""><div class="" style="color: rgb(0, 0, 0);letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal;widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space;-webkit-line-break: after-white-space;"><div class="" style="color: rgb(0, 0, 0); letter-spacing: normal; orphans:auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing:0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><divclass="" style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent:0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><span class="Apple-style-span"style="border-collapse: separate; font-variant-ligatures: normal; font-variant-position: normal;font-variant-numeric: normal; font-variant-alternates: normal; font-variant-east-asian: normal; line-height: normal;orphans: 2; text-indent: 0px; widows: 2; border-spacing: 0px;"><div class="" style="color: rgb(0, 0, 0); font-family:Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing:normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows:2; word-spacing: 0px; -webkit-text-stroke-width: 0px; -webkit-text-decorations-in-effect: none;"><b class="" style="font-weight:bold;"><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-weight:bold;"><span class="Apple-style-span" style="font-weight: bold;"><br class="Apple-interchange-newline"/>Doug Easterbrook</span></span></span></b></div><div class="" style="color: rgb(0, 0, 0);font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing:normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows:2; word-spacing: 0px; -webkit-text-stroke-width: 0px; -webkit-text-decorations-in-effect: none;"><span class="Apple-style-span"><bclass="" style="font-weight: bold;"><span class="Apple-style-span" style="font-weight: bold;"><spanclass="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-weight: bold;">ArtsManagement Systems Ltd.</span></span></span></b></span></div><div class="" style="color: rgb(0, 0, 0); font-family:Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing:normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows:2; word-spacing: 0px; -webkit-text-stroke-width: 0px; -webkit-text-decorations-in-effect: none;"><a class="" href="mailto:doug@artsman.com">mailto:doug@artsman.com</a></div><divclass="" style="color: rgb(0, 0, 0); font-family: Helvetica;font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans:2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;-webkit-text-stroke-width: 0px; -webkit-text-decorations-in-effect: none;"><a class="" href="http://www.artsman.com">http://www.artsman.com</a></div><divclass="" style="color: rgb(0, 0, 0); font-family: Helvetica;font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans:2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;-webkit-text-stroke-width: 0px; -webkit-text-decorations-in-effect: none;">Phone (403) 650-1978</div></span></div></div></div></div><brclass="" />
pgadmin-support by date: