Re: clear pg_stats

From: Magnus Hagander <magnus(at)hagander(dot)net>
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:57:25
Message-ID: 474F35C5.9080103@hagander.net
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.

pg_stat_reset()

//Magnus

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2007-11-29 23:31:01 Re: TB-sized databases
Previous Message Heikki Linnakangas 2007-11-29 21:54:08 Re: clear pg_stats