Question Help understanding QryLog output

Status
Not open for further replies.
Cringer

Cringer

ProgressTalk.com Moderator
Staff member
Been playing around with the QryLog logging type and was wondering if someone could help me get my head around what it is telling me. Some of it is self-explanatory, and I can make assumptions about other stuff, but I'd rather not assume! :) Here's the output for on of the queries I'm interested in:

Code: 
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Query Plan:  CreateQuery Farselwt.w line 11006
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        QueryId: 35052280
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Query Handle: 1811
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Type: Dynamically Opened Query
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        PREPARE-STRING: FOR EACH FaultReport NO-LOCK WHERE ICMAS.FaultReport.FarDeveloperPersonKey = 49775421 AND  LOOKUP(STRING(ICMAS.FaultReport.ObjectStatusKey,'999999999'),'003540805,029753236,090400997,029753234,090400998,029753238,029753235,029753239,029753240,063726893') GT 0 AND  LOOKUP(STRING(ICMAS.FaultReport.FarBusinessJustification),'BUSRISK,CUSCRIT,FINANCE,NONE,OPPORT,RESOURCE') GT 0 AND ICMAS.FaultReport.FarManagerConfirmedDate= ICMAS.FaultReport.FarManagerConfirmedDate,FIRST FaultReportCategory WHER
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Prepared at Runtime
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Client Sort: Y 
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Scrolling: Y
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.FaultReport
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: DeveloperIdx
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.FaultReportCategory
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: FaultReportCategoryKeyIdx
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.Person
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: PersonPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.lb-Person
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: PersonPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.ObjectStatus
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: ObjectStatusPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.TeamMember
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: PersonKeyIdx
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.Team
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: TeamPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.EntityFieldChoiceValues
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: IdxFieldChoiceKey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.Customer
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: CustomerPkey
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO        Table: icmasliv.Supplier
[15/02/04@10:37:08.365+0000] P-007152 T-007844 2 4GL QRYINFO          Indexes: SupplierPkey
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Query Statistics:  CreateQuery Farselwt.w line -1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        QueryId: 35052280
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Query Handle: 1811
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Times prepared: 1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Time to prepare (ms): 11
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        DB Blocks accessed to prepare:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         icmasliv : 82
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Times opened: 1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Entries in result list: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        Time to build result list (ms): 65
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        DB Blocks accessed to build result list:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         icmasliv : 1301
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        DB Reads to build result list:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.FaultReport : 267
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: FaultReport.DeveloperIdx : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.FaultReportCategory : 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: FaultReportCategory.FaultReportCategoryKeyIdx : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Person : 45
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Person.PersonPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.lb-Person : 45
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: lb-Person.PersonPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.ObjectStatus : 204
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: ObjectStatus.ObjectStatusPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.TeamMember : 22
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: TeamMember.PersonKeyIdx : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Team : 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Team.TeamPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.EntityFieldChoiceValues : 62
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: EntityFieldChoiceValues.IdxFieldChoiceKey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Customer : 28
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Customer.CustomerPkey : UNAVAILABLE
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Supplier : 1
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Supplier.SupplierPkey : UNAVAILABLE
 
Cringer

Cringer

ProgressTalk.com Moderator
Staff member
I've had to split this to get it to post...
Code: 
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.FaultReport Table:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Fields: FaultReportKey,FarDateReported,FarReportedByPersonKey,FarDeveloperPersonKey,ObjectStatusKey,CustomerKey,FaultReportCategoryKey,FarStrategicDevelopment,SupplierKey
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.FaultReportCategory Table:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Person Table:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.lb-Person Table:
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.433+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.ObjectStatus Table:
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.TeamMember Table:
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Fields: TeamKey
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Team Table:
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.EntityFieldChoiceValues Table:
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 17
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Customer Table:
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 1
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 1
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Supplier Table:
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Records from server: 1
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Useful: 1
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO          Failed: 0
[15/02/04@10:37:08.434+0000] P-007152 T-007844 2 4GL QRYINFO         Select By Client: N
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        Query Statistics:  CreateQuery Farselwt.w line 11056
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        QueryId: 35052280
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        Query Handle: 1811
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        Used REPOSITION: N
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        DB Blocks accessed:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         icmasliv : 280
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        DB Reads:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.FaultReport : 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: FaultReport.DeveloperIdx : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.FaultReportCategory : 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: FaultReportCategory.FaultReportCategoryKeyIdx : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Person : 44
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Person.PersonPkey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.lb-Person : 42
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: lb-Person.PersonPkey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.ObjectStatus : 220
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: ObjectStatus.ObjectStatusPkey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.TeamMember : 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: TeamMember.PersonKeyIdx : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Team : 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Team.TeamPkey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.EntityFieldChoiceValues : 34
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: EntityFieldChoiceValues.IdxFieldChoiceKey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Customer : 37
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Customer.CustomerPkey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Table: icmasliv.Supplier : 5
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         Index: Supplier.SupplierPkey : UNAVAILABLE
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.FaultReport Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.FaultReportCategory Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Person Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.lb-Person Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.ObjectStatus Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.TeamMember Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Team Table:
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.628+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.EntityFieldChoiceValues Table:
[15/02/04@10:37:08.629+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 17
[15/02/04@10:37:08.629+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Customer Table:
[15/02/04@10:37:08.629+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 1
[15/02/04@10:37:08.629+0000] P-007152 T-007844 2 4GL QRYINFO        icmasliv.Supplier Table:
[15/02/04@10:37:08.629+0000] P-007152 T-007844 2 4GL QRYINFO         4GL Records: 1
 
O

oli

Member
Hi Cringer,

Did you already read the 14 pages of explanation about QRYINFO in the Progress Doc (Development: Debugging and troubleshooting (dvdbg))?
 
Status
Not open for further replies.

Similar threads

Mike
Need to find out root cause Please help
Replies
1
Views
532
TomBascom
TomBascom
Z
  • Locked
[Progress News] [Progress OpenEdge ABL] A Guide on How Writers Can Optimize Content for SEO
Replies
0
Views
764
Zach Stone
Z
T
  • Locked
[Progress News] [Progress OpenEdge ABL] Understanding ISO 8601 Date and Time Format
Replies
0
Views
1K
Thierry Ciot
T
C
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: FW: Progress Alert and Notification Service Article Alert OpenEdge
Replies
0
Views
464
Community Admin
C
3
  • Locked
[Progress Communities] [Progress OpenEdge ABL] Forum Post: Zombie remote servers - need some advice
Replies
0
Views
1K
302218
3
Top