bug: query slow down after optimize compact

[yufan022]

Search before asking

• I had searched in the issues and found no similar issues.

Version

0.8.85

What's Wrong?

I have two identical tables, table B was created by create table B as select * from A;

• Table B never executed PURGE/COMPACT, the query speed was only a few seconds.
• After PURGE/COMPACT was executed , the table A query speed dropped from 1min to 13min

select * from xx where requesturl='/xx/xx' and requesttime=1661990400077 and responsetime = 1661990400084;

explain details:

How to Reproduce?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!