q: explain analyze

From: Mark <sendmailtomark(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: q: explain analyze
Date: 2006-01-10 17:13:04
Message-ID: 20060110171304.84151.qmail@web31912.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

When I run 'explain analyze' on a query, how do I know what index is
used and is it used at all. What are specific words should I look
for?

Is "Seq Scan" indicates that index has been used?
How do I know that it was Full Table Scan?

Thanks,
Mark.


__________________________________________
Yahoo! DSL – Something to write home about.
Just $16.99/mo. or less.
dsl.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2006-01-10 17:18:15 Re: q: explain analyze
Previous Message Ted Byers 2006-01-10 16:58:31 Re: [Bulk] Re: Best programming language / connectivity for best performance