<!-- CANARY: REQ=REQ-DOCS-001; FEATURE="Docs"; ASPECT=Documentation; STATUS=TESTED; OWNER=docs; UPDATED=2026-01-28 -->
<h2 id="statistics-and-metrics-reference" class="position-relative d-flex align-items-center group">
<span>Statistics and Metrics Reference</span>
<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="statistics-and-metrics-reference"
aria-haspopup="dialog"
aria-label="Share link: Statistics and Metrics Reference">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h2><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">
<i class="fa-solid fa-xmark"></i>
</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">
<i class="fa-duotone fa-clipboard" aria-hidden="true"></i>
</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">
<i class="fa-brands fa-twitter me-2"></i>Twitter
</a>
<a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-linkedin me-2"></i>LinkedIn
</a>
<a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-facebook me-2"></i>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><p>Geode provides comprehensive statistics and metrics for monitoring, optimization, and observability. This reference documents all available metrics, collection methods, and integration options.</p>
<h3 id="overview" class="position-relative d-flex align-items-center group">
<span>Overview</span>
<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="overview"
aria-haspopup="dialog"
aria-label="Share link: Overview">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="metric-categories" class="position-relative d-flex align-items-center group">
<span>Metric Categories</span>
<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="metric-categories"
aria-haspopup="dialog"
aria-label="Share link: Metric Categories">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>Category</th>
<th>Purpose</th>
<th>Collection Method</th>
</tr>
</thead>
<tbody>
<tr>
<td><strong>Query Statistics</strong></td>
<td>Query performance analysis</td>
<td>Automatic</td>
</tr>
<tr>
<td><strong>Storage Statistics</strong></td>
<td>Disk and memory usage</td>
<td>Automatic</td>
</tr>
<tr>
<td><strong>Index Statistics</strong></td>
<td>Index efficiency</td>
<td>Automatic + Manual</td>
</tr>
<tr>
<td><strong>Transaction Statistics</strong></td>
<td>ACID operations</td>
<td>Automatic</td>
</tr>
<tr>
<td><strong>Connection Statistics</strong></td>
<td>Client connections</td>
<td>Automatic</td>
</tr>
<tr>
<td><strong>System Statistics</strong></td>
<td>Resource utilization</td>
<td>Automatic</td>
</tr>
</tbody>
</table>
<h4 id="access-methods" class="position-relative d-flex align-items-center group">
<span>Access Methods</span>
<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="access-methods"
aria-haspopup="dialog"
aria-label="Share link: Access Methods">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ol>
<li><strong>GQL Procedures</strong>: <code>CALL db.stats.*</code></li>
<li><strong>Prometheus Endpoint</strong>: <code>/metrics</code></li>
<li><strong>Admin API</strong>: REST endpoints</li>
<li><strong>EXPLAIN/PROFILE</strong>: Per-query metrics</li>
</ol>
<hr>
<h3 id="query-statistics" class="position-relative d-flex align-items-center group">
<span>Query Statistics</span>
<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="query-statistics"
aria-haspopup="dialog"
aria-label="Share link: Query Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="global-query-statistics" class="position-relative d-flex align-items-center group">
<span>Global Query Statistics</span>
<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="global-query-statistics"
aria-haspopup="dialog"
aria-label="Share link: Global Query Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">View</span><span class="w"> </span><span class="py">overall</span><span class="w"> </span><span class="kd">query</span><span class="w"> </span><span class="nc">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">queries</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Output:</strong></p>
<table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>total_queries</code></td>
<td>Counter</td>
<td>Total queries executed</td>
</tr>
<tr>
<td><code>successful_queries</code></td>
<td>Counter</td>
<td>Successfully completed queries</td>
</tr>
<tr>
<td><code>failed_queries</code></td>
<td>Counter</td>
<td>Failed queries</td>
</tr>
<tr>
<td><code>queries_in_progress</code></td>
<td>Gauge</td>
<td>Currently executing queries</td>
</tr>
<tr>
<td><code>avg_query_time_ms</code></td>
<td>Gauge</td>
<td>Average query latency</td>
</tr>
<tr>
<td><code>p50_query_time_ms</code></td>
<td>Gauge</td>
<td>Median query latency</td>
</tr>
<tr>
<td><code>p95_query_time_ms</code></td>
<td>Gauge</td>
<td>95th percentile latency</td>
</tr>
<tr>
<td><code>p99_query_time_ms</code></td>
<td>Gauge</td>
<td>99th percentile latency</td>
</tr>
<tr>
<td><code>max_query_time_ms</code></td>
<td>Gauge</td>
<td>Maximum observed latency</td>
</tr>
</tbody>
</table>
<h4 id="query-type-breakdown" class="position-relative d-flex align-items-center group">
<span>Query Type Breakdown</span>
<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="query-type-breakdown"
aria-haspopup="dialog"
aria-label="Share link: Query Type Breakdown">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Statistics</span><span class="w"> </span><span class="py">by</span><span class="w"> </span><span class="kd">query</span><span class="w"> </span><span class="nc">type</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">queries</span><span class="err">.</span><span class="py">by_type</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Query Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>MATCH</code></td>
<td>Read queries</td>
</tr>
<tr>
<td><code>CREATE</code></td>
<td>Node/relationship creation</td>
</tr>
<tr>
<td><code>SET</code></td>
<td>Property updates</td>
</tr>
<tr>
<td><code>DELETE</code></td>
<td>Deletions</td>
</tr>
<tr>
<td><code>MERGE</code></td>
<td>Upsert operations</td>
</tr>
<tr>
<td><code>CALL</code></td>
<td>Procedure calls</td>
</tr>
</tbody>
</table>
<h4 id="slow-query-log" class="position-relative d-flex align-items-center group">
<span>Slow Query Log</span>
<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="slow-query-log"
aria-haspopup="dialog"
aria-label="Share link: Slow Query Log">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">View</span><span class="w"> </span><span class="py">slow</span><span class="w"> </span><span class="py">queries</span><span class="w"> </span><span class="p">(</span><span class="err">></span><span class="w"> </span><span class="py">threshold</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">slow_queries</span><span class="p">(</span><span class="py">100</span><span class="p">)</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">threshold</span><span class="w"> </span><span class="py">in</span><span class="w"> </span><span class="py">ms</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Configure</span><span class="w"> </span><span class="py">slow</span><span class="w"> </span><span class="kd">query</span><span class="w"> </span><span class="nc">threshold</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">config</span><span class="err">.</span><span class="py">set</span><span class="p">(</span><span class="err">'</span><span class="kd">query</span><span class="err">.</span><span class="nc">slow_threshold_ms</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">100</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Slow Query Entry:</strong></p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json"><span class="line"><span class="cl"><span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"timestamp"</span><span class="p">:</span> <span class="s2">"2026-01-28T10:30:00Z"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"query"</span><span class="p">:</span> <span class="s2">"MATCH (p:Person)-[:KNOWS*5]->(f) RETURN f"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"duration_ms"</span><span class="p">:</span> <span class="mi">1523</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"rows_returned"</span><span class="p">:</span> <span class="mi">10000</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"db_hits"</span><span class="p">:</span> <span class="mi">500000</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"user"</span><span class="p">:</span> <span class="s2">"alice"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"client_ip"</span><span class="p">:</span> <span class="s2">"192.168.1.100"</span>
</span></span><span class="line"><span class="cl"><span class="p">}</span>
</span></span></code></pre></div>
<h4 id="query-plan-statistics" class="position-relative d-flex align-items-center group">
<span>Query Plan Statistics</span>
<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="query-plan-statistics"
aria-haspopup="dialog"
aria-label="Share link: Query Plan Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">View</span><span class="w"> </span><span class="py">cached</span><span class="w"> </span><span class="kd">query</span><span class="w"> </span><span class="nc">plans</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="kd">query</span><span class="nc">_plans</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>plan_cache_size</code></td>
<td>Number of cached plans</td>
</tr>
<tr>
<td><code>plan_cache_hits</code></td>
<td>Cache hit count</td>
</tr>
<tr>
<td><code>plan_cache_misses</code></td>
<td>Cache miss count</td>
</tr>
<tr>
<td><code>plan_cache_hit_rate</code></td>
<td>Hit rate percentage</td>
</tr>
<tr>
<td><code>avg_plan_time_ms</code></td>
<td>Average planning time</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="storage-statistics" class="position-relative d-flex align-items-center group">
<span>Storage Statistics</span>
<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="storage-statistics"
aria-haspopup="dialog"
aria-label="Share link: Storage Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="database-size" class="position-relative d-flex align-items-center group">
<span>Database Size</span>
<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="database-size"
aria-haspopup="dialog"
aria-label="Share link: Database Size">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Overall</span><span class="w"> </span><span class="py">storage</span><span class="w"> </span><span class="py">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">storage</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Output:</strong></p>
<table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>data_size_bytes</code></td>
<td>Gauge</td>
<td>Total data file size</td>
</tr>
<tr>
<td><code>index_size_bytes</code></td>
<td>Gauge</td>
<td>Total index size</td>
</tr>
<tr>
<td><code>wal_size_bytes</code></td>
<td>Gauge</td>
<td>Write-ahead log size</td>
</tr>
<tr>
<td><code>total_size_bytes</code></td>
<td>Gauge</td>
<td>Total disk usage</td>
</tr>
<tr>
<td><code>page_count</code></td>
<td>Gauge</td>
<td>Total pages allocated</td>
</tr>
<tr>
<td><code>used_pages</code></td>
<td>Gauge</td>
<td>Pages with data</td>
</tr>
<tr>
<td><code>free_pages</code></td>
<td>Gauge</td>
<td>Available pages</td>
</tr>
<tr>
<td><code>fragmentation_ratio</code></td>
<td>Gauge</td>
<td>Space fragmentation (0-1)</td>
</tr>
</tbody>
</table>
<h4 id="graph-statistics" class="position-relative d-flex align-items-center group">
<span>Graph Statistics</span>
<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="graph-statistics"
aria-haspopup="dialog"
aria-label="Share link: Graph Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Graph</span><span class="w"> </span><span class="py">element</span><span class="w"> </span><span class="py">counts</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">graph</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>node_count</code></td>
<td>Total nodes</td>
</tr>
<tr>
<td><code>relationship_count</code></td>
<td>Total relationships</td>
</tr>
<tr>
<td><code>label_count</code></td>
<td>Distinct node labels</td>
</tr>
<tr>
<td><code>relationship_type_count</code></td>
<td>Distinct relationship types</td>
</tr>
<tr>
<td><code>property_key_count</code></td>
<td>Distinct property keys</td>
</tr>
</tbody>
</table>
<h4 id="label-statistics" class="position-relative d-flex align-items-center group">
<span>Label Statistics</span>
<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="label-statistics"
aria-haspopup="dialog"
aria-label="Share link: Label Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Statistics</span><span class="w"> </span><span class="py">per</span><span class="w"> </span><span class="py">label</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">labels</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Per-label metrics:</strong></p>
<table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>node_count</code></td>
<td>Nodes with this label</td>
</tr>
<tr>
<td><code>avg_property_count</code></td>
<td>Average properties per node</td>
</tr>
<tr>
<td><code>avg_relationship_count</code></td>
<td>Average relationships per node</td>
</tr>
</tbody>
</table>
<h4 id="relationship-type-statistics" class="position-relative d-flex align-items-center group">
<span>Relationship Type Statistics</span>
<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="relationship-type-statistics"
aria-haspopup="dialog"
aria-label="Share link: Relationship Type Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Statistics</span><span class="w"> </span><span class="py">per</span><span class="w"> </span><span class="py">relationship</span><span class="w"> </span><span class="kd">type</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="nc">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">relationship_types</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Per-type metrics:</strong></p>
<table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>count</code></td>
<td>Relationships of this type</td>
</tr>
<tr>
<td><code>avg_property_count</code></td>
<td>Average properties per relationship</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="index-statistics" class="position-relative d-flex align-items-center group">
<span>Index Statistics</span>
<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="index-statistics"
aria-haspopup="dialog"
aria-label="Share link: Index Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="index-overview" class="position-relative d-flex align-items-center group">
<span>Index Overview</span>
<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="index-overview"
aria-haspopup="dialog"
aria-label="Share link: Index Overview">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">All</span><span class="w"> </span><span class="py">index</span><span class="w"> </span><span class="py">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">indexes</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Per-index metrics:</strong></p>
<table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>index_name</code></td>
<td>String</td>
<td>Index identifier</td>
</tr>
<tr>
<td><code>index_type</code></td>
<td>String</td>
<td>btree, hash, fulltext, etc.</td>
</tr>
<tr>
<td><code>label</code></td>
<td>String</td>
<td>Target label</td>
</tr>
<tr>
<td><code>property</code></td>
<td>String</td>
<td>Indexed property</td>
</tr>
<tr>
<td><code>size_bytes</code></td>
<td>Gauge</td>
<td>Index storage size</td>
</tr>
<tr>
<td><code>entry_count</code></td>
<td>Gauge</td>
<td>Number of indexed entries</td>
</tr>
<tr>
<td><code>unique_values</code></td>
<td>Gauge</td>
<td>Distinct indexed values</td>
</tr>
<tr>
<td><code>null_count</code></td>
<td>Gauge</td>
<td>NULL entries</td>
</tr>
<tr>
<td><code>avg_values_per_key</code></td>
<td>Gauge</td>
<td>Average duplicates per key</td>
</tr>
</tbody>
</table>
<h4 id="index-usage-statistics" class="position-relative d-flex align-items-center group">
<span>Index Usage Statistics</span>
<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="index-usage-statistics"
aria-haspopup="dialog"
aria-label="Share link: Index Usage Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Index</span><span class="w"> </span><span class="py">usage</span><span class="w"> </span><span class="py">metrics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">index_usage</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>reads</code></td>
<td>Index read operations</td>
</tr>
<tr>
<td><code>scans</code></td>
<td>Full index scans</td>
</tr>
<tr>
<td><code>seeks</code></td>
<td>Point lookups</td>
</tr>
<tr>
<td><code>range_scans</code></td>
<td>Range query operations</td>
</tr>
<tr>
<td><code>updates</code></td>
<td>Index update operations</td>
</tr>
<tr>
<td><code>last_used</code></td>
<td>Timestamp of last use</td>
</tr>
</tbody>
</table>
<h4 id="index-health" class="position-relative d-flex align-items-center group">
<span>Index Health</span>
<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="index-health"
aria-haspopup="dialog"
aria-label="Share link: Index Health">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Check</span><span class="w"> </span><span class="py">index</span><span class="w"> </span><span class="py">health</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">index_health</span><span class="p">(</span><span class="err">'</span><span class="py">index_name</span><span class="err">'</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
<th>Healthy Range</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>fragmentation</code></td>
<td>Internal fragmentation</td>
<td>< 0.3</td>
</tr>
<tr>
<td><code>depth</code></td>
<td>Tree depth (B-tree)</td>
<td>< 5</td>
</tr>
<tr>
<td><code>fill_factor</code></td>
<td>Page fill ratio</td>
<td>> 0.7</td>
</tr>
<tr>
<td><code>bloom_false_positive_rate</code></td>
<td>Bloom filter FP rate</td>
<td>< 0.01</td>
</tr>
</tbody>
</table>
<h4 id="manual-statistics-update" class="position-relative d-flex align-items-center group">
<span>Manual Statistics Update</span>
<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="manual-statistics-update"
aria-haspopup="dialog"
aria-label="Share link: Manual Statistics Update">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Update</span><span class="w"> </span><span class="py">statistics</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">all</span><span class="w"> </span><span class="py">indexes</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">update</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Update</span><span class="w"> </span><span class="py">statistics</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">specific</span><span class="w"> </span><span class="py">label</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">update</span><span class="p">(</span><span class="err">'</span><span class="py">Person</span><span class="err">'</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Update</span><span class="w"> </span><span class="py">specific</span><span class="w"> </span><span class="py">index</span><span class="w"> </span><span class="py">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">index</span><span class="err">.</span><span class="py">analyze</span><span class="p">(</span><span class="err">'</span><span class="py">person_email_idx</span><span class="err">'</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="cardinality-estimation" class="position-relative d-flex align-items-center group">
<span>Cardinality Estimation</span>
<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="cardinality-estimation"
aria-haspopup="dialog"
aria-label="Share link: Cardinality Estimation">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><p>The query optimizer uses cardinality estimates for cost-based optimization.</p>
<h4 id="histogram-statistics" class="position-relative d-flex align-items-center group">
<span>Histogram Statistics</span>
<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="histogram-statistics"
aria-haspopup="dialog"
aria-label="Share link: Histogram Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">View</span><span class="w"> </span><span class="py">histograms</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">a</span><span class="w"> </span><span class="py">property</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">histogram</span><span class="p">(</span><span class="err">'</span><span class="py">Person</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">age</span><span class="err">'</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><p><strong>Output:</strong></p>
<table>
<thead>
<tr>
<th>Column</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>bucket_min</code></td>
<td>Bucket lower bound</td>
</tr>
<tr>
<td><code>bucket_max</code></td>
<td>Bucket upper bound</td>
</tr>
<tr>
<td><code>frequency</code></td>
<td>Row count in bucket</td>
</tr>
<tr>
<td><code>cumulative_frequency</code></td>
<td>Cumulative row count</td>
</tr>
<tr>
<td><code>distinct_count</code></td>
<td>Distinct values in bucket</td>
</tr>
</tbody>
</table>
<h4 id="selectivity-estimates" class="position-relative d-flex align-items-center group">
<span>Selectivity Estimates</span>
<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="selectivity-estimates"
aria-haspopup="dialog"
aria-label="Share link: Selectivity Estimates">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Estimate</span><span class="w"> </span><span class="py">predicate</span><span class="w"> </span><span class="py">selectivity</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">selectivity</span><span class="p">(</span><span class="err">'</span><span class="py">Person</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="err">'</span><span class="py">age</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">30</span><span class="err">'</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>estimated_rows</code></td>
<td>Rows matching predicate</td>
</tr>
<tr>
<td><code>selectivity</code></td>
<td>Fraction of total (0-1)</td>
</tr>
<tr>
<td><code>confidence</code></td>
<td>Estimate confidence (low/medium/high)</td>
</tr>
</tbody>
</table>
<h4 id="statistics-configuration" class="position-relative d-flex align-items-center group">
<span>Statistics Configuration</span>
<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="statistics-configuration"
aria-haspopup="dialog"
aria-label="Share link: Statistics Configuration">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"><span class="line"><span class="cl"><span class="nt">statistics</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">auto_update</span><span class="p">:</span><span class="w"> </span><span class="kc">true</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">update_threshold</span><span class="p">:</span><span class="w"> </span><span class="m">10000</span><span class="w"> </span><span class="c"># Update after N modifications</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">sample_size</span><span class="p">:</span><span class="w"> </span><span class="m">1000</span><span class="w"> </span><span class="c"># Rows sampled for histograms</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">histogram_buckets</span><span class="p">:</span><span class="w"> </span><span class="m">100</span><span class="w"> </span><span class="c"># Number of histogram buckets</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">update_interval</span><span class="p">:</span><span class="w"> </span><span class="m">3600</span><span class="w"> </span><span class="c"># Auto-update interval (seconds)</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="transaction-statistics" class="position-relative d-flex align-items-center group">
<span>Transaction Statistics</span>
<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="transaction-statistics"
aria-haspopup="dialog"
aria-label="Share link: Transaction Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Transaction</span><span class="w"> </span><span class="py">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">transactions</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>active_transactions</code></td>
<td>Gauge</td>
<td>Currently open transactions</td>
</tr>
<tr>
<td><code>total_commits</code></td>
<td>Counter</td>
<td>Successful commits</td>
</tr>
<tr>
<td><code>total_rollbacks</code></td>
<td>Counter</td>
<td>Rollbacks</td>
</tr>
<tr>
<td><code>commit_rate</code></td>
<td>Gauge</td>
<td>Commits per second</td>
</tr>
<tr>
<td><code>avg_transaction_time_ms</code></td>
<td>Gauge</td>
<td>Average transaction duration</td>
</tr>
<tr>
<td><code>deadlock_count</code></td>
<td>Counter</td>
<td>Deadlock occurrences</td>
</tr>
<tr>
<td><code>lock_wait_time_ms</code></td>
<td>Counter</td>
<td>Total lock wait time</td>
</tr>
</tbody>
</table>
<h4 id="lock-statistics" class="position-relative d-flex align-items-center group">
<span>Lock Statistics</span>
<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="lock-statistics"
aria-haspopup="dialog"
aria-label="Share link: Lock Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Current</span><span class="w"> </span><span class="py">lock</span><span class="w"> </span><span class="py">information</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">locks</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>active_locks</code></td>
<td>Currently held locks</td>
</tr>
<tr>
<td><code>waiting_locks</code></td>
<td>Lock requests waiting</td>
</tr>
<tr>
<td><code>lock_timeouts</code></td>
<td>Lock timeout count</td>
</tr>
<tr>
<td><code>avg_lock_wait_ms</code></td>
<td>Average lock wait time</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="connection-statistics" class="position-relative d-flex align-items-center group">
<span>Connection Statistics</span>
<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="connection-statistics"
aria-haspopup="dialog"
aria-label="Share link: Connection Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Connection</span><span class="w"> </span><span class="py">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">connections</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>active_connections</code></td>
<td>Gauge</td>
<td>Currently connected clients</td>
</tr>
<tr>
<td><code>total_connections</code></td>
<td>Counter</td>
<td>Total connections (lifetime)</td>
</tr>
<tr>
<td><code>connection_errors</code></td>
<td>Counter</td>
<td>Failed connection attempts</td>
</tr>
<tr>
<td><code>max_connections</code></td>
<td>Gauge</td>
<td>Connection limit</td>
</tr>
<tr>
<td><code>available_connections</code></td>
<td>Gauge</td>
<td>Available connection slots</td>
</tr>
</tbody>
</table>
<h4 id="per-client-statistics" class="position-relative d-flex align-items-center group">
<span>Per-Client Statistics</span>
<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="per-client-statistics"
aria-haspopup="dialog"
aria-label="Share link: Per-Client Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Statistics</span><span class="w"> </span><span class="py">per</span><span class="w"> </span><span class="py">connected</span><span class="w"> </span><span class="py">client</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">clients</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Column</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>client_id</code></td>
<td>Client identifier</td>
</tr>
<tr>
<td><code>user</code></td>
<td>Authenticated user</td>
</tr>
<tr>
<td><code>ip_address</code></td>
<td>Client IP</td>
</tr>
<tr>
<td><code>connected_at</code></td>
<td>Connection timestamp</td>
</tr>
<tr>
<td><code>queries_executed</code></td>
<td>Query count for session</td>
</tr>
<tr>
<td><code>bytes_sent</code></td>
<td>Data sent to client</td>
</tr>
<tr>
<td><code>bytes_received</code></td>
<td>Data received from client</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="system-metrics" class="position-relative d-flex align-items-center group">
<span>System Metrics</span>
<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="system-metrics"
aria-haspopup="dialog"
aria-label="Share link: System Metrics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="resource-utilization" class="position-relative d-flex align-items-center group">
<span>Resource Utilization</span>
<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="resource-utilization"
aria-haspopup="dialog"
aria-label="Share link: Resource Utilization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">System</span><span class="w"> </span><span class="py">resource</span><span class="w"> </span><span class="py">metrics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">system</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>cpu_usage_percent</code></td>
<td>Gauge</td>
<td>CPU utilization</td>
</tr>
<tr>
<td><code>memory_used_bytes</code></td>
<td>Gauge</td>
<td>Memory in use</td>
</tr>
<tr>
<td><code>memory_available_bytes</code></td>
<td>Gauge</td>
<td>Available memory</td>
</tr>
<tr>
<td><code>memory_heap_bytes</code></td>
<td>Gauge</td>
<td>Heap memory usage</td>
</tr>
<tr>
<td><code>gc_pause_ms</code></td>
<td>Histogram</td>
<td>GC pause times</td>
</tr>
<tr>
<td><code>gc_count</code></td>
<td>Counter</td>
<td>GC cycles</td>
</tr>
</tbody>
</table>
<h4 id="io-statistics" class="position-relative d-flex align-items-center group">
<span>I/O Statistics</span>
<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="io-statistics"
aria-haspopup="dialog"
aria-label="Share link: I/O Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Disk</span><span class="w"> </span><span class="py">I</span><span class="err">/</span><span class="py">O</span><span class="w"> </span><span class="py">statistics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">io</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Type</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>read_bytes</code></td>
<td>Counter</td>
<td>Bytes read from disk</td>
</tr>
<tr>
<td><code>write_bytes</code></td>
<td>Counter</td>
<td>Bytes written to disk</td>
</tr>
<tr>
<td><code>read_ops</code></td>
<td>Counter</td>
<td>Read operations</td>
</tr>
<tr>
<td><code>write_ops</code></td>
<td>Counter</td>
<td>Write operations</td>
</tr>
<tr>
<td><code>read_latency_ms</code></td>
<td>Histogram</td>
<td>Read latency</td>
</tr>
<tr>
<td><code>write_latency_ms</code></td>
<td>Histogram</td>
<td>Write latency</td>
</tr>
<tr>
<td><code>fsync_count</code></td>
<td>Counter</td>
<td>fsync operations</td>
</tr>
<tr>
<td><code>fsync_latency_ms</code></td>
<td>Histogram</td>
<td>fsync latency</td>
</tr>
</tbody>
</table>
<h4 id="buffer-pool-statistics" class="position-relative d-flex align-items-center group">
<span>Buffer Pool Statistics</span>
<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="buffer-pool-statistics"
aria-haspopup="dialog"
aria-label="Share link: Buffer Pool Statistics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Buffer</span><span class="w"> </span><span class="py">pool</span><span class="w"> </span><span class="py">metrics</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">db</span><span class="err">.</span><span class="py">stats</span><span class="err">.</span><span class="py">buffer_pool</span><span class="p">()</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div><table>
<thead>
<tr>
<th>Metric</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>pool_size_pages</code></td>
<td>Total buffer pool pages</td>
</tr>
<tr>
<td><code>used_pages</code></td>
<td>Pages in use</td>
</tr>
<tr>
<td><code>dirty_pages</code></td>
<td>Modified pages pending write</td>
</tr>
<tr>
<td><code>hit_rate</code></td>
<td>Buffer cache hit rate</td>
</tr>
<tr>
<td><code>evictions</code></td>
<td>Page evictions</td>
</tr>
<tr>
<td><code>reads_from_disk</code></td>
<td>Cache misses</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="prometheus-integration" class="position-relative d-flex align-items-center group">
<span>Prometheus Integration</span>
<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-integration"
aria-haspopup="dialog"
aria-label="Share link: Prometheus Integration">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="metrics-endpoint" class="position-relative d-flex align-items-center group">
<span>Metrics Endpoint</span>
<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="metrics-endpoint"
aria-haspopup="dialog"
aria-label="Share link: Metrics Endpoint">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p>Geode exposes metrics in Prometheus format at <code>/metrics</code>:</p>
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"><span class="line"><span class="cl">curl http://localhost:3141/metrics
</span></span></code></pre></div>
<h4 id="sample-output" class="position-relative d-flex align-items-center group">
<span>Sample Output</span>
<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="sample-output"
aria-haspopup="dialog"
aria-label="Share link: Sample Output">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback"><span class="line"><span class="cl"># HELP geode_queries_total Total queries executed
</span></span><span class="line"><span class="cl"># TYPE geode_queries_total counter
</span></span><span class="line"><span class="cl">geode_queries_total{status="success"} 1234567
</span></span><span class="line"><span class="cl">geode_queries_total{status="error"} 123
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"># HELP geode_query_duration_seconds Query execution time
</span></span><span class="line"><span class="cl"># TYPE geode_query_duration_seconds histogram
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_bucket{le="0.001"} 10000
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_bucket{le="0.01"} 50000
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_bucket{le="0.1"} 100000
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_bucket{le="1.0"} 120000
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_bucket{le="+Inf"} 123456
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_sum 12345.67
</span></span><span class="line"><span class="cl">geode_query_duration_seconds_count 123456
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"># HELP geode_connections_active Active client connections
</span></span><span class="line"><span class="cl"># TYPE geode_connections_active gauge
</span></span><span class="line"><span class="cl">geode_connections_active 42
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"># HELP geode_storage_bytes Storage size in bytes
</span></span><span class="line"><span class="cl"># TYPE geode_storage_bytes gauge
</span></span><span class="line"><span class="cl">geode_storage_bytes{type="data"} 1073741824
</span></span><span class="line"><span class="cl">geode_storage_bytes{type="index"} 268435456
</span></span><span class="line"><span class="cl">geode_storage_bytes{type="wal"} 134217728
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"># HELP geode_nodes_total Total nodes in database
</span></span><span class="line"><span class="cl"># TYPE geode_nodes_total gauge
</span></span><span class="line"><span class="cl">geode_nodes_total 1000000
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"># HELP geode_relationships_total Total relationships
</span></span><span class="line"><span class="cl"># TYPE geode_relationships_total gauge
</span></span><span class="line"><span class="cl">geode_relationships_total 5000000
</span></span></code></pre></div>
<h4 id="prometheus-configuration" class="position-relative d-flex align-items-center group">
<span>Prometheus Configuration</span>
<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-configuration"
aria-haspopup="dialog"
aria-label="Share link: Prometheus Configuration">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"><span class="line"><span class="cl"><span class="c"># prometheus.yml</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="nt">scrape_configs</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">job_name</span><span class="p">:</span><span class="w"> </span><span class="s1">'geode'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">static_configs</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">targets</span><span class="p">:</span><span class="w"> </span><span class="p">[</span><span class="s1">'geode-server:3141'</span><span class="p">]</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">metrics_path</span><span class="p">:</span><span class="w"> </span><span class="s1">'/metrics'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">scrape_interval</span><span class="p">:</span><span class="w"> </span><span class="l">15s</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="available-prometheus-metrics" class="position-relative d-flex align-items-center group">
<span>Available Prometheus Metrics</span>
<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="available-prometheus-metrics"
aria-haspopup="dialog"
aria-label="Share link: Available Prometheus Metrics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><table>
<thead>
<tr>
<th>Metric Name</th>
<th>Type</th>
<th>Labels</th>
<th>Description</th>
</tr>
</thead>
<tbody>
<tr>
<td><code>geode_queries_total</code></td>
<td>Counter</td>
<td>status</td>
<td>Total queries</td>
</tr>
<tr>
<td><code>geode_query_duration_seconds</code></td>
<td>Histogram</td>
<td>-</td>
<td>Query latency</td>
</tr>
<tr>
<td><code>geode_connections_active</code></td>
<td>Gauge</td>
<td>-</td>
<td>Active connections</td>
</tr>
<tr>
<td><code>geode_connections_total</code></td>
<td>Counter</td>
<td>-</td>
<td>Total connections</td>
</tr>
<tr>
<td><code>geode_transactions_total</code></td>
<td>Counter</td>
<td>status</td>
<td>Transaction count</td>
</tr>
<tr>
<td><code>geode_storage_bytes</code></td>
<td>Gauge</td>
<td>type</td>
<td>Storage usage</td>
</tr>
<tr>
<td><code>geode_nodes_total</code></td>
<td>Gauge</td>
<td>label</td>
<td>Node count</td>
</tr>
<tr>
<td><code>geode_relationships_total</code></td>
<td>Gauge</td>
<td>type</td>
<td>Relationship count</td>
</tr>
<tr>
<td><code>geode_index_size_bytes</code></td>
<td>Gauge</td>
<td>index</td>
<td>Index sizes</td>
</tr>
<tr>
<td><code>geode_buffer_pool_hit_ratio</code></td>
<td>Gauge</td>
<td>-</td>
<td>Cache hit rate</td>
</tr>
<tr>
<td><code>geode_wal_size_bytes</code></td>
<td>Gauge</td>
<td>-</td>
<td>WAL size</td>
</tr>
<tr>
<td><code>geode_gc_pause_seconds</code></td>
<td>Histogram</td>
<td>-</td>
<td>GC pauses</td>
</tr>
</tbody>
</table>
<hr>
<h3 id="alerting-guidelines" class="position-relative d-flex align-items-center group">
<span>Alerting Guidelines</span>
<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-guidelines"
aria-haspopup="dialog"
aria-label="Share link: Alerting Guidelines">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="recommended-alerts" class="position-relative d-flex align-items-center group">
<span>Recommended Alerts</span>
<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="recommended-alerts"
aria-haspopup="dialog"
aria-label="Share link: Recommended Alerts">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"><span class="line"><span class="cl"><span class="c"># Alert rules for Geode</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="nt">groups</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">name</span><span class="p">:</span><span class="w"> </span><span class="l">geode_alerts</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">rules</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="c"># High query latency</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">alert</span><span class="p">:</span><span class="w"> </span><span class="l">GeodeHighQueryLatency</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">expr</span><span class="p">:</span><span class="w"> </span><span class="l">histogram_quantile(0.95, geode_query_duration_seconds_bucket) > 1</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">for</span><span class="p">:</span><span class="w"> </span><span class="l">5m</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">labels</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">severity</span><span class="p">:</span><span class="w"> </span><span class="l">warning</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">annotations</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">summary</span><span class="p">:</span><span class="w"> </span><span class="s2">"High query latency detected"</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="c"># Connection pool exhaustion</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">alert</span><span class="p">:</span><span class="w"> </span><span class="l">GeodeConnectionPoolLow</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">expr</span><span class="p">:</span><span class="w"> </span><span class="l">geode_connections_active / geode_connections_max > 0.9</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">for</span><span class="p">:</span><span class="w"> </span><span class="l">5m</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">labels</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">severity</span><span class="p">:</span><span class="w"> </span><span class="l">critical</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">annotations</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">summary</span><span class="p">:</span><span class="w"> </span><span class="s2">"Connection pool nearly exhausted"</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="c"># Storage space</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">alert</span><span class="p">:</span><span class="w"> </span><span class="l">GeodeStorageHigh</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">expr</span><span class="p">:</span><span class="w"> </span><span class="l">geode_storage_bytes{type="data"} > 100e9</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">for</span><span class="p">:</span><span class="w"> </span><span class="l">1h</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">labels</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">severity</span><span class="p">:</span><span class="w"> </span><span class="l">warning</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">annotations</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">summary</span><span class="p">:</span><span class="w"> </span><span class="s2">"Database storage exceeds 100GB"</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="c"># Buffer pool hit rate</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span>- <span class="nt">alert</span><span class="p">:</span><span class="w"> </span><span class="l">GeodeLowCacheHitRate</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">expr</span><span class="p">:</span><span class="w"> </span><span class="l">geode_buffer_pool_hit_ratio < 0.9</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">for</span><span class="p">:</span><span class="w"> </span><span class="l">10m</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">labels</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">severity</span><span class="p">:</span><span class="w"> </span><span class="l">warning</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">annotations</span><span class="p">:</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="nt">summary</span><span class="p">:</span><span class="w"> </span><span class="s2">"Buffer pool hit rate below 90%"</span><span class="w">
</span></span></span></code></pre></div><hr>
<h3 id="grafana-dashboards" class="position-relative d-flex align-items-center group">
<span>Grafana Dashboards</span>
<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="grafana-dashboards"
aria-haspopup="dialog"
aria-label="Share link: Grafana Dashboards">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="key-panels" class="position-relative d-flex align-items-center group">
<span>Key Panels</span>
<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="key-panels"
aria-haspopup="dialog"
aria-label="Share link: Key Panels">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p><strong>Query Performance:</strong></p>
<ul>
<li>Queries per second (rate)</li>
<li>Query latency percentiles (p50, p95, p99)</li>
<li>Slow query count</li>
<li>Error rate</li>
</ul>
<p><strong>Storage:</strong></p>
<ul>
<li>Database size growth</li>
<li>Index size breakdown</li>
<li>WAL size</li>
<li>Fragmentation ratio</li>
</ul>
<p><strong>Resources:</strong></p>
<ul>
<li>Buffer pool hit rate</li>
<li>Memory usage</li>
<li>I/O throughput</li>
<li>Connection count</li>
</ul>
<h4 id="example-dashboard-json" class="position-relative d-flex align-items-center group">
<span>Example Dashboard JSON</span>
<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="example-dashboard-json"
aria-haspopup="dialog"
aria-label="Share link: Example Dashboard JSON">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json"><span class="line"><span class="cl"><span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"dashboard"</span><span class="p">:</span> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"title"</span><span class="p">:</span> <span class="s2">"Geode Database"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"panels"</span><span class="p">:</span> <span class="p">[</span>
</span></span><span class="line"><span class="cl"> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"title"</span><span class="p">:</span> <span class="s2">"Query Rate"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"type"</span><span class="p">:</span> <span class="s2">"graph"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"targets"</span><span class="p">:</span> <span class="p">[</span>
</span></span><span class="line"><span class="cl"> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"expr"</span><span class="p">:</span> <span class="s2">"rate(geode_queries_total[5m])"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"legendFormat"</span><span class="p">:</span> <span class="s2">"{{status}}"</span>
</span></span><span class="line"><span class="cl"> <span class="p">}</span>
</span></span><span class="line"><span class="cl"> <span class="p">]</span>
</span></span><span class="line"><span class="cl"> <span class="p">},</span>
</span></span><span class="line"><span class="cl"> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"title"</span><span class="p">:</span> <span class="s2">"Query Latency (p95)"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"type"</span><span class="p">:</span> <span class="s2">"graph"</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"targets"</span><span class="p">:</span> <span class="p">[</span>
</span></span><span class="line"><span class="cl"> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="nt">"expr"</span><span class="p">:</span> <span class="s2">"histogram_quantile(0.95, rate(geode_query_duration_seconds_bucket[5m]))"</span>
</span></span><span class="line"><span class="cl"> <span class="p">}</span>
</span></span><span class="line"><span class="cl"> <span class="p">]</span>
</span></span><span class="line"><span class="cl"> <span class="p">}</span>
</span></span><span class="line"><span class="cl"> <span class="p">]</span>
</span></span><span class="line"><span class="cl"> <span class="p">}</span>
</span></span><span class="line"><span class="cl"><span class="p">}</span>
</span></span></code></pre></div><hr>
<h3 id="best-practices" class="position-relative d-flex align-items-center group">
<span>Best Practices</span>
<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">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="statistics-collection" class="position-relative d-flex align-items-center group">
<span>Statistics Collection</span>
<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="statistics-collection"
aria-haspopup="dialog"
aria-label="Share link: Statistics Collection">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ol>
<li><strong>Enable auto-update</strong> for query optimizer accuracy</li>
<li><strong>Monitor slow queries</strong> with appropriate thresholds</li>
<li><strong>Track index usage</strong> to identify unused indexes</li>
<li><strong>Set up alerting</strong> for critical metrics</li>
</ol>
<h4 id="performance-monitoring" class="position-relative d-flex align-items-center group">
<span>Performance Monitoring</span>
<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-monitoring"
aria-haspopup="dialog"
aria-label="Share link: Performance Monitoring">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ol>
<li><strong>Baseline metrics</strong> during normal operation</li>
<li><strong>Track trends</strong> over time</li>
<li><strong>Correlate metrics</strong> (e.g., latency vs. connection count)</li>
<li><strong>Review after changes</strong> (schema, indexes, configuration)</li>
</ol>
<h4 id="capacity-planning" class="position-relative d-flex align-items-center group">
<span>Capacity Planning</span>
<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="capacity-planning"
aria-haspopup="dialog"
aria-label="Share link: Capacity Planning">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ol>
<li><strong>Monitor storage growth</strong> rate</li>
<li><strong>Track query volume</strong> trends</li>
<li><strong>Plan index storage</strong> needs</li>
<li><strong>Size buffer pool</strong> based on working set</li>
</ol>
<hr>
<h3 id="related-documentation" class="position-relative d-flex align-items-center group">
<span>Related Documentation</span>
<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-documentation"
aria-haspopup="dialog"
aria-label="Share link: Related Documentation">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><ul>
<li><a
href="/docs/ops/observability/"
>Observability Guide</a>
- Monitoring setup</li>
<li><a
href="/docs/query/performance-tuning/"
>Performance Tuning</a>
- Optimization guide</li>
<li><a
href="/docs/reference/indexes/"
>Index Types Reference</a>
- Index statistics</li>
<li><a
href="/docs/ops/telemetry-advanced/"
>Telemetry</a>
- Advanced telemetry</li>
</ul>
<hr>
<p><strong>Last Updated:</strong> January 28, 2026
<strong>Geode Version:</strong> <strong>v0.2.18</strong>+
<strong>Metrics Count:</strong> 50+ observable metrics</p>
Statistics and Metrics Reference
Complete reference for Geode statistics, metrics, and monitoring including query statistics, storage metrics, index statistics, and Prometheus integration