relkind='p' has no pg_stat_user_tables - Mailing list pgsql-general

From Justin Pryzby
Subject relkind='p' has no pg_stat_user_tables
Date
Msg-id 20180503141430.GA28019@telsasoft.com
Whole thread Raw
Responses Re: relkind='p' has no pg_stat_user_tables  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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


pgsql-general by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: Wanted: postgresql-9.6-dbg_9.6.5-1.pgdg80+1_amd64.deb
Next
From: Adrian Klaver
Date:
Subject: Re: relkind='p' has no pg_stat_user_tables