Statistics for the epoch column
Thank you for all your help.
Currently we are loading Vertica tables using the COPY command.
Vertica tables are reference only and not updated.
(Deletion by truncate may be performed)
After the load process, use
select analyze_statistics('public.table_name', 10);.
- The WLA is automatically executed at 18:00 every day.
When I checked today after my vacation, the following messages were output to Workload Analyzer.
analyze statistics on table column public.table_name.column_name
When I checked the details, I found that most of them were for the
The statistics on table column public.table_name.column_name
Is it possible that the statistics of the
epoch column are not retrieved by simply retrieving the statistics when the table is loaded?
I will try to retrieve the statistics again according to the Management Console.
If you know the cause of the output, please reply.