Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 53803B5DBC4 for ; Fri, 10 Jun 2011 06:01:37 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 60022-09 for ; Fri, 10 Jun 2011 09:01:30 +0000 (UTC) X-Greylist: delayed 22:15:53.468479 by SQLgrey-1.7.6 Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com [209.85.212.46]) by mail.postgresql.org (Postfix) with ESMTP id E7F74B5D944 for ; Fri, 10 Jun 2011 06:01:29 -0300 (ADT) Received: by vws1 with SMTP id 1so1935856vws.19 for ; Fri, 10 Jun 2011 02:01:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=juffo.org; s=google; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type; bh=OOeQfyT2QTWdr0hu46GPQAE5pKNQDcI+Fwxxxt4X15Y=; b=M+i4iWylH57N+0ug9jv0QWdPqLAr0odiO1QnpiWvWOyBvTsXz7FsAVpvWjl8kPFHrA ssnZajupDpP9r1FRpnEKBxYJQAU8Ll5JBBnPygDKDiQ52D25AHXcxglPRKVsCIhQ1R/Y ptCuFw3nl3vNl6cK3NE/CN8aYATcubTkinBgA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=juffo.org; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=BooWaupvdgraGeIWVh6hisTwno5oBPzaJvbuUKkzESR5SwuuKDNevuRBUpg+Eb+gfw kRwvmKanDdB9gGx3rwO76y3BkzEKVxr4l6ufn6u2iP0pkJ2Z+4dPw/j72YcTtr9gwFzm /snHis6Ku1vUcj1ovyr5Aos7tD67fvzkPIrlc= Received: by 10.220.7.72 with SMTP id c8mr683278vcc.129.1307696489125; Fri, 10 Jun 2011 02:01:29 -0700 (PDT) MIME-Version: 1.0 Received: by 10.220.180.141 with HTTP; Fri, 10 Jun 2011 02:00:59 -0700 (PDT) In-Reply-To: <1307506768241-4465765.post@n5.nabble.com> References: <1307506768241-4465765.post@n5.nabble.com> From: Marti Raudsepp Date: Fri, 10 Jun 2011 12:00:59 +0300 Message-ID: Subject: Re: 100% CPU Utilization when we run queries. To: bakkiya Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201106/110 X-Sequence-Number: 44043 On Wed, Jun 8, 2011 at 07:19, bakkiya wrote: > We have a postgresql 8.3.8 DB which consumes 100% of the CPU whenever we run > any query. We got vmstat output Machine details are below: Any query? Does even "SELECT 1" not work? Or "SELECT * FROM sometable LIMIT 1" Or are you having problems with only certain kinds of queries? If so, please follow this for how to report it: https://wiki.postgresql.org/wiki/SlowQueryQuestions Regards, Marti