Re: pg_stat_all_tables column value reseting problem.

On Wed, Mar 16, 2011 at 1:28 PM, leslie samuel <leslie(dot)bks(at)gmail(dot)com> wrote:

> Dear friends,
>
> I would like to know the particular table's insert,update and delete
> record history.
> I have done some googling and got to know about pg_stat_all_tables and
> pg_stat_user_tables. These tables having this below field , which has the
> tables insert,update and delete history,
>
> n_tup_ins | bigint |
> n_tup_upd | bigint |
> n_tup_del | bigint |
>
> But some time It was getting reset.. I don't know which scenario It is
> happening.
>
> Done the blow testing:
>
> => inserting,updating and deleting some record in a particular table
> => checked this pg_stat_all_tables entry, It has displayed perfect
> count of the history.
> => restarted the server for check the these
> (n_tup_ins,n_tup_upd,n_tup_del) entries.
> but values weren't reseted, history remains.
> => Two days after I have checked this pg_stat_all_tables entry again,
> but proper records wasn't there. Value of n_tup_ins,n_tup_upd and n_tup_del
> was 0. I don't know why it has happened.
>
> Please let me know the reason and which scenario it will get reset.
> Whether I have to do any configuration related changes ?
>
> Note:
>
> I am using PostgreSQL 8.3.7.
>
>
>
In PostgreSQL, pg_stat tables shows a variety of statistical information
regarding the database.

psql=# select pg_stat_reset();

Whenever you perform above command in PSQL prompt,it will clear out the
gathered statistics and start from scratch. Could you please check it in
your end.

--Raghu Ram

>
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/pg-stat-all-tables-column-value-reseting-problem-tp3767851p3767851.html
> Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>