Purpose
This page will help you to check the statisticsĀ date on a schema.
RDBMS
Release | Yes/No |
---|---|
CSS3 | |
CSS2 | |
CSS1 |
Details
- 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 to List statistics date tables on a selected schema
select relname as table, last_analyze, last_autoanalyze from pg_stat_user_tables where lower(schemaname) = lower('<selected_schema>') and n_live_tup > 0 order by relname
here is a sample for a schema
Notes / Comments
Related Pages