All Products
Search
Document Center

RDS Hour Data

Last Updated: Jul 08, 2019

API Name

QueryUserOmsData

Overview

You can call this API to get original usage data of RDS product.

Request parameters

Name Type Required Description
Table String Yes rds
DataType String Yes Time type, normally value is Hour
StartTime String Yes Data start time, format:yyyy-mm-ddThh:mm:ssZ
EndTime String Yes Data end time, format:yyyy-mm-ddThh:mm:ssZ
Maker String No Tag of last records of current request, using this parameter you can start next request with continuous records
PageSize Integer No 1~200,by default is 100

Response parameters

Name Type Required
HostId String User owned site
DBVersion String Database version
InstanceId String Instance Id
AdvancedMonitor String
Storage Integer Storage space, in Bytes
NetworkIn Integer The amount of data flowing into the RDS from the external network that occurred during the StartTime and EndTime , in Bytes
NetworkOut Integer The amount of data flowing out of the RDS to the external network that occurred during the StartTime and EndTime , in Bytes
BackupCharged String
ClassCode String Class Code
Memory Integer Memory capacity, in Bytes
Region String Region
ProviderId String Product supplier number, default 26842
DBType String Database type
SqlCollected String
InstanceUseType String Instance Use Type
InstanceName String Instance Name
EndTime String Billing data end time
StartTime String Billing data start time

Sample requests

For Hour:

  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

Sample responses

For Hour:

  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. }