relkind='p' has no pg_stat_user_tables

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: relkind='p' has no pg_stat_user_tables
Date: 2018-05-03 14:14:30
Message-ID: 20180503141430.GA28019@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I (finally) realized that my script for ANALYZEing parents of table hierarchies
every month or so was looping around the same parent tables every night due to
no stats for date of last last analysis.

I guess that's deliberate/known and maybe related to relkind='p' having no
relfilenode.

Is there any good workaround other than making stampfiles or making my own
"last analyzed" table?

Thanks,
Justin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-05-03 14:44:24 Re: relkind='p' has no pg_stat_user_tables
Previous Message Fabio Pardi 2018-05-03 09:12:05 Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb