A new tool for generating Graphite metrics from PostgreSQL queries

Bug #1321249 reported by Gro-Anita Vindheim
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Network Administration Visualized
Fix Released
Wishlist
John-Magne Bredal

Bug Description

Because comments can't be edited, I will post the implementation notes above the original request.

This will be implemented as a NAV subsystem. This means that it is
started with the NAV command. The suggested name is 'stats'. The job
itself will run as a cron job.

The code itself will use the 'send_metrics' function to send collected
data to Carbon. This ensures correctness.

To make collection flexible, the collection parameters - what to
collect and where to send it - will be put in a configuration file
called 'stats.conf'. Each collection have a section. Each section has
two required options - the metric path and the SQL to run to get the
metric value to send. The metric timestamp will be fetched when the
metric is sent.

A new metric path prefix is created for these data - nav.stats.

The initial proposal is kinda light on specs but suggested paths for
the wishes are:
- "How many switchports, and how many of those are in use"
  - nav.stats.ports.switchports.active
  - nav.stats.ports.switchports.all
- "What kind of netboxes do we have, sort by vendor & model"
  - nav.stats.devices.<vendor>.<type>
- "how many netboxes do we have in our network" - sum of the above

Original request follows:

For the wishlist...

Our management often ask for information like
"how many netboxes do we have in our network"
"How many switchports, and how many of those are in use"
"What kind of netboxes do we have, sort by vendor & model"

I would like NAV to save these data as carbon-datapoints.

This will make my management able too see trends without asking me once a month :)

Tags: navref
Revision history for this message
John-Magne Bredal (john-m-bredal) wrote :

I guess this is relevant for the new WatchDog overview, as there already are some NAV overview data there.

Personally I think it's a good idea to store this data using Carbon.

Changed in nav:
importance: Undecided → Wishlist
status: New → Triaged
tags: added: nav-ref
tags: added: navref
removed: nav-ref
description: updated
description: updated
Changed in nav:
milestone: none → 4.4.3
Changed in nav:
milestone: 4.4.3 → 4.5.0
Changed in nav:
assignee: nobody → John-Magne Bredal (john-m-bredal)
status: Triaged → Fix Committed
summary: - "management statistics" should be implemented
+ A new tool for generating Graphite metrics from PostgreSQL queries
Changed in nav:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.