Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod? - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
Date
Msg-id 27532.1545056914@sss.pgh.pa.us
Whole thread Raw
In response to [ADMIN] Is it safe to run pg_stat_reset() i Prod?  (Gustav Karlsson <gustav.karlsson@bekk.no>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: [ADMIN] Is it safe to run pg_stat_reset() i Prod?
Next
From: "Davenport, Julie"
Date:
Subject: cannot reach repository pgdg94/7Server/x86_64