Message-ID: <509BBCB0.7050502@gmail.com>
Date: Thu, 08 Nov 2012 22:07:44 +0800
From: Rural Hunter <ruralhunter@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1;
	rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: analyze log question on parent/children tables
Content-Type: text/plain; charset=GB18030; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I'm on 9.1.3. I set auto vacuum off for some tables. I noticed one 
thing: when I run manual analyze on parent table, It seems the children 
tables are also analyzed. Here is the analyze log:

INFO:  analyzing "public.table_parent"
INFO:  "table_parent": scanned 0 of 0 pages, containing 0 live rows and 
0 dead rows; 0 rows in sample, 0 estimated total rows
INFO:  analyzing "public.table_parent" inheritance tree
INFO:  "table_child1": scanned 11405 of 692945 pages, containing 105632 
live rows and 103 dead rows; 11405 rows in sample, 10739605 estimated 
total rows
INFO:  "table_child2": scanned 1858 of 112866 pages, containing 35818 
live rows and 0 dead rows; 1858 rows in sample, 2178974 estimated total rows
....

But when I check the table status in pgAdmin, I noticed the (auto) 
analyze time of children tables was not logged. So my question here is: 
should I run a separate analyze on children tables?