Re: [HACKERS] Postgre inner work question
On Tuesday 12 April 2011 01.02:35 Lucas Cotta wrote: Does postgre execute the queries following a execution plan tree, where the leafs are table scans, and the nodes are joins? yes, see the EXPLAIN SQL command (EXPLAIN SELECT * FROM ), it will shwo this tree. http://www.postgresql.org/docs/9.0/static/sql-explain.html cheers -- vbi -- The woman you buy -- and she is the least expensive -- takes a great deal of money. The woman who gives herself takes all your time. -- Balzac signature.asc Description: This is a digitally signed message part.
[HACKERS] Postgre inner work question
Hi! Does postgre execute the queries following a execution plan tree, where the leafs are table scans, and the nodes are joins? I'm looking for a database where I can get a cardinality from a partial result of the execution... for example, print the cardinality of the results until the next join operator use this result... Thanks!
[HACKERS] Postgre inner work question
Hi! Does postgre execute the queries following a execution plan tree, where the leafs are table scans, and the nodes are joins? I'm looking for a database where I can get a cardinality from a partial result of the execution... for example, print the cardinality of the results until the next join operator use this result... Thanks!