Skip to main content
Question

Help me find what triggers AnalyzeStats

  • Mar 17, 2025 3:38 PM UTC
  • 1 reply
  • 8 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
  • Mar 17, 2025 4:18 PM UTC

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