Member Log In

If your organization is an EBRI member (please check here) and you do not have your credentials, fill in the information in "I'm New Here" to get your user name and login. Still unable to login? Contact EBRI Member Relations.

I'm New Here

Not a Member? Join today, your support is appreciated! EBRI is a nonprofit funded by individual and organization membership. Contact EBRI Member Relations for more information.

Total Time

Count

Avg Time

Query

0.017

1 call
1 row

0.017

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hasShowPassword' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.015

1 call
1 row

0.015

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.015

1 call
1 row

0.015

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.014

1 call
1 row

0.014

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.013

1 call
1 row

0.013

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='recaptcha_site_key' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.012

1 call
1 row

0.012

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.009

1 call
0 rows

0.009

UPDATE `PageRequest` SET `mxxUpdated`='2026-06-15 16:18:00', `mxxUpdatedBy`=NULL, `PageRequestId`=0x6018E900000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='1847024', `requestNum`='2', `growth`='12396', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='876708', `startTime`='2026-06-15 16:17:59', `sessionId`=0x3DAB1D33AE37277A, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.062020301818847656', `timeTaken`='24', `dictSize`='0', `fields`='{\\'oauth\\':\\'1\\', \\'service\\':\\'/forms/oauth/authorize?response_type=code&client_id=d3a0d9cba1eb4bed9434057b584d2b00&scope=scope&state=https%3a%2f%2fwww.ebri.maxx.matrixdev.net%2fpublications%2fresearch-publications%2fissue-briefs%2fcontent%2ffull%2fareas-of-health-care-spending-concentrations-ppt&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.187' WHERE `PageRequestId`=0x6018E900000001

0.008

1 call
0 rows

0.008

INSERT INTO `Ticket` SET `mxxCreated`='2026-06-15 16:18:01', `mxxCreatedBy`=NULL, `TicketId`=0x6018E900000004, `type`='2', `value`='LT-1781554681-UWHGoBHHyuJMPHrmKADfGnR3fo0J4eWY', `expires`='2026/06/15 17:48:01.0897 US/Eastern', `username`=NULL, `service`='/forms/oauth/authorize?response_type=code&client_id=d3a0d9cba1eb4bed9434057b584d2b00&scope=scope&state=https%3a%2f%2fwww.ebri.maxx.matrixdev.net%2fpublications%2fresearch-publications%2fissue-briefs%2fcontent%2ffull%2famerica-s-retirement-deficit-ebri-projections-show-improvements-ppt&redirect_uri=https://www.ebri.org/mxt/authservice/callback/', `isPrimary`='2'

0.007

1 call
1 row

0.007

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='recaptcha_secret_key' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.004

1 call
1 row

0.004

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText_bottom' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.004

1 call
1 row

0.004

SELECT version from databasemap;

0.004

1 call
0 rows

0.004

START TRANSACTION

0.003

1 call
0 rows

0.003

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 16:18:01', `mxxCreatedBy`=NULL, `PageRequestId`=0x6018E900000003, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='1847024', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='876708', `startTime`='2026-06-15 16:18:01', `sessionId`=0x4CD7FCDD88BA6395, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'oauth\\':\\'1\\', \\'service\\':\\'/forms/oauth/authorize?response_type=code&client_id=d3a0d9cba1eb4bed9434057b584d2b00&scope=scope&state=https%3a%2f%2fwww.ebri.maxx.matrixdev.net%2fpublications%2fresearch-publications%2fissue-briefs%2fcontent%2ffull%2famerica-s-retirement-deficit-ebri-projections-show-improvements-ppt&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.187'

0.003

1 call
0 rows

0.003

COMMIT

0.003

1 call
1 row

0.003

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.002

1 call
1 row

0.002

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

138445 function calls (137473 primitive calls) in 1.228 seconds Ordered by: cumulative time List reduced from 1118 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.228 1.228 /data/ebri/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 1.190 1.190 /data/ebri/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.156 1.156 /data/ebri/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.156 1.156 /data/ebri/current/generic/sites/www/forms/cas.py:198(login) 1 0.000 0.000 1.156 1.156 /data/ebri/current/generic/sites/www/forms/cas.py:84(_presentLoginPage) 1 0.000 0.000 0.658 0.658 /data/ebri/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.658 0.658 /data/ebri/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 0.431 0.431 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.431 0.431 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.431 0.431 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 1 0.000 0.000 0.418 0.418 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.418 0.418 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.418 0.418 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.418 0.418 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.418 0.418 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.030 0.030 0.418 0.418 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.349 0.349 /data/ebri/current/generic/classes/Ticket.py:42(create) 1 0.000 0.000 0.349 0.349 /data/ebri/current/libs/PLayer/PersistentObject.py:956(save) 1 0.333 0.333 0.333 0.333 {built-in method gc.collect} 1 0.000 0.000 0.227 0.227 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:718(process) 919 0.020 0.000 0.172 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 20 0.000 0.000 0.170 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 20 0.000 0.000 0.169 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 20 0.000 0.000 0.168 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 20 0.168 0.008 0.168 0.008 {function Connection.query at 0xfa8ec7a189a0} 10 0.000 0.000 0.131 0.013 /data/ebri/current/generic/classes/ClientSetting.py:97(getClientSettingValue) 13 0.000 0.000 0.124 0.010 /data/ebri/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 279/263 0.000 0.000 0.120 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 262 0.012 0.000 0.116 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 9 0.000 0.000 0.114 0.013 /data/ebri/current/libs/framework/BaseHandler.py:832(getClientSetting) 10 0.000 0.000 0.106 0.011 /data/ebri/current/generic/classes/ClientSetting.py:33(getClientSetting) 10 0.000 0.000 0.105 0.010 /data/ebri/current/libs/PLayer/PersistentBroker.py:847(processCriteria) 10 0.000 0.000 0.093 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.001 0.000 0.093 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 6 0.000 0.000 0.091 0.015 /data/ebri/current/libs/framework/WebApp.py:722(getClientSetting) 684 0.017 0.000 0.085 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 1 0.000 0.000 0.083 0.083 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:707(_drape) 263 0.020 0.000 0.082 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 412 0.001 0.000 0.080 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 412 0.001 0.000 0.079 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 2133 0.028 0.000 0.076 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 26256/26149 0.073 0.000 0.074 0.000 {built-in method builtins.isinstance} 1 0.000 0.000 0.073 0.073 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1 0.000 0.000 0.073 0.073 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 263/1 0.017 0.000 0.073 0.073 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 263/1 0.012 0.000 0.073 0.073 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 1 0.000 0.000 0.065 0.065 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:640(doPostScrapeStuff) 77 0.000 0.000 0.056 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP) 1 0.000 0.000 0.050 0.050 /data/ebri/current/ebri_org/classes/ebri_ScrapeAndDrape.py:17(_makeBreadCrumbs) 1 0.000 0.000 0.050 0.050 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 1 0.000 0.000 0.050 0.050 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 1 0.000 0.000 0.050 0.050 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 1 0.000 0.000 0.050 0.050 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 2 0.000 0.000 0.050 0.025 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 2 0.000 0.000 0.050 0.025 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 331 0.000 0.000 0.046 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre) 263 0.000 0.000 0.044 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 2274 0.001 0.000 0.042 0.000 /data/ebri/current/libs/framework/BaseHandler.py:1480(mxxImporter) 836 0.012 0.000 0.042 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1980(search_tag) 900 0.014 0.000 0.039 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:256(dataState) 6324 0.018 0.000 0.034 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:234(char) 2451 0.034 0.000 0.034 0.000 {method 'startswith' of 'str' objects} 679 0.001 0.000 0.031 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:576(object_was_parsed) 263 0.003 0.000 0.031 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 855 0.001 0.000 0.030 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/formatter.py:75(substitute) 596/579 0.001 0.000 0.028 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2076(_matches) 1 0.000 0.000 0.028 0.028 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:447(_addToHead) 263 0.000 0.000 0.028 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 8 0.000 0.000 0.027 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1742(find) 11 0.000 0.000 0.026 0.002 /data/ebri/current/libs/utils/htmlTools.py:100(cleanHTML) 3 0.000 0.000 0.026 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 490 0.026 0.000 0.026 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:375(tagOpenState) 3 0.000 0.000 0.026 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:153(clean) 57 0.000 0.000 0.024 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1098(startTagA) 62 0.000 0.000 0.024 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:957(addFormattingElement) 265 0.008 0.000 0.024 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:267(__init__) 3 0.000 0.000 0.024 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/serializer.py:375(render) 59 0.000 0.000 0.024 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:639(serialize) 839 0.015 0.000 0.023 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:1007(attributeValueDoubleQuotedState) 3 0.000 0.000 0.023 0.008 /data/ebri/current/libs/utils/getCpuTime.py:10(getCpuTime) 6 0.023 0.004 0.023 0.004 {method 'readlines' of '_io._IOBase' objects} 263 0.000 0.000 0.023 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:229(position) 266 0.000 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:218(_position) 1030 0.011 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:887(attributeNameState) 273 0.022 0.000 0.022 0.000 {method 'count' of 'str' objects} 1262 0.011 0.000 0.022 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:434(tagNameState) 1 0.000 0.000 0.021 0.021 /data/ebri/current/libs/framework/WebSite.py:602(logEndRequest) 1 0.000 0.000 0.021 0.021 /data/ebri/current/libs/utils/recaptcha.py:15(__init__) 1 0.000 0.000 0.021 0.021 /data/ebri/current/libs/framework/MakoTemplate.py:48(__call__) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 49 0.000 0.000 0.020 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1062(startTagListItem) 1 0.000 0.000 0.020 0.020 /tmp/mako_modules_1011/ebri/www/26.1.1/data/ebri/current/generic/themes/shared/mako/login/caslogin.html.py:18(render_body) 949 0.018 0.000 0.019 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:332(setAttributes) 2 0.000 0.000 0.019 0.010 /data/ebri/current/libs/framework/Auth.py:421(getValidSessionRecord) 68 0.000 0.000 0.019 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:997(processCharacters) 496 0.000 0.000 0.019 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:347(_last_descendant) 1375 0.018 0.000 0.018 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:158(setup)