Re: Postgre inner work question

From: Adrian von Bidder <avbidder(at)fortytwo(dot)ch>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Lucas Cotta <luccotta(at)gmail(dot)com>
Subject: Re: Postgre inner work question
Date: 2011-04-13 07:01:30
Message-ID: 201104130901.31612@fortytwo.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2011-04-13 08:45:25 Re: Windows build issues
Previous Message Tom Lane 2011-04-13 06:06:11 Re: POSIX shared memory redux