Try
Home   >   mailing lists

Re: Get info about the index - Mailing list pgsql-general

From David Barbour
Subject Re: Get info about the index
Date
Msg-id CAEMHB2QQpfxjbqbyB6zy+TMv9zf42tavLuYUSxDXgyZEaq46Xg@mail.gmail.com
Whole thread Raw
In response to Re: Get info about the index  (Jon Zeppieri <zeppieri@gmail.com>)
Responses Re: Get info about the index
List pgsql-general
Tree view
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@gmail.com> wrote:
On Sat, Jul 26, 2025 at 3:13 PM Igor Korot <ikorot01@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');


pgsql-general by date:

Previous
From: "DINESH NAIR"
Date:
Subject: Re: Regarding logical replication issues with PostgreSQL versions 16 and above
Next
From: Laurenz Albe
Date:
Subject: Re: Get info about the index