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@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