[ovirt-users] Postgresql tables

Fri Apr 20 06:59:10 UTC 2018

Thanks Much. You solved all my problems.

On Fri, Apr 20, 2018 at 11:52 AM, Peter Hudec <phudec at 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 at redhat.com
> > <mailto: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 at msystechnologies.com
> > <mailto:hariprasanth.l at 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
> > <mailto: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 <mailto: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
> > <mailto: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/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 at ovirt.org <mailto:Users at ovirt.org>
> > http://lists.ovirt.org/mailman/listinfo/users
> > <http://lists.ovirt.org/mailman/listinfo/users>
> >
> >
> >
> >
> > _______________________________________________ Users mailing list
> > Users at ovirt.org <mailto:Users at ovirt.org>
> > http://lists.ovirt.org/mailman/listinfo/users
> > <http://lists.ovirt.org/mailman/listinfo/users>
> >
> >
> >
> >
> > _______________________________________________ Users mailing list
> > Users at ovirt.org http://lists.ovirt.org/mailman/listinfo/users
> >
>
>
> - --
> *Peter Hudec*
> Infraštruktúrny architekt
> phudec at cnc.sk <mailto:phudec at 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 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/e07c7085/attachment.html>