Re: meaning of explain - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: meaning of explain
Date
Msg-id 20020709081356.V38937-100000@megazone23.bigpanda.com
Whole thread Raw
In response to meaning of explain  (Auri Mason <amason@syntrex.com>)
List 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.


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: createuser --password
Next
From: Stephan Szabo
Date:
Subject: Re: multiple primary keys