On this page

    SYS.ORGANIZATION.USAGE

    The sys.organization.usage table contains data for usage for an organization.

    Syntax
    SELECT * 
    FROM sys.organization.usage
    

    note:

    Queries to sys.organization.usage will return 90 days of usage data, if available.

    Example Output

    replica_idproject_idengine_idstart_timeend_timeengine_sizeinstance_typeinstance_hourly_cost_dcustotal_usage_dcus
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 03:45:05.8972021-12-21 04:00:00.0001m5d.4xlarge4.00.9934477777777778
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 04:00:00.0002021-12-21 05:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 05:00:00.0002021-12-21 06:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 06:00:00.0002021-12-21 07:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 07:00:00.0002021-12-21 08:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 08:00:00.0002021-12-21 09:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 09:00:00.0002021-12-21 10:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 10:00:00.0002021-12-21 11:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 11:00:00.0002021-12-21 12:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 12:00:00.000 2021-12-2113:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 13:00:00.0002021-12-21 14:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 14:00:00.0002021-12-21 15:00:00.0001m5d.4xlarge4.04.0
    1e3eb29e-ddfd-d02b-cf21-6d049d3cafbe0c6e634e-0546-4da8-8e81-6b7b9f15530c2049e2a8-fc8d-48bd-98ed-c1554dfaef0b2021-12-21 15:00:00.0002021-12-21 16:00:00.0001m5d.4xlarge4.04.0

    Fields

    FieldData TypeDescription
    replica_idvarcharThe UUID to identify the engine replica that this usage data point is for.
    project_idvarcharThe UUID to identify the project that this usage data point is for.
    engine_idvarcharThe UUID to identify the engine that that this usage data point is for.
    start_timetimestampThe engine replica start time.
    end_timetimestampThe engine replica stop time.
    engine_sizeintegerThe number of AWS instances that are provisioned for the replica.
    instance_typevarcharThe AWS instance type that makes up the engine.
    Enum: m5d.4xlarge, m5d.8xlarge
    instance_hourly_cost_dcusdoubleThe cost of the instance type in DCUs.
    total_usage_dcusdoubleThe cost in DCUs for the time that the engine was running. This is calculated by the time that the engine replica was running multiplied by the hourly cost of the instance type.