Skip to main content
Question

Help me find what triggers AnalyzeStats

  • March 17, 2025
  • 1 reply
  • 3 views

dimitri_p
Forum|alt.badge.img+2

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?

1 reply

dimitri_p
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • March 17, 2025

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