Issue
Queries from one module, e.g. Database Logging (dblog), are completely overwhelming a Drupal site. No standard (and clean) ways of uninstalling the offending module are possible, due to current traffic.
Resolution
First log into one of the live webservers using https://docs.acquia.com/cloud-platform/manage/ssh/. Examples of ssh command-lines, for the various environments are given on the "Users and keys" page. To go to one of the live webservers, the command used here should begin ssh sitename.prod@... or ssh sitename.01live@... or similar.
Then try the command in this transcript to disable the module:
mycompany@web-3840:/var/www/html/mycompany.01live/docroot$ drush eval "\$module_data = \Drupal::config('core.extension')->get('module'); unset(\$module_data['MODULE_NAME']); \Drupal::configFactory()->getEditable('core.extension')->set('module', \$module_data)->save();" --uri=https://www.MisconfiguredSite.com(For the most common case, MODULE_NAME is dblog.)
Putting the site into maintenance mode, and fully uninstalling the module will be necessary once working with the site is possible again.
Cause
The "Database Logging" module was enabled in on subsite of a large Drupal multisite, or on one site in ACSF Stack.