Home > mailing lists

understanding output from Explain - Mailing list pgsql-general

From	Tom Allison
Subject	understanding output from Explain
Date	April 22, 2007 13:43:39
Msg-id	462B6684.4070306@tacocat.net Whole thread Raw
Responses	Re: understanding output from Explain ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-general

"Seq Scan on"  - is this just a FULL TABLE scan?

I'm familiar with Oracles explain plans and terminology.
But not so much so with psql...

From: "Joshua D. Drake"
Date: 22 April 2007, 04:13:47
Subject: Re: ERROR: Failed to build any 5-way joins

From: "A. Kretschmer"
Date: 22 April 2007, 14:36:09
Subject: Re: understanding output from Explain