Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 29 Nov 2007 21:54:08 +0000
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
- References:
- clear pg_stats
- From: Campbell, Lance
- clear pg_stats
- Prev by Date: clear pg_stats
- Next by Date: Re: clear pg_stats
- Previous by thread: clear pg_stats
- Next by thread: Re: clear pg_stats
- Indexes: