From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
---|---|
To: | Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: System catalog vacuum issues |
Date: | 2013-08-06 07:26:55 |
Message-ID: | CAL_0b1t+J6i2zk1-rf2NUqyuwDZbX5QbOf0X2pL2ZvLKLW6YUg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Vlad Arkhipov | 2013-08-06 07:37:57 | Re: System catalog vacuum issues |
Previous Message | Vlad Arkhipov | 2013-08-06 07:19:59 | Re: System catalog vacuum issues |