From: | Andrew Bartley <ambartley(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Redundant database objects. |
Date: | 2010-07-13 00:09:48 |
Message-ID: | AANLkTim89HDk1sV6LDnCoZ0FnRZqgzn8iI6qlLd3kNDZ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Greg,
It seems that the underlying stats tables are reset on a periodic basis, can
i stop this process? Is it a .conf setting? I have had a good look around,
nothing sticks out. If I can stop it, then i could use pg_stat_reset() then
monitor the stat views over an extended period without them being reset by
some periodic job. That, at the moment, is my main concern.
Thanks again.
Also i need to find similar information regarding functions and views....
Any suggestions?
Thanks
Andrew Bartley
On 13 July 2010 09:45, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> Andrew Bartley wrote:
>
>> Unfortunately these views only give me what appears to be a certain time
>> frame. This does not help all that much. It will give a list of tables,
>> indexes and sequences that have been used in the time frame, so that is at
>> least a start.
>>
>
> You can use pg_stat_reset() to set those back to 0 again and then see what
> actually gets used moving forward from the point you do that. That's a
> reasonable idea to do anyway to make all those statistics better reflect
> recent activity rather than historical. Just be warned that it will screw
> up many monitoring systems if you have them pointed toward those statistics
> tables and grabbing snapshots, some will view the reset as the values going
> negative which doesn't make any real-world sense.
>
> --
> Greg Smith 2ndQuadrant US Baltimore, MD
> PostgreSQL Training, Services and Support
> greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-07-13 01:43:20 | Re: PG_DUMP very slow because of STDOUT ?? |
Previous Message | Greg Smith | 2010-07-12 23:45:13 | Re: Redundant database objects. |