文档

RDS小时数据

更新时间:
一键部署

QueryUserOmsData

描述

查询RDS产品按小时计量的数据信息。

请求参数

名称类型是否必填说明
TableStringrds
DataTypeString计量数据时间类型。Hour:小时
StartTimeString请求的开始时间。日期格式按照ISO8601标准标示,并需要使用UTC时间。格式:yyyy-mm-ddThh:mm:ssZ
EndTimeString请求的结束时间。日期格式按照ISO8601标准标示,并需要使用UTC时间。格式:yyyy-mm-ddThh:mm:ssZ
MakerString设定结果从NextToken之后按字母排序的第一个开始返回。默认从头返回
PageSizeInteger分页查询每页行数,1~200,默认100行

返回参数

名称类型说明
HostIdString用户所属站点,cn为中国内地站
DBVersionString数据库版本
InstanceIdString实例ID
AdvancedMonitorString
StorageInteger存储空间,单位为Bytes
NetworkInInteger在StartTime和EndTime时间段内发生的从外部网络流入RDS的数据量,单位Bytes
NetworkOutInteger在StartTime和EndTime时间段内发生的从RDS流出到外部网络的数据量,单位Bytes
BackupChargedString
ClassCodeString规格代码
MemoryInteger内存容量,单位为Bytes
RegionString地域
ProviderIdString产品供应商对应编号,默认26842
DBTypeString数据库类型
SqlCollectedString
InstanceUseTypeString实例使用类型
InstanceNameString实例名称
EndTimeString计费数据发生结束时间
StartTimeString计费数据发生开始时间

请求示例

示例(按小时):

https://business.aliyuncs.com/? Action=QueryUserOmsData
&DataType=Hour
&EndTime=2019-04-24T09:15:54Z
&StartTime=2019-03-18T09:15:54Z
&Table=rds
&<公共请求参数>
            

返回示例

示例(按小时):

{
    "Data": {
        "OmsData": [
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T10:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T09:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T11:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T10:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T12:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T11:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T13:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T12:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T14:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T13:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T15:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T14:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T16:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T15:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T17:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T16:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T18:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T17:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T19:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T18:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T20:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T19:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T21:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T20:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T22:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T21:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-23T23:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T22:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-24T00:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-23T23:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-24T01:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-24T00:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-24T02:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-24T01:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-24T03:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-24T02:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-24T04:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-24T03:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            },
            {
                "DBVersion": "9.4",
                "InstanceId": "14163171",
                "NetworkIn": "0",
                "AdvancedMonitor": "off",
                "NetworkOut": "0",
                "Storage": "5368709120",
                "BackupCharged": "0",
                "ClassCode": "rds.pg.t1.small",
                "Memory": "1073741824",
                "Region": "cn-hangzhou",
                "ProviderId": "26842",
                "DBType": "PostgreSQL",
                "EndTime": "2019-04-24T05:00:00Z",
                "SqlCollected": "0",
                "StartTime": "2019-04-24T04:00:00Z",
                "InstanceUseType": "Primary",
                "InstanceName": "rm-bp12cz3ml9p020ef4"
            }
        ],
        "HostId": "cn"
    },
    "Message": "Successful!",
    "RequestId": "F9A2044E-71FA-4FC5-BD6D-432951BBFB7E",
    "Success": true,
    "Code": "Success"
}
            
  • 本页导读 (0)
文档反馈