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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gustav Karlsson <gustav(dot)karlsson(at)bekk(dot)no>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
Date: 2018-12-17 14:28:34
Message-ID: 27532.1545056914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Gustav Karlsson <gustav(dot)karlsson(at)bekk(dot)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() 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Davenport, Julie 2018-12-17 21:16:53 cannot reach repository pgdg94/7Server/x86_64
Previous Message Shreeyansh Dba 2018-12-17 12:33:28 Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?