<html><head>
<style id="css_styles">
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><div>Hi,</div><div>generally, using the top command, to see which connection to the db is causing a high load, just take the pid inside the brackets and make a fuser in the following way:</div><div><br /></div><div>String of top command: <b>postgres: postgres dbname192.168.0.12(59864)</b> </div><div><br /></div><div>Command to see shell PID of process: <b> fuser 59864/tcp</b> and I will see PID of process.</div><div><br /></div><div>With pgpool, however, this type of search does not work and the fuser command does not show any process.<br />Is there any way to understand which query corresponds to that pid 59864?</div><div>Best regards.</div><div><br /></div><div>Giancarlo</div>
</body></html>