[ovirt-users] Postgresql tables

[Hari Prasanth Loganathan]

Appreciated for your help. Could you tell me how frequently the statistics
are updated in this table ?

I also found one more way to get the statistics, which is the recommended
way?

select * from
getdiskbydiskid('a570a8a4-d4ff-4826-bc39-50bb0b42785c','27e73630-3688-11e8-8432-000c29cc7b80','f');

Thanks,
Hari

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@
> 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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>             },
>> *            "name": "data.current.read",*
>>             "description": "Read data rate",
>>             "href": "/ovirt-engine/api/disks/a570a
>> 8a4-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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>             },
>>        *     "name": "data.current.write",*
>>             "description": "Write data rate",
>>             "href": "/ovirt-engine/api/disks/a570a
>> 8a4-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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>             },
>>      *       "name": "disk.read.latency",*
>>             "description": "Read latency",
>>             "href": "/ovirt-engine/api/disks/a570a
>> 8a4-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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>             },
>>   *          "name": "disk.write.latency",*
>>             "description": "Write latency",
>>             "href": "/ovirt-engine/api/disks/a570a
>> 8a4-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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>>                 "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>>             },
>>             "name": "disk.flush.latency",
>>             "description": "Flush latency",
>>             "href": "/ovirt-engine/api/disks/a570a
>> 8a4-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
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180419/57c4fb0a/attachment.html>