[ovirt-users] Postgresql tables

[Peter Hudec]

-----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 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 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-----

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-----