Re: Explain returns extremely high cost

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Andrii Vasyliev <andrii(dot)vasyliev(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Explain returns extremely high cost
Date: 2006-08-15 10:22:32
Message-ID: 20060815102232.GA30802@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 15, 2006 at 10:14:49AM +0300, Andrii Vasyliev wrote:
> Hi!
>
> I have a database just recreated from scratch with SQL script.
> (My PostgreSQL version is 8.1.3).
> All of the tables are pretty empty, but that's what I've got with explain:
>
> EXPLAIN SELECT * FROM account;
> QUERY PLAN
> ------------------------------------------------------------------------
> Seq Scan on account (cost=100000000.00..100000001.05 rows=5 width=41)

Looks like someone did an "enable_seqscan=no" somewhere, do a "show
all" and check the planner variables...

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message MaXX 2006-08-15 11:13:23 Partial indexes Vs standard indexes : Insert performance
Previous Message Kari Lavikka 2006-08-15 09:08:40 Excluding a table from pg_dump