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 <zeppieri@xxxxxxxxx> wrote:
On Sat, Jul 26, 2025 at 3:13 PM Igor Korot <ikorot01@xxxxxxxxx> 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');
