On 04/09/2018 02:29, Iwata, Aya wrote: > Since I'd like to monitor the information the server and the client exchange, > I think monitoring protocol messages is good. > > When a slow query is occurs, we check this client side trace log. > The purpose of this log acquisition I thought is to identify where is the > problem: > server side, application side or traffic. > And if the problem is in application side, checking the trace log to identify > what is the problem.
Between perf/systemtap/dtrace and wireshark, you can already do pretty much all of that. Have you looked at those and found anything missing? -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services