[pgpool-general: 7133] Re: how to find the query that is generating a high load

Bo Peng 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:

> Hi,
> 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 
> 59864?

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
58194/tcp:            6736

$ ps -ef | grep psql
pengbo    6736  9049  0 22:19 pts/8    00:00:00 psql -h -p 11000 -U pengbo postgres

> Best regards.
> Giancarlo

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list