Skip to main content

workspace_usage_totals

Creates, updates, deletes, gets or lists a workspace_usage_totals resource.

Overview​

Nameworkspace_usage_totals
TypeResource
Idrailway.billing.workspace_usage_totals

Fields​

The following fields are returned by SELECT queries:

One row per AggregatedUsage. The aggregated usage of a single measurement.

NameDatatypeDescription
measurementstringThe measurement that was aggregated. (AGENT_CACHE_READ_TOKENS, AGENT_CACHE_WRITE_TOKENS, AGENT_INPUT_TOKENS, AGENT_OUTPUT_TOKENS, AGENT_SPEND_USD, BACKUP_USAGE_GB, CPU_LIMIT, CPU_USAGE, CPU_USAGE_2, DISK_USAGE_GB, EPHEMERAL_DISK_USAGE_GB, MEASUREMENT_UNSPECIFIED, MEMORY_LIMIT_GB, MEMORY_USAGE_GB, NETWORK_RX_GB, NETWORK_TX_GB, UNRECOGNIZED)
tagsobjectThe tags that were used to group the metric. Only the tags that were used in the groupBy will be present.
valuenumberThe aggregated value.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectmeasurementsend_date, include_deleted, start_date, workspace_idWorkspace-wide SUM of the same UI usage rollup as usage grouped by project. Use this for the usage-page header so it does not wait on per-project rows. Deleted projects that still bill are included when includeDeleted is true. Backed by the Railway GraphQL query workspaceUsageTotals.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
measurementsstringGraphQL list literal of MetricMeasurement values, for example [AGENT_CACHE_READ_TOKENS, AGENT_CACHE_WRITE_TOKENS].
end_datestring (date-time)
include_deletedbooleanWhether to include deleted projects in the usage.
start_datestring (date-time)
workspace_idstring

SELECT examples​

Workspace-wide SUM of the same UI usage rollup as usage grouped by project. Use this for the usage-page header so it does not wait on per-project rows. Deleted projects that still bill are included when includeDeleted is true. Backed by the Railway GraphQL query workspaceUsageTotals.

SELECT
measurement,
tags,
value
FROM railway.billing.workspace_usage_totals
WHERE measurements = '{{ measurements }}' -- required
AND end_date = '{{ end_date }}'
AND include_deleted = '{{ include_deleted }}'
AND start_date = '{{ start_date }}'
AND workspace_id = '{{ workspace_id }}'
;