[Phpwm] Postgres query plan terminology

David Goodwin david at codepoets.co.uk
Tue Oct 23 20:17:53 BST 2007


Greg Jones wrote :
> Does anyone know of anything that will tell me what exactly is meant
> by the various terms used when I run an 'explain analyze' on a query?
> Some are fairly self explanatory ('seq_scan' vs 'index_scan' for
> example) but I have no idea what 'materialize' means in this context?

Err.. #postgres ? are there any postgres mailing lists ?

We have some books I can check, but not until tomorrow.

David.
-- 
David Goodwin 

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]



More information about the Phpwm mailing list