Postgres Pro
Downloads
Home   >   mailing lists

[PERFORM] query performance issue - Mailing list pgsql-performance

From Samir Magar
Subject [PERFORM] query performance issue
Date
Msg-id CAA=to3gXpr94TqSAYXT9zwxYwY_xKrLFnu8ZJNgJKP-kWza2CA@mail.gmail.com
Whole thread Raw
Responses Re: [PERFORM] query performance issue  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: [PERFORM] query performance issue  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view
Hello,
I am having performance issues with one of the query.
The query is taking 39 min to fetch 3.5 mil records.

I want to reduce that time to 15 mins. 
could you please suggest something to its performance?

server configuration:
 CPUs = 4
memory = 16 GM
shared_buffers = 3 GB
work_mem = 100MB
effective_cache_size = 12 GB

we are doing the vacuum/analyze regularly on the database. 

attached is the query with its explain plan.

Thanks,
Samir Magar  
Attachment

pgsql-performance by date:

Previous
From: legrand legrand
Date:
Subject: [PERFORM] Re: Query planner gaining the ability to replanning after start ofquery execution.
Next
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] query performance issue