MIME-Version: 1.0
References: <1503164276875-5979128.post@n3.nabble.com>
 <20170821183226.GW24376@telsasoft.com>
In-Reply-To: <20170821183226.GW24376@telsasoft.com>
From: Carlos Augusto Machado <caugustom@gmail.com>
Date: Mon, 21 Aug 2017 18:46:32 +0000
Message-ID: 
 <CAK2MEjuV+99716Qg7wU8C4LMdYdEXSimzXJ7uf1yH6yhp4e7Qg@mail.gmail.com>
Subject: Re: Performance Issue -- "Materialize"
To: Justin Pryzby <pryzby@telsasoft.com>, anand086 <anand086@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary="001a113ce5a06042af055747e62c"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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

Do you have an index on login column ?

If not, try creating an index and taking off those DISTICTs.

Em seg, 21 de ago de 2017 =C3=A0s 15:33, Justin Pryzby <pryzby@telsasoft.co=
m>
escreveu:

> On Sat, Aug 19, 2017 at 10:37:56AM -0700, anand086 wrote:
> >
> +------------------------------------------------------------------------=
---------------------------------------------------------------------------=
--------+|
> > QUERY PLAN
> >
> |+-----------------------------------------------------------------------=
---------------------------------------------------------------------------=
---------+|
> > Aggregate  (cost=3D351405.08..351405.09 rows=3D1 width=3D8)
>
> Would you send explain ANALYZE and not just explain ?
>
> Justin
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org=
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

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

<div dir=3D"ltr"><br><div>Do you have an index on login column ?</div><div>=
<br></div><div>If not, try creating an index and taking off those DISTICTs.=
</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr">Em seg, 21 de a=
go de 2017 =C3=A0s 15:33, Justin Pryzby &lt;<a href=3D"mailto:pryzby@telsas=
oft.com">pryzby@telsasoft.com</a>&gt; escreveu:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex">On Sat, Aug 19, 2017 at 10:37:56AM -0700, anand086 wrote:<br>
&gt; +---------------------------------------------------------------------=
---------------------------------------------------------------------------=
-----------+|<br>
&gt; QUERY PLAN<br>
&gt; |+--------------------------------------------------------------------=
---------------------------------------------------------------------------=
------------+|<br>
&gt; Aggregate=C2=A0 (cost=3D351405.08..351405.09 rows=3D1 width=3D8)<br>
<br>
Would you send explain ANALYZE and not just explain ?<br>
<br>
Justin<br>
<br>
<br>
--<br>
Sent via pgsql-performance mailing list (<a href=3D"mailto:pgsql-performanc=
e@postgresql.org" target=3D"_blank">pgsql-performance@postgresql.org</a>)<b=
r>
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/mailpref/pgsql-perform=
ance</a><br>
</blockquote></div>

--001a113ce5a06042af055747e62c--