Data Collector Policy not working
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;
select distinct trunc(start_timestamp) from query_requests;
Please help me fixing this issue. Thanks, Saurabh