Re: Identifying optimizer usage of indexed expressions

2024-02-20 Thread Laurenz Albe
On Mon, 2024-02-19 at 23:08 +, Tim Palmer wrote: > I can identify indexes that are used directly during query execution using > pg_stat_user_indexes. However, it is possible that the optimizer might be > using the statistics on the indexed expressions to guide query planning. > If that is the

Identifying optimizer usage of indexed expressions

2024-02-19 Thread Tim Palmer
Hello, I have a Postgres database where many similar expression-based indexes have been added by a script. It is quite likely that some of the indexes are not actually used, and I would like to remove these unused indexes. I can identify indexes that are used directly during query execution