Re: decrease my query duration

From: bricklen <bricklen(at)gmail(dot)com>
To: David Carpio <davidc(at)consistentstate(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: decrease my query duration
Date: 2013-07-05 01:04:31
Message-ID: CAGrpgQ-VuuGhSamRpHK=HYCbDVWs0hF9Z44fvoX2XStKSp0oYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 4, 2013 at 5:26 PM, David Carpio <davidc(at)consistentstate(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2013-07-05 01:10:45 Re: decrease my query duration
Previous Message David Johnston 2013-07-05 00:43:51 Re: How to create a cursor that is independent of transactions and doesn't calculated when created ?