Just to share, Disabling JIT on the PostgreSQL running the Prefect DB, significantly reduces peak load on the database (see screenshot). I ran the Prefect DB with pg_stat_statements to identify where our timeout issues came from. A query starting with

WITH RECURSIVE typeinfo_tree ...

was by far the heaviest. Several places online this was reported to be related to JIT (e.g. https://github.com/MagicStack/asyncpg/issues/530) so I attempted to disable JIT (

-c jit=false

when starting the PostgreSQL docker container) ... and then all the peak loads disappeared from our server. (Prefect 2.7.12)

That is some nice detective work!