英文:
Auto stats update ruining background?
问题
我试图理解自动统计更新过程，目前我看到自动清理和统计设置都是独立的。但我总是只看到自动清理在后台运行，而不是自动分析。
我是否漏掉了什么，因为我从未看到自动分析通过Pg_stat_activity运行。
在哪里可以查看实时分析运行状态（仅限自动，手动可以查看详细信息/Pg_stat_activity）？
我尝试使用相同的清理设置和不同的设置，但我总是只看到自动清理被触发，而不是分析。
英文:
I tried to understand the Auto stats update process, as of now I see auto Vacuum and stats settings both are independent. But I always see only auto vacuum is running background not auto Analyze.
Do I missing anything as I never see auto analyze running through Pg_stat_activity.
where to see live analyze running status(Auto only, Manually I can see verbose/Pg_stat_activity)?
I tried by same vacuum settings and both different settings, I always see only auto vacuum triggered not analyze.
答案1
得分: 1
ANALYZE通常比VACUUM快得多，所以如果你从未捕获到其中一个运行，我不会感到惊讶。查看pg_stat_user_tables以查看自动分析上次运行的时间以及运行频率。
英文:
ANALYZE is usually much faster than VACUUM, so I am not surprised if you never catch one running. Look at pg_stat_user_tables to see when last and how often autoanalyze did run on your tables.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论