Hi,
Sorry but I couldn't find the answer to this...

I would like to empty all stats (pg_stat_all_tables probably mostly)
so I can get an idea of what's going on now. Is this possible? I
didn't want to just go deleting without knowing what it would do...
Thanks
Anton

--
echo '16i[q]sa[ln0=aln100%Pln100/snlbx]sbA0D4D465452snlbxq' | dc
This will help you for 99.9% of your problems ...

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Anton Melser escribió:
> Hi,
> Sorry but I couldn't find the answer to this...
>
> I would like to empty all stats (pg_stat_all_tables probably mostly)
> so I can get an idea of what's going on now. Is this possible? I
> didn't want to just go deleting without knowing what it would do...

Sure, use pg_stat_reset();

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

On 20/12/2007, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> Anton Melser escribió:
> > Hi,
> > Sorry but I couldn't find the answer to this...
> >
> > I would like to empty all stats (pg_stat_all_tables probably mostly)
> > so I can get an idea of what's going on now. Is this possible? I
> > didn't want to just go deleting without knowing what it would do...
>
> Sure, use pg_stat_reset();

Pura vida, gracias.
A

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org