Updating to 10.5.3 causes gateway timeouts on revisioned content

Problem/Motivation

After upgrading to Drupal core 10.5.3, our site hits database saturation, leading to site-wide 504 (Gateway Timeout) errors. The trigger appears to be rendering revisioned entities that use Paragraphs; once triggered, the overload causes all pages to time out until the DB recovers. Pinning core below 10.5.3 immediately restores stability.

Note that our site that I'm noticing this behaviour have ~550000 revisions and exposes content via APIs that returns nodes.

Steps to reproduce

1. Start from a working site on 10.5.2 with Paragraphs and revisionable content types.
2. Update to 10.5.3, run database updates, clear caches.
3. Visit pages that render nodes using Paragraphs on revisioned entities.
4. Observe DB load ramp; soon all routes begin returning 504.

Workaround

• Pin core < 10.5.3 (e.g., 10.5.2) to avoid the outage.

References

• Code introduced in: https://www.drupal.org/project/drupal/issues/2950869 🐛 Entity queries querying the latest revision very slow with lots of revisions Needs work
• Commit: https://git.drupalcode.org/project/drupal/-/commit/ad6d4462ba6fc9335a59f...