Query Time

From: "Lufkin, Brad" <brad(dot)lufkin(at)ngc(dot)com>
To: 'psql' <pgsql-jdbc(at)postgresql(dot)org>
Subject: Query Time
Date: 2003-08-13 19:46:59
Message-ID: 0E253E40DC78F4499CEDDE9223099F430706B7CB@xcgva040.northgrum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm running the following query:

SELECT * FROM someTable LIMIT 20

I turned on explain analyze (tip #8!) and was told that the query plan was
sequential (no surprise there) with an estimated cost of between 0.00 and
1.07. Surprisingly, the actual time was around 90000 msec (or one-and-a-half
minutes). What's going on?

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message scott.marlowe 2003-08-13 20:19:43 Re: Query Time
Previous Message Barry Lind 2003-08-13 18:25:46 Re: Character Decoding Problems