On Mon, Feb 5, 2024 at 9:54 PM Greg Sabino Mullane
wrote:
> The pg_stat_*_tables tables idx_* columns has accumulated usage since the
>> last time you started the postmaster.
>>
>
> Actually, those persist at restart - you can use
>
> select datname, stats_reset from pg_stat_database;
>
> to see
>
> The pg_stat_*_tables tables idx_* columns has accumulated usage since the
> last time you started the postmaster.
>
Actually, those persist at restart - you can use
select datname, stats_reset from pg_stat_database;
to see when/if they were reset. You can look for zero/low entries in
pg_sta
On Mon, Feb 5, 2024 at 9:02 AM arun chirappurath
wrote:
> Hi All,
>
> Do we have a script to get unused indexes for 30 days and once identified
> do we have an option to disable and enable when required?
>
The pg_stat_*_tables tables idx_* columns has accumulated usage since the
last time you s
El sáb., 1 dic. 2018 a las 8:24, Ron () escribió:
>
> For indexes that existed before the cluster was last started, and for which
> REINDEX hasn't been run on them since the cluster was last started... is it
> valid to say that an index has not been used since the cluster was started
> if these thr
I think your assumption is correct, as long as the statistics collector is
working correctly (I've never seen this not being the case), and the
setting "track_counts" is set to on.
Am Sa., 1. Dez. 2018 um 05:24 Uhr schrieb Ron :
> For indexes that existed before the cluster was last started, and
