RDBMS Information - PostgreSQL - Identify schemas with missing statistics

RDBMS

This page gives the schemas’ name where the statistics have never been ran on at least one table

Open pgAdmin3 located in the CastStorageServices\bin installed directory.

Connect to the server and deploy the node database postgres.
Select Sql query item in the tools menu and execute the query below.

List schemas with missing statistics on at least one no empty table

select distinct schemaname
from pg_stat_user_tables
where last_analyze is null
  and last_autoanalyze is null
  and n_live_tup > 0
order by schemaname

sample: