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.005

2 calls
0 rows

0.003

COMMIT

0.005

1 call
0 rows

0.005

INSERT INTO `Ticket` SET `mxxCreated`='2026-06-15 20:52:28', `mxxCreatedBy`=NULL, `TicketId`=0x6019B600000002, `type`='2', `value`='LT-1781571148-DSGU4KdnqLJLjg0hLbmrm41RPwajLZjQ', `expires`='2026/06/15 22:22:28.3174 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%2fcapping-small-business-retirement-savings&redirect_uri=https://www.ebri.org/mxt/authservice/callback/', `isPrimary`='2'

0.005

1 call
1 row

0.005

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)

0.005

2 calls
0 rows

0.002

START TRANSACTION

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 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.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`='recaptcha_site_key' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.003

1 call
159 rows

0.003

SELECT * FROM webselect

0.003

1 call
0 rows

0.003

UPDATE `PageRequest` SET `mxxUpdated`='2026-06-15 20:52:28', `mxxUpdatedBy`=NULL, `PageRequestId`=0x6019B600000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='1897294', `requestNum`='1', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='918069', `startTime`='2026-06-15 20:52:28', `sessionId`=0xBBDBAC254DD6831, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.005923748016357422', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'d3a0d9cba1eb4bed9434057b584d2b00\\', \\'redirect_uri\\':\\'https://www.ebri.org/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'scope\\':\\'scope\\', \\'state\\':\\'https://www.ebri.maxx.matrixdev.net/publications/research-publications/issue-briefs/content/full/do-older-americans-own-or-rent\\'}', `clientIPAddr`='216.73.217.83' WHERE `PageRequestId`=0x6019B600000000

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`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.003

1 call
1 row

0.003

SELECT version from databasemap;

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 20:52:28', `mxxCreatedBy`=NULL, `PageRequestId`=0x6019B600000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='1897294', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='918069', `startTime`='2026-06-15 20:52:28', `sessionId`=0x36EA69BAF46C1371, `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%2fcapping-small-business-retirement-savings&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.217.83'

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`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 20:52:28', `mxxCreatedBy`=NULL, `PageRequestId`=0x6019B600000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='1897294', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='918069', `startTime`='2026-06-15 20:52:28', `sessionId`=0xBBDBAC254DD6831, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'d3a0d9cba1eb4bed9434057b584d2b00\\', \\'redirect_uri\\':\\'https://www.ebri.org/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'scope\\':\\'scope\\', \\'state\\':\\'https://www.ebri.maxx.matrixdev.net/publications/research-publications/issue-briefs/content/full/do-older-americans-own-or-rent\\'}', `clientIPAddr`='216.73.217.83'

0.001

1 call
11 rows

0.001

DESCRIBE Ticket

0.001

1 call
1 row

0.001

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.001

1 call
1 row

0.001

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.001

1 call
1 row

0.001

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.001

1 call
1 row

0.001

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.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

480340 function calls (473962 primitive calls) in 2.262 seconds Ordered by: cumulative time List reduced from 1711 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 2.262 2.262 /data/ebri/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 2.244 2.244 /data/ebri/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 2.217 2.217 /data/ebri/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 2.217 2.217 /data/ebri/current/generic/sites/www/forms/cas.py:198(login) 1 0.000 0.000 2.217 2.217 /data/ebri/current/generic/sites/www/forms/cas.py:84(_presentLoginPage) 1 0.000 0.000 1.716 1.716 /data/ebri/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 1.716 1.716 /data/ebri/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 1.587 1.587 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 1.586 1.586 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 13 0.000 0.000 0.791 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 13 0.006 0.000 0.790 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 13 0.000 0.000 0.784 0.060 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 13 0.000 0.000 0.771 0.059 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 13 0.000 0.000 0.771 0.059 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 13 0.026 0.002 0.770 0.059 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.695 0.695 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:530(_addStylesAndScripts) 2 0.000 0.000 0.584 0.292 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:362(rebuildSoup) 1 0.000 0.000 0.416 0.416 /usr/lib/python3.11/urllib/request.py:139(urlopen) 1 0.000 0.000 0.415 0.415 /usr/lib/python3.11/urllib/request.py:500(open) 1 0.000 0.000 0.415 0.415 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.415 0.208 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 1 0.000 0.000 0.415 0.415 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.415 0.415 /usr/lib/python3.11/urllib/request.py:1307(do_open) 1 0.000 0.000 0.370 0.370 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:477(_includeMaxxCSS) 2860 0.068 0.000 0.335 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.325 0.325 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:498(_includeMaxxJavascript) 11 0.000 0.000 0.281 0.026 /data/ebri/current/libs/utils/htmlTools.py:100(cleanHTML) 10645/10471 0.031 0.000 0.272 0.000 /data/ebri/current/libs/framework/BaseHandler.py:1480(mxxImporter) 7 0.000 0.000 0.264 0.038 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 7 0.000 0.000 0.264 0.038 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 7 0.000 0.000 0.263 0.038 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 7 0.000 0.000 0.262 0.037 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 13 0.000 0.000 0.262 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 13 0.001 0.000 0.258 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 878/834 0.002 0.000 0.252 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 10659/10471 0.030 0.000 0.227 0.000 {built-in method builtins.__import__} 802 0.004 0.000 0.200 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 36/8 0.000 0.000 0.198 0.025 :934(exec_module) 35/7 0.000 0.000 0.197 0.028 :666(_load_unlocked) 1 0.000 0.000 0.195 0.195 /usr/lib/python3.11/http/client.py:1446(__init__) 35/6 0.000 0.000 0.195 0.033 :1165(_find_and_load) 1 0.000 0.000 0.195 0.195 /usr/lib/python3.11/ssl.py:745(create_default_context) 35/6 0.000 0.000 0.195 0.033 :1120(_find_and_load_unlocked) 85/11 0.000 0.000 0.195 0.018 :233(_call_with_frames_removed) 36/8 0.000 0.000 0.193 0.024 {built-in method builtins.exec} 1832 0.026 0.000 0.192 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.189 0.189 /usr/lib/python3.11/ssl.py:591(load_default_certs) 1 0.189 0.189 0.189 0.189 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 1 0.000 0.000 0.171 0.171 /usr/lib/python3.11/http/client.py:1371(getresponse) 1 0.000 0.000 0.171 0.171 /usr/lib/python3.11/http/client.py:323(begin) 3 0.000 0.000 0.171 0.057 /usr/lib/python3.11/socket.py:704(readinto) 1 0.000 0.000 0.171 0.171 /usr/lib/python3.11/http/client.py:290(_read_status) 16 0.000 0.000 0.171 0.011 {method 'readline' of '_io.BufferedReader' objects} 3 0.000 0.000 0.171 0.057 /usr/lib/python3.11/ssl.py:1299(recv_into) 3 0.000 0.000 0.171 0.057 /usr/lib/python3.11/ssl.py:1157(read) 3 0.171 0.057 0.171 0.057 {method 'read' of '_ssl._SSLSocket' objects} 1 0.000 0.000 0.164 0.164 /data/ebri/current/generic/classes/Ticket.py:42(create) 1 0.000 0.000 0.159 0.159 /data/ebri/current/libs/PLayer/PersistentObject.py:956(save) 4 0.000 0.000 0.155 0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 1080/4 0.042 0.000 0.155 0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 1080/4 0.040 0.000 0.155 0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 1 0.146 0.146 0.146 0.146 {built-in method gc.collect} 1 0.000 0.000 0.146 0.146 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1832 0.008 0.000 0.131 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.129 0.129 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:718(process) 47 0.001 0.000 0.112 0.002 /usr/lib/python3.11/re/__init__.py:272(_compile) 42 0.000 0.000 0.112 0.003 /usr/lib/python3.11/re/__init__.py:225(compile) 28 0.000 0.000 0.111 0.004 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.110 0.110 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 1832 0.001 0.000 0.108 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 139/107 0.000 0.000 0.100 0.001 :1207(_handle_fromlist) 2 0.000 0.000 0.099 0.049 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1264 0.002 0.000 0.094 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 1264 0.014 0.000 0.092 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 237 0.000 0.000 0.090 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP) 815 0.011 0.000 0.088 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 1012 0.007 0.000 0.086 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre) 2106 0.032 0.000 0.083 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 1 0.000 0.000 0.081 0.081 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:654(prepMetaTags) 1832 0.013 0.000 0.081 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 3 0.000 0.000 0.075 0.025 /data/ebri/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 6 0.075 0.013 0.075 0.013 /data/ebri/current/libs/utils/htmlTools.py:53(init) 2947 0.041 0.000 0.068 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:332(setAttributes) 1839 0.004 0.000 0.065 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants) 6614 0.029 0.000 0.065 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag) 21 0.000 0.000 0.061 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 3988 0.041 0.000 0.061 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:314(charsUntil) 21 0.000 0.000 0.061 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 21 0.000 0.000 0.060 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 21 0.060 0.003 0.060 0.003 {function Connection.query at 0xfe3fdec949a0} 3 0.000 0.000 0.059 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 1 0.000 0.000 0.059 0.059 /data/ebri/current/libs/framework/BaseHandler.py:1609(writeCachedFile) 3824 0.044 0.000 0.058 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 2072 0.013 0.000 0.058 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:576(object_was_parsed) 28 0.000 0.000 0.058 0.002 /usr/lib/python3.11/re/_compiler.py:573(_code) 2469 0.019 0.000 0.058 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:1007(attributeValueDoubleQuotedState) 3034 0.007 0.000 0.057 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:887(attributeNameState) 2 0.000 0.000 0.056 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1512(encode) 1 0.000 0.000 0.055 0.055 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 28 0.000 0.000 0.052 0.002 /usr/lib/python3.11/re/_parser.py:979(parse)