This table aggregates daily performance metrics for pipeline requests.
Note: This table is not constrained by IP Address Filters configured in Business Manager.
| 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 |