[ADMIN] Is it safe to run pg_stat_reset() i Prod?

From: Gustav Karlsson <gustav(dot)karlsson(at)bekk(dot)no>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
Date: 2018-12-17 11:41:10
Message-ID: 5BCD9CB6-A4DE-4360-9C13-23A06091A52A@bekk.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-12-17 12:33:28 Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
Previous Message Laurenz Albe 2018-12-15 13:55:07 Re: finding queries doing sequential search