[ovirt-users] Postgresql tables
Peter Hudec
phudec at cnc.sk
Fri Apr 20 06:22:17 UTC 2018
-----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-----
More information about the Users
mailing list