perf: temporary workaround for top-level namespace usage calculation

This MR addresses #779 (closed) by replacing the existing query with a more complex (but faster) one that yields a much faster execution. The query was provided here. This is meant to be a temporary solution until we can rely on post-deployment migrations to create a suitable index for the current/previous query (which should be the optimal one).