Re: Get info about the index
| От | David Barbour |
|---|---|
| Тема | Re: Get info about the index |
| Дата | |
| Msg-id | CAEMHB2QQpfxjbqbyB6zy+TMv9zf42tavLuYUSxDXgyZEaq46Xg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Get info about the index (Jon Zeppieri <zeppieri@gmail.com>) |
| Ответы |
Re: Get info about the index
|
| Список | pgsql-general |
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 по дате отправления: