全部产品
云市场

RDS小时数据

更新时间:2019-07-08 09:10:36

接口名

QueryUserOmsData

描述

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

请求参数

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

返回参数

名称 类型 说明
HostId String 用户所属站点,cn为国内站
DBVersion String 数据库版本
InstanceId String 实例ID
AdvancedMonitor String
Storage Integer 存储空间,单位为Bytes
NetworkIn Integer 在StartTime和EndTime时间段内发生的从外部网络流入RDS的数据量,单位Bytes
NetworkOut Integer 在StartTime和EndTime时间段内发生的从RDS流出到外部网络的数据量,单位Bytes
BackupCharged String
ClassCode String 规格代码
Memory Integer 内存容量,单位为Bytes
Region String 地域
ProviderId String 产品供应商对应编号,默认26842
DBType String 数据库类型
SqlCollected String
InstanceUseType String 实例使用类型
InstanceName String 实例名称
EndTime String 计费数据发生结束时间
StartTime String 计费数据发生开始时间

请求示例

示例(按小时):

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

返回示例

示例(按小时):

  1. {
  2. "Data": {
  3. "OmsData": [
  4. {
  5. "DBVersion": "9.4",
  6. "InstanceId": "14163171",
  7. "NetworkIn": "0",
  8. "AdvancedMonitor": "off",
  9. "NetworkOut": "0",
  10. "Storage": "5368709120",
  11. "BackupCharged": "0",
  12. "ClassCode": "rds.pg.t1.small",
  13. "Memory": "1073741824",
  14. "Region": "cn-hangzhou",
  15. "ProviderId": "26842",
  16. "DBType": "PostgreSQL",
  17. "EndTime": "2019-04-23T10:00:00Z",
  18. "SqlCollected": "0",
  19. "StartTime": "2019-04-23T09:00:00Z",
  20. "InstanceUseType": "Primary",
  21. "InstanceName": "rm-bp12cz3ml9p020ef4"
  22. },
  23. {
  24. "DBVersion": "9.4",
  25. "InstanceId": "14163171",
  26. "NetworkIn": "0",
  27. "AdvancedMonitor": "off",
  28. "NetworkOut": "0",
  29. "Storage": "5368709120",
  30. "BackupCharged": "0",
  31. "ClassCode": "rds.pg.t1.small",
  32. "Memory": "1073741824",
  33. "Region": "cn-hangzhou",
  34. "ProviderId": "26842",
  35. "DBType": "PostgreSQL",
  36. "EndTime": "2019-04-23T11:00:00Z",
  37. "SqlCollected": "0",
  38. "StartTime": "2019-04-23T10:00:00Z",
  39. "InstanceUseType": "Primary",
  40. "InstanceName": "rm-bp12cz3ml9p020ef4"
  41. },
  42. {
  43. "DBVersion": "9.4",
  44. "InstanceId": "14163171",
  45. "NetworkIn": "0",
  46. "AdvancedMonitor": "off",
  47. "NetworkOut": "0",
  48. "Storage": "5368709120",
  49. "BackupCharged": "0",
  50. "ClassCode": "rds.pg.t1.small",
  51. "Memory": "1073741824",
  52. "Region": "cn-hangzhou",
  53. "ProviderId": "26842",
  54. "DBType": "PostgreSQL",
  55. "EndTime": "2019-04-23T12:00:00Z",
  56. "SqlCollected": "0",
  57. "StartTime": "2019-04-23T11:00:00Z",
  58. "InstanceUseType": "Primary",
  59. "InstanceName": "rm-bp12cz3ml9p020ef4"
  60. },
  61. {
  62. "DBVersion": "9.4",
  63. "InstanceId": "14163171",
  64. "NetworkIn": "0",
  65. "AdvancedMonitor": "off",
  66. "NetworkOut": "0",
  67. "Storage": "5368709120",
  68. "BackupCharged": "0",
  69. "ClassCode": "rds.pg.t1.small",
  70. "Memory": "1073741824",
  71. "Region": "cn-hangzhou",
  72. "ProviderId": "26842",
  73. "DBType": "PostgreSQL",
  74. "EndTime": "2019-04-23T13:00:00Z",
  75. "SqlCollected": "0",
  76. "StartTime": "2019-04-23T12:00:00Z",
  77. "InstanceUseType": "Primary",
  78. "InstanceName": "rm-bp12cz3ml9p020ef4"
  79. },
  80. {
  81. "DBVersion": "9.4",
  82. "InstanceId": "14163171",
  83. "NetworkIn": "0",
  84. "AdvancedMonitor": "off",
  85. "NetworkOut": "0",
  86. "Storage": "5368709120",
  87. "BackupCharged": "0",
  88. "ClassCode": "rds.pg.t1.small",
  89. "Memory": "1073741824",
  90. "Region": "cn-hangzhou",
  91. "ProviderId": "26842",
  92. "DBType": "PostgreSQL",
  93. "EndTime": "2019-04-23T14:00:00Z",
  94. "SqlCollected": "0",
  95. "StartTime": "2019-04-23T13:00:00Z",
  96. "InstanceUseType": "Primary",
  97. "InstanceName": "rm-bp12cz3ml9p020ef4"
  98. },
  99. {
  100. "DBVersion": "9.4",
  101. "InstanceId": "14163171",
  102. "NetworkIn": "0",
  103. "AdvancedMonitor": "off",
  104. "NetworkOut": "0",
  105. "Storage": "5368709120",
  106. "BackupCharged": "0",
  107. "ClassCode": "rds.pg.t1.small",
  108. "Memory": "1073741824",
  109. "Region": "cn-hangzhou",
  110. "ProviderId": "26842",
  111. "DBType": "PostgreSQL",
  112. "EndTime": "2019-04-23T15:00:00Z",
  113. "SqlCollected": "0",
  114. "StartTime": "2019-04-23T14:00:00Z",
  115. "InstanceUseType": "Primary",
  116. "InstanceName": "rm-bp12cz3ml9p020ef4"
  117. },
  118. {
  119. "DBVersion": "9.4",
  120. "InstanceId": "14163171",
  121. "NetworkIn": "0",
  122. "AdvancedMonitor": "off",
  123. "NetworkOut": "0",
  124. "Storage": "5368709120",
  125. "BackupCharged": "0",
  126. "ClassCode": "rds.pg.t1.small",
  127. "Memory": "1073741824",
  128. "Region": "cn-hangzhou",
  129. "ProviderId": "26842",
  130. "DBType": "PostgreSQL",
  131. "EndTime": "2019-04-23T16:00:00Z",
  132. "SqlCollected": "0",
  133. "StartTime": "2019-04-23T15:00:00Z",
  134. "InstanceUseType": "Primary",
  135. "InstanceName": "rm-bp12cz3ml9p020ef4"
  136. },
  137. {
  138. "DBVersion": "9.4",
  139. "InstanceId": "14163171",
  140. "NetworkIn": "0",
  141. "AdvancedMonitor": "off",
  142. "NetworkOut": "0",
  143. "Storage": "5368709120",
  144. "BackupCharged": "0",
  145. "ClassCode": "rds.pg.t1.small",
  146. "Memory": "1073741824",
  147. "Region": "cn-hangzhou",
  148. "ProviderId": "26842",
  149. "DBType": "PostgreSQL",
  150. "EndTime": "2019-04-23T17:00:00Z",
  151. "SqlCollected": "0",
  152. "StartTime": "2019-04-23T16:00:00Z",
  153. "InstanceUseType": "Primary",
  154. "InstanceName": "rm-bp12cz3ml9p020ef4"
  155. },
  156. {
  157. "DBVersion": "9.4",
  158. "InstanceId": "14163171",
  159. "NetworkIn": "0",
  160. "AdvancedMonitor": "off",
  161. "NetworkOut": "0",
  162. "Storage": "5368709120",
  163. "BackupCharged": "0",
  164. "ClassCode": "rds.pg.t1.small",
  165. "Memory": "1073741824",
  166. "Region": "cn-hangzhou",
  167. "ProviderId": "26842",
  168. "DBType": "PostgreSQL",
  169. "EndTime": "2019-04-23T18:00:00Z",
  170. "SqlCollected": "0",
  171. "StartTime": "2019-04-23T17:00:00Z",
  172. "InstanceUseType": "Primary",
  173. "InstanceName": "rm-bp12cz3ml9p020ef4"
  174. },
  175. {
  176. "DBVersion": "9.4",
  177. "InstanceId": "14163171",
  178. "NetworkIn": "0",
  179. "AdvancedMonitor": "off",
  180. "NetworkOut": "0",
  181. "Storage": "5368709120",
  182. "BackupCharged": "0",
  183. "ClassCode": "rds.pg.t1.small",
  184. "Memory": "1073741824",
  185. "Region": "cn-hangzhou",
  186. "ProviderId": "26842",
  187. "DBType": "PostgreSQL",
  188. "EndTime": "2019-04-23T19:00:00Z",
  189. "SqlCollected": "0",
  190. "StartTime": "2019-04-23T18:00:00Z",
  191. "InstanceUseType": "Primary",
  192. "InstanceName": "rm-bp12cz3ml9p020ef4"
  193. },
  194. {
  195. "DBVersion": "9.4",
  196. "InstanceId": "14163171",
  197. "NetworkIn": "0",
  198. "AdvancedMonitor": "off",
  199. "NetworkOut": "0",
  200. "Storage": "5368709120",
  201. "BackupCharged": "0",
  202. "ClassCode": "rds.pg.t1.small",
  203. "Memory": "1073741824",
  204. "Region": "cn-hangzhou",
  205. "ProviderId": "26842",
  206. "DBType": "PostgreSQL",
  207. "EndTime": "2019-04-23T20:00:00Z",
  208. "SqlCollected": "0",
  209. "StartTime": "2019-04-23T19:00:00Z",
  210. "InstanceUseType": "Primary",
  211. "InstanceName": "rm-bp12cz3ml9p020ef4"
  212. },
  213. {
  214. "DBVersion": "9.4",
  215. "InstanceId": "14163171",
  216. "NetworkIn": "0",
  217. "AdvancedMonitor": "off",
  218. "NetworkOut": "0",
  219. "Storage": "5368709120",
  220. "BackupCharged": "0",
  221. "ClassCode": "rds.pg.t1.small",
  222. "Memory": "1073741824",
  223. "Region": "cn-hangzhou",
  224. "ProviderId": "26842",
  225. "DBType": "PostgreSQL",
  226. "EndTime": "2019-04-23T21:00:00Z",
  227. "SqlCollected": "0",
  228. "StartTime": "2019-04-23T20:00:00Z",
  229. "InstanceUseType": "Primary",
  230. "InstanceName": "rm-bp12cz3ml9p020ef4"
  231. },
  232. {
  233. "DBVersion": "9.4",
  234. "InstanceId": "14163171",
  235. "NetworkIn": "0",
  236. "AdvancedMonitor": "off",
  237. "NetworkOut": "0",
  238. "Storage": "5368709120",
  239. "BackupCharged": "0",
  240. "ClassCode": "rds.pg.t1.small",
  241. "Memory": "1073741824",
  242. "Region": "cn-hangzhou",
  243. "ProviderId": "26842",
  244. "DBType": "PostgreSQL",
  245. "EndTime": "2019-04-23T22:00:00Z",
  246. "SqlCollected": "0",
  247. "StartTime": "2019-04-23T21:00:00Z",
  248. "InstanceUseType": "Primary",
  249. "InstanceName": "rm-bp12cz3ml9p020ef4"
  250. },
  251. {
  252. "DBVersion": "9.4",
  253. "InstanceId": "14163171",
  254. "NetworkIn": "0",
  255. "AdvancedMonitor": "off",
  256. "NetworkOut": "0",
  257. "Storage": "5368709120",
  258. "BackupCharged": "0",
  259. "ClassCode": "rds.pg.t1.small",
  260. "Memory": "1073741824",
  261. "Region": "cn-hangzhou",
  262. "ProviderId": "26842",
  263. "DBType": "PostgreSQL",
  264. "EndTime": "2019-04-23T23:00:00Z",
  265. "SqlCollected": "0",
  266. "StartTime": "2019-04-23T22:00:00Z",
  267. "InstanceUseType": "Primary",
  268. "InstanceName": "rm-bp12cz3ml9p020ef4"
  269. },
  270. {
  271. "DBVersion": "9.4",
  272. "InstanceId": "14163171",
  273. "NetworkIn": "0",
  274. "AdvancedMonitor": "off",
  275. "NetworkOut": "0",
  276. "Storage": "5368709120",
  277. "BackupCharged": "0",
  278. "ClassCode": "rds.pg.t1.small",
  279. "Memory": "1073741824",
  280. "Region": "cn-hangzhou",
  281. "ProviderId": "26842",
  282. "DBType": "PostgreSQL",
  283. "EndTime": "2019-04-24T00:00:00Z",
  284. "SqlCollected": "0",
  285. "StartTime": "2019-04-23T23:00:00Z",
  286. "InstanceUseType": "Primary",
  287. "InstanceName": "rm-bp12cz3ml9p020ef4"
  288. },
  289. {
  290. "DBVersion": "9.4",
  291. "InstanceId": "14163171",
  292. "NetworkIn": "0",
  293. "AdvancedMonitor": "off",
  294. "NetworkOut": "0",
  295. "Storage": "5368709120",
  296. "BackupCharged": "0",
  297. "ClassCode": "rds.pg.t1.small",
  298. "Memory": "1073741824",
  299. "Region": "cn-hangzhou",
  300. "ProviderId": "26842",
  301. "DBType": "PostgreSQL",
  302. "EndTime": "2019-04-24T01:00:00Z",
  303. "SqlCollected": "0",
  304. "StartTime": "2019-04-24T00:00:00Z",
  305. "InstanceUseType": "Primary",
  306. "InstanceName": "rm-bp12cz3ml9p020ef4"
  307. },
  308. {
  309. "DBVersion": "9.4",
  310. "InstanceId": "14163171",
  311. "NetworkIn": "0",
  312. "AdvancedMonitor": "off",
  313. "NetworkOut": "0",
  314. "Storage": "5368709120",
  315. "BackupCharged": "0",
  316. "ClassCode": "rds.pg.t1.small",
  317. "Memory": "1073741824",
  318. "Region": "cn-hangzhou",
  319. "ProviderId": "26842",
  320. "DBType": "PostgreSQL",
  321. "EndTime": "2019-04-24T02:00:00Z",
  322. "SqlCollected": "0",
  323. "StartTime": "2019-04-24T01:00:00Z",
  324. "InstanceUseType": "Primary",
  325. "InstanceName": "rm-bp12cz3ml9p020ef4"
  326. },
  327. {
  328. "DBVersion": "9.4",
  329. "InstanceId": "14163171",
  330. "NetworkIn": "0",
  331. "AdvancedMonitor": "off",
  332. "NetworkOut": "0",
  333. "Storage": "5368709120",
  334. "BackupCharged": "0",
  335. "ClassCode": "rds.pg.t1.small",
  336. "Memory": "1073741824",
  337. "Region": "cn-hangzhou",
  338. "ProviderId": "26842",
  339. "DBType": "PostgreSQL",
  340. "EndTime": "2019-04-24T03:00:00Z",
  341. "SqlCollected": "0",
  342. "StartTime": "2019-04-24T02:00:00Z",
  343. "InstanceUseType": "Primary",
  344. "InstanceName": "rm-bp12cz3ml9p020ef4"
  345. },
  346. {
  347. "DBVersion": "9.4",
  348. "InstanceId": "14163171",
  349. "NetworkIn": "0",
  350. "AdvancedMonitor": "off",
  351. "NetworkOut": "0",
  352. "Storage": "5368709120",
  353. "BackupCharged": "0",
  354. "ClassCode": "rds.pg.t1.small",
  355. "Memory": "1073741824",
  356. "Region": "cn-hangzhou",
  357. "ProviderId": "26842",
  358. "DBType": "PostgreSQL",
  359. "EndTime": "2019-04-24T04:00:00Z",
  360. "SqlCollected": "0",
  361. "StartTime": "2019-04-24T03:00:00Z",
  362. "InstanceUseType": "Primary",
  363. "InstanceName": "rm-bp12cz3ml9p020ef4"
  364. },
  365. {
  366. "DBVersion": "9.4",
  367. "InstanceId": "14163171",
  368. "NetworkIn": "0",
  369. "AdvancedMonitor": "off",
  370. "NetworkOut": "0",
  371. "Storage": "5368709120",
  372. "BackupCharged": "0",
  373. "ClassCode": "rds.pg.t1.small",
  374. "Memory": "1073741824",
  375. "Region": "cn-hangzhou",
  376. "ProviderId": "26842",
  377. "DBType": "PostgreSQL",
  378. "EndTime": "2019-04-24T05:00:00Z",
  379. "SqlCollected": "0",
  380. "StartTime": "2019-04-24T04:00:00Z",
  381. "InstanceUseType": "Primary",
  382. "InstanceName": "rm-bp12cz3ml9p020ef4"
  383. }
  384. ],
  385. "HostId": "cn"
  386. },
  387. "Message": "Successful!",
  388. "RequestId": "F9A2044E-71FA-4FC5-BD6D-432951BBFB7E",
  389. "Success": true,
  390. "Code": "Success"
  391. }