Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV6zN-0006zb-9E for pgsql-performance@arkaria.postgresql.org; Tue, 01 Apr 2014 22:17:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WV6zM-0004wO-L1 for pgsql-performance@arkaria.postgresql.org; Tue, 01 Apr 2014 22:17:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV6zL-0004wH-HP for pgsql-performance@postgresql.org; Tue, 01 Apr 2014 22:16:59 +0000 Received: from moutng.kundenserver.de ([212.227.126.131]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WV6zI-0004xk-7U for pgsql-performance@postgresql.org; Tue, 01 Apr 2014 22:16:59 +0000 Received: from anarazel.de (p5DDC6844.dip0.t-ipconnect.de [93.220.104.68]) by mrelayeu.kundenserver.de (node=mreue005) with ESMTP (Nemesis) id 0Mgrp6-1WiMVi2CkC-00M0SK; Wed, 02 Apr 2014 00:16:54 +0200 Received: by anarazel.de (Postfix, from userid 1000) id CBAC21021B4; Wed, 2 Apr 2014 00:16:53 +0200 (CEST) Date: Wed, 2 Apr 2014 00:16:53 +0200 From: Andres Freund To: Niels Kristian =?iso-8859-1?Q?Schj=F8dt?= Cc: Merlin Moncure , "pgsql-performance@postgresql.org list" Subject: Re: Sudden crazy high CPU usage Message-ID: <20140401221653.GI3750@awork2.anarazel.de> References: <24BBD031-7384-4FFF-848B-90F5664C0063@autouncle.com> <2ABC90E9-8312-45A4-96E0-CFE202CCD9CE@autouncle.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: Content-Transfer-Encoding: quoted-printable X-Provags-ID: V02:K0:5N2uSim5LhfogozqxmFt12DummxGTilh32h92xoHHs+ gYj60zlhmJyEblv0lcJt2qyIQvOrWNvKFX58z8ilBzETi0GPmZ HF/OWtcixHqk6XOdENnoVxg0mgXK4evWS6XvKageq3yTCmn7hi Kufqqt2XIbCv8GtQswr4L0R9d6xLRmd8Kbjoa5tR88sfFiBPCq e1VLvhK7osdaSwnsRN+T/Lo7UOTw3Aaroi2PHhwy3evTORMise BUf5gWRxCUI/on58MWyoJ/FF0ChRoLXTfylK6JO0E3JanJP+JT d7EKq0VnIa1Srx4PRXI7tfk0gFf5DGbTIO4ZJ8/rbyz431C5+A Xiaa/w6uns4At+l4OadXiBkDMFJCpWuSuPfu7S+Dg X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 2014-03-31 19:16:58 +0200, Niels Kristian Schj=C3=B8dt wrote: > Yes, I could install =E2=80=9Cperf=E2=80=9D, though I=E2=80=99m not famil= iar 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 --=20 Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance