Postgres Pro
Downloads
Home   >   mailing lists

Re: decrease my query duration - Mailing list pgsql-general

From bricklen
Subject Re: decrease my query duration
Date
Msg-id CAGrpgQ-VuuGhSamRpHK=HYCbDVWs0hF9Z44fvoX2XStKSp0oYQ@mail.gmail.com
Whole thread Raw
In response to decrease my query duration  (David Carpio <davidc@consistentstate.com>)
Responses Re: decrease my query duration
List pgsql-general
Tree view

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 by date:

Previous
From: David Johnston
Date:
Subject: Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?
Next
From: Michael Paquier
Date:
Subject: Re: decrease my query duration