Hi,
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).
Regards,
Richard Lee
On Mon, Nov 5, 2018 at 9:55 PM Justin Pryzby <pryzby@xxxxxxxxxxxxx> wrote:
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).
https://wiki.postgresql.org/wiki/Profiling_with_perf
Justin
