How frequently is the 'disk_all table' is updated with new statistics? On Fri, Apr 20, 2018 at 11:15 AM, Hari Prasanth Loganathan < [email protected]> 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 <[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]> 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 >>> [email protected] >>> http://lists.ovirt.org/mailman/listinfo/users >>> >>> >> >
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
