On 07/17/2016 08:08 PM, Patrick B wrote:
Hi all, select stats_reset from pg_stat_database; It says the statistics were reseted back in 2014. I want to reset it now (production database), to get more clear data. select pg_stat_reset(); Should be ok? Those stats aren't used for Query plan, right?
That would be pg_statistic: https://www.postgresql.org/docs/9.2/static/catalog-pg-statistic.html
Thanks Patrick
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general