9:36 p.m.
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
1:45 a.m.
It is in the disk_image_dynamic table
On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan <
hariprasanth.l(a)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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
1:48 a.m.
Appreciated for your help. Could you tell me how frequently the statistics
are updated in this table ?
I also found one more way to get the statistics, which is the recommended
way?
select * from
getdiskbydiskid('a570a8a4-d4ff-4826-bc39-50bb0b42785c','27e73630-3688-11e8-8432-000c29cc7b80','f');
Thanks,
Hari
On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik <bzlotnik(a)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@
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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "data.current.read",*
> "description": "Read data rate",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "data.current.write",*
> "description": "Write data rate",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "disk.read.latency",*
> "description": "Read latency",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "disk.write.latency",*
> "description": "Write latency",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> "name": "disk.flush.latency",
> "description": "Flush latency",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
7:27 a.m.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Hi Hari,
there are also another way how to get VM stats.
You could hook into VDSM, see
https://www.ovirt.org/develop/developer-guide/vdsm/vdsm-client/,
command vdsm-client Host getAllVmStats
Peter
On 19/04/2018 18:48, Hari Prasanth Loganathan wrote:
"id": "33b9212b-f9cb-3fd0-b364-248fb61e1272"
"id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"
"id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"
"id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"
"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(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users
>
>
>
>
> _______________________________________________ Users mailing list
> Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users
>
- --
*Peter Hudec*
Infraštruktúrny architekt
phudec(a)cnc.sk <mailto:phudec@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>
Appreciated for your help. Could you tell me how frequently the
statistics are updated in this table ?
I also found one more way to get the statistics, which is the
recommended way?
select * from
getdiskbydiskid('a570a8a4-d4ff-4826-bc39-50bb0b42785c','27e73630-3688-
11e8-8432-000c29cc7b80','f');
Thanks, Hari
On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik
<bzlotnik(a)redhat.com <mailto:bzlotnik@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(a)msystechnologies.com
<mailto:hariprasanth.l@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",
}, { "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",
}, { "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",
}, { "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",
}, { "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",
-----BEGIN PGP SIGNATURE-----
iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZF8gACgkQQnvVWOJ3
5BBESw//dlAMwvj7MeI+6I4404tVS7peSsWkaxP0QKytw2ng11ilS9P+MsASDRVN
ZJxbnwxK26kR58uh3If1S8DJQ4/l/mTYZkncd/BVrwWr/gR4KwLPN4HE0KPOarSW
aqf5G2RPHHTxjko7NM9wTHxpck0bpRhBJU/iBnpGz9hJ3mkjxLruBaN0ZztXwS6P
j42lJxIrVfcANl/5KGrndZYqPtqBtc2rlAmmO0IfHiTvbQb4tvUQyc5v05+UUsZa
vCddamDDJAMn93locGykt6ySA9ZMhrQsx0sax3oKoa3vJ3NP03r+9fX8J906jRcX
GN6k5iDG+yXcxCAHEctW2e6iyysBvysoML3ejmPLwD9+W0pG87xo6GH5Cv41CYYn
dP0OSoQkZLOOJdchkfbce/mytIJHHdTOHPzjSMMBaDLgNWD3Qa2HeeTUMO9e6tao
x3pfJUOxz2DSjOdHX7lo1IOsl4ctez3+I8nJxwjNYhcZF/Pttb529SoYp+s+ZCx6
bpKIVatUZhuBpjoayIxy1/HTbTyVuaBy59ogXvYOb+HotmdwQYBo9ydp9lh+1NF6
FRTRsoYuKHzf2/wOCri9mk6w2MNdSOZILWp7gxmxUWAtFtMoqNoWPoqreszQgp+d
sGoVlUFwrXgbPab0dZvfje0qKsSbKZ1g4eyZvsbehcRw6C1ChHI=
=9IA+
-----END PGP SIGNATURE-----
10:23 a.m.
Thanks I will look into vdsm client.
1) In PostgreSQL how frequently the disk statitsitics are updated ?
2) Where can I find the history of disk statitsitcs?
On Fri, 20 Apr 2018 at 3:57 AM, Peter Hudec <phudec(a)cnc.sk> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Hi Hari,
there are also another way how to get VM stats.
You could hook into VDSM, see
https://www.ovirt.org/develop/developer-guide/vdsm/vdsm-client/,
command vdsm-client Host getAllVmStats
Peter
On 19/04/2018 18:48, Hari Prasanth Loganathan wrote:
> Appreciated for your help. Could you tell me how frequently the
> statistics are updated in this table ?
>
> I also found one more way to get the statistics, which is the
> recommended way?
>
> select * from
> getdiskbydiskid('a570a8a4-d4ff-4826-bc39-50bb0b42785c','27e73630-3688-
11e8-8432-000c29cc7b80','f');
>
> Thanks, Hari
>
> On Thu, Apr 19, 2018 at 10:15 PM, Benny Zlotnik
> <bzlotnik(a)redhat.com <mailto:bzlotnik@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(a)msystechnologies.com
> <mailto:hariprasanth.l@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(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users>
>
>
>
>
>
> _______________________________________________ Users mailing list
> Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users
>
- --
*Peter Hudec*
Infraštruktúrny architekt
phudec(a)cnc.sk <mailto:phudec@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-----
iQIzBAEBCgAdFiEEqSUbhuEwhryifNeVQnvVWOJ35BAFAlrZF8gACgkQQnvVWOJ3
5BBESw//dlAMwvj7MeI+6I4404tVS7peSsWkaxP0QKytw2ng11ilS9P+MsASDRVN
ZJxbnwxK26kR58uh3If1S8DJQ4/l/mTYZkncd/BVrwWr/gR4KwLPN4HE0KPOarSW
aqf5G2RPHHTxjko7NM9wTHxpck0bpRhBJU/iBnpGz9hJ3mkjxLruBaN0ZztXwS6P
j42lJxIrVfcANl/5KGrndZYqPtqBtc2rlAmmO0IfHiTvbQb4tvUQyc5v05+UUsZa
vCddamDDJAMn93locGykt6ySA9ZMhrQsx0sax3oKoa3vJ3NP03r+9fX8J906jRcX
GN6k5iDG+yXcxCAHEctW2e6iyysBvysoML3ejmPLwD9+W0pG87xo6GH5Cv41CYYn
dP0OSoQkZLOOJdchkfbce/mytIJHHdTOHPzjSMMBaDLgNWD3Qa2HeeTUMO9e6tao
x3pfJUOxz2DSjOdHX7lo1IOsl4ctez3+I8nJxwjNYhcZF/Pttb529SoYp+s+ZCx6
bpKIVatUZhuBpjoayIxy1/HTbTyVuaBy59ogXvYOb+HotmdwQYBo9ydp9lh+1NF6
FRTRsoYuKHzf2/wOCri9mk6w2MNdSOZILWp7gxmxUWAtFtMoqNoWPoqreszQgp+d
sGoVlUFwrXgbPab0dZvfje0qKsSbKZ1g4eyZvsbehcRw6C1ChHI=
=9IA+
-----END PGP SIGNATURE-----
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
2:45 p.m.
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(a)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@
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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "data.current.read",*
> "description": "Read data rate",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "data.current.write",*
> "description": "Write data rate",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "disk.read.latency",*
> "description": "Read latency",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> * "name": "disk.write.latency",*
> "description": "Write latency",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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/a570a
> 8a4-d4ff-4826-bc39-50bb0b42785c",
> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
> },
> "name": "disk.flush.latency",
> "description": "Flush latency",
> "href": "/ovirt-engine/api/disks/a570a
> 8a4-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(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
>
2:56 p.m.
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(a)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(a)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(a)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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>> },
>> * "name": "data.current.read",*
>> "description": "Read data rate",
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c/statistics/33b9212b-f9cb-3fd
>> 0-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/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>> },
>> * "name": "data.current.write",*
>> "description": "Write data rate",
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c/statistics/2f23addd-4ebd-3d8
>> 2-a449-c28778bc33eb",
>> "id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"
>> },
>> {
>> "kind": "gauge",
>> "type": "decimal",
>> "unit": "seconds",
>> "values": {
>> "value": [
>> {
>> "datum": 0
>> }
>> ]
>> },
>> "disk": {
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>> },
>> * "name": "disk.read.latency",*
>> "description": "Read latency",
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c/statistics/3a7b3f72-d035-3bb
>> 9-b196-e86a4eb34993",
>> "id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"
>> },
>> {
>> "kind": "gauge",
>> "type": "decimal",
>> "unit": "seconds",
>> "values": {
>> "value": [
>> {
>> "datum": 0
>> }
>> ]
>> },
>> "disk": {
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>> },
>> * "name": "disk.write.latency",*
>> "description": "Write latency",
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c/statistics/b1e75c7b-cea4-37d
>> 2-8459-f7d68efc69a3",
>> "id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"
>> },
>> {
>> "kind": "gauge",
>> "type": "decimal",
>> "unit": "seconds",
>> "values": {
>> "value": [
>> {
>> "datum": 0
>> }
>> ]
>> },
>> "disk": {
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c",
>> "id": "a570a8a4-d4ff-4826-bc39-50bb0b42785c"
>> },
>> "name": "disk.flush.latency",
>> "description": "Flush latency",
>> "href": "/ovirt-engine/api/disks/a570a
>> 8a4-d4ff-4826-bc39-50bb0b42785c/statistics/9c17ad7b-9ef1-3e8
>> d-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(a)ovirt.org
>> http://lists.ovirt.org/mailman/listinfo/users
>>
>>
>
3:13 p.m.
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(a)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(a)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(a)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(a)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(a)ovirt.org
>>> http://lists.ovirt.org/mailman/listinfo/users
>>>
>>>
>>
>
_______________________________________________
Users mailing list
Users(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
3:14 p.m.
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(a)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(a)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(a)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(a)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(a)ovirt.org
>>>> http://lists.ovirt.org/mailman/listinfo/users
>>>>
>>>>
>>>
>>
> _______________________________________________
> Users mailing list
> Users(a)ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>
3:22 p.m.
-----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:
"id": "33b9212b-f9cb-3fd0-b364-248fb61e1272"
"id": "2f23addd-4ebd-3d82-a449-c28778bc33eb"
"id": "3a7b3f72-d035-3bb9-b196-e86a4eb34993"
"id": "b1e75c7b-cea4-37d2-8459-f7d68efc69a3"
"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(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> _______________________________________________ Users mailing list
> Users(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users
>
>
>
> _______________________________________________ Users mailing list
> Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users
>
- --
*Peter Hudec*
Infraštruktúrny architekt
phudec(a)cnc.sk <mailto:phudec@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>
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(a)redhat.com
<mailto:ykaul@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(a)msystechnologies.com
<mailto: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(a)msystechnologies.com
<mailto:hariprasanth.l@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(a)redhat.com <mailto:bzlotnik@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(a)msystechnologies.com
<mailto:hariprasanth.l@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",
}, { "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",
}, { "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",
}, { "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",
}, { "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",
-----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-----
3:59 p.m.
Thanks Much. You solved all my problems.
On Fri, Apr 20, 2018 at 11:52 AM, Peter Hudec <phudec(a)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(a)redhat.com
> <mailto:ykaul@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(a)msystechnologies.com
> <mailto: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(a)msystechnologies.com
> <mailto:hariprasanth.l@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(a)redhat.com <mailto:bzlotnik@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(a)msystechnologies.com
> <mailto:hariprasanth.l@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(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users>
>
>
>
>
> _______________________________________________ Users mailing list
> Users(a)ovirt.org <mailto:Users@ovirt.org>
> http://lists.ovirt.org/mailman/listinfo/users
> <http://lists.ovirt.org/mailman/listinfo/users>
>
>
>
>
> _______________________________________________ Users mailing list
> Users(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users
>
- --
*Peter Hudec*
Infraštruktúrny architekt
phudec(a)cnc.sk <mailto:phudec@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(a)ovirt.org
http://lists.ovirt.org/mailman/listinfo/users
2582
days inactive
2583
days old
10 comments
4 participants
participants (4)
-
Benny Zlotnik -
Hari Prasanth Loganathan -
Peter Hudec -
Yaniv Kaul