pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedReinitialising stats once only without restarting
3+ messages / 2 participants
[nested] [flat]
* Reinitialising stats once only without restarting
@ 2007-12-20 10:05 Anton Melser <melser.anton@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Anton Melser @ 2007-12-20 10:05 UTC (permalink / raw)
To: pgsql-performance
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 ...
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Reinitialising stats once only without restarting
@ 2007-12-20 13:35 Alvaro Herrera <alvherre@commandprompt.com>
parent: Anton Melser <melser.anton@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Alvaro Herrera @ 2007-12-20 13:35 UTC (permalink / raw)
To: Anton Melser <melser.anton@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Reinitialising stats once only without restarting
@ 2007-12-20 16:23 Anton Melser <melser.anton@gmail.com>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 3+ messages in thread
From: Anton Melser @ 2007-12-20 16:23 UTC (permalink / raw)
To: Alvaro Herrera <alvherre@commandprompt.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-12-20 16:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-12-20 10:05 Reinitialising stats once only without restarting Anton Melser <melser.anton@gmail.com>
2007-12-20 13:35 ` Alvaro Herrera <alvherre@commandprompt.com>
2007-12-20 16:23 ` Anton Melser <melser.anton@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox