I urge folks to avoid ^%GSIZE with show details = yes unless there is an urgent need for recent size info. If you're going to read the whole database, I'd suggest an Integrity Check instead. It provides the same information but also verifies integrity. 

I use the following to get the full query. 

SELECT Location, RuntimeLocation, Statement->Statement 
FROM INFORMATION_SCHEMA.STATEMENT_LOCATIONS 
WHERE Location  = ?
OR RunTimeLocation = ?

"You cannot create namespace-specific mappings to resources that are mapped in the %ALL namespace, as %ALL mappings override any namespace-specific mappings to the same resource." - Docs