Jira (PDB-691) Extend PuppetDB to store & publish metrics information

[Michal Ruzicka (JIRA)]

Title: Message Title

Michal Ruzicka created an issue   PuppetDB / PDB-691 Extend PuppetDB to store & publish metrics information Issue Type: New Feature Assignee: Unassigned Components: PE Created: 27/May/14 8:33 AM Priority: Normal Reporter: Michal Ruzicka Here is sample of data stored in the metrics table in the PE console database: id | report_id | category | name | value -----+-----------+-----------+----------------------------+------------ 1 | 1 | resources | total | 118.000000 2 | 1 | resources | skipped | 0.000000 3 | 1 | resources | failed | 0.000000 4 | 1 | resources | failed_to_restart | 0.000000 5 | 1 | resources | restarted | 0.000000 6 | 1 | resources | changed | 0.000000 7 | 1 | resources | out_of_sync | 0.000000 8 | 1 | resources | scheduled | 0.000000 9 | 1 | time | schedule | 0.003832 10 | 1 | time | file | 0.607948 11 | 1 | time | filebucket | 0.000347 12 | 1 | time | ini_setting | 0.012560 13 | 1 | time | exec | 0.857653 14 | 1 | time | group | 0.001346 15 | 1 | time | user | 0.004715 16 | 1 | time | java_ks | 3.057121 17 | 1 | time | service | 0.931602 18 | 1 | time | package | 0.001737 19 | 1 | time | ini_subsetting | 0.002056 20 | 1 | time | file_line | 0.006851 21 | 1 | time | postgresql_psql | 0.674327 22 | 1 | time | config_retrieval | 12.801218 23 | 1 | time | total | 18.963311 24 | 1 | changes | total | 0.000000 25 | 1 | events | total | 0.000000 26 | 1 | events | failure | 0.000000 27 | 1 | events | success | 0.000000 29 | 1 | resources | unchanged | 118.000000 28 | 1 | resources | noop | 0.000000 In order to be able to back the reporting in the PE console by data from PuppetDB we need it to store an equivalent information. Note that some pieces of the information can be inferred from data available in PuppetDB even today - for example the numbers of changed and failed resources can be computed as the counts of the respective records in the resource_events table. Other pieces of the information - e.g all the times metrics - are currently not available in PuppetDB in any from. It would seem straightforward to infer the various resources and events metrics from the information in the resource_events table provided that all resources are stored there - currently only changed/failed resources are stored there. On the other hand the time resources would probably need to be stored in a new dedicated table. But this proposal should not be treated as something set in stone - the actual solution is up for a discussion. Add Comment   This message was sent by Atlassian JIRA (v6.1.4#6159-sha1:44eaede) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To post to this group, send email to puppet-bugs@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-bugs. For more options, visit https://groups.google.com/d/optout.