Importance of pxOtherBrowserElapsed Time in Pega00005 Alert

General
, , , ,
1

Hi there,

I see a lot of Pega00005 alerts in production. When analyzed the alert I don’t see any issue with the database query but I see a field pxOtherBrowserElapsed field elapsed time is consuming 95 of the total elapsed time.

Could someone explain me the importance of the pxOtherBrowserElapsed field?

Appreciate if anyone can help me to understand the field. Below is the alert detail

2022-12-14 15:06:17,373 GMT8PEGA00051259345001e9b01641e40417adc0fd7c2c828689cNANAHBFF88FYP109AQLQCC0P4JV7WA3QDRJ7HSandY02AACCheckSA-WorkAACAdjustments:19.05.0163eceb5908bd4f198a6c472e022ec8abN4159HBFF88FYP109AQLQCC0P4JV7WA3QDRJ7H4446WebContainer : 5TABTHREAD0com.pega.pegarules.data.internal.store.DataStorePreparedStatementcstar.wellsfargo.com|lb165mnsvdc-fj.wellsfargo.comActivity=FinishAssignmentRule-Obj-Activity:FinishAssignmentAACCHECKSA-WORK-POSTEDTWICE FINSETOFFSETCLASSES #20181215T160318.485 GMT Step: 1 Circum: 0643*****pxRDBIOElapsed=0.12;pxRDBIOCount=33;pxRunStreamCount=26;pxTotalReqCPU=0.80;pxRunModelCount=92;pxRunWhenCount=236;pxDeclarativePageLoadElapsed=0.01;pxConnectClientResponseElapsed=8.61;pxRulesExecuted=1,068;pxOtherCount=263;pxDBInputBytes=23,140;pxTotalReqTime=138.34;pxActivityCount=341;pxAlertCount=2;pxOtherFromCacheCount=550;pxRDBWithoutStreamCount=24;pxFlowCount=21;pxRunOtherRuleCount=21;pxOtherBrowseElapsed=125.93;pxConnectElapsed=8.79;pxDeclarativeRulesInvokedCount=131;pxInteractions=1;pxLegacyRuleAPIUsedCount=10;pxRuleCount=302;pxInputBytes=1,447;pxConnectCount=24;pxDeclarativeRulesInvokedElapsed=0.03;pxRuleIOElapsed=0.02;pxRulesUsed=1,861;pxDeclarativePageLoadCount=2;pxProceduralRuleReadCount=2;pxRuleFromCacheCount=308;pxOtherIOElapsed=0.21;pxRuleBrowseElapsed=0.00;pxTrackedPropertyChangesCount=543;pxDBOutputBytes=356,292;pxRDBRowWithoutStreamCount=29;pxOtherIOCount=61;pxConnectOutMapReqElapsed=0.01;pxConnectInMapReqElapsed=0.11;AACCheckSA-Work-PostedTwicepyWorkPageAACCheckSA-Work-PostedTwicepyWorkPage*Java;RULE-OBJ-ACTIVITY AACCHECKSA-WORK FINSEARCHFINANCIALOFFSETS #20210323T212719.641 GMT Step: 9 Circum: 0;doActivity Rule-Obj-Activity:FinSearchFinancialOffsets;doActivity Rule-Obj-Flow;doActivity Rule-Obj-Flow;12 additional frames in stack;*OutputPageClass=;OutstandingBalanceRange=;StepSLA=;pyDeferCommit=;Index=;WorkDateRange=;ReferencePageName=;pyIterationType=;RTN=;ReferenceInsName=;pyIterationTarget=;TimeFlowStarted=;pyDraftMode=;CreateProblemFlow=;pyStatus=;OnlyCreateOutputPageIfError=;ReferenceInsKey=;pyParentFlowPath=;pyTopLevelFlow=;ScoreRuleName=;Threshold=;WorkType=;IsInvestigative=;pyNextAssignment=;MaxResults=;FlowHasEnded=;pyDeferErrors=;InterestPage=;flowName=;pyTempPlaceHolder=TempPlaceHolder;pyStageID=;InterestPageClass=;pyStageLabel=;ReferenceClass=;TaskName=;pyConfirmHarness=;pzRowIndex=;FlowType=AACCheckSA-Work-PostedTwice;pyHowInvoked=;HistoryOperator=;OutputPageName=;pyForEachCount=471;flowType=OffsetSearch;*Database operation took more than the threshold of 500 ms: 125,934 ms SQL: select pzPVStream from PRPCPROD.paf_work where pzInsKey like ? and “PXOBJCLASS” in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) and “SUSPTYPE” = ? and “SUSPCURR” = ? and “OUTBAL” > ? and “OUTBAL” >= ? and “OUTBAL” <= ? and “SUSPINFLIGHT” <> ? and “INCOMINGDUPLICATEWORKDATE” >= ? and “INCOMINGDUPLICATEWORKDATE” <= ? order by pzInsKey inserts: <AACCHECKSA-WORK %> <0> <74.75> <74.75> <20221125> <20221215>

Thanks,

Suman

2

Any thoughts on this query?

3

@VenkataSumanP5754 I’m unable to see references to field pxOtherBrowserElapsed in your log extract.

Did you already check details of the PEGA005 documentation / 8.8 documentation? Other documentation such as this one also offer a good insight.

If there is no further response from our forum community could I ask that you log a support incident for this on the MSP?

4

@MarijeSchillern My bad the field is pxOtherBrowseElapsed.

5

@VenkataSumanP5754 does the explanation here help answer your question?

“Elapsed time for Obj-List operations. excluding Obj-List operations on rules,”

Using the full details display of Performance Analyzer

If you require an in-depth analysis of your issue, please could you log a support incident and let us know the INC number so that we can help track it?

6

@VenkataSumanP5754 Can this query be optimized to only retrieve only the required/few columns instead of the blob column?

select pzPVStream from PRPCPROD.paf_work where pzInsKey like ? and “PXOBJCLASS” in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) and “SUSPTYPE” = ? and “SUSPCURR” = ? and “OUTBAL” > ? and “OUTBAL” >= ? and “OUTBAL” <= ? and “SUSPINFLIGHT” <> ? and “INCOMINGDUPLICATEWORKDATE” >= ? and “INCOMINGDUPLICATEWORKDATE” <= ? order by pzInsKey