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 PM Jon Zeppieri <zeppi...@gmail.com> wrote:
> On Sat, Jul 26, 2025 at 3:13 PM Igor Korot <ikoro...@gmail.com> wrote:
> >
> > 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');
>
>
>
