On Wed, Apr 2, 2014 at 7:16 AM, Andres Freund <andres@xxxxxxxxxxxxxxx> wrote: > On 2014-03-31 19:16:58 +0200, Niels Kristian Schjødt wrote: >> Yes, I could install "perf", though I'm not familiar with it. What would i do? :-) > > As root: > perf record -a sleep 5 > perf report > my-nice-perf-report.txt > > And then send the my-nice-perf-report.txt file. > > Locally it's much nicer to see the output using "perf report" without > redirect into a file, you'll get an interactive UI. The Postgres wiki has a page dedicated to perf as well here: https://wiki.postgresql.org/wiki/Profiling_with_perf Regards, -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance