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@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/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@ovirt.org
http://lists.ovirt.org/mailman/listinfo/users