Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity

Поиск
Список
Период
Сортировка
От Doug Easterbrook
Тема Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity
Дата
Msg-id BCBA628F-A63E-49ED-A7E8-81E03AD9B9BC@artsman.com
обсуждение исходный текст
Ответы Re: Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity
Список 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 по дате отправления:

Предыдущее
От: Andy Hsu
Дата:
Сообщение: Re: help on issue connecting to Greenplum 4.3.7.1 database using pgAdmin 4 v 1.1
Следующее
От: Jack Royal-Gordon
Дата:
Сообщение: UI Odditiies in the Query Tool