Skip site navigation (1) Skip section navigation (2)

Re: Using Explain

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "P(dot) Dwayne Miller" <dmiller(at)espgroup(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Using Explain
Date: 2001-07-05 16:10:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
"P. Dwayne Miller" <dmiller(at)espgroup(dot)net> writes:
> Any places to look that might explain the results of explain?

If you're still confused, feel free to post the query, table schemas,
and EXPLAIN output.

BTW, have you run VACUUM ANALYZE?  If not, you're unlikely to get a
good plan.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Naomi WalkerDate: 2001-07-05 16:13:40
Subject: Re: Re: Backup and Recovery
Previous:From: Bruce MomjianDate: 2001-07-05 16:05:49
Subject: Re: AW: Re: Backup and Recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group