ccdw_aggr_controller_request
This table aggregates daily performance metrics for pipeline requests.
Column Alias | Data Type | Key | Description | Index? |
---|---|---|---|---|
request_date | DATE | Date of the request. | No | |
controller_name | VARCHAR | Name of the pipeline/controller. | No | |
site_id | SMALLINT | FK | Foreign key to ccdw_dim_site . | No |
cache_behavior | VARCHAR | Cache behavior of the request. | No | |
status_code | SMALLINT | HTTP status code of the response. | No | |
num_requests | INTEGER | Total number of requests. | No | |
response_time | NUMERIC | Average response time for the requests. | No | |
num_requests_bucket1 | INTEGER | Number of requests in response time bucket 1. | No | |
num_requests_bucket2 | INTEGER | Number of requests in response time bucket 2. | No | |
num_requests_bucket3 | INTEGER | Number of requests in response time bucket 3. | No | |
num_requests_bucket4 | INTEGER | Number of requests in response time bucket 4. | No | |
num_requests_bucket5 | INTEGER | Number of requests in response time bucket 5. | No | |
num_requests_bucket6 | INTEGER | Number of requests in response time bucket 6. | No | |
num_requests_bucket7 | INTEGER | Number of requests in response time bucket 7. | No | |
num_requests_bucket8 | INTEGER | Number of requests in response time bucket 8. | No | |
num_requests_bucket9 | INTEGER | Number of requests in response time bucket 9. | No | |
num_requests_bucket10 | INTEGER | Number of requests in response time bucket 10. | No | |
num_requests_bucket11 | INTEGER | Number of requests in response time bucket 11. | No |