Re: clear pg_stats

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: "Campbell, Lance" <lance(at)uiuc(dot)edu>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: clear pg_stats
Date: 2007-11-29 21:54:08
Message-ID: 474F3500.7010109@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Magnus Hagander 2007-11-29 21:57:25 Re: clear pg_stats
Previous Message Campbell, Lance 2007-11-29 21:46:42 clear pg_stats