Re: Postgre inner work question

Поиск
Список
Период
Сортировка
От Adrian von Bidder
Тема Re: Postgre inner work question
Дата
Msg-id 201104130901.31612@fortytwo.ch
обсуждение исходный текст
Ответ на Postgre inner work question  (Lucas Cotta <luccotta@gmail.com>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: POSIX shared memory redux
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Windows build issues