Re: How to find out about index - Mailing list pgsql-general

From Tom Lane
Subject Re: How to find out about index
Date
Msg-id 1573.1034085613@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to find out about index  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Tue, Oct 08, 2002 at 12:22:15PM +0530, Savita wrote:
>> What does the row indicate in the NOTICE:  QUERY PLAN:

> Try EXPLAIN ANALYZE.

Also, do an ANALYZE first.  Those row counts look suspiciously like the
default ones that are used for never-ANALYZEd tables, where the planner
really has no idea what's in the table.

            regards, tom lane

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Hot Backup
Next
From: Justin Clift
Date:
Subject: Re: Rép. : Re: Hot Backup