<div dir="ltr"><div><div><div>Appreciated for your help. Could you tell me how frequently the statistics are updated in this table ? <br><br></div>I also found one more way to get the statistics, which is the recommended way? <br><br>select * from  getdiskbydiskid(&#39;a570a8a4-d4ff-4826-bc39-50bb0b42785c&#39;,&#39;27e73630-3688-11e8-8432-000c29cc7b80&#39;,&#39;f&#39;);<br><br></div>Thanks,<br></div>Hari <br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik <span dir="ltr">&lt;<a href="mailto:bzlotnik@redhat.com" target="_blank">bzlotnik@redhat.com</a>&gt;</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="h5">On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan <span dir="ltr">&lt;<a href="mailto:hariprasanth.l@msystechnologies.com" target="_blank">hariprasanth.l@<wbr>msystechnologies.com</a>&gt;</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="h5"><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/{uniqu<wbr>e_disk_id}/statistics/</font><br><br></span></div><b>and I get this response : <br></b><br> {<br>    &quot;statistic&quot;: [<br>        {<br>            &quot;kind&quot;: &quot;gauge&quot;,<br>            &quot;type&quot;: &quot;decimal&quot;,<br>            &quot;unit&quot;: &quot;bytes_per_second&quot;,<br>            &quot;values&quot;: {<br>                &quot;value&quot;: [<br>                    {<br>                        &quot;datum&quot;: 0<br>                    }<br>                ]<br>            },<br>            &quot;disk&quot;: {<br>                &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c&quot;,<br>                &quot;id&quot;: &quot;a570a8a4-d4ff-4826-bc39-50bb0<wbr>b42785c&quot;<br>            },<b><br>            &quot;name&quot;: &quot;data.current.read&quot;,</b><br>            &quot;description&quot;: &quot;Read data rate&quot;,<br>            &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c/statistics/33b9212b-f9cb-<wbr>3fd0-b364-248fb61e1272&quot;,<br>            &quot;id&quot;: &quot;33b9212b-f9cb-3fd0-b364-248fb<wbr>61e1272&quot;<br>        },<br>        {<br>            &quot;kind&quot;: &quot;gauge&quot;,<br>            &quot;type&quot;: &quot;decimal&quot;,<br>            &quot;unit&quot;: &quot;bytes_per_second&quot;,<br>            &quot;values&quot;: {<br>                &quot;value&quot;: [<br>                    {<br>                        &quot;datum&quot;: 0<br>                    }<br>                ]<br>            },<br>            &quot;disk&quot;: {<br>                &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c&quot;,<br>                &quot;id&quot;: &quot;a570a8a4-d4ff-4826-bc39-50bb0<wbr>b42785c&quot;<br>            },<br>       <b>     &quot;name&quot;: &quot;data.current.write&quot;,</b><br>            &quot;description&quot;: &quot;Write data rate&quot;,<br>            &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c/statistics/2f23addd-4ebd-<wbr>3d82-a449-c28778bc33eb&quot;,<br>            &quot;id&quot;: &quot;2f23addd-4ebd-3d82-a449-c2877<wbr>8bc33eb&quot;<br>        },<br>        {<br>            &quot;kind&quot;: &quot;gauge&quot;,<br>            &quot;type&quot;: &quot;decimal&quot;,<br>            &quot;unit&quot;: &quot;seconds&quot;,<br>            &quot;values&quot;: {<br>                &quot;value&quot;: [<br>                    {<br>                        &quot;datum&quot;: 0<br>                    }<br>                ]<br>            },<br>            &quot;disk&quot;: {<br>                &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c&quot;,<br>                &quot;id&quot;: &quot;a570a8a4-d4ff-4826-bc39-50bb0<wbr>b42785c&quot;<br>            },<br>     <b>       &quot;name&quot;: &quot;disk.read.latency&quot;,</b><br>            &quot;description&quot;: &quot;Read latency&quot;,<br>            &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c/statistics/3a7b3f72-d035-<wbr>3bb9-b196-e86a4eb34993&quot;,<br>            &quot;id&quot;: &quot;3a7b3f72-d035-3bb9-b196-e86a4<wbr>eb34993&quot;<br>        },<br>        {<br>            &quot;kind&quot;: &quot;gauge&quot;,<br>            &quot;type&quot;: &quot;decimal&quot;,<br>            &quot;unit&quot;: &quot;seconds&quot;,<br>            &quot;values&quot;: {<br>                &quot;value&quot;: [<br>                    {<br>                        &quot;datum&quot;: 0<br>                    }<br>                ]<br>            },<br>            &quot;disk&quot;: {<br>                &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c&quot;,<br>                &quot;id&quot;: &quot;a570a8a4-d4ff-4826-bc39-50bb0<wbr>b42785c&quot;<br></div>            }, <br><div>  <b>          &quot;name&quot;: &quot;disk.write.latency&quot;,</b><br>            &quot;description&quot;: &quot;Write latency&quot;,<br>            &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c/statistics/b1e75c7b-cea4-<wbr>37d2-8459-f7d68efc69a3&quot;,<br>            &quot;id&quot;: &quot;b1e75c7b-cea4-37d2-8459-f7d68<wbr>efc69a3&quot;<br>        },<br>        {<br>            &quot;kind&quot;: &quot;gauge&quot;,<br>            &quot;type&quot;: &quot;decimal&quot;,<br>            &quot;unit&quot;: &quot;seconds&quot;,<br>            &quot;values&quot;: {<br>                &quot;value&quot;: [<br>                    {<br>                        &quot;datum&quot;: 0<br>                    }<br>                ]<br>            },<br>            &quot;disk&quot;: {<br>                &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c&quot;,<br>                &quot;id&quot;: &quot;a570a8a4-d4ff-4826-bc39-50bb0<wbr>b42785c&quot;<br>            },<br>            &quot;name&quot;: &quot;disk.flush.latency&quot;,<br>            &quot;description&quot;: &quot;Flush latency&quot;,<br>            &quot;href&quot;: &quot;/ovirt-engine/api/disks/a570a<wbr>8a4-d4ff-4826-bc39-50bb0b42785<wbr>c/statistics/9c17ad7b-9ef1-<wbr>3e8d-ad0a-ff8bee3925f0&quot;,<br>            &quot;id&quot;: &quot;9c17ad7b-9ef1-3e8d-ad0a-ff8be<wbr>e3925f0&quot;<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>______________________________<wbr>_________________<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<wbr>/listinfo/users</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>