Postgres Pro
Downloads
Home   >   mailing lists

Reset stats - Pg 9.2 - Mailing list pgsql-general

From Patrick B
Subject Reset stats - Pg 9.2
Date
Msg-id CAJNY3iuuwC-EDYXGAQxvaLpkdAuLGi8JCXSL8oKopbrTojNJPw@mail.gmail.com
Whole thread Raw
Responses Re: Reset stats - Pg 9.2  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Re: pg_basebackup vs archive_command - looking for WAL archive older than archive_command start
Next
From: Adrian Klaver
Date:
Subject: Re: Reset stats - Pg 9.2