<div dir="auto"><div>May I ask what are you trying to achieve? Why not use the oVirt REST API? </div><div dir="auto">Y. <br><br><div class="gmail_quote" dir="auto"><div dir="ltr">On Fri, Apr 20, 2018, 8:57 AM Hari Prasanth Loganathan <<a href="mailto:hariprasanth.l@msystechnologies.com">hariprasanth.l@msystechnologies.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">How frequently is the 'disk_all table' is updated with new statistics? <br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan <span dir="ltr"><<a href="mailto:hariprasanth.l@msystechnologies.com" target="_blank" rel="noreferrer">hariprasanth.l@msystechnologies.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>How is the disk id mapped to this table : disk_image_dynamic table? <br><br></div>If I need statistics of all the disk, How can I get it? <br></div><div class="m_-3050616178860949508HOEnZb"><div class="m_-3050616178860949508h5"><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik <span dir="ltr"><<a href="mailto:bzlotnik@redhat.com" target="_blank" rel="noreferrer">bzlotnik@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">It is in the disk_image_dynamic table</div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_-3050616178860949508m_5438800791559692562h5">On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan <span dir="ltr"><<a href="mailto:hariprasanth.l@msystechnologies.com" target="_blank" rel="noreferrer">hariprasanth.l@msystechnologies.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_-3050616178860949508m_5438800791559692562h5"><div dir="ltr"><div><div><div>Hi Team,<br><br></div>I am trying to get the disk level statistics using oVirt with the following API,<br><br><span style="color:rgb(80,80,80);font-family:OpenSans,Helvetica,Arial,sans-serif;font-size:12px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:left;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;background-color:rgb(250,250,250);text-decoration-style:initial;text-decoration-color:initial;display:inline;float:none"><font size="2">/ovirt-engine/api/disks/{unique_disk_id}/statistics/</font><br><br></span></div><b>and I get this response : <br></b><br> {<br> "statistic": [<br> {<br> "kind": "gauge",<br> "type": "decimal",<br> "unit": "bytes_per_second",<br> "values": {<br> "value": [<br> {<br> "datum": 0<br> }<br> ]<br> },<br> "disk": {<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",<br> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"<br> },<b><br> "name": "data.current.read",</b><br> "description": "Read data rate",<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/33b9212b-f9cb-3fd0-b364-248fb61e1272",<br> "id": "33b9212b-f9cb-3fd0-b364-248fb61e1272"<br> },<br> {<br> "kind": "gauge",<br> "type": "decimal",<br> "unit": "bytes_per_second",<br> "values": {<br> "value": [<br> {<br> "datum": 0<br> }<br> ]<br> },<br> "disk": {<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",<br> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"<br> },<br> <b> "name": "data.current.write",</b><br> "description": "Write data rate",<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/2f23addd-4ebd-3d82-a449-c28778bc33eb",<br> "id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"<br> },<br> {<br> "kind": "gauge",<br> "type": "decimal",<br> "unit": "seconds",<br> "values": {<br> "value": [<br> {<br> "datum": 0<br> }<br> ]<br> },<br> "disk": {<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",<br> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"<br> },<br> <b> "name": "disk.read.latency",</b><br> "description": "Read latency",<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/3a7b3f72-d035-3bb9-b196-e86a4eb34993",<br> "id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"<br> },<br> {<br> "kind": "gauge",<br> "type": "decimal",<br> "unit": "seconds",<br> "values": {<br> "value": [<br> {<br> "datum": 0<br> }<br> ]<br> },<br> "disk": {<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",<br> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"<br></div> }, <br><div> <b> "name": "disk.write.latency",</b><br> "description": "Write latency",<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/b1e75c7b-cea4-37d2-8459-f7d68efc69a3",<br> "id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"<br> },<br> {<br> "kind": "gauge",<br> "type": "decimal",<br> "unit": "seconds",<br> "values": {<br> "value": [<br> {<br> "datum": 0<br> }<br> ]<br> },<br> "disk": {<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c",<br> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"<br> },<br> "name": "disk.flush.latency",<br> "description": "Flush latency",<br> "href": "/ovirt-engine/api/disks/a570a8a4-d4ff-4826-bc39-50bb0b42785c/statistics/9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0",<br> "id": "9c17ad7b-9ef1-3e8d-ad0a-ff8bee3925f0"<br> }<br> ]<br>}<br><br></div><div>I am able to get the disk write and read latency, write and read bandwidth. <br><br></div><div><b>But I am not able to find the postgresql tables used for these statistics in oVirt? <br></b></div><div><b>Could somebody let me know the statistics table for the disk?</b><br><br></div><div>Any help is much Appreciated.<br><br></div><div>Thanks, <br></div><div>Harry <br></div></div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank" rel="noreferrer">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>
</div></div></blockquote></div><br></div>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org" target="_blank" rel="noreferrer">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer noreferrer" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br>
</blockquote></div></div></div>