Grafana Visualization

Grafana is a widely-used open-source platform for metrics visualization, enabling you to create rich, interactive dashboards that transform Geode’s operational metrics into actionable insights. With support for Prometheus, Loki, and other data sources, Grafana provides a unified interface for monitoring database health, performance, and resource utilization. Geode’s comprehensive metrics integrate seamlessly with Grafana, allowing you to build dashboards tailored to your monitoring needs—from high-level executive overviews to detailed performance analysis for database administrators and developers. This guide covers Grafana installation, configuration, dashboard creation, advanced visualization techniques, and best practices for monitoring Geode deployments. <h3 id="installation-and-setup" class="position-relative d-flex align-items-center group"> Installation and Setup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="installation-and-setup" aria-haspopup="dialog" aria-label="Share link: Installation and Setup"> Share link </button> </h3><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script> <h4 id="docker-installation" class="position-relative d-flex align-items-center group"> Docker Installation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="docker-installation" aria-haspopup="dialog" aria-label="Share link: Docker Installation"> Share link </button> </h4>Quick setup using Docker Compose: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># docker-compose.yml version: '3.8' services: prometheus: image: prom/prometheus:latest volumes: - ./prometheus.yml:/etc/prometheus/prometheus.yml - prometheus-data:/prometheus ports: - "9090:9090" command: - '--config.file=/etc/prometheus/prometheus.yml' - '--storage.tsdb.retention.time=30d' grafana: image: grafana/grafana:latest environment: - GF_SECURITY_ADMIN_PASSWORD=admin - GF_USERS_ALLOW_SIGN_UP=false - GF_SERVER_ROOT_URL=http://grafana.example.com volumes: - grafana-data:/var/lib/grafana - ./grafana/provisioning:/etc/grafana/provisioning ports: - "3000:3000" depends_on: - prometheus geode: image: codepros/geode:latest ports: - "3141:3141" - "8080:8080" # Metrics endpoint volumes: prometheus-data: grafana-data: </code></pre></div>Start the stack: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">docker-compose up -d # Access Grafana at http://localhost:3000 # Default credentials: admin/admin </code></pre></div> <h4 id="kubernetes-installation" class="position-relative d-flex align-items-center group"> Kubernetes Installation <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="kubernetes-installation" aria-haspopup="dialog" aria-label="Share link: Kubernetes Installation"> Share link </button> </h4>Deploy using Helm: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Add Grafana Helm repository helm repo add grafana https://grafana.github.io/helm-charts helm repo update # Install Grafana helm install grafana grafana/grafana \ --namespace monitoring \ --set adminPassword=admin \ --set persistence.enabled=true \ --set persistence.size=10Gi # Get Grafana URL kubectl get svc -n monitoring grafana -o jsonpath='{.status.loadBalancer.ingress[0].ip}' </code></pre></div> <h3 id="data-source-configuration" class="position-relative d-flex align-items-center group"> Data Source Configuration <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="data-source-configuration" aria-haspopup="dialog" aria-label="Share link: Data Source Configuration"> Share link </button> </h3> <h4 id="prometheus-data-source" class="position-relative d-flex align-items-center group"> Prometheus Data Source <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prometheus-data-source" aria-haspopup="dialog" aria-label="Share link: Prometheus Data Source"> Share link </button> </h4>Configure Prometheus as the primary data source: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># provisioning/datasources/prometheus.yml apiVersion: 1 datasources: - name: Prometheus type: prometheus access: proxy url: http://prometheus:9090 isDefault: true editable: false jsonData: timeInterval: "15s" queryTimeout: "60s" httpMethod: POST prometheusType: Prometheus prometheusVersion: 2.40.0 cacheLevel: High incrementalQuerying: true disableRecordingRules: false </code></pre></div> <h4 id="loki-data-source-for-logs" class="position-relative d-flex align-items-center group"> Loki Data Source (for Logs) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="loki-data-source-for-logs" aria-haspopup="dialog" aria-label="Share link: Loki Data Source (for Logs)"> Share link </button> </h4>Add Loki for log visualization: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># provisioning/datasources/loki.yml apiVersion: 1 datasources: - name: Loki type: loki access: proxy url: http://loki:3100 jsonData: maxLines: 1000 derivedFields: - datasourceUid: tempo matcherRegex: "trace_id=(\\w+)" name: TraceID url: "$${__value.raw}" </code></pre></div> <h4 id="tempo-data-source-for-traces" class="position-relative d-flex align-items-center group"> Tempo Data Source (for Traces) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="tempo-data-source-for-traces" aria-haspopup="dialog" aria-label="Share link: Tempo Data Source (for Traces)"> Share link </button> </h4>Add Tempo for distributed tracing: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># provisioning/datasources/tempo.yml apiVersion: 1 datasources: - name: Tempo type: tempo access: proxy url: http://tempo:3200 jsonData: nodeGraph: enabled: true tracesToLogs: datasourceUid: loki tags: ['trace_id'] </code></pre></div> <h3 id="dashboard-provisioning" class="position-relative d-flex align-items-center group"> Dashboard Provisioning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="dashboard-provisioning" aria-haspopup="dialog" aria-label="Share link: Dashboard Provisioning"> Share link </button> </h3>Automatically provision dashboards on startup: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># provisioning/dashboards/dashboard.yml apiVersion: 1 providers: - name: 'Geode Dashboards' orgId: 1 folder: 'Geode' type: file disableDeletion: false updateIntervalSeconds: 10 allowUiUpdates: true options: path: /etc/grafana/provisioning/dashboards/geode </code></pre></div>Place dashboard JSON files in the specified path: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">/etc/grafana/provisioning/dashboards/geode/ ├── geode-overview.json ├── geode-query-performance.json ├── geode-transactions.json └── geode-resources.json </code></pre></div> <h3 id="creating-custom-dashboards" class="position-relative d-flex align-items-center group"> Creating Custom Dashboards <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="creating-custom-dashboards" aria-haspopup="dialog" aria-label="Share link: Creating Custom Dashboards"> Share link </button> </h3> <h4 id="dashboard-json-structure" class="position-relative d-flex align-items-center group"> Dashboard JSON Structure <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="dashboard-json-structure" aria-haspopup="dialog" aria-label="Share link: Dashboard JSON Structure"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "dashboard": { "title": "Geode Query Performance", "tags": ["geode", "performance"], "timezone": "browser", "schemaVersion": 36, "version": 1, "refresh": "10s", "templating": { "list": [ { "name": "instance", "type": "query", "datasource": "Prometheus", "query": "label_values(geode_queries_total, instance)", "refresh": 1, "multi": true, "includeAll": true } ] }, "panels": [ { "id": 1, "title": "Query Rate", "type": "graph", "gridPos": {"h": 8, "w": 12, "x": 0, "y": 0}, "targets": [ { "expr": "sum(rate(geode_queries_total{instance=~\"$instance\"}[5m]))", "legendFormat": "Total Queries/sec" } ], "yaxes": [ {"format": "ops", "label": "Queries/sec"}, {"format": "short"} ] } ] } } </code></pre></div> <h4 id="panel-types-and-use-cases" class="position-relative d-flex align-items-center group"> Panel Types and Use Cases <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="panel-types-and-use-cases" aria-haspopup="dialog" aria-label="Share link: Panel Types and Use Cases"> Share link </button> </h4>Graph Panel: Time series visualization <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "graph", "title": "Query Latency", "targets": [ { "expr": "histogram_quantile(0.95, rate(geode_query_duration_seconds_bucket[5m]))", "legendFormat": "p95 Latency" } ], "yaxes": [ {"format": "s", "label": "Latency"} ] } </code></pre></div>Stat Panel: Single value with thresholds <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "stat", "title": "Query Success Rate", "targets": [ { "expr": "rate(geode_queries_total{status=\"success\"}[5m]) / rate(geode_queries_total[5m]) * 100" } ], "options": { "reduceOptions": { "values": false, "calcs": ["lastNotNull"] } }, "fieldConfig": { "defaults": { "thresholds": { "mode": "absolute", "steps": [ {"color": "red", "value": 0}, {"color": "yellow", "value": 99}, {"color": "green", "value": 99.9} ] }, "unit": "percent" } } } </code></pre></div>Gauge Panel: Percentage visualization <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "gauge", "title": "Memory Usage", "targets": [ { "expr": "geode_memory_used_bytes / geode_memory_total_bytes * 100" } ], "fieldConfig": { "defaults": { "thresholds": { "steps": [ {"color": "green", "value": 0}, {"color": "yellow", "value": 75}, {"color": "red", "value": 90} ] }, "unit": "percent", "min": 0, "max": 100 } } } </code></pre></div>Table Panel: Detailed data display <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "table", "title": "Top Slow Queries", "targets": [ { "expr": "topk(10, geode_query_duration_seconds{quantile=\"0.99\"})", "format": "table", "instant": true } ], "transformations": [ { "id": "organize", "options": { "excludeByName": {"Time": true}, "indexByName": { "query_id": 0, "query_text": 1, "Value": 2 }, "renameByName": { "Value": "Duration (ms)" } } } ] } </code></pre></div>Heatmap Panel: Distribution visualization <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "heatmap", "title": "Query Latency Distribution", "targets": [ { "expr": "sum(rate(geode_query_duration_seconds_bucket[5m])) by (le)" } ], "heatmap": { "colorScheme": "interpolateViridis" }, "dataFormat": "tsbuckets" } </code></pre></div> <h3 id="advanced-visualization-techniques" class="position-relative d-flex align-items-center group"> Advanced Visualization Techniques <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="advanced-visualization-techniques" aria-haspopup="dialog" aria-label="Share link: Advanced Visualization Techniques"> Share link </button> </h3> <h4 id="multi-axis-graphs" class="position-relative d-flex align-items-center group"> Multi-Axis Graphs <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="multi-axis-graphs" aria-haspopup="dialog" aria-label="Share link: Multi-Axis Graphs"> Share link </button> </h4>Combine different metrics on one graph: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "graph", "title": "Query Rate vs Latency", "targets": [ { "expr": "sum(rate(geode_queries_total[5m]))", "legendFormat": "Query Rate", "yaxis": 1 }, { "expr": "histogram_quantile(0.95, rate(geode_query_duration_seconds_bucket[5m]))", "legendFormat": "p95 Latency", "yaxis": 2 } ], "yaxes": [ {"format": "ops", "label": "Queries/sec"}, {"format": "s", "label": "Latency"} ] } </code></pre></div> <h4 id="conditional-formatting" class="position-relative d-flex align-items-center group"> Conditional Formatting <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="conditional-formatting" aria-haspopup="dialog" aria-label="Share link: Conditional Formatting"> Share link </button> </h4>Apply colors based on value ranges: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "stat", "fieldConfig": { "overrides": [ { "matcher": {"id": "byName", "options": "Error Rate"}, "properties": [ { "id": "thresholds", "value": { "steps": [ {"color": "green", "value": null}, {"color": "yellow", "value": 1}, {"color": "red", "value": 10} ] } } ] } ] } } </code></pre></div> <h4 id="template-variables" class="position-relative d-flex align-items-center group"> Template Variables <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="template-variables" aria-haspopup="dialog" aria-label="Share link: Template Variables"> Share link </button> </h4>Create dynamic dashboards with variables: Query Variable: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "name": "instance", "type": "query", "query": "label_values(geode_queries_total, instance)", "refresh": "on_time_range_change", "multi": true, "includeAll": true, "allValue": ".*" } </code></pre></div>Interval Variable: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "name": "interval", "type": "interval", "query": "1m,5m,10m,30m,1h", "auto": true, "auto_count": 30, "auto_min": "10s" } </code></pre></div>Custom Variable: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "name": "percentile", "type": "custom", "query": "0.50,0.95,0.99", "current": { "value": "0.95", "text": "p95" } } </code></pre></div>Use variables in queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-promql" data-lang="promql"># Dynamic instance filtering rate(geode_queries_total{instance=~"$instance"}[$interval]) # Dynamic percentile histogram_quantile($percentile, rate(geode_query_duration_seconds_bucket[5m])) </code></pre></div> <h4 id="transformations" class="position-relative d-flex align-items-center group"> Transformations <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="transformations" aria-haspopup="dialog" aria-label="Share link: Transformations"> Share link </button> </h4>Transform query results before visualization: Join by Field: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "transformations": [ { "id": "merge", "options": {} }, { "id": "organize", "options": { "excludeByName": {"Time": true}, "indexByName": { "instance": 0, "queries": 1, "errors": 2 } } } ] } </code></pre></div>Calculate Field: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "transformations": [ { "id": "calculateField", "options": { "mode": "binary", "reduce": { "reducer": "sum" }, "alias": "Error Rate", "binary": { "left": "Errors", "operator": "/", "right": "Total" } } } ] } </code></pre></div> <h3 id="alerting-in-grafana" class="position-relative d-flex align-items-center group"> Alerting in Grafana <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="alerting-in-grafana" aria-haspopup="dialog" aria-label="Share link: Alerting in Grafana"> Share link </button> </h3> <h4 id="configure-alert-rules" class="position-relative d-flex align-items-center group"> Configure Alert Rules <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="configure-alert-rules" aria-haspopup="dialog" aria-label="Share link: Configure Alert Rules"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "type": "graph", "title": "Query Error Rate", "alert": { "name": "High Query Error Rate", "conditions": [ { "evaluator": { "type": "gt", "params": [10] }, "operator": { "type": "and" }, "query": { "params": ["A", "5m", "now"] }, "reducer": { "type": "avg" }, "type": "query" } ], "executionErrorState": "alerting", "frequency": "1m", "handler": 1, "message": "Query error rate exceeds threshold", "noDataState": "no_data", "notifications": [ {"uid": "slack-alerts"} ] } } </code></pre></div> <h4 id="notification-channels" class="position-relative d-flex align-items-center group"> Notification Channels <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="notification-channels" aria-haspopup="dialog" aria-label="Share link: Notification Channels"> Share link </button> </h4>Slack: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "name": "Slack Alerts", "type": "slack", "settings": { "url": "https://hooks.slack.com/services/...", "recipient": "#database-alerts", "username": "Grafana" } } </code></pre></div>PagerDuty: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "name": "PagerDuty", "type": "pagerduty", "settings": { "integrationKey": "xxxxx", "severity": "critical", "autoResolve": true } } </code></pre></div>Email: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "name": "Email Alerts", "type": "email", "settings": { "addresses": "[email protected];[email protected]", "singleEmail": false } } </code></pre></div> <h3 id="performance-optimization" class="position-relative d-flex align-items-center group"> Performance Optimization <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="performance-optimization" aria-haspopup="dialog" aria-label="Share link: Performance Optimization"> Share link </button> </h3> <h4 id="use-recording-rules" class="position-relative d-flex align-items-center group"> Use Recording Rules <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="use-recording-rules" aria-haspopup="dialog" aria-label="Share link: Use Recording Rules"> Share link </button> </h4>Pre-compute expensive queries in Prometheus: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># prometheus-rules.yml groups: - name: grafana_recordings interval: 15s rules: - record: job:geode_query_rate:5m expr: sum(rate(geode_queries_total[5m])) by (job, instance) - record: job:geode_query_latency_p95:5m expr: histogram_quantile(0.95, sum(rate(geode_query_duration_seconds_bucket[5m])) by (job, instance, le)) </code></pre></div>Use in Grafana: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-promql" data-lang="promql"># Instead of complex query sum(rate(geode_queries_total[5m])) by (job, instance) # Use recording rule job:geode_query_rate:5m </code></pre></div> <h4 id="optimize-query-performance" class="position-relative d-flex align-items-center group"> Optimize Query Performance <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="optimize-query-performance" aria-haspopup="dialog" aria-label="Share link: Optimize Query Performance"> Share link </button> </h4>Reduce Time Range: Use appropriate time windows <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-promql" data-lang="promql"># Good for real-time dashboard rate(geode_queries_total[5m]) # Too expensive for dashboard rate(geode_queries_total[24h]) </code></pre></div>Limit Series: Use filters to reduce cardinality <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-promql" data-lang="promql"># Too broad sum(rate(geode_queries_total[5m])) # Filtered appropriately sum(rate(geode_queries_total{instance=~"$instance"}[5m])) </code></pre></div>Use Instant Queries for Tables: When only latest value needed <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "targets": [ { "expr": "topk(10, geode_query_duration_seconds)", "instant": true, "format": "table" } ] } </code></pre></div> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="best-practices" aria-haspopup="dialog" aria-label="Share link: Best Practices"> Share link </button> </h3>Consistent Naming: Use consistent dashboard and panel names across folders. Organize by Persona: Create dashboards for specific audiences (ops, devs, executives). Use Folders: Group related dashboards in folders for easy navigation. Version Control: Store dashboard JSON in Git for versioning and collaboration. Document Dashboards: Add descriptions to dashboards and panels explaining metrics. Set Appropriate Refresh: Balance freshness with performance (10s-1m for most dashboards). Use Variables: Make dashboards reusable with template variables. Test Performance: Ensure dashboards load quickly even with many panels. Color Consistently: Use standard color schemes (green=good, red=bad). Include Links: Link related dashboards and runbooks. <h3 id="related-topics" class="position-relative d-flex align-items-center group"> Related Topics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="related-topics" aria-haspopup="dialog" aria-label="Share link: Related Topics"> Share link </button> </h3><ul> <li><a href="/tags/dashboard/" >Monitoring Dashboards</a> - Dashboard design</li> <li><a href="/tags/prometheus/" >Prometheus Integration</a> - Prometheus setup</li> <li><a href="/tags/metrics/" >Performance Metrics</a> - Metrics collection</li> <li><a href="/tags/monitoring/" >System Monitoring</a> - Monitoring strategies</li> <li><a href="/tags/alerting/" >Alert Management</a> - Alert configuration</li> <li><a href="/tags/observability/" >System Observability</a> - Observability pillars</li> </ul> <h3 id="further-reading" class="position-relative d-flex align-items-center group"> Further Reading <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="further-reading" aria-haspopup="dialog" aria-label="Share link: Further Reading"> Share link </button> </h3><ul> <li>Grafana Documentation</li> <li>Dashboard Best Practices</li> <li>PromQL Query Guide</li> <li>Grafana Alerting Guide</li> <li>Dashboard as Code Patterns</li> </ul>

Popular

Related Articles

Monitoring

Monitoring Guide