Hi please send EXPLAIN ANALYZE output.
Regards Pavel 2017-11-15 10:33 GMT+01:00 Samir Magar <samirmag...@gmail.com>: > 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 > > > -- > Sent via pgsql-performance mailing list (email@example.com) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > >