[ADMIN] Is it safe to run pg_stat_reset() i Prod?
[ADMIN] Is it safe to run pg_stat_reset() i Prod?
От:
Gustav Karlsson <gustav.karlsson@bekk.no>
Дата:
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
Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
От:
Shreeyansh Dba <shreeyansh2014@gmail.com>
Дата:
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
Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Gustav Karlsson writes: > 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? The planner doesn't look at any of that data. regards, tom lane