---
schema_version: "1"
id: 7fda4184cb3f3eff2790b56cc26eca3a83690ce8a3b58a1e2e0b2c1913b81cf8
title: ccdw_aggr_controller_request
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_controller_request.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_controller_request.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 8bae76b9bd1d9eda66d6315247d0a774f9f30c21e2bc0bdb6936e833aa0de0a8
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_controller_request

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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md). | 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     |

<!-- **Indices**: None listed -->