Hi, I am finding a whole block of these in my vertica log, appearing hourly:
2025-03-13 04:00:06.802 DistCall Dispatch:0x7f081f7fe700-a000000676f5f6 [Txn] Starting Commit: Txn: a000000676f5f6 'AnalyzeStats: (Table: shema_name.TABLE_NAME) (Mode: All Columns)' 73665929
I am at my wits' end trying to understand what triggers them. Whenever I trigger them manually, I use
select analyze_statistics(''); or select analyze_statistics('schema_name.TABLE_NAME') and then I can see those selects in the log. But in my case no 'select analyze_statistics' queries can be found in the log!
So how else do those AnalyzeStats get triggered?