Re: System catalog vacuum issues

On 08/06/2013 04:26 PM, Sergey Konoplev wrote:
> On Mon, Aug 5, 2013 at 10:56 PM, Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru> wrote:
>> dcdb=# select relname, n_live_tup, n_dead_tup, last_vacuum, last_autovacuum
>> from pg_stat_sys_tables where relname = 'pg_attribute';
>> relname | n_live_tup | n_dead_tup | last_vacuum |
>> last_autovacuum
>> --------------+------------+------------+-------------------------------+-------------------------------
>> pg_attribute | 39318086 | 395478 | 2013-08-06 14:47:48.187259+09 |
>> 2013-08-06 13:43:03.162286+09
> What pgstattuple shows on this table?
> http://www.postgresql.org/docs/9.2/interactive/pgstattuple.html
>

dcdb=# select * from pgstattuple('pg_catalog.pg_attribute');
table_len | tuple_count | tuple_len | tuple_percent |
dead_tuple_count | dead_tuple_len | dead_tuple_percent | free_space |
free_percent
------------+-------------+-----------+---------------+------------------+----------------+--------------------+------------+--------------
6363938816 | 48786 | 6830040 | 0.11 | 1459439 |
204321460 | 3.21 | 5939017376 | 93.32
(1 row)