Re: decrease my query duration

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: decrease my query duration
Дата
Msg-id CAGrpgQ-VuuGhSamRpHK=HYCbDVWs0hF9Z44fvoX2XStKSp0oYQ@mail.gmail.com
обсуждение исходный текст
Ответ на decrease my query duration  (David Carpio <davidc@consistentstate.com>)
Ответы Re: decrease my query duration  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
Дерево обсуждения

On Thu, Jul 4, 2013 at 5:26 PM, David Carpio <davidc@consistentstate.com> wrote:
Hello All

I am newbie in this forum that's why I will be very grateful if would be able to help me and if you need some additional information please let me know.
I have a query that I would like decrease its duration

<snip query & EXPLAIN>

Have a look at https://wiki.postgresql.org/wiki/Slow_Query_Questions and supply a few more details, it will increase your chances of getting helpful answers.
Also, can you supply the EXPLAIN (ANALYZE, BUFFERS) plan instead of the simple EXPLAIN plan?

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

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: decrease my query duration