Wayfast Usage and Performance Logs
- Matias
Context
This document explains briefly how to consume the information stored within the WayFastStats database. This database receives information directly produced by the frontend while a user navigates different WayFast applications. It collects information including date, project, pagename, username, userid and queries being executed against any DB or API.
LogRequest and LogRequestDetail tables
These tables contain information regarding what a user does while navigating a project. These both provide useful information for log and a troubleshooting purposes.
LogRequest table acts as a header, indicating general actions captured whenever a user requests to load a specific page.
LogRequestDetail table provides more in depth information regarding which actions the frontend executed while processing a page.
Note: all times are registered in milliseconds.
Examples
Querying LogRequest by username
select * from wayfaststats.dbo.logrequest where context_user_name=’user_name’Querying LogRequest by HostName
select * from wayfaststats.dbo.logrequest
where context_request_hostname=’host_name_in_fqdn_format’Querying LogRequest by page name
select * from wayfaststats.dbo.logrequest
where context_request_pagename=’page_name_as_defined_in_IDE’Querying LogRequest with detailed information
CursorsLog View
This view provides an insight of all DataSets executed as a result of a user request in the frontend. It has detailed information on the parameters being used on each call, making this info useful to track database access and query issues.
Examples
Querying CursorsLog by date, hostname and pagename. Output groups results by execution times only for those over 5 seconds:
Note: CursorsLog and LogRequest can be joined by projectname, pagename, hostname and user (logrequest.context_user_id with cursorslog.userid).