Re: Sudden crazy high CPU usage

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Sudden crazy high CPU usage
Дата
Msg-id 20140401221653.GI3750@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Sudden crazy high CPU usage  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Ответы Re: Sudden crazy high CPU usage  (Michael Paquier <michael.paquier@gmail.com>)
Список 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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Niels Kristian Schjødt
Дата:
Сообщение: Re: Sudden crazy high CPU usage
Следующее
От: bricklen
Дата:
Сообщение: Re: Slow Count-Distinct Query