From: =?windows-1252?Q?Niels_Kristian_Schj=F8dt?=
 <nielskristian@autouncle.com>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
Subject: Sudden crazy high CPU usage
Message-Id: <24BBD031-7384-4FFF-848B-90F5664C0063@autouncle.com>
Date: Mon, 31 Mar 2014 12:25:52 +0200
To: "pgsql-performance@postgresql.org list" <pgsql-performance@postgresql.org>
Mime-Version: 1.0 (Mac OS X Mail 7.2 \(1874\))
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

I'm running postgresql 9.3 on a production server. An hour ago, out of the =
"blue", I ran into an issue I have never encountered before: my server star=
ted to use CPU as crazy. The server is a standard ubuntu 12.04 LTE installa=
tion running only Postgres and Redis.

The incident can be seen on the in numbers below:=20

https://s3-eu-west-1.amazonaws.com/autouncle-public/other/cpu.png

I imidiatly took a look at pg_stat_activity but nothing in there seemed sus=
picious. I also had a look at the postgres log, but nothing was in there to=
o. I have pg_stat_statements running, so I reseted that one, and nothing re=
ally suspicious occurred in there, expect for the fact, that all queries we=
re taking 100x times longer than usual.

I have tried the following with no luck:

	=95 Restart clients connecting to the db
	=95 Restart postgres
	=95 Restart the whole server

I have run memory tests on the server as well, and nothing seems to be wron=
g.

No changes in any software running on the servers has been made within the =
last 24 hours.

The question is: I have a streaming replication server running, which I hav=
e now done a failover to, and it runs fine. However I still have no clue wh=
y my master suddenly has become so CPU consuming, and how I can debug / tra=
ce it further down?

--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance