Re: Analyze tool?

2010/10/1 bricklen <bricklen(at)gmail(dot)com>:
> 2010/10/1 Thom Brown <thom(at)linux(dot)com>:
>> But to find out what indexes you'll need, getting used to reading
>> query plans will help as it will show you more than just where
>> sequentials scans are taking place.  It will also show you what the
>> planner believes a query will cost compared to how much it actually
>> costs, which can provide insight into tables which require vacuuming,
>> indexes which might need clustering, or table stats which require
>> modifying to match you data.
>
> A couple related tools to help with explain plans are the query
> analyzer in pgAdmin
> (http://www.pgadmin.org/images/screenshots/pgadmin3_macosx.png), and
> online at http://explain.depesz.com/

Believe it or not, I still prefer to read the plain text query plan,
although pgAdmin's graphical representation is quite nice.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935