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@dc.baikal.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)