cratedb日常管理

版本：4.2.1

1.查看操作日志

select
date_format('%Y%m%d %H',started),name,count(1)
from sys.operations_log
group by
date_format('%Y%m%d %H',started),name limit 100;

 

2.查看job日志

select
date_format('%Y%m%d %H',started),username,count(1)
from sys.jobs_log
group by date_format('%Y%m%d %H',started),username limit 100;

 

3.查看系统表

select * from information_schema.tables limit 100;