--- title: "How To: Get the Daily Cost Report for StatefulSets" slug: "how-to-get-the-daily-cost-report-for-statefulsets" updated: 2026-06-15T20:25:17Z published: 2026-06-15T20:25:17Z canonical: "resources.realtheory.io/how-to-get-the-daily-cost-report-for-statefulsets" --- > ## Documentation Index > Fetch the complete documentation index at: https://resources.realtheory.io/llms.txt > Use this file to discover all available pages before exploring further. # How To: Get the Daily Cost Report for StatefulSets After deploying the RealTheory collector to a Kubernetes cluster (See [Installing RealTheory in a Cluster](/v1/docs/installing-realtheory-in-a-cluster)), the cluster and its associated objects become available in the RealTheory API within minutes. ### Get Daily Cost Report To get the Daily Cost report data for all stateful sets for a given cluster, call the method below on the [K8sReports](https://api-dev.realtheory.io/swagger/k8sreports/index.html) endpoint. ``` GET /theory/api/v1/k8sreports/dailycostreport/statefulsets/search/query/{query}/{offset}/{span}?index={index}&count={count}&order={order}&direction={direction} ``` where - `{endpoint}` - is the URL of the RealTheory SaaS portal for your account. - `{query}` - is a [query](/v1/docs/queries) used to limit the results to stateful sets for a given cluster. - `{offset}` - is an offset from the current time, in a human readable format, that represents the start of the report data. Supported examples include '24h', '7d', '31d', '365d' - `{span}` - a span of time, in a human readable format, to include in the report data. Supported examples include '24h', '7d', '31d', '365d' - `{index}` - is the starting index of the rows to include in the list. This parameter is optional and defaults to 0 if not specified. - `{count}` - is the maximum number of rows to return, up to a limit of 500. This parameter is optional and defaults to 100 if not specified. - `{order}` - is a string containing the name of the attribute to sort on. This parameter is optional. Default value is totalCost. - `{direction}` - is a number that controls the direction of the sort. A value equal to or greater than 0 indicates ascending order; a value less than 0 indicates descending order. This parameter is optional and defaults to -1 if not specified. **Note:** - All calls to RealTheory APIs must be authenticated and authorized. See [Authentication](/v1/docs/authentication) for more details. - To retrieve all rows, increment the `{index}` by the `{count}` on each subsequent call until a response returns fewer rows than the `{count}` requested. See [Paging](/v1/docs/paging) for more details on how to page through all results. #### Example ``` GET myendpoint.realtheory.io/theory/api/v1/k8sreports/dailycostreport/statefulsets/search/query/metadata.name=my-statefulset/31d/31d?index=0&count=50&order=totalCost&direction=-1 ``` which returns the first 50 rows for the Daily Cost report for the last 31 days, listing only the stateful sets named `my-statefulset`, sorted by stateful sets with the highest total cost to the lowest total cost. #### Output Returns an array of [StatefulSetItem](/v1/docs/k8sreportsdailycoststatefulsetitem) objects. ``` [ { "id": "7ca5298c-2e28-4f31-84ff-a7119787f7d8", "metadata": { "id": "7ca5298c-2e28-4f31-84ff-a7119787f7d8", "name": "my-statefulset", "clusterId": "8ca6aa4c-8c7d-9fb9-c751-3e038f90d283", "clusterName": "realtheory-cluster-01", "customResourceDefinitionId": "00000000-0000-0000-0000-000000000000", "customResourceDefinitionName": "", "namespaceId": "c392dd78-b765-41a6-9285-d796cf730fad", "namespaceName": "realtheory-example", "customResourceId": "00000000-0000-0000-0000-000000000000", "customResourceName": "", "timestamp": "2024-03-08T00:31:27.4975629Z" }, "totalCost": 5.85435895, "costs": [ { "total": 0.19213541, "cpuUtilization": 11.166667, "memoryUtilization": 7.7842236, "utilization": 9.475417, "efficiency": 10.76, "timestamp": "2024-02-06T00:00:00Z" }, { "total": 0.18412977, "cpuUtilization": 11.326087, "memoryUtilization": 7.894035, "utilization": 9.610435, "efficiency": 10.914348, "timestamp": "2024-02-07T00:00:00Z" }, { "total": 0.18413823, "cpuUtilization": 11.282609, "memoryUtilization": 8.104556, "utilization": 9.692174, "efficiency": 10.902174, "timestamp": "2024-02-08T00:00:00Z" }, ... ], "clusterName": "realtheory-cluster-01", "namespaceName": "realtheory-example", "statefulSetName": "my-statefulset", "accountName": "RealTheory,Inc.", "accountOwner": "Joe.Bloggs" }, ... ] ``` **Note:** Content has been omitted from the JSON response above for brevity.