ccdw_aggr_controller_request

This table aggregates daily performance metrics for pipeline requests.

Column AliasData TypeKeyDescriptionIndex?
request_dateDATEDate of the request.No
controller_nameVARCHARName of the pipeline/controller.No
site_idSMALLINTFKForeign key to ccdw_dim_site.No
cache_behaviorVARCHARCache behavior of the request.No
status_codeSMALLINTHTTP status code of the response.No
num_requestsINTEGERTotal number of requests.No
response_timeNUMERICAverage response time for the requests.No
num_requests_bucket1INTEGERNumber of requests in response time bucket 1.No
num_requests_bucket2INTEGERNumber of requests in response time bucket 2.No
num_requests_bucket3INTEGERNumber of requests in response time bucket 3.No
num_requests_bucket4INTEGERNumber of requests in response time bucket 4.No
num_requests_bucket5INTEGERNumber of requests in response time bucket 5.No
num_requests_bucket6INTEGERNumber of requests in response time bucket 6.No
num_requests_bucket7INTEGERNumber of requests in response time bucket 7.No
num_requests_bucket8INTEGERNumber of requests in response time bucket 8.No
num_requests_bucket9INTEGERNumber of requests in response time bucket 9.No
num_requests_bucket10INTEGERNumber of requests in response time bucket 10.No
num_requests_bucket11INTEGERNumber of requests in response time bucket 11.No