HELP - ANALYTICS
Here, data is provided to allow a per query-pattern view of the queries passing through the system, as logged with the Log action or with global VDB logging. Filters can be applied to limit the data to approximately a given timeframe (this is limited to the granularity of the log files) and to the data source or query pattern. When the results are displayed, the following columns are present:
- Rank: The current sort rank of a given query pattern
- One-Click Cache: If a query is a potentially cacheable query, a button will be presented to pull the query into the rules tab.
- Query: The query pattern itself
- Server Time (%): The percentage of time overall time waiting on the server represented by this particular query pattern. This column should add to 100% for all queries (rounding excluded).
- Duplicate Query & Response (%): An estimate of the percentage of query responses that are duplicated. The higher this number, the more gains are likely to occur for caching a particular pattern.
- Cache Safety Rating: An estimate on how variable the data is being queried by a pattern. The higher this number, the less variability has been detected in responses.
- Cache Time (s): A estimate of how long a query can be cached safely to prevent stale content from being delivered. This correlates with the cache safety rating.
- Cache Hit (%): The percent of time a particular query pattern has been served from cache vs. retrieved from the Origin.
- Count: How many times this query pattern has been observed.
- Query Response Time (µs): On average, how long it takes for queries matching this pattern to be return from an execution.
- Result Retrieval Time (µs): Like the Query Response Time, but measured from the time the query is sent to the server to the time the result-set is closed. This can include additional time spent by the application processing the result-set, and may be significantly longer than the Query Response Time for very large responses.
- Total KBs: The total result-set retrieval size for this query pattern, in aggregate. (1.0.6): This field will be replaced with “Average Result Size” and will represent the average size of the result-sets returned vs. the sum total.
The “Duplicate Query & Response” column and “Cache Safety Rating” are intended to provide a guide to answer two questions: “What content is worth caching”, and “How safe is a particular query to cache?” High values for both are a strong indicator that a query should be cached for optimal performance. The logic behind these two fields can be expected to be fine tuned over time.