Ah, apologize for the mistake. The entire will take several hours to complete and the problem query won't be executed until about halfway through the benchmark. Should I do `perf record` when the query appears? Or one `perf record` at the start of the test and another one when the query appears? I imagine doing a `perf record` of the entire benchmark will fill the storage (only about 100GB of space on the server).
On Mon, Nov 05, 2018 at 03:04:29PM +0800, Richard Lee wrote: > Executed perf-record and perf-report: > -bash-4.2$ perf record -g -- psql -U sri sri < > /var/lib/pgsql/10/data/pg_log/1-b10/query.txt > < ... snipped ... >
That's showing perf output for the psql client. What you want is output for the server process (essentially all the client does is move data between the user to the server).