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 <[email protected]> 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 > > <[email protected] <mailto:[email protected]>> wrote: > > > > It is in the disk_image_dynamic table > > > > On Thu, Apr 19, 2018 at 3:36 PM, Hari Prasanth Loganathan > > <[email protected] > > <mailto:[email protected]>> 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 > > [email protected] <mailto:[email protected]> > > http://lists.ovirt.org/mailman/listinfo/users > > <http://lists.ovirt.org/mailman/listinfo/users> > > > > > > > > > > > > _______________________________________________ Users mailing list > > [email protected] http://lists.ovirt.org/mailman/listinfo/users > > > > > - -- > *Peter Hudec* > Infraštruktúrny architekt > [email protected] <mailto:[email protected]> > > *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 > [email protected] > http://lists.ovirt.org/mailman/listinfo/users >
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
