Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

nuderstanding 'explain analyse'

Поиск
Список
Период
Сортировка
От Alexandre Leclerc
Тема nuderstanding 'explain analyse'
Дата
Msg-id 1dc7f0e304111613116532a64b@mail.gmail.com
обсуждение исходный текст
Ответы Re: nuderstanding 'explain analyse'
Список pgsql-performance
Hello,

I build two SELECT queries, and in one I used COALESCE with a CASE,
and in the second one I used only CASE statements.

When analysing, I'm getting the exact same result, except the cost.
(For now I have so few data that the results are too fragmented.

If the plans for both queries are exactly the same, should I assume
that the cost will also be the same?

Thanks for any help.
--
Alexandre Leclerc

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