[ovirt-users] Postgresql tables
Hari Prasanth Loganathan
hariprasanth.l at msystechnologies.com
Fri Apr 20 06:14:58 UTC 2018
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 at 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 at 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 at 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 at 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 at ovirt.org
>>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>>
>>>>>
>>>>
>>>
>> _______________________________________________
>> Users mailing list
>> Users at ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180420/5723f0d9/attachment.html>
More information about the Users
mailing list