You have several publications from SDL Tridion Docs 14 SP1/SP2 that are published to the Digital Experience Delivery (DXD) platform (SDL Tridion Unified Delivery Platform 11.0). The Content API (GraphQL) is used to retrieve a larger set of publications and the query constructed is slow on the database. Page load times on the site can take 10 - 15 seconds at times.
The content may also come from SDL Tridion Sites 9.0 so that queries are required to retrieve several publications for the loading of a page from the Content API.
A poor construction of the query generated from Content API.
A hotfix is available for SDL Tridion Sites 9.0/UDP 11.0 to improve the construction of the query - CD_220.127.116.1177. This is available via FTP as per: