Reset stats - Pg 9.2

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Reset stats - Pg 9.2
Date: 2016-07-18 03:08:21
Message-ID: CAJNY3iuuwC-EDYXGAQxvaLpkdAuLGi8JCXSL8oKopbrTojNJPw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks
Patrick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-07-18 04:07:12 Re: Reset stats - Pg 9.2
Previous Message maav 2016-07-18 00:20:45 Re: PostgreSQL GUI tools