Help me find what triggers AnalyzeStats

dimitri_p

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?

dimitri_p

Looks like the query itself is only recorded in the vertica.log of the node, that it was issued on and the rest of the nodes just get the output