Purpose

This page will help you to check the statisticsĀ date on a schema.

RDBMS
Release
Yes/No
CSS3(tick)
CSS2(tick)
CSS1(tick)


Details
  1. Open pgAdmin3 located in the CastStorageServices\bin installed directory.
  2. Connect to the server and deploy the node database postgres.
  3. 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