On 9/5/24 10:11, Aditya Singh wrote:
> The query on the first table didn't hit the wait event; it hit on the
> second table. I can show you the same on RDS Database Insights. Both
> tables have the same *Indexes*, *Data*, and *Columns*. There is only a
> difference in the ID datatype. Is there any possibility of scheduling a
> call to troubleshoot this issue since it is happening in the Production
> environment?
>
As this is a RDS database, you should probably talk to AWS support?
Other than that, share the explain plans for the two queries (as I asked
in my previous response).
BTW please don't top post. It's customary to reply inline on this list.
regards
--
Tomas Vondra