The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Data Collector Policy not working

Hi,
I have set up data collector policy 5 days ago using below command.
SELECT set_data_collector_time_policy('v_monitor.query_requests', '5 days'::interval);
It's also reflecting correctly in the database using below command.
select GET_DATA_COLLECTOR_POLICY ('RequestsIssued');
2000KB kept in memory, 5000000KB kept on disk. 5 days kept on disk.
However, I am still not able to see all historical queries of last 5 days. It just showing me last two days queries only.
select distinct substr(query_start, 1, 10 ) from query_profiles;
--2019-11-08
select distinct trunc(start_timestamp) from query_requests;
--2019-11-08 00:00:00
Please help me fixing this issue. Thanks, Saurabh

Best Answer

Answers

  • chaimachaima Employee

    Hi,
    You should change the size retention policy of all the data_collector tables used in those views . If the disk size is not enough, the time constraint won't be enforced,
    For example, for query_requests: RequestsIssued,RequestsIssued, RequestsIssued, ResourceAcquisitions.
    Can you check also how many days you have in dc_requests_issued?
    SELECT
    node_name,
    MIN(TIME),
    MAX(TIME)
    FROM
    dc_requests_issued
    GROUP BY
    node_name;

    Ps: increasing the retention time /size will affect performance on those system tables

    Chaima

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.