Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Grafana Fundamentals with PostgreSQL Metrics

via CodeSignal

Go to class Write review

Overview

Discover Grafana by visualizing real-time–like infrastructure metrics from a PostgreSQL database. In this course, learners will connect Grafana to Postgres, build time-series and stat panels, calculate derived metrics like CPU headroom, and master time bucketing for efficient, responsive dashboards that work at any time scale.

Syllabus

  • Unit 1: Connecting Grafana to Your First Data Source
    • Sign In and Add PostgreSQL Data Source
  • Unit 2: Building a Time-Series Panel
    • Discovering Available Metrics Tables
    • Format Timestamps for Grafana Time Series
    • Connecting Query to Time Range Picker
  • Unit 3: Stat Panels for Memory Usage
    • Add Time Filter to Memory Query
    • Build Complete Average Memory Query
    • Switch to Maximum Memory Usage
    • Calculate Memory Usage Range
  • Unit 4: Calculating CPU Headroom
    • Transform CPU Usage into Headroom Metric
    • Add Professional Labels to Panel Legend
    • Calculate Memory Headroom from Usage Data
    • Focus Cluttered Graphs with Compound Filtering
  • Unit 5: Time Bucketing in Grafana
    • Observing Grafana's Automatic Interval Calculator
    • Converting Individual Points to Time Buckets
    • Grouping Multiple Metrics with Time Buckets
    • Aggregating Memory Metrics with Time Buckets
    • Filtering Aggregated Results with HAVING Clause

Reviews

Start your review of Grafana Fundamentals with PostgreSQL Metrics

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.