q: explain analyze - Mailing list pgsql-general

From Mark
Subject q: explain analyze
Date
Msg-id 20060110171304.84151.qmail@web31912.mail.mud.yahoo.com
Whole thread Raw
Responses Re: q: explain analyze  (Jaime Casanova <systemguards@gmail.com>)
List 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


pgsql-general by date:

Previous
From: "Ted Byers"
Date:
Subject: Re: [Bulk] Re: Best programming language / connectivity for best performance
Next
From: Jaime Casanova
Date:
Subject: Re: q: explain analyze