Skip site navigation (1) Skip section navigation (2)

Re: CPU usage goes to 100%, query seems to ran forever

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: CPU usage goes to 100%, query seems to ran forever
Date: 2006-04-27 19:09:13
Message-ID: 14690.1146164953@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"Andrus" <eetasoft(at)online(dot)ee> writes:
> I have small database running in  8.1.3 in W2K server.
> The following query causes Postgres process to use 100% CPU and seems to run 
> forever.
> If I change '1EEKPANT' to less frequently used item code, it runs fast.

You have ANALYZEd all these tables recently, I hope?  The planner
certainly doesn't think this query will take very long.

To find out what's wrong, you're going to have to be patient enough to
let an EXPLAIN ANALYZE run to completion.  Plain EXPLAIN won't tell.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Mark KirkwoodDate: 2006-04-28 02:30:36
Subject: Re: Hardware: HP StorageWorks MSA 1500
Previous:From: Dan GormanDate: 2006-04-27 18:58:59
Subject: Re: Running on an NFS Mounted Directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group