[ovirt-users] Postgresql tables

[Benny Zlotnik]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180419/68e072e7/attachment.html>