RDBMS Information - PostgreSQL - Checking statistics date on a schema

Purpose

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

RDBMS

ReleaseYes/No
CSS3✅
CSS2✅
CSS1✅

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