[spike] Explore the solution for this issue and create an ADR to discuss with the team

[harshad16]

Based on the issue: https://github.com/thoth-station/thoth-application/issues/2689 check for various possible solutions, either on consumer investigator, or kafka itself , or on producers side.