MIME-Version: 1.0
In-Reply-To: 
 <CAA=to3gXpr94TqSAYXT9zwxYwY_xKrLFnu8ZJNgJKP-kWza2CA@mail.gmail.com>
References: 
 <CAA=to3gXpr94TqSAYXT9zwxYwY_xKrLFnu8ZJNgJKP-kWza2CA@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Wed, 15 Nov 2017 10:43:23 +0100
Message-ID: 
 <CAFj8pRCyvCktcxtEQrmF4kw5oR1DNYd_4gJNd6mkjrHw_NPPPw@mail.gmail.com>
Subject: Re: query performance issue
To: Samir Magar <samirmagar8@gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Type: multipart/alternative; boundary="001a11444a200963f2055e02580e"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--001a11444a200963f2055e02580e
Content-Type: text/plain; charset="UTF-8"

Hi

please send EXPLAIN ANALYZE output.

Regards

Pavel

2017-11-15 10:33 GMT+01:00 Samir Magar <samirmagar8@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 (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
>

--001a11444a200963f2055e02580e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div>Hi<br><br></div>please send EXPLAIN ANALYZE=
 output.<br><br></div>Regards<br><br></div>Pavel<br></div><div class=3D"gma=
il_extra"><br><div class=3D"gmail_quote">2017-11-15 10:33 GMT+01:00 Samir M=
agar <span dir=3D"ltr">&lt;<a href=3D"mailto:samirmagar8@gmail.com" target=
=3D"_blank">samirmagar8@gmail.com</a>&gt;</span>:<br><blockquote class=3D"g=
mail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-l=
eft:1ex"><div dir=3D"ltr">Hello,<div>I am having performance issues with on=
e of the query.</div><div>The query is taking 39 min to fetch 3.5 mil recor=
ds.</div><div><br></div><div>I want to reduce that time to 15 mins.=C2=A0</=
div><div>could you please suggest something to its performance?</div><div><=
br></div><div>server configuration:</div><div>=C2=A0CPUs =3D 4</div><div>me=
mory =3D 16 GM</div><div>shared_buffers =3D 3 GB</div><div>work_mem =3D 100=
MB</div><div>effective_cache_size =3D 12 GB</div><div><br></div><div>we are=
 doing the vacuum/analyze regularly on the database.=C2=A0</div><div><br></=
div><div>attached is the query with its explain plan.</div><div><br></div><=
div>Thanks,</div><div>Samir Magar=C2=A0=C2=A0</div></div>
<br><br>
--<br>
Sent via pgsql-performance mailing list (<a href=3D"mailto:pgsql-performanc=
e@postgresql.org">pgsql-performance@postgresql.<wbr>org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-performance" rel=3D"nor=
eferrer" target=3D"_blank">http://www.postgresql.org/<wbr>mailpref/pgsql-pe=
rformance</a><br>
<br></blockquote></div><br></div>

--001a11444a200963f2055e02580e--