When you add self=true, your query traverses through the entire content repository and I think that is causing the issue.

Having self=true is inefficient. Query as such, traverses through all the nodes by executing //element(*, cq:Page) then apply filter with {path=path: path=/content/page_path, self=true}. Depending on your requirements, you can try querying cq:PageContent instead of cq:Page which will always be a chi...

Can you share the query you're trying to run?

You can leverage Dispatcher SSI and mod_unique_id Module to generate nonce every request and SSI to put the nonce in the attribute. For more details, check: https://abdulmunim.com/2024/04/securing-aem-scripts-with-csp-nonces-on-dispatcher-cache/