
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

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

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

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi Hari, there are also another way how to get VM stats. You could hook into VDSM, see https://www.ovirt.org/develop/developer-guide/vdsm/vdsm-client/, command vdsm-client Host getAllVmStats Peter On 19/04/2018 18:48, Hari Prasanth Loganathan wrote:
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 <mailto: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 <mailto: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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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 <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
- -- *Peter Hudec* Infraštruktúrny architekt phudec@cnc.sk <mailto:phudec@cnc.sk> *CNC, a.s.* Borská 6, 841 04 Bratislava Recepcia: +421 2 35 000 100 Mobil:+421 905 997 203 *www.cnc.sk* <http:///www.cnc.sk> -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZF8gACgkQQnvVWOJ3 5BBESw//dlAMwvj7MeI+6I4404tVS7peSsWkaxP0QKytw2ng11ilS9P+MsASDRVN ZJxbnwxK26kR58uh3If1S8DJQ4/l/mTYZkncd/BVrwWr/gR4KwLPN4HE0KPOarSW aqf5G2RPHHTxjko7NM9wTHxpck0bpRhBJU/iBnpGz9hJ3mkjxLruBaN0ZztXwS6P j42lJxIrVfcANl/5KGrndZYqPtqBtc2rlAmmO0IfHiTvbQb4tvUQyc5v05+UUsZa vCddamDDJAMn93locGykt6ySA9ZMhrQsx0sax3oKoa3vJ3NP03r+9fX8J906jRcX GN6k5iDG+yXcxCAHEctW2e6iyysBvysoML3ejmPLwD9+W0pG87xo6GH5Cv41CYYn dP0OSoQkZLOOJdchkfbce/mytIJHHdTOHPzjSMMBaDLgNWD3Qa2HeeTUMO9e6tao x3pfJUOxz2DSjOdHX7lo1IOsl4ctez3+I8nJxwjNYhcZF/Pttb529SoYp+s+ZCx6 bpKIVatUZhuBpjoayIxy1/HTbTyVuaBy59ogXvYOb+HotmdwQYBo9ydp9lh+1NF6 FRTRsoYuKHzf2/wOCri9mk6w2MNdSOZILWp7gxmxUWAtFtMoqNoWPoqreszQgp+d sGoVlUFwrXgbPab0dZvfje0qKsSbKZ1g4eyZvsbehcRw6C1ChHI= =9IA+ -----END PGP SIGNATURE-----

Thanks I will look into vdsm client. 1) In PostgreSQL how frequently the disk statitsitics are updated ? 2) Where can I find the history of disk statitsitcs? On Fri, 20 Apr 2018 at 3:57 AM, Peter Hudec <phudec@cnc.sk> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Hi Hari,
there are also another way how to get VM stats.
You could hook into VDSM, see https://www.ovirt.org/develop/developer-guide/vdsm/vdsm-client/, command vdsm-client Host getAllVmStats
Peter
On 19/04/2018 18:48, Hari Prasanth Loganathan wrote:
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 <mailto: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 <mailto: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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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 <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
- -- *Peter Hudec* Infraštruktúrny architekt phudec@cnc.sk <mailto:phudec@cnc.sk>
*CNC, a.s.* Borská 6, 841 04 Bratislava Recepcia: +421 2 35 000 100
Mobil:+421 905 997 203 *www.cnc.sk* <http:///www.cnc.sk>
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZF8gACgkQQnvVWOJ3 5BBESw//dlAMwvj7MeI+6I4404tVS7peSsWkaxP0QKytw2ng11ilS9P+MsASDRVN ZJxbnwxK26kR58uh3If1S8DJQ4/l/mTYZkncd/BVrwWr/gR4KwLPN4HE0KPOarSW aqf5G2RPHHTxjko7NM9wTHxpck0bpRhBJU/iBnpGz9hJ3mkjxLruBaN0ZztXwS6P j42lJxIrVfcANl/5KGrndZYqPtqBtc2rlAmmO0IfHiTvbQb4tvUQyc5v05+UUsZa vCddamDDJAMn93locGykt6ySA9ZMhrQsx0sax3oKoa3vJ3NP03r+9fX8J906jRcX GN6k5iDG+yXcxCAHEctW2e6iyysBvysoML3ejmPLwD9+W0pG87xo6GH5Cv41CYYn dP0OSoQkZLOOJdchkfbce/mytIJHHdTOHPzjSMMBaDLgNWD3Qa2HeeTUMO9e6tao x3pfJUOxz2DSjOdHX7lo1IOsl4ctez3+I8nJxwjNYhcZF/Pttb529SoYp+s+ZCx6 bpKIVatUZhuBpjoayIxy1/HTbTyVuaBy59ogXvYOb+HotmdwQYBo9ydp9lh+1NF6 FRTRsoYuKHzf2/wOCri9mk6w2MNdSOZILWp7gxmxUWAtFtMoqNoWPoqreszQgp+d sGoVlUFwrXgbPab0dZvfje0qKsSbKZ1g4eyZvsbehcRw6C1ChHI= =9IA+ -----END PGP SIGNATURE----- _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

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

How frequently is the 'disk_all table' is updated with new statistics? On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
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/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-3fd 0-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-3d8 2-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-3bb 9-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-37d 2-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-3e8 d-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

May I ask what are you trying to achieve? Why not use the oVirt REST API? Y. On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
How frequently is the 'disk_all table' is updated with new statistics?
On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
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
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

Ovirt API doesn't provide the API to get all the disk statistics at once. We need to hit for each Disk. It is an overhead. On Fri, Apr 20, 2018 at 11:43 AM, Yaniv Kaul <ykaul@redhat.com> wrote:
May I ask what are you trying to achieve? Why not use the oVirt REST API? Y.
On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan <hariprasanth.l@ msystechnologies.com> wrote:
How frequently is the 'disk_all table' is updated with new statistics?
On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan < hariprasanth.l@msystechnologies.com> wrote:
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
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Yes, it does, but you have to use follow=statistics on disks endpoint, see See http://ovirt.github.io/ovirt-engine-api-model/4.2/#documents/003_common_ concepts/follow For all disks https://dipovirt-engine02.cnc.sk/ovirt-engine/api/disks?follow=statistic s For all disks of one VMS https://dipovirt-engine02.cnc.sk/ovirt-engine/api/vms/963d7540-619c-437d - -978a-86e550e5e571?follow=disk_attachments.disk.statistics Peter On 20/04/2018 08:14, Hari Prasanth Loganathan wrote:
Ovirt API doesn't provide the API to get all the disk statistics at once. We need to hit for each Disk. It is an overhead.
On Fri, Apr 20, 2018 at 11:43 AM, Yaniv Kaul <ykaul@redhat.com <mailto:ykaul@redhat.com>> wrote:
May I ask what are you trying to achieve? Why not use the oVirt REST API? Y.
On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan <hariprasanth.l@msystechnologies.com <mailto:hariprasanth.l@msystechnologies.com>> wrote:
How frequently is the 'disk_all table' is updated with new statistics?
On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan <hariprasanth.l@msystechnologies.com <mailto:hariprasanth.l@msystechnologies.com>> wrote:
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 <mailto: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 <mailto: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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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 <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
_______________________________________________ Users mailing list Users@ovirt.org <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
- -- *Peter Hudec* Infraštruktúrny architekt phudec@cnc.sk <mailto:phudec@cnc.sk> *CNC, a.s.* Borská 6, 841 04 Bratislava Recepcia: +421 2 35 000 100 Mobil:+421 905 997 203 *www.cnc.sk* <http:///www.cnc.sk> -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZhxkACgkQQnvVWOJ3 5BA7+hAAp194pPXA1q1kCC1lkXZBISrcJsubzgEjD6lwZX936tHDGFqWHAQY6QZJ xX9+3L7VXkpmk/eGqvFvUOt7FQJUNGTV37KobdxmgtlJ9lLXDBu62LN92RtVpb9L U7LYvh25UHYmCo5hD6YQgLFi45UnBqoS8l8Js2CtjW5ZWQzOqlx5//zdZtZjg+qy XVs82Ircx8S0Ue4e70YFhghN5y6UHPiyo+fq2QFLtsDIm0blOfGd1VfJ93QQZYEE pc4svxnGDZH9Nd5sTTqH7pbaTE5O52AK1vud2Sn0PC8wK09xpuF2PdmBqBVwat6A D0ikPl0m9GpNoaI/hcGM70dNqoO6HfWnj4fio/67qloCX+9j46qSYtRYw0KPk1dQ JNQwY7bdbwZfSutcxiswz3usglCgfl0NgOKglzY2rLsqbwm52YhEZOH9IBMiaisP RxRyF6AVasuYkp/wAoEoZGF0yzJhYUWLzrZkMYCk2/pAr/drCcpYefSKwLMOp2i7 Wz1iAj5X2hf+CKJ2kP++cXVmhki6S+K3B2+IE3mazrSOGtY5os95NWGfxRzUUJSE +9B1mPorHJXCIWJkPUtnCegVSJ8/Vsuom8p95GhJtvbqk3TheS1SfqeGKHJtJWdj C15HfIZfb9VO6YMl7zzinJaB83P0bTNs4PwQwqj0lWMEPzVA1SM= =aqdJ -----END PGP SIGNATURE-----

Thanks Much. You solved all my problems. On Fri, Apr 20, 2018 at 11:52 AM, Peter Hudec <phudec@cnc.sk> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512
Yes, it does, but you have to use follow=statistics on disks endpoint, see See http://ovirt.github.io/ovirt-engine-api-model/4.2/#documents/003_common_ concepts/follow
For all disks https://dipovirt-engine02.cnc.sk/ovirt-engine/api/disks?follow=statistic s
For all disks of one VMS https://dipovirt-engine02.cnc.sk/ovirt-engine/api/vms/963d7540-619c-437d - -978a-86e550e5e571?follow=disk_attachments.disk.statistics
Peter
On 20/04/2018 08:14, Hari Prasanth Loganathan wrote:
Ovirt API doesn't provide the API to get all the disk statistics at once. We need to hit for each Disk. It is an overhead.
On Fri, Apr 20, 2018 at 11:43 AM, Yaniv Kaul <ykaul@redhat.com <mailto:ykaul@redhat.com>> wrote:
May I ask what are you trying to achieve? Why not use the oVirt REST API? Y.
On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan <hariprasanth.l@msystechnologies.com <mailto:hariprasanth.l@msystechnologies.com>> wrote:
How frequently is the 'disk_all table' is updated with new statistics?
On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan <hariprasanth.l@msystechnologies.com <mailto:hariprasanth.l@msystechnologies.com>> wrote:
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 <mailto: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 <mailto: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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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/statisti cs/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 <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
_______________________________________________ Users mailing list Users@ovirt.org <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users <http://lists.ovirt.org/mailman/listinfo/users>
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
- -- *Peter Hudec* Infraštruktúrny architekt phudec@cnc.sk <mailto:phudec@cnc.sk>
*CNC, a.s.* Borská 6, 841 04 Bratislava Recepcia: +421 2 35 000 100
Mobil:+421 905 997 203 *www.cnc.sk* <http:///www.cnc.sk>
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZhxkACgkQQnvVWOJ3 5BA7+hAAp194pPXA1q1kCC1lkXZBISrcJsubzgEjD6lwZX936tHDGFqWHAQY6QZJ xX9+3L7VXkpmk/eGqvFvUOt7FQJUNGTV37KobdxmgtlJ9lLXDBu62LN92RtVpb9L U7LYvh25UHYmCo5hD6YQgLFi45UnBqoS8l8Js2CtjW5ZWQzOqlx5//zdZtZjg+qy XVs82Ircx8S0Ue4e70YFhghN5y6UHPiyo+fq2QFLtsDIm0blOfGd1VfJ93QQZYEE pc4svxnGDZH9Nd5sTTqH7pbaTE5O52AK1vud2Sn0PC8wK09xpuF2PdmBqBVwat6A D0ikPl0m9GpNoaI/hcGM70dNqoO6HfWnj4fio/67qloCX+9j46qSYtRYw0KPk1dQ JNQwY7bdbwZfSutcxiswz3usglCgfl0NgOKglzY2rLsqbwm52YhEZOH9IBMiaisP RxRyF6AVasuYkp/wAoEoZGF0yzJhYUWLzrZkMYCk2/pAr/drCcpYefSKwLMOp2i7 Wz1iAj5X2hf+CKJ2kP++cXVmhki6S+K3B2+IE3mazrSOGtY5os95NWGfxRzUUJSE +9B1mPorHJXCIWJkPUtnCegVSJ8/Vsuom8p95GhJtvbqk3TheS1SfqeGKHJtJWdj C15HfIZfb9VO6YMl7zzinJaB83P0bTNs4PwQwqj0lWMEPzVA1SM= =aqdJ -----END PGP SIGNATURE----- _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
participants (4)
-
Benny Zlotnik
-
Hari Prasanth Loganathan
-
Peter Hudec
-
Yaniv Kaul