金仓数据库age查询

数据库年龄：

SELECT datname, age(datfrozenxid) FROM sys_database order by age(datfrozenxid) desc;

表年龄：

SELECT n.nspname as "Schema", c.relname as "Name", c.relfrozenxid

FROM sys_catalog.sys_class c

LEFT JOIN sys_catalog.sys_namespace n ON n.oid = c.relnamespace

WHERE c.relkind IN ('r','')

AND n.nspname <> 'information_schema' AND n.nspname !~ '^sys_toast'

AND sys_catalog.sys_table_is_visible(c.oid)

ORDER BY c.relfrozenxid::text::bigint DESC;

表执行autovacuum时间

select schemaname,relname,last_autovacuum,last_autoanalyze from sys_stat_all_tables where relname='tablename';