Re: Question about explain-command...

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of
> Clemens Eisserer
> Sent: Wednesday, May 10, 2006 6:50 AM
> To: pgsql-performance(at)postgresql(dot)org
> Subject: [PERFORM] Question about explain-command...

>
> What does the hash-lines mean, does that mean my query does not use
> the indices at all?
> Why are some table-names and some column-names surrounded by ' " '?
> Are they threated as text-columns?
> I have to admit that the tables are just filled with test-data so the
> analyzer may take just a very simple way since almost no data is in...
>

For small tables, it is faster to do a sequential scan than an index
scan. You probably don't have enough test data to make the planner
choose an index scan.

I don't think the quotes really mean anything. They are just used as
delimiters.

The hash lines mean your tables are being joined by hash joins. You
should read this page for more info:

http://www.postgresql.org/docs/8.1/interactive/performance-tips.html