<div dir="auto">Thanks I will look into vdsm client.</div><div dir="auto"><br></div><div dir="auto">1) In PostgreSQL how frequently the disk statitsitics are updated ? </div><div dir="auto">2) Where can I find the history of disk statitsitcs?</div><div dir="auto"><br></div><div dir="auto"><br></div><div><br><div class="gmail_quote"><div>On Fri, 20 Apr 2018 at 3:57 AM, Peter Hudec <<a href="mailto:phudec@cnc.sk">phudec@cnc.sk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">-----BEGIN PGP SIGNED MESSAGE-----<br>
Hash: SHA512<br>
<br>
Hi Hari,<br>
<br>
there are also another way how to get VM stats.<br>
<br>
You could hook into VDSM, see<br>
<a href="https://www.ovirt.org/develop/developer-guide/vdsm/vdsm-client/" rel="noreferrer" target="_blank">https://www.ovirt.org/develop/developer-guide/vdsm/vdsm-client/</a>,<br>
command vdsm-client Host getAllVmStats<br>
<br>
Peter<br>
<br>
On 19/04/2018 18:48, Hari Prasanth Loganathan wrote:<br>
> Appreciated for your help. Could you tell me how frequently the <br>
> statistics are updated in this table ?<br>
> <br>
> I also found one more way to get the statistics, which is the <br>
> recommended way?<br>
> <br>
> select * from <br>
> getdiskbydiskid('a570a8a4-d4ff-4826-bc39-50bb0b42785c','27e73630-3688-<br>
11e8-8432-000c29cc7b80','f');<br>
><br>
> Thanks, Hari<br>
> <br>
> On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik<br>
> <<a href="mailto:bzlotnik@redhat.com" target="_blank">bzlotnik@redhat.com</a> <mailto:<a href="mailto:bzlotnik@redhat.com" target="_blank">bzlotnik@redhat.com</a>>> wrote:<br>
> <br>
> It is in the disk_image_dynamic table<br>
> <br>
> On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan <br>
> <<a href="mailto:hariprasanth.l@msystechnologies.com" target="_blank">hariprasanth.l@msystechnologies.com</a> <br>
> <mailto:<a href="mailto:hariprasanth.l@msystechnologies.com" target="_blank">hariprasanth.l@msystechnologies.com</a>>> wrote:<br>
> <br>
> Hi Team,<br>
> <br>
> I am trying to get the disk level statistics using oVirt with the<br>
> following API,<br>
> <br>
> /ovirt-engine/api/disks/{unique_disk_id}/statistics/<br>
> <br>
> *and I get this response : * { "statistic": [ { "kind": "gauge", <br>
> "type": "decimal", "unit": "bytes_per_second", "values": { "value":<br>
> [ { "datum": 0 } ] }, "disk": { "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c", <br>
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c" },* "name":<br>
> "data.current.read",* "description": "Read data rate", "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statisti<br>
cs/33b9212b-f9cb-3fd0-b364-248fb61e1272",<br>
><br>
> <br>
"id": "33b9212b-f9cb-3fd0-b364-248fb61e1272"<br>
> }, { "kind": "gauge", "type": "decimal", "unit":<br>
> "bytes_per_second", "values": { "value": [ { "datum": 0 } ] }, <br>
> "disk": { "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c", <br>
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c" }, * "name":<br>
> "data.current.write",* "description": "Write data rate", "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statisti<br>
cs/2f23addd-4ebd-3d82-a449-c28778bc33eb",<br>
><br>
> <br>
"id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"<br>
> }, { "kind": "gauge", "type": "decimal", "unit": "seconds", <br>
> "values": { "value": [ { "datum": 0 } ] }, "disk": { "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c", <br>
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c" }, * "name":<br>
> "disk.read.latency",* "description": "Read latency", "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statisti<br>
cs/3a7b3f72-d035-3bb9-b196-e86a4eb34993",<br>
><br>
> <br>
"id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"<br>
> }, { "kind": "gauge", "type": "decimal", "unit": "seconds", <br>
> "values": { "value": [ { "datum": 0 } ] }, "disk": { "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c", <br>
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c" }, * "name":<br>
> "disk.write.latency",* "description": "Write latency", "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statisti<br>
cs/b1e75c7b-cea4-37d2-8459-f7d68efc69a3",<br>
><br>
> <br>
"id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"<br>
> }, { "kind": "gauge", "type": "decimal", "unit": "seconds", <br>
> "values": { "value": [ { "datum": 0 } ] }, "disk": { "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c", <br>
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c" }, "name":<br>
> "disk.flush.latency", "description": "Flush latency", "href": <br>
> "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statisti<br>
cs/9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0",<br>
><br>
> <br>
"id": "9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0"<br>
> } ] }<br>
> <br>
> I am able to get the disk write and read latency, write and read <br>
> bandwidth.<br>
> <br>
> *But I am not able to find the postgresql tables used for these <br>
> statistics in oVirt? * *Could somebody let me know the statistics<br>
> table for the disk?*<br>
> <br>
> Any help is much Appreciated.<br>
> <br>
> Thanks, Harry<br>
> <br>
> _______________________________________________ Users mailing list <br>
> <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <mailto:<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a>> <br>
> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a> <br>
> <<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a>><br>
> <br>
> <br>
> <br>
> <br>
> <br>
> _______________________________________________ Users mailing list <br>
> <a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a> <a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
> <br>
<br>
<br>
- -- <br>
*Peter Hudec*<br>
Infraštruktúrny architekt<br>
<a href="mailto:phudec@cnc.sk" target="_blank">phudec@cnc.sk</a> <mailto:<a href="mailto:phudec@cnc.sk" target="_blank">phudec@cnc.sk</a>><br>
<br>
*CNC, a.s.*<br>
Borská 6, 841 04 Bratislava<br>
Recepcia: +421 2 35 000 100<br>
<br>
Mobil:+421 905 997 203<br>
*<a href="http://www.cnc.sk" rel="noreferrer" target="_blank">www.cnc.sk</a>* <http:///<a href="http://www.cnc.sk" rel="noreferrer" target="_blank">www.cnc.sk</a>><br>
<br>
-----BEGIN PGP SIGNATURE-----<br>
<br>
iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZF8gACgkQQnvVWOJ3<br>
5BBESw//dlAMwvj7MeI+6I4404tVS7peSsWkaxP0QKytw2ng11ilS9P+MsASDRVN<br>
ZJxbnwxK26kR58uh3If1S8DJQ4/l/mTYZkncd/BVrwWr/gR4KwLPN4HE0KPOarSW<br>
aqf5G2RPHHTxjko7NM9wTHxpck0bpRhBJU/iBnpGz9hJ3mkjxLruBaN0ZztXwS6P<br>
j42lJxIrVfcANl/5KGrndZYqPtqBtc2rlAmmO0IfHiTvbQb4tvUQyc5v05+UUsZa<br>
vCddamDDJAMn93locGykt6ySA9ZMhrQsx0sax3oKoa3vJ3NP03r+9fX8J906jRcX<br>
GN6k5iDG+yXcxCAHEctW2e6iyysBvysoML3ejmPLwD9+W0pG87xo6GH5Cv41CYYn<br>
dP0OSoQkZLOOJdchkfbce/mytIJHHdTOHPzjSMMBaDLgNWD3Qa2HeeTUMO9e6tao<br>
x3pfJUOxz2DSjOdHX7lo1IOsl4ctez3+I8nJxwjNYhcZF/Pttb529SoYp+s+ZCx6<br>
bpKIVatUZhuBpjoayIxy1/HTbTyVuaBy59ogXvYOb+HotmdwQYBo9ydp9lh+1NF6<br>
FRTRsoYuKHzf2/wOCri9mk6w2MNdSOZILWp7gxmxUWAtFtMoqNoWPoqreszQgp+d<br>
sGoVlUFwrXgbPab0dZvfje0qKsSbKZ1g4eyZvsbehcRw6C1ChHI=<br>
=9IA+<br>
-----END PGP SIGNATURE-----<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div></div>