MIME-Version: 1.0
References: <CAJCZkoL+DHs0H9enQEg8JXZw=7032zrmFKG8Vx0fup6_wqNpnQ@mail.gmail.com>
 <b319261b-3e06-41f9-9772-1a1747ede2b1@aklaver.com> <CAJCZkoLSaApgwHuWepO4EUENtjKMy1oX+GpEsFW4D+gFKoN_GQ@mail.gmail.com>
 <77CFD347-1A36-4A78-8D95-21569977C0A5@gmail.com>
In-Reply-To: <77CFD347-1A36-4A78-8D95-21569977C0A5@gmail.com>
From: Durgamahesh Manne <maheshpostgres9@gmail.com>
Date: Fri, 14 Mar 2025 08:09:46 +0530
Message-ID: <CAJCZko+jAv98MZJp0T8KthDoWKdmhKTk-XukQJ1CR-v=+mSRhg@mail.gmail.com>
Subject: Re: Query optimization
To: Rob Sargent <robjsargent@gmail.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general <pgsql-general@lists.postgresql.org>, laurenz.albe@cybertec.at
Content-Type: multipart/alternative; boundary="000000000000c3149d0630445a87"
Archived-At: <https://www.postgresql.org/message-id/CAJCZko%2BjAv98MZJp0T8KthDoWKdmhKTk-XukQJ1CR-v%3D%2BmSRhg%40mail.gmail.com>
Precedence: bulk

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

On Fri, 14 Mar, 2025, 08:04 Rob Sargent, <robjsargent@gmail.com> wrote:

>
>
>
> 3) Output of EXPLAIN ANALYZE of query.
>
>  Result  (cost=3D2.80..2.83 rows=3D1 width=3D1) (actual time=3D0.030..0.0=
30 rows=3D1
> loops=3D1)
>    InitPlan 1 (returns $0)
>      ->  Index Only Scan using idx_cachekeys on cachekeys
>  (cost=3D0.55..2.80 rows=3D1 width=3D0) (actual time=3D0.029..0.029 rows=
=3D1 loops=3D1)
>            Index Cond: ((cachetype =3D 'BoMatrix'::text) AND (trsid =3D
> 'daznbetuk'::text) AND (brandid =3D 'daznbet'::text) AND (sportid =3D
> 'BOX'::text) AND (competitionid =3D 'U-1998'::text) AND (eventid =3D
> 'U-523596'::text))
>            Heap Fetches: 0
>  Planning Time: 0.221 ms
>  Execution Time: 0.046 ms
>
>
>
> And is the explain analyze output if from your original query:
> "SELECT EXISTS (SELECT Key FROM CACHEKEYS WHERE CacheType =3D $1 AND TrsI=
d
> =3D $2 AND BrandId =3D $3 AND SportId =3D $4 AND CompetitionId =3D $5 AND=
 EventId =3D
> $6 AND MarketId =3D $7 LIMIT ?)=E2=80=9D
>
> Has there been any significant addition of rows recently? i.e. are the
> statistics up-to-date for that table?
>
Hi

Gave you plan with out limit . Stats up to date insert .....on conflict do
nothing runs some times

Regards
Durga Mahesh

>
>
>

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

<div dir=3D"auto"><div><br><br><div class=3D"gmail_quote gmail_quote_contai=
ner"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 14 Mar, 2025, 08:04 Rob =
Sargent, &lt;<a href=3D"mailto:robjsargent@gmail.com">robjsargent@gmail.com=
</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:=
0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style=3D"word-=
wrap:break-word;line-break:after-white-space"><br><div><br><blockquote type=
=3D"cite"><div><br></div><div><div dir=3D"ltr"><div class=3D"gmail_quote">3=
) Output of EXPLAIN ANALYZE of query.</div><div class=3D"gmail_quote"><br><=
/div><div class=3D"gmail_quote">=C2=A0Result =C2=A0(cost=3D2.80..2.83 rows=
=3D1 width=3D1) (actual time=3D0.030..0.030 rows=3D1 loops=3D1)<br>=C2=A0 =
=C2=A0InitPlan 1 (returns $0)<br>=C2=A0 =C2=A0 =C2=A0-&gt; =C2=A0Index Only=
 Scan using idx_cachekeys on cachekeys =C2=A0(cost=3D0.55..2.80 rows=3D1 wi=
dth=3D0) (actual time=3D0.029..0.029 rows=3D1 loops=3D1)<br>=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0Index Cond: ((cachetype =3D &#39;BoMatrix&#39;::=
text) AND (trsid =3D &#39;daznbetuk&#39;::text) AND (brandid =3D &#39;daznb=
et&#39;::text) AND (sportid =3D &#39;BOX&#39;::text) AND (competitionid =3D=
 &#39;U-1998&#39;::text) AND (eventid =3D &#39;U-523596&#39;::text))<br>=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Heap Fetches: 0<br>=C2=A0Planning Tim=
e: 0.221 ms<br>=C2=A0Execution Time: 0.046 ms<br><br></div></div></div></bl=
ockquote><div><br></div><div><br></div>And is the explain analyze output if=
 from your original query:</div><div>&quot;<span style=3D"font-family:Couri=
erNewPSMT">SELECT EXISTS (SELECT Key FROM CACHEKEYS WHERE CacheType =3D $1 =
AND TrsId =3D $2 AND BrandId =3D $3 AND SportId =3D $4 AND CompetitionId =
=3D $5 AND EventId =3D $6 AND MarketId =3D $7 LIMIT ?)</span><font face=3D"=
CourierNewPSMT">=E2=80=9D</font></div><div><span style=3D"font-family:Couri=
erNewPSMT"><br></span></div><div><span style=3D"font-family:CourierNewPSMT"=
>Has there been any significant addition of rows recently? i.e. are the sta=
tistics up-to-date for that table?</span></div><div><span style=3D"font-fam=
ily:CourierNewPSMT"></span></div></div></blockquote></div></div><div dir=3D=
"auto">Hi</div><div dir=3D"auto"><br></div><div dir=3D"auto">Gave you plan =
with out limit . Stats up to date insert .....on conflict do nothing runs s=
ome times=C2=A0</div><div dir=3D"auto"><br></div><div dir=3D"auto">Regards=
=C2=A0</div><div dir=3D"auto">Durga Mahesh</div><div dir=3D"auto"><div clas=
s=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gmail_quote" s=
tyle=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div=
 style=3D"word-wrap:break-word;line-break:after-white-space"><div><span sty=
le=3D"font-family:CourierNewPSMT"><br></span></div><div><span style=3D"font=
-family:CourierNewPSMT"><br></span></div></div></blockquote></div></div></d=
iv>

--000000000000c3149d0630445a87--