MIME-Version: 1.0
References: <CA+FnnTw2ouEQKSKzQ_SNo8efWE8wEqjr9Ux-F-wbR+y=Pn6bGg@mail.gmail.com>
 <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <CA+FnnTyKb0cLp9GF3YENoBZ4LVW3db_RSGR99BPFnA4BZtc8kQ@mail.gmail.com>
 <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com> <CA+FnnTy8bdXxFZBmFfm1oNMQLVxL-+UmkX8EecbLB0MehX8gFw@mail.gmail.com>
 <CAKfDxxw=4Vax5Oq0apoAE=RkzNgHwvHzKX1ejE6z7n7_vtGBUQ@mail.gmail.com>
In-Reply-To: <CAKfDxxw=4Vax5Oq0apoAE=RkzNgHwvHzKX1ejE6z7n7_vtGBUQ@mail.gmail.com>
From: David Barbour <david.barbour@amiralearning.com>
Date: Mon, 28 Jul 2025 08:19:56 -0500
Message-ID: <CAEMHB2QQpfxjbqbyB6zy+TMv9zf42tavLuYUSxDXgyZEaq46Xg@mail.gmail.com>
Subject: Re: Get info about the index
To: Jon Zeppieri <zeppieri@gmail.com>
Cc: Igor Korot <ikorot01@gmail.com>, Christophe Pettus <xof@thebuild.com>, 
	Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000008288fc063afd26b3"
Archived-At: <https://www.postgresql.org/message-id/CAEMHB2QQpfxjbqbyB6zy%2BTMv9zf42tavLuYUSxDXgyZEaq46Xg%40mail.gmail.com>
Precedence: bulk

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

Couple of suggestions.  You might try ChatGPT.  I've had some success using
this tool to uncover improvements to the use of indexes.  The other would
be to look at https://explain.depesz.com/.  It's pretty self-explanatory.
You run an explain plan and paste the results into the tool and it will run
an automated analysis.

On Sat, Jul 26, 2025 at 2:51=E2=80=AFPM Jon Zeppieri <zeppieri@gmail.com> w=
rote:

> On Sat, Jul 26, 2025 at 3:13=E2=80=AFPM Igor Korot <ikorot01@gmail.com> w=
rote:
> >
> > I didn't find the sorting for the field.
> >
> > Can you help?
>
> The pg_index_column_has_property() can provide this information. E.g.,
>
> select pg_index_column_has_property('my_index'::regclass, 2, 'desc');
>
>
>

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

<div dir=3D"ltr">Couple of suggestions.=C2=A0 You might try ChatGPT.=C2=A0 =
I&#39;ve had some success using this tool to uncover improvements to the us=
e of indexes.=C2=A0 The other would be to look at=C2=A0<a href=3D"https://e=
xplain.depesz.com/">https://explain.depesz.com/</a>.=C2=A0 It&#39;s pretty =
self-explanatory.=C2=A0 You run an explain plan and paste the results into =
the tool and it will run an automated analysis.</div><br><div class=3D"gmai=
l_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Jul 26, 2025 at 2:51=
=E2=80=AFPM Jon Zeppieri &lt;<a href=3D"mailto:zeppieri@gmail.com" target=
=3D"_blank">zeppieri@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex">On Sat, Jul 26, 2025 at 3:13=E2=80=AFPM Igor =
Korot &lt;<a href=3D"mailto:ikorot01@gmail.com" target=3D"_blank">ikorot01@=
gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; I didn&#39;t find the sorting for the field.<br>
&gt;<br>
&gt; Can you help?<br>
<br>
The pg_index_column_has_property() can provide this information. E.g.,<br>
<br>
select pg_index_column_has_property(&#39;my_index&#39;::regclass, 2, &#39;d=
esc&#39;);<br>
<br>
<br>
</blockquote></div>

--0000000000008288fc063afd26b3--