Re: How to reset pg_stat_user_tables

From: Neil Conway <neilc(at)samurai(dot)com>
To: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to reset pg_stat_user_tables
Date: 2003-02-19 02:53:51
Message-ID: 1045623231.585.185.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2003-02-19 02:55:48 Re: pg and chroot (performance)
Previous Message Timtohy 2003-02-19 02:42:23 query length