RDBMS
Release | Yes/No |
---|---|
CSS3 | |
CSS2 | |
CSS1 |
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: