Thread: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
Hi, Am tracking unused indices and wondering if it is safe to run pg_stat_reset() i production? I.e. will pg_stat_reset() affectstats used by the query planner in any way which could affect performance? Regards, Gustav
On Mon, Dec 17, 2018 at 5:11 PM Gustav Karlsson <gustav.karlsson@bekk.no> wrote:
Hi,
Am tracking unused indices and wondering if it is safe to run pg_stat_reset() i production? I.e. will pg_stat_reset() affect stats used by the query planner in any way which could affect performance?
Regards,
Gustav
Gustav Karlsson <gustav.karlsson@bekk.no> writes: > Am tracking unused indices and wondering if it is safe to run pg_stat_reset() i production? I.e. will pg_stat_reset() affectstats used by the query planner in any way which could affect performance? The planner doesn't look at any of that data. regards, tom lane