Usage reports don't match up

asked 2019-04-12 16:37:29 -0500

HI Y'all,

We are using Openstack Queens, as installed via the RHEL repo on CentOS 7. Everything seems to be working just fine in our setup but we are now trying to get usage stats for our projects, and we are confused as to "which" stats we should trust, as the stats from various sources don't match up. For example, we assume 'openstack usage list' would get us the CPU hours per project for a timeframe, and it does report that. But the numbers reported in the horizon dashboard show almost 2x the usage. Also, 'nova usage-list' shows a number that is neither the horizon report nor the 'openstack usage list' report, but it's closer to the horizon report As an example:

# nova usage-list
Usage from 2019-03-15 to 2019-04-13:
+----------------------------------+---------+---------------+-----------+---------------+
| Tenant ID                        | Servers | RAM MB-Hours  | CPU Hours | Disk GB-Hours |
+----------------------------------+---------+---------------+-----------+---------------+
| 737af1e9a61448038ef7841fd2ced520 | 4       | 53587852.28   | 9812.23   | 1707327.81    |
| 3f85b986e83d448b90d7d38486e0ef39 | 9       | 35497618.49   | 7298.75   | 1154934.93    |
| 915814e3ab1d460d811ebf57675e7b1b | 40      | 3179615060.97 | 397451.88 | 72601210.56   |
| 986b55b08f694c7fb22bd114d30a5066 | 6       | 264241172.66  | 48384.00  | 8418816.66    |
| 986e3cfb381d435ea2af8207fe3877c6 | 12      | 506161227.82  | 86688.01  | 13942658.09   |
| eb099a87d60a4d5cad341478aad88f7f | 32      | 2490593808.36 | 336000.07 | 49709194.55   |
| 41e142e18a07427caf61ed29652c8c08 | 34      | 746254192.22  | 122656.49 | 21204432.35   |
| 4fce5fde70244505a35275d8090d417b | 6       | 278118204.68  | 41246.19  | 7357290.58    |
+----------------------------------+---------+---------------+-----------+---------------+

# openstack usage list
Usage from 2019-03-15 to 2019-04-13: 
+---------------+---------+---------------+-----------+---------------+
| Project       | Servers |  RAM MB-Hours | CPU Hours | Disk GB-Hours |
+---------------+---------+---------------+-----------+---------------+
| project1      |       2 |   26793716.28 |   4906.08 |     853657.22 |
| project2      |       9 |   35497618.49 |   7298.75 |    1154934.93 |
| project3      |      20 | 1589807748.47 | 198725.97 |   36300610.26 |
| project4      |       3 |  132120638.26 |  24192.01 |    4209409.98 |
| project5      |       4 |  168720463.51 |  28896.01 |    4647554.19 |
| project6      |       8 |  622648613.42 |  84000.04 |   12427301.86 |
| project7      |      34 |  746253554.81 |  122656.3 |   21204399.66 |
| project8      |       6 |  278117304.64 |  41246.07 |    7357268.51 | 
+---------------+---------+---------------+-----------+---------------+

Does anyone know how horizon gets its info? Which of these reports is likely the most accurate?

Many thanks!

edit retag flag offensive close merge delete