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

[Giancarlo Celli]

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?
Best regards.

Giancarlo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200707/fe806862/attachment.html>