FMU

DJDT

Versions

Package	Name	Version
Django		4.2.17
Python		3.10.18
debug_toolbar	Debug Toolbar	4.4.6
django_extensions	Django Extensions	3.2.1
rest_framework	Django REST framework	3.15.1
storages	Storages	1.14.4
taggit	Taggit	5.0.1
wagtail	Wagtail core	6.3.1.final.1
wagtail_modeladmin	Wagtail ModelAdmin	2.0.0
wagtailmedia	Wagtail media	0.15.2

Time

Resource usage

Resource	Value
User CPU time	143.105 msec
System CPU time	0.000 msec
Total CPU time	143.105 msec
Elapsed time	307.234 msec
Context switches	56 voluntary, 48 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

Settings from helpsite.settings.qa

Setting	Value
ABSOLUTE_URL_OVERRIDES	`{}`
ADMINS	`[]`
AGENCY_OKTA_GROUP	`'supervisioncentral-agency.user'`
ALLOWED_HOSTS	`['.frboasis.org', '.oasis.gov']`
APPEND_SLASH	`True`
AUTHENTICATION_BACKENDS	`['django.contrib.auth.backends.ModelBackend']`
AUTH_NONCE	`'WBYA'`
AUTH_PASSWORD_VALIDATORS	`'********************'`
AUTH_STATE	`'X1lxX20ySFpJVzZJcF85ZUdyX29YcVp5fnREQ2xwUUN4ZElpUEhYTW9UanA2'`
AUTH_USER_MODEL	`'auth.User'`
AWS_BUCKET_ACL	`None`
AWS_DEFAULT_ACL	`None`
AWS_S3_CUSTOM_DOMAIN	`'qa.help.oasis.gov'`
AWS_S3_FILE_OVERWRITE	`False`
AWS_STORAGE_BUCKET_NAME	`'kcsr-media-non-prod'`
BANKER_OKTA_GROUP	`'supervisioncentral-banker.user'`
BASE_DIR	`'/help-site'`
CACHES	`{'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache'}}`
CACHE_MIDDLEWARE_ALIAS	`'default'`
CACHE_MIDDLEWARE_KEY_PREFIX	`'********************'`
CACHE_MIDDLEWARE_SECONDS	`600`
CORS_ALLOWED_ORIGINS	`['https://www.qa.frboasis.org', 'https://qa.help.oasis.gov']`
CSRF_COOKIE_AGE	`31449600`
CSRF_COOKIE_DOMAIN	`None`
CSRF_COOKIE_HTTPONLY	`False`
CSRF_COOKIE_MASKED	`False`
CSRF_COOKIE_NAME	`'csrftoken'`
CSRF_COOKIE_PATH	`'/'`
CSRF_COOKIE_SAMESITE	`'Lax'`
CSRF_COOKIE_SECURE	`True`
CSRF_FAILURE_VIEW	`'django.views.csrf.csrf_failure'`
CSRF_HEADER_NAME	`'HTTP_X_CSRFTOKEN'`
CSRF_TRUSTED_ORIGINS	`[]`
CSRF_USE_SESSIONS	`False`
DATABASES	`{'default': {'ATOMIC_REQUESTS': False, 'AUTOCOMMIT': True, 'CONN_HEALTH_CHECKS': False, 'CONN_MAX_AGE': 0, 'ENGINE': 'django.db.backends.postgresql', 'HOST': 'rds-oasis-help-qa.cluster-cjpyezguwzci.us-east-2.rds.amazonaws.com', 'NAME': 'oasis', 'OPTIONS': {}, 'PASSWORD': '********************', 'PORT': '5432', 'TEST': {'CHARSET': None, 'COLLATION': None, 'MIGRATE': True, 'MIRROR': None, 'NAME': None}, 'TIME_ZONE': None, 'USER': 'oasisusr'}}`
DATABASE_ROUTERS	`[]`
DATA_UPLOAD_MAX_MEMORY_SIZE	`2621440`
DATA_UPLOAD_MAX_NUMBER_FIELDS	`1000`
DATA_UPLOAD_MAX_NUMBER_FILES	`100`
DATETIME_FORMAT	`'l, N j, Y g:i a e'`
DATETIME_INPUT_FORMATS	`['%m/%d/%Y %I:%M %p']`
DATE_FORMAT	`'l, N j, Y'`
DATE_INPUT_FORMATS	`['%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y']`
DEBUG	`True`
DEBUG_PROPAGATE_EXCEPTIONS	`False`
DEBUG_TOOLBAR_CONFIG	`{'SHOW_TOOLBAR_CALLBACK': <function show_toolbar at 0x7f2cc0079480>}`
DECIMAL_SEPARATOR	`'.'`
DEFAULT_AUTO_FIELD	`'django.db.models.AutoField'`
DEFAULT_CHARSET	`'utf-8'`
DEFAULT_EXCEPTION_REPORTER	`'django.views.debug.ExceptionReporter'`
DEFAULT_EXCEPTION_REPORTER_FILTER	`'django.views.debug.SafeExceptionReporterFilter'`
DEFAULT_FILE_STORAGE	`'storages.backends.s3boto3.S3Boto3Storage'`
DEFAULT_FROM_EMAIL	`'webmaster@localhost'`
DEFAULT_INDEX_TABLESPACE	`''`
DEFAULT_TABLESPACE	`''`
DISALLOWED_USER_AGENTS	`[]`
EMAIL_BACKEND	`'django.core.mail.backends.console.EmailBackend'`
EMAIL_HOST	`'localhost'`
EMAIL_HOST_PASSWORD	`'********************'`
EMAIL_HOST_USER	`''`
EMAIL_PORT	`25`
EMAIL_SSL_CERTFILE	`None`
EMAIL_SSL_KEYFILE	`'********************'`
EMAIL_SUBJECT_PREFIX	`'[Django] '`
EMAIL_TIMEOUT	`None`
EMAIL_USE_LOCALTIME	`False`
EMAIL_USE_SSL	`False`
EMAIL_USE_TLS	`False`
FILE_UPLOAD_DIRECTORY_PERMISSIONS	`None`
FILE_UPLOAD_HANDLERS	`['django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler']`
FILE_UPLOAD_MAX_MEMORY_SIZE	`2621440`
FILE_UPLOAD_PERMISSIONS	`420`
FILE_UPLOAD_TEMP_DIR	`None`
FIRST_DAY_OF_WEEK	`0`
FIXTURE_DIRS	`[]`
FORCE_SCRIPT_NAME	`None`
FORMAT_MODULE_PATH	`None`
FORM_RENDERER	`'django.forms.renderers.DjangoTemplates'`
FRB_INTERNAL_GROUP	`'^OASiS Internal (Test)'`
FRB_INTERNAL_OKTA_GROUPS	`['^OASiS Internal (Test)', 'supervisioncentral-system.admin', 'supervisioncentral-system.publisher']`
FRB_PUBLISHER_GROUP	`'supervisioncentral-system.publisher'`
FRB_SYSTEM_ADMIN_GROUP	`'supervisioncentral-system.admin'`
HOME_ROUTE	`'/'`
IGNORABLE_404_URLS	`[]`
INSTALLED_APPS	['category', 'home', 'search', 'shared', 'status', 'support_article', 'system_notification', 'topic', 'rest_framework', 'corsheaders', 'wagtail.contrib.forms', 'django.contrib.postgres', 'wagtail.contrib.redirects', 'wagtail.contrib.routable_page', 'wagtail.contrib.search_promotions', 'wagtail.contrib.table_block', 'wagtail.embeds', 'wagtail.sites', 'wagtail.users', 'wagtail.snippets', 'wagtail.documents', 'wagtail.images', 'wagtail.search', 'wagtail.admin', 'wagtail', 'wagtailmedia', 'modelcluster', 'taggit', 'wagtail_modeladmin', 'django.contrib.admin', 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.messages', 'django.contrib.staticfiles', 'django_extensions', 'storages', 'whitenoise.runserver_nostatic', 'frb_saml2_auth_ext', 'frb_saml2_auth_int', 'debug_toolbar']
INTERNAL_IPS	`['199.169.204.180']`
LANGUAGES	`[('en', 'English')]`
LANGUAGES_BIDI	`['he', 'ar', 'ar-dz', 'ckb', 'fa', 'ur']`
LANGUAGE_CODE	`'en-us'`
LANGUAGE_COOKIE_AGE	`None`
LANGUAGE_COOKIE_DOMAIN	`None`
LANGUAGE_COOKIE_HTTPONLY	`False`
LANGUAGE_COOKIE_NAME	`'django_language'`
LANGUAGE_COOKIE_PATH	`'/'`
LANGUAGE_COOKIE_SAMESITE	`None`
LANGUAGE_COOKIE_SECURE	`False`
LOCALE_PATHS	`[]`
LOGGING	`{}`
LOGGING_CONFIG	`'logging.config.dictConfig'`
LOGIN_REDIRECT_URL	`'/accounts/profile/'`
LOGIN_URL	`'/accounts/login/'`
LOGOUT_REDIRECT_URL	`None`
MANAGERS	`[]`
MEDIA_ROOT	`'/help-site/media'`
MEDIA_URL	`'/media/'`
MESSAGE_STORAGE	`'django.contrib.messages.storage.fallback.FallbackStorage'`
META_DATA_PATH	`'/help-site/helpsite/metadata/metadata_okta_internal_test_appian.xml'`
META_DATA_PATH_EXTERNAL	`'/help-site/helpsite/metadata/metadata_okta_external_test.xml'`
MIDDLEWARE	['helpsite.middleware.SecurityMiddleware', 'helpsite.middleware.HealthCheckMiddleware', 'corsheaders.middleware.CorsMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'django.middleware.clickjacking.XFrameOptionsMiddleware', 'django.middleware.security.SecurityMiddleware', 'wagtail.contrib.redirects.middleware.RedirectMiddleware', 'whitenoise.middleware.WhiteNoiseMiddleware', 'debug_toolbar.middleware.DebugToolbarMiddleware']
MIGRATION_MODULES	`{}`
MONTH_DAY_FORMAT	`'F j'`
NUMBER_GROUPING	`0`
OKTA_AUTH	{'CACHE_ALIAS': 'default', 'CACHE_PREFIX': 'okta', 'CLIENT_ID': '0oa5sdj56hrOOH89X4h7', 'CLIENT_SECRET': '********************', 'ISSUER': 'https://frbanks-ext.okta.com/oauth2/aus5sdtrle5jyzUO04h7', 'LOGIN_REDIRECT_URL': 'https://www.qa.frboasis.org/', 'ORG_URL': 'https://frbanks-ext.okta.com', 'PUBLIC_NAMED_URLS': (), 'PUBLIC_URLS': '^status/$', 'REDIRECT_URI': 'https://www.qa.frboasis.org/oauth2/callback', 'SCOPES': 'openid profile email', 'SUPERUSER_GROUPS': ['supervisioncentral-system.admin', 'supervisioncentral-system.publisher']}
OKTA_LOGIN_REDIRECT	`'https://frbanks-ext.okta.com/oauth2/aus5sdtrle5jyzUO04h7/v1/authorize?response_type=code&scope=openid&client_id=0oa5sdj56hrOOH89X4h7&state=X1lxX20ySFpJVzZJcF85ZUdyX29YcVp5fnREQ2xwUUN4ZElpUEhYTW9UanA2&redirect_uri=https%3A%2F%2Fwww.qa.frboasis.org%2Foauth2%2Fcallback&nonce=WBYA'`
OKTA_REDIRECT_URL	`'https%3A%2F%2Fwww.qa.frboasis.org%2Foauth2%2Fcallback'`
PASSWORD_HASHERS	`'********************'`
PASSWORD_RESET_TIMEOUT	`'********************'`
PREPEND_WWW	`False`
PROJECT_DIR	`'/help-site/helpsite'`
PUBLIC_URLS	`'^status/$'`
PUBLISHER_ROLE	`'OASiS Internal (Test)-Help Site Administrator'`
REST_FRAMEWORK	`{'DEFAULT_PERMISSION_CLASSES': ['rest_framework.permissions.IsAuthenticated'], 'DEFAULT_RENDERER_CLASSES': ['rest_framework.renderers.JSONRenderer'], 'EXCEPTION_HANDLER': 'system_notification.exception_handler.custom_exception_handler'}`
ROOT_URLCONF	`'helpsite.urls'`
SAML2_AUTH	{'ATTRIBUTES_MAP': {'email': 'email', 'first_name': 'firstName', 'groups': 'member-of', 'last_name': 'lastName', 'username': 'email'}, 'AUTHN_REQUESTS_SIGNED': False, 'DEBUG': True, 'DEFAULT_NEXT_URL': '/', 'ENTITY_ID': 'https://oasis-test.sr.federalreserve.org', 'METADATA_LOCAL_FILE_PATH': '/help-site/helpsite/metadata/metadata_okta_internal_test_appian.xml', 'NEW_USER_PROFILE': {'ACTIVE_STATUS': True, 'STAFF_STATUS': True, 'SUPERUSER_STATUS': True, 'USER_GROUPS': []}, 'TOKEN_REQUIRED': '********************', 'WANT_ASSERTIONS_SIGNED': True, 'WANT_RESPONSE_SIGNED': True}
SAML2_AUTH_EXTERNAL	{'ATTRIBUTES_MAP': {'email': 'email', 'first_name': 'firstName', 'last_name': 'lastName', 'username': 'email'}, 'AUTHN_REQUESTS_SIGNED': False, 'DEBUG': True, 'DEFAULT_NEXT_URL': '/', 'ENTITY_ID': 'https://oasis-test.sr.federalreserve.org', 'METADATA_LOCAL_FILE_PATH': '/help-site/helpsite/metadata/metadata_okta_external_test.xml', 'NEW_USER_PROFILE': {'ACTIVE_STATUS': True, 'STAFF_STATUS': False, 'SUPERUSER_STATUS': False, 'USER_GROUPS': []}, 'TOKEN_REQUIRED': '********************', 'WANT_ASSERTIONS_SIGNED': True, 'WANT_RESPONSE_SIGNED': True}
SECRET_KEY	`'********************'`
SECRET_KEY_FALLBACKS	`'********************'`
SECURE_CONTENT_TYPE_NOSNIFF	`True`
SECURE_CROSS_ORIGIN_OPENER_POLICY	`'same-origin'`
SECURE_HSTS_INCLUDE_SUBDOMAINS	`True`
SECURE_HSTS_PRELOAD	`False`
SECURE_HSTS_SECONDS	`31536000`
SECURE_PROXY_SSL_HEADER	`None`
SECURE_REDIRECT_EXEMPT	`[]`
SECURE_REFERRER_POLICY	`'same-origin'`
SECURE_SSL_HOST	`None`
SECURE_SSL_REDIRECT	`True`
SERVER_EMAIL	`'root@localhost'`
SESSION_CACHE_ALIAS	`'default'`
SESSION_COOKIE_AGE	`1209600`
SESSION_COOKIE_DOMAIN	`None`
SESSION_COOKIE_HTTPONLY	`True`
SESSION_COOKIE_NAME	`'sessionid'`
SESSION_COOKIE_PATH	`'/'`
SESSION_COOKIE_SAMESITE	`'Lax'`
SESSION_COOKIE_SECURE	`True`
SESSION_ENGINE	`'django.contrib.sessions.backends.db'`
SESSION_EXPIRE_AT_BROWSER_CLOSE	`False`
SESSION_FILE_PATH	`None`
SESSION_SAVE_EVERY_REQUEST	`False`
SESSION_SERIALIZER	`'django.contrib.sessions.serializers.JSONSerializer'`
SETTINGS_MODULE	`'helpsite.settings.qa'`
SHORT_DATETIME_FORMAT	`'m/d/Y P'`
SHORT_DATE_FORMAT	`'m/d/Y'`
SIGNING_BACKEND	`'django.core.signing.TimestampSigner'`
SILENCED_SYSTEM_CHECKS	`[]`
STATICFILES_DIRS	`['/help-site/helpsite/static']`
STATICFILES_FINDERS	`['django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder']`
STATICFILES_STORAGE	`'whitenoise.storage.CompressedStaticFilesStorage'`
STATIC_ROOT	`'/help-site/static'`
STATIC_URL	`'/static/'`
STORAGES	`{'default': {'BACKEND': 'storages.backends.s3boto3.S3Boto3Storage'}, 'staticfiles': {'BACKEND': 'whitenoise.storage.CompressedStaticFilesStorage'}}`
TEMPLATES	`[{'APP_DIRS': True, 'BACKEND': 'django.template.backends.django.DjangoTemplates', 'DIRS': ['/help-site/helpsite/templates'], 'OPTIONS': {'context_processors': ['django.template.context_processors.debug', 'django.template.context_processors.request', 'django.contrib.auth.context_processors.auth', 'django.contrib.messages.context_processors.messages', 'support_article.context_processor.support_article_index_page']}}]`
TEST_NON_SERIALIZED_APPS	`[]`
TEST_RUNNER	`'django.test.runner.DiscoverRunner'`
THOUSAND_SEPARATOR	`','`
TIME_FORMAT	`'P'`
TIME_INPUT_FORMATS	`['%I:%M %p']`
TIME_ZONE	`'America/Chicago'`
USE_DEPRECATED_PYTZ	`False`
USE_I18N	`True`
USE_L10N	`False`
USE_THOUSAND_SEPARATOR	`False`
USE_TZ	`True`
USE_X_FORWARDED_HOST	`False`
USE_X_FORWARDED_PORT	`False`
WAGTAILADMIN_BASE_URL	`'https://www.qa.frboasis.org/'`
WAGTAILADMIN_PERMITTED_LANGUAGES	`[('en', 'English')]`
WAGTAILADMIN_RICH_TEXT_EDITORS	`{'custom': {'OPTIONS': {'features': ['bold', 'italic', 'link', 'document-link']}, 'WIDGET': 'wagtail.admin.rich_text.DraftailRichTextArea'}, 'default': {'OPTIONS': {'features': ['bold', 'italic', 'ol', 'ul', 'link']}, 'WIDGET': 'wagtail.admin.rich_text.DraftailRichTextArea'}}`
WAGTAILEMBEDS_FINDERS	[{'class': 'helpsite.settings.oembed_finder.oembed_models.CustomOembedFinder', 'options': {'scheme': 'http'}, 'providers': [{'endpoint': 'https://www.youtube.com/oembed', 'urls': ['^https?://(?:[-\\w]+\\.)?youtube\\.com/watch.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/v/.+$', '^https?://youtu\\.be/.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/user/.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/[^#?/]+#[^#?/]+/.+$', '^https?://m\\.youtube\\.com/index.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/profile.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/view_play_list.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/playlist.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/shorts/.+$', '^https?://(?:[-\\w]+\\.)?youtube\\.com/live/.+$']}, {'endpoint': 'https://www.vimeo.com/api/oembed.{format}', 'urls': ['^https?://(?:www\\.)?vimeo\\.com/.+$', '^https?://player\\.vimeo\\.com/.+$']}]}]
WAGTAILMEDIA_MEDIA_MODEL	`'shared.SupportArticleMedia'`
WAGTAILSEARCH_BACKENDS	`{'default': {'AUTO_UPDATE': True, 'BACKEND': 'wagtail.search.backends.database', 'SEARCH_CONFIG': 'english'}}`
WAGTAIL_AUTO_UPDATE_PREVIEW	`False`
WAGTAIL_DATETIME_FORMAT	`'%m/%d/%Y %I:%M %p'`
WAGTAIL_DATE_FORMAT	`'%m/%d/%Y'`
WAGTAIL_SITE_NAME	`'OASIS Help'`
WAGTAIL_TIME_FORMAT	`'%I:%M %p'`
WAGTAIL_USER_TIME_ZONES	`['US/Alaska', 'US/Hawaii', 'US/Arizona', 'US/Pacific', 'US/Mountain', 'US/Central', 'US/Eastern']`
WSGI_APPLICATION	`'helpsite.wsgi.application'`
X_FRAME_OPTIONS	`'DENY'`
YEAR_MONTH_FORMAT	`'F Y'`

Headers

Request headers

Key	Value
Accept	/
Accept-Encoding	gzip
Akamai-Origin-Hop	2
Cache-Control	no-cache, max-age=0
Cdn-Loop	akamai;v=1.0;c=1
Host	qa.help.oasis.gov
Pragma	no-cache
Referer	https://qa.help.oasis.gov/category2/fmu
True-Client-Ip	216.73.216.97
User-Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Via	1.1 v1-akamaitech.net(ghost) (AkamaiGHost), 1.1 akamai.net(ghost) (AkamaiGHost)
X-Akamai-Config-Log-Detail	true
X-Amzn-Trace-Id	Root=1-69339500-7fad72e22f4638647d0cc86c
X-Forwarded-For	216.73.216.97, 23.62.38.233, 23.220.106.14, 10.121.139.105
X-Forwarded-Port	443
X-Forwarded-Proto	https
X-Real-Ip	23.62.38.233

Response headers

Key	Value
Content-Type	text/html; charset=utf-8

WSGI environ

Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.

Key	Value
PATH_INFO	/category2/fmu/
QUERY_STRING
REMOTE_ADDR	10.145.115.43
REQUEST_METHOD	GET
SCRIPT_NAME
SERVER_NAME	0.0.0.0
SERVER_PORT	443
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	gunicorn/23.0.0

Request

View information

View function	Arguments	Keyword arguments	URL name
`wagtail.views.serve`	`('category2/fmu/',)`	`{}`	`wagtail_serve`

No cookies

No session data

No GET data

No POST data

SQL queries from 1 connection

default 62.03 ms (35 queries including 27 similar and 25 duplicates )

Query Timeline Time (ms) Action

SELECT "wagtailcore_site"."id",
       "wagtailcore_site"."hostname",
       "wagtailcore_site"."port",
       "wagtailcore_site"."site_name",
       "wagtailcore_site"."root_page_id",
       "wagtailcore_site"."is_default_site",
       CASE WHEN ("wagtailcore_site"."hostname" = 'qa.help.oasis.gov' AND "wagtailcore_site"."port" = 443)      THEN 0
            WHEN ("wagtailcore_site"."hostname" = 'qa.help.oasis.gov' AND "wagtailcore_site"."is_default_site") THEN 1
            WHEN "wagtailcore_site"."is_default_site"                                                           THEN 2
            ELSE 3
             END AS "match",
       "wagtailcore_page"."id",
       "wagtailcore_page"."path",
       "wagtailcore_page"."depth",
       "wagtailcore_page"."numchild",
       "wagtailcore_page"."translation_key",
       "wagtailcore_page"."locale_id",
       "wagtailcore_page"."latest_revision_id",
       "wagtailcore_page"."live",
       "wagtailcore_page"."has_unpublished_changes",
       "wagtailcore_page"."first_published_at",
       "wagtailcore_page"."last_published_at",
       "wagtailcore_page"."live_revision_id",
       "wagtailcore_page"."go_live_at",
       "wagtailcore_page"."expire_at",
       "wagtailcore_page"."expired",
       "wagtailcore_page"."locked",
       "wagtailcore_page"."locked_at",
       "wagtailcore_page"."locked_by_id",
       "wagtailcore_page"."title",
       "wagtailcore_page"."draft_title",
       "wagtailcore_page"."slug",
       "wagtailcore_page"."content_type_id",
       "wagtailcore_page"."url_path",
       "wagtailcore_page"."owner_id",
       "wagtailcore_page"."seo_title",
       "wagtailcore_page"."show_in_menus",
       "wagtailcore_page"."search_description",
       "wagtailcore_page"."latest_revision_created_at",
       "wagtailcore_page"."alias_of_id"
  FROM "wagtailcore_site"
INNER JOIN "wagtailcore_page"
    ON ("wagtailcore_site"."root_page_id" = "wagtailcore_page"."id")
WHERE ("wagtailcore_site"."hostname" = 'qa.help.oasis.gov' OR "wagtailcore_site"."is_default_site")
ORDER BY 7 ASCSELECT ••• FROM "wagtailcore_site" INNER JOIN "wagtailcore_page" ON ("wagtailcore_site"."root_page_id" = "wagtailcore_page"."id") WHERE ("wagtailcore_site"."hostname" = 'qa.help.oasis.gov' OR "wagtailcore_site"."is_default_site") ORDER BY 7 ASC

3.86

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(13)
  route_result = Page.route_for_request(request, path)

/usr/local/lib/python3.10/site-packages/wagtail/models/__init__.py in route_for_request(1394)
  if site := Site.find_for_request(request):

/usr/local/lib/python3.10/site-packages/wagtail/models/sites.py in find_for_request(157)
  site = Site._find_for_request(request)

/usr/local/lib/python3.10/site-packages/wagtail/models/sites.py in _find_for_request(167)
  site = get_site_for_hostname(hostname, port)

/usr/local/lib/python3.10/site-packages/wagtail/models/sites.py in get_site_for_hostname(23)
  sites = list(

SELECT "wagtailcore_page"."id",
       "wagtailcore_page"."path",
       "wagtailcore_page"."depth",
       "wagtailcore_page"."numchild",
       "wagtailcore_page"."translation_key",
       "wagtailcore_page"."locale_id",
       "wagtailcore_page"."latest_revision_id",
       "wagtailcore_page"."live",
       "wagtailcore_page"."has_unpublished_changes",
       "wagtailcore_page"."first_published_at",
       "wagtailcore_page"."last_published_at",
       "wagtailcore_page"."live_revision_id",
       "wagtailcore_page"."go_live_at",
       "wagtailcore_page"."expire_at",
       "wagtailcore_page"."expired",
       "wagtailcore_page"."locked",
       "wagtailcore_page"."locked_at",
       "wagtailcore_page"."locked_by_id",
       "wagtailcore_page"."title",
       "wagtailcore_page"."draft_title",
       "wagtailcore_page"."slug",
       "wagtailcore_page"."content_type_id",
       "wagtailcore_page"."url_path",
       "wagtailcore_page"."owner_id",
       "wagtailcore_page"."seo_title",
       "wagtailcore_page"."show_in_menus",
       "wagtailcore_page"."search_description",
       "wagtailcore_page"."latest_revision_created_at",
       "wagtailcore_page"."alias_of_id",
       "home_homepage"."page_ptr_id"
  FROM "home_homepage"
INNER JOIN "wagtailcore_page"
    ON ("home_homepage"."page_ptr_id" = "wagtailcore_page"."id")
WHERE "home_homepage"."page_ptr_id" = 3
LIMIT 21SELECT ••• FROM "home_homepage" INNER JOIN "wagtailcore_page" ON ("home_homepage"."page_ptr_id" = "wagtailcore_page"."id") WHERE "home_homepage"."page_ptr_id" = 3 LIMIT 21

0.86

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(13)
  route_result = Page.route_for_request(request, path)

/usr/local/lib/python3.10/site-packages/wagtail/models/__init__.py in route_for_request(1399)
  site.root_page.localized.specific.route(

/usr/local/lib/python3.10/site-packages/wagtail/models/specific.py in specific(93)
  return self.get_specific()

/usr/local/lib/python3.10/site-packages/wagtail/models/specific.py in get_specific(73)
  specific_obj = model_class._default_manager.get(id=self.id)

SELECT "wagtailcore_page"."id",
"wagtailcore_page"."alias_of_id"
FROM "wagtailcore_page"
WHERE ("wagtailcore_page"."path" IN ('0001', '00010001') AND NOT ("wagtailcore_page"."id" = 3))
ORDER BY "wagtailcore_page"."path" ASCSELECT ••• FROM "wagtailcore_page" WHERE ("wagtailcore_page"."path" IN ('0001', '00010001') AND NOT ("wagtailcore_page"."id" = 3)) ORDER BY "wagtailcore_page"."path" ASC

0.92

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(20)
  result = fn(page, request, args, kwargs)

/usr/local/lib/python3.10/site-packages/wagtail/wagtail_hooks.py in check_view_restrictions(34)
  for restriction in page.get_view_restrictions():

/usr/local/lib/python3.10/site-packages/wagtail/models/__init__.py in get_view_restrictions(2687)
  for page in self.get_ancestors().only("alias_of"):

SELECT "wagtailcore_pageviewrestriction"."id",
       "wagtailcore_pageviewrestriction"."restriction_type",
       "wagtailcore_pageviewrestriction"."password",
       "wagtailcore_pageviewrestriction"."page_id"
  FROM "wagtailcore_pageviewrestriction"
WHERE "wagtailcore_pageviewrestriction"."page_id" IN (1, 3)SELECT ••• FROM "wagtailcore_pageviewrestriction" WHERE "wagtailcore_pageviewrestriction"."page_id" IN (1, 3)

0.62

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(20)
  result = fn(page, request, args, kwargs)

/usr/local/lib/python3.10/site-packages/wagtail/wagtail_hooks.py in check_view_restrictions(34)
  for restriction in page.get_view_restrictions():

SELECT "category_category"."id",
       "category_category"."path",
       "category_category"."depth",
       "category_category"."numchild",
       "category_category"."name",
       "category_category"."slug",
       "category_category"."is_selectable"
  FROM "category_category"
WHERE NOT ("category_category"."id" = 1)
ORDER BY "category_category"."path" ASCSELECT ••• FROM "category_category" WHERE NOT ("category_category"."id" = 1) ORDER BY "category_category"."path" ASC

0.91

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(24)
  return page.serve(request, *args, **kwargs)

/usr/local/lib/python3.10/site-packages/wagtail/contrib/routable_page/models.py in serve(173)
  return view(request, *args, **kwargs)

/help-site/home/models.py in category_category_landing_page(120)
  for category in categories:

SELECT "category_category"."id",
       "category_category"."path",
       "category_category"."depth",
       "category_category"."numchild",
       "category_category"."name",
       "category_category"."slug",
       "category_category"."is_selectable"
  FROM "category_category"
WHERE "category_category"."path" = '0001'
LIMIT 21SELECT ••• FROM "category_category" WHERE "category_category"."path" = '0001' LIMIT 21

25 similar queries. Duplicated 9 times.

0.43

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(24)
  return page.serve(request, *args, **kwargs)

/usr/local/lib/python3.10/site-packages/wagtail/contrib/routable_page/models.py in serve(173)
  return view(request, *args, **kwargs)

/help-site/home/models.py in category_category_landing_page(121)
  if category.get_parent().slug == tag_slug:

/usr/local/lib/python3.10/site-packages/treebeard/mp_tree.py in get_parent(1144)
  self._cached_parent_obj = get_result_class(

SELECT "category_category"."id",
       "category_category"."path",
       "category_category"."depth",
       "category_category"."numchild",
       "category_category"."name",
       "category_category"."slug",
       "category_category"."is_selectable"
  FROM "category_category"
WHERE "category_category"."path" = '0001'
LIMIT 21SELECT ••• FROM "category_category" WHERE "category_category"."path" = '0001' LIMIT 21

25 similar queries. Duplicated 9 times.

0.42

Connection: default

Transaction status: Idle

/usr/local/bin/gunicorn in <module>(8)
  sys.exit(run())

/usr/local/lib/python3.10/site-packages/gunicorn/app/wsgiapp.py in run(66)
  WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]", prog=prog).run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(235)
  super().run()

/usr/local/lib/python3.10/site-packages/gunicorn/app/base.py in run(71)
  Arbiter(self).run()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in run(201)
  self.manage_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in manage_workers(570)
  self.spawn_workers()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_workers(641)
  self.spawn_worker()

/usr/local/lib/python3.10/site-packages/gunicorn/arbiter.py in spawn_worker(608)
  worker.init_process()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/base.py in init_process(143)
  self.run()

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run(125)
  self.run_for_one(timeout)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in run_for_one(69)
  self.accept(listener)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in accept(31)
  self.handle(listener, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle(134)
  self.handle_request(listener, req, client, addr)

/usr/local/lib/python3.10/site-packages/gunicorn/workers/sync.py in handle_request(177)
  respiter = self.wsgi(environ, resp.start_response)

/help-site/helpsite/middleware.py in __call__(17)
  response = self.get_response(request)

/help-site/helpsite/middleware.py in __call__(32)
  return self.get_response(request)

/usr/local/lib/python3.10/site-packages/whitenoise/middleware.py in __call__(60)
  response = self.get_response(request)

/usr/local/lib/python3.10/site-packages/wagtail/views.py in serve(24)
  return page.serve(request, *args, **kwargs)

/usr/local/lib/python3.10/site-packages/wagtail/contrib/routable_page/models.py in serve(173)
  return view(request, *args, **kwargs)

/help-site/home/models.py in category_category_landing_page(121)
  if category.get_parent().slug == tag_slug:

/usr/local/lib/python3.10/site-packages/treebeard/mp_tree.py in get_parent(1144)
  self._cached_parent_obj = get_result_class(

SELECT "category_category"."id",
       "category_category"."path",
       "category_category"."depth",
       "category_category"."numchild",
       "category_category"."name",
       "category_category"."slug",
       "category_category"."is_selectable"
  FROM "category_category"
WHERE "category_category"."path" = '00010002'
LIMIT 21SELECT ••• FROM "category_category" WHERE "category_category"."path" = '00010002' LIMIT 21