From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>, PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Database and Table stats gets reset automatically |
Date: | 2016-07-25 14:10:42 |
Message-ID: | a6731bf4-22b6-6ccc-c632-60c7be6ae801@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/24/2016 09:58 PM, Sameer Kumar wrote:
> Hi,
>
> I have PostgreSQL v9.4.4 running in my environment. It has been up for
> over 2 years now. I noticed that suddenly the statistics have been reset
> and all the stat tables/columns got restarted from.
Any of these happen?:
https://www.postgresql.org/docs/9.4/static/monitoring-stats.html
". When recovery is performed at server start (e.g. after immediate
shutdown, server crash, and point-in-time recovery), all statistics
counters are reset."
>
> This happened 2 weeks ago. I noticed only recently after I looked at the
> plot over last week (which dipped suddenly for "number of tuples
> returned", "number of conflicts" etc).
Any change in procedures the last two weeks?
>
> The columns which got reset are from pg_stat_database,
> pg_stat_user_tables, pg_stat_bgwriter
>
> As far I know no one has fired pg_stat_reset or pg_stat_reset_shared.
>
> I noticed that the last largest value is from pg_stat_user_tables.
> tup_returned (470440261405). Does the statistics get reset automatically
tup_returned is in pg_stat_database.
What does the stats_reset field show in pg_stat_database?
> when the value for one of the statistics reaches the high number
> supported by int4?
>
> I am running on Red Hat 6.7.
>
> Regards
> Sameer
> --
> --
> Best Regards
> Sameer Kumar | DB Solution Architect
> *ASHNIK PTE. LTD.*
>
> 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
>
> T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Sameer Kumar | 2016-07-25 14:28:04 | Re: Database and Table stats gets reset automatically |
Previous Message | David G. Johnston | 2016-07-25 13:11:35 | Re: Return results of join with polymorphically-defined table in pl/pgsql |