Thread

1. Postgre inner work question

   Lucas Cotta <luccotta@gmail.com> — 2011-04-11T23:02:35Z

   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!
   

2. Postgre inner work question

   Lucas Cotta <luccotta@gmail.com> — 2011-04-11T23:08:28Z

   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!
   

3. Re: Postgre inner work question

   Adrian von Bidder <avbidder@fortytwo.ch> — 2011-04-13T07:01:30Z

   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