[ovirt-users] Postgresql tables

[Hari Prasanth Loganathan]

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