Re: Sudden crazy high CPU usage - Mailing list pgsql-performance

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.

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services