| From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
|---|---|
| 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 12:33:28 |
| Message-ID: | CAGDYbUO1E_og5pseHcANeFO9oEZ0pRGh+vN05Yp+q5bphuEzXQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi Gustav Karlsson,
It only resets the stats for the current database, not the cluster wide
stats - pg_database is cluster wide.
Specially when values associated to inserts, updates, deleted, etc. In
pg_stat_user_* get a new value after running pg_stat_reset().
On Mon, Dec 17, 2018 at 5:11 PM Gustav Karlsson <gustav(dot)karlsson(at)bekk(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-12-17 14:28:34 | Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod? |
| Previous Message | Gustav Karlsson | 2018-12-17 11:41:10 | [ADMIN] Is it safe to run pg_stat_reset() i Prod? |