Does Catalog contain the information of index insert/update/delete tuples number ??

From: "phd9110" <phd9110(at)cs(dot)nchu(dot)edu(dot)tw>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Does Catalog contain the information of index insert/update/delete tuples number ??
Date: 2003-12-04 15:45:23
Message-ID: 001001c3ba7d$a2f85d50$6c0d788c@husky
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi :
pg_stat_user_tables store the n_tup_ins,n_tup_upd,n_tup_del information, and those information is very useful.
I check the pg_stat_user_indexes table, but there are no such information.

can i get such information in other way ?
or system catalog does not store such information !
or those information can be derived from other statistic ?

i want use these information to tuning the index
please give me some suggestion!
thank you very much!

Kao , Nchu Taiwan

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2003-12-04 15:46:11 Re: Encoding problem with 7.4
Previous Message Andrew Dunstan 2003-12-04 15:00:37 Re: Encoding problem with 7.4