[ovirt-users] Postgresql tables

[Yaniv Kaul]

May I ask what are you trying to achieve? Why not use the oVirt REST API?
Y.

On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan <
hariprasanth.l at msystechnologies.com> wrote:

> How frequently is the 'disk_all table' is updated with new statistics?
>
> On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan <
> hariprasanth.l at msystechnologies.com> wrote:
>
>> How is the disk id mapped to this table : disk_image_dynamic table?
>>
>> If I need statistics of all the disk, How can I get it?
>>
>> On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik <bzlotnik at redhat.com>
>> wrote:
>>
>>> It is in the disk_image_dynamic table
>>>
>>> On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan <
>>> hariprasanth.l at msystechnologies.com> wrote:
>>>
>>>> Hi Team,
>>>>
>>>> I am trying to get the disk level statistics using oVirt with the
>>>> following API,
>>>>
>>>> /ovirt-engine/api/disks/{unique_disk_id}/statistics/
>>>>
>>>>
>>>> *and I get this response : *
>>>>  {
>>>>     "statistic": [
>>>>         {
>>>>             "kind": "gauge",
>>>>             "type": "decimal",
>>>>             "unit": "bytes_per_second",
>>>>             "values": {
>>>>                 "value": [
>>>>                     {
>>>>                         "datum": 0
>>>>                     }
>>>>                 ]
>>>>             },
>>>>             "disk": {
>>>>                 "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>>>             },
>>>> *            "name": "data.current.read",*
>>>>             "description": "Read data rate",
>>>>             "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/33b9212b-f9cb-3fd0-b364-248fb61e1272",
>>>>             "id": "33b9212b-f9cb-3fd0-b364-248fb61e1272"
>>>>         },
>>>>         {
>>>>             "kind": "gauge",
>>>>             "type": "decimal",
>>>>             "unit": "bytes_per_second",
>>>>             "values": {
>>>>                 "value": [
>>>>                     {
>>>>                         "datum": 0
>>>>                     }
>>>>                 ]
>>>>             },
>>>>             "disk": {
>>>>                 "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>>>             },
>>>>        *     "name": "data.current.write",*
>>>>             "description": "Write data rate",
>>>>             "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/2f23addd-4ebd-3d82-a449-c28778bc33eb",
>>>>             "id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"
>>>>         },
>>>>         {
>>>>             "kind": "gauge",
>>>>             "type": "decimal",
>>>>             "unit": "seconds",
>>>>             "values": {
>>>>                 "value": [
>>>>                     {
>>>>                         "datum": 0
>>>>                     }
>>>>                 ]
>>>>             },
>>>>             "disk": {
>>>>                 "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>>>             },
>>>>      *       "name": "disk.read.latency",*
>>>>             "description": "Read latency",
>>>>             "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/3a7b3f72-d035-3bb9-b196-e86a4eb34993",
>>>>             "id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"
>>>>         },
>>>>         {
>>>>             "kind": "gauge",
>>>>             "type": "decimal",
>>>>             "unit": "seconds",
>>>>             "values": {
>>>>                 "value": [
>>>>                     {
>>>>                         "datum": 0
>>>>                     }
>>>>                 ]
>>>>             },
>>>>             "disk": {
>>>>                 "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>>>             },
>>>>   *          "name": "disk.write.latency",*
>>>>             "description": "Write latency",
>>>>             "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/b1e75c7b-cea4-37d2-8459-f7d68efc69a3",
>>>>             "id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"
>>>>         },
>>>>         {
>>>>             "kind": "gauge",
>>>>             "type": "decimal",
>>>>             "unit": "seconds",
>>>>             "values": {
>>>>                 "value": [
>>>>                     {
>>>>                         "datum": 0
>>>>                     }
>>>>                 ]
>>>>             },
>>>>             "disk": {
>>>>                 "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",
>>>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>>>             },
>>>>             "name": "disk.flush.latency",
>>>>             "description": "Flush latency",
>>>>             "href":
>>>> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0",
>>>>             "id": "9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0"
>>>>         }
>>>>     ]
>>>> }
>>>>
>>>> I am able to get the disk write and read latency, write and read
>>>> bandwidth.
>>>>
>>>>
>>>> *But I am not able to find the postgresql tables used for these
>>>> statistics in oVirt? *
>>>> *Could somebody let me know the statistics table for the disk?*
>>>>
>>>> Any help is much Appreciated.
>>>>
>>>> Thanks,
>>>> Harry
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at ovirt.org
>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>
>>>>
>>>
>>
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180420/f2a21442/attachment.html>