Thread: How to reset pg_stat_user_tables

How to reset pg_stat_user_tables

From
Medi Montaseri
Date:
I'd like to use pg_stat_user_tables to find when to purge some tables,
I'm wondering if there
is a way to reset it after I'm done....

Sort of like "stats_reset_on_server_start" config param,  but more in
demand without bouncing
the engine...

Thanks


Re: How to reset pg_stat_user_tables

From
Neil Conway
Date:
On Tue, 2003-02-18 at 15:52, Medi Montaseri wrote:
> I'd like to use pg_stat_user_tables to find when to purge some tables,
> I'm wondering if there
> is a way to reset it after I'm done....

Try the pg_stat_reset() function.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC