Re: meaning of explain

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Auri Mason <amason(at)syntrex(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: meaning of explain
Date: 2002-07-09 15:15:09
Message-ID: 20020709081356.V38937-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Tue, 9 Jul 2002, Auri Mason wrote:

> in order to measure the improve of performances after a vacuum+reindex (do
> you suggest something more?), I want to understand exactly the output of
> the explain command.
> After a google search I found a broken link posted by Tom.

As a suggestion, vaccum analyze rather than vacuum to get the stats
updated and I'd suggest checking chapter 11 of the user's guide if you're
using 7.2 which appears to have a section on explain.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-07-09 15:17:40 Re: multiple primary keys
Previous Message Guthrie, John 2002-07-09 15:08:05 Re: psql in Batch mode and passwords?