vertica审计日志

最近时段的所有请求：

select * from dc_requests_issued order by time desc limit 10;

默认在磁盘上保留50MB：

dbadmin=> SELECT get_data_collector_policy('RequestsIssued');
get_data_collector_policy
-----------------------------------------------------------------------------
2000KB kept in memory, 50000KB kept on disk. Time based retention disabled.
(1 row)

 

默认值太小了，修改为在磁盘上保留5GB

dbadmin=> SELECT set_data_collector_policy('RequestsIssued', '2000', '5000000');
set_data_collector_policy
---------------------------
SET
(1 row)

dbadmin=> SELECT get_data_collector_policy('RequestsIssued');
get_data_collector_policy
-------------------------------------------------------------------------------
2000KB kept in memory, 5000000KB kept on disk. Time based retention disabled.
(1 row)

-------------------------

 

其它日志：

SELECT MIN(start_timestamp) FROM v_monitor.query_requests;
SELECT MIN(time) FROM v_internal.dc_requests_issued;

当前会话：

select * from sessions;

 

-----------

设置方式在这里：

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/ConfiguringDataRetentionPolicies.htm

 

如果想按保留时间来设置，而不是磁盘大小，可以参照这里：

https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/DataCollection/SET_DATA_COLLECTOR_TIME_POLICY.htm

 

节点的日志文件在这里：

/home/dbadmin/bigdata/v_bigdata_node0001_catalog