请问大佬们，如何优化偶尔慢的问题！

[zyw8136]

我有一个sql在一直执行，但是总出现这样的查询慢，这个如何优化，从哪里入手，还请高手们指点一下！

[dataalive]

you could try to get metrics during that time as follows :

• CPU / IO Util
• BE log(compaction, error or sth like this)
• FE GC log