Postgres Pro
Downloads
Home   >   mailing lists

Re: clear pg_stats - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: clear pg_stats
Date
Msg-id 474F3500.7010109@enterprisedb.com
Whole thread Raw
In response to clear pg_stats  ("Campbell, Lance" <lance@uiuc.edu>)
List pgsql-performance
Tree view 
Campbell, Lance wrote:
> How can I clear the pg_stats views without restarting PostgreSQL?  I
> thought there was a function.

SELECT pg_stat_reset();

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: "Campbell, Lance"
Date:
Subject: clear pg_stats
Next
From: Magnus Hagander
Date:
Subject: Re: clear pg_stats