[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [HACKERS] Postgre inner work question
From: Adrian von Bidder <avbidder () fortytwo ! ch>
Date: 2011-04-13 7:01:30
Message-ID: 201104130901.31612 () fortytwo ! ch
[Download RAW message or body]
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" (application/pgp-signature)]
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic