Port commit 149fb47 from main branch to 1.12 branch.

Original commit: Defer cleanup for log/index compactions, add debug log (#26511)
Commit hash: 149fb47