<html><head>
<style id="css_styles" type="text/css"><!--blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc }
blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding-top: 0px; }
a img { border: 0px; }
li[style='text-align: center;'], li[style='text-align: right;'] { list-style-position: inside;}
body { font-family: Atlanta; font-size: 10pt; }--></style></head><body class="plain"><div>Hi,</div><div><br /></div>
<div><br /></div>
<div id="xd72dac0fd55b4a8"><blockquote type="cite" class="cite2">
<div class="plain_line">Hello,</div>
<div class="plain_line"> </div>
<div class="plain_line">On Tue, 07 Jul 2020 13:01:00 +0000</div>
<div class="plain_line">"Giancarlo Celli" <<a href="mailto:giancarlo.celli@flottaweb.com">giancarlo.celli@flottaweb.com</a>> wrote:</div>
<div class="plain_line"> </div>
<blockquote type="cite" class="cite2">
<div class="plain_line"> Hi,</div>
<div class="plain_line"> generally, using the top command, to see which connection to the db is</div>
<div class="plain_line"> causing a high load, just take the pid inside the brackets and make a</div>
<div class="plain_line"> fuser in the following way:</div>
<div class="plain_line"> </div>
<div class="plain_line"> String of top command: postgres: postgres dbname192.168.0.12(59864)</div>
<div class="plain_line"> </div>
<div class="plain_line"> Command to see shell PID of process: fuser 59864/tcp and I will see</div>
<div class="plain_line"> PID of process.</div>
<div class="plain_line"> </div>
<div class="plain_line"> With pgpool, however, this type of search does not work and the fuser</div>
<div class="plain_line"> command does not show any process.</div>
<div class="plain_line"> Is there any way to understand which query corresponds to that pid</div>
<div class="plain_line"> 59864?</div>
</blockquote>
<div class="plain_line"> </div>
<div class="plain_line">You want to display the PID of client command?</div>
<div class="plain_line">I tried the following command and I think "6736" is the PID which you want to display, right?</div>
<div class="plain_line"> </div>
<div class="plain_line">=================</div>
<div class="plain_line">$ fuser 58194/tcp</div>
<div class="plain_line">58194/tcp: 6736</div>
<div class="plain_line"> </div>
<div class="plain_line">$ ps -ef | grep psql</div>
<div class="plain_line">pengbo 6736 9049 0 22:19 pts/8 00:00:00 psql -h 192.168.154.7 -p 11000 -U pengbo postgres</div>
<div class="plain_line">=================</div>
<div class="plain_line"> </div></blockquote><span><div id="xd72dac0fd55b4a8"><b>It works like this on servers without pgpool, but in my case the fuser command returns nothing on either server with pgpool and postgres</b></div><div id="xd72dac0fd55b4a8"><b>Why?</b></div><div id="xd72dac0fd55b4a8"><br /></div><br /></span><blockquote type="cite" class="cite2"><div class="plain_line"><br /></div>
<blockquote type="cite" class="cite2">
<div class="plain_line"> Best regards.</div>
<div class="plain_line"> </div>
<div class="plain_line"> Giancarlo</div>
</blockquote>
<div class="plain_line"> </div>
<div class="plain_line"> </div>
<div class="plain_line">--</div>
<div class="plain_line">Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>></div>
<div class="plain_line">SRA OSS, Inc. Japan</div>
</blockquote></div>
</body></html>