Subject: Re: Query is running very slow......
To: pgsql-performance@postgresql.org
References: <3152be5a435f45649cef6bf9321beb9a@cyient.com>
From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Message-ID: <4caed7cc-07d8-e364-78ca-7a96b9780a9d@2ndquadrant.com>
Date: Wed, 24 May 2017 19:25:54 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:54.0) Gecko/20100101
 Thunderbird/54.0a2
MIME-Version: 1.0
In-Reply-To: <3152be5a435f45649cef6bf9321beb9a@cyient.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi,

On 5/24/17 7:04 PM, Dinesh Chandra 12108 wrote:
> Dear Expert,
> 
> While executing the blow query, its taking too long time to fetch output.
> 
> Could you please help to fine tune the same?
> 

You'll have to provide far more details - the query alone is certainly 
not enough for anyone to guess why it's slow. Perhaps look at this:

     https://wiki.postgresql.org/wiki/Slow_Query_Questions

In particular, you'll have to tell us

(a) something about the hardware it's running on

(b) amounts of data in the tables / databases

(c) EXPLAIN or even better EXPLAIN ANALYZE of the query

(d) configuration of the database (work_mem, shared_buffers etc.)


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance