[pgpool-general: 7133] Re: how to find the query that is generating a high load
pengbo at sraoss.co.jp
Tue Jul 7 22:25:21 JST 2020
On Tue, 07 Jul 2020 13:01:00 +0000
"Giancarlo Celli" <giancarlo.celli at flottaweb.com> wrote:
> 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:
> String of top command: postgres: postgres dbname192.168.0.12(59864)
> Command to see shell PID of process: fuser 59864/tcp and I will see
> PID of process.
> With pgpool, however, this type of search does not work and the fuser
> command does not show any process.
> Is there any way to understand which query corresponds to that pid
You want to display the PID of client command?
I tried the following command and I think "6736" is the PID which you want to display, right?
$ fuser 58194/tcp
$ ps -ef | grep psql
pengbo 6736 9049 0 22:19 pts/8 00:00:00 psql -h 192.168.154.7 -p 11000 -U pengbo postgres
> Best regards.
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general