Tag: Query Optimization

Documentation tagged with query-optimization in the Geode graph database. This comprehensive collection covers query performance analysis, optimization techniques, execution plan understanding, and strategies for achieving maximum efficiency in your GQL queries. <h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <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"> 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>Query optimization is critical for building high-performance graph applications. Geode provides powerful tools for analyzing and optimizing query execution, including the EXPLAIN command for execution plan analysis, the PROFILE command for runtime performance metrics, and advanced index strategies for accelerating pattern matching and traversals. Understanding query optimization helps you: <ul> <li>Analyze Query Performance: Use EXPLAIN to understand execution strategies</li> <li>Optimize Index Usage: Design indexes that accelerate critical access patterns</li> <li>Reduce Execution Time: Apply optimization techniques to slow queries</li> <li>Scale to Production: Ensure consistent performance under load</li> <li>Debug Performance Issues: Identify and resolve bottlenecks systematically</li> </ul> <h3 id="core-concepts" class="position-relative d-flex align-items-center group"> Core Concepts <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="core-concepts" aria-haspopup="dialog" aria-label="Share link: Core Concepts"> Share link </button> </h3> <h4 id="execution-plan-analysis" class="position-relative d-flex align-items-center group"> Execution Plan Analysis <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="execution-plan-analysis" aria-haspopup="dialog" aria-label="Share link: Execution Plan Analysis"> Share link </button> </h4>Geode’s query optimizer generates execution plans that determine how queries are executed: Understanding EXPLAIN Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Analyze a pattern match query EXPLAIN MATCH (u:User)-[:FOLLOWS]->(f:User) WHERE u.name = 'Alice' RETURN f.name, f.created_at ORDER BY f.created_at DESC LIMIT 10 // Output shows: // 1. Access method (index seek vs scan) // 2. Join strategy (nested loop, hash join) // 3. Filter application points // 4. Sort operations // 5. Estimated row counts </code></pre></div>Key Plan Components: <ul> <li>Access Methods: Index seek, index scan, full scan</li> <li>Join Strategies: Nested loop, hash join, merge join</li> <li>Filter Placement: Early vs late predicate application</li> <li>Sort Operations: In-memory vs external sort</li> <li>Projection: Column selection and transformation</li> </ul> <h4 id="index-strategy" class="position-relative d-flex align-items-center group"> Index Strategy <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-strategy" aria-haspopup="dialog" aria-label="Share link: Index Strategy"> Share link </button> </h4>Indexes dramatically accelerate query execution when used effectively: Index Types: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Property index for equality lookups CREATE INDEX user_email_idx ON User(email); // Composite index for multi-property filters CREATE INDEX user_location_idx ON User(city, state); // Label index for type-based queries CREATE INDEX transaction_type_idx ON Transaction(type, amount); </code></pre></div>Index Selection Rules: <ol> <li>Equality First: Indexes work best for equality predicates</li> <li>Prefix Matching: Composite indexes match left-to-right</li> <li>Cardinality Matters: High-cardinality columns benefit most</li> <li>Covering Indexes: Include all referenced properties when possible</li> </ol> <h4 id="pattern-matching-efficiency" class="position-relative d-flex align-items-center group"> Pattern Matching Efficiency <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="pattern-matching-efficiency" aria-haspopup="dialog" aria-label="Share link: Pattern Matching Efficiency"> Share link </button> </h4>Graph pattern matching can be optimized through careful query design: Optimization Techniques: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// BEFORE: Inefficient - scans all users MATCH (u:User)-[:FOLLOWS]->(f:User) WHERE f.name STARTS WITH 'A' RETURN u.name, f.name; // AFTER: Optimized - uses index on target first MATCH (f:User)-[:FOLLOWS]-(u:User) WHERE f.name STARTS WITH 'A' RETURN u.name, f.name; // Even better: Add index CREATE INDEX user_name_prefix_idx ON User(name); </code></pre></div>Pattern Ordering: <ul> <li>Filter Early: Apply selective predicates first</li> <li>Index-Backed Patterns: Start with indexed properties</li> <li>Relationship Direction: Consider relationship cardinality</li> <li>Optional Matches: Use sparingly, can force Cartesian products</li> </ul> <h3 id="optimization-strategies" class="position-relative d-flex align-items-center group"> Optimization Strategies <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="optimization-strategies" aria-haspopup="dialog" aria-label="Share link: Optimization Strategies"> Share link </button> </h3> <h4 id="query-rewriting" class="position-relative d-flex align-items-center group"> Query Rewriting <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-rewriting" aria-haspopup="dialog" aria-label="Share link: Query Rewriting"> Share link </button> </h4>Restructure queries for better performance: Predicate Pushdown: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// BEFORE: Filter after aggregation MATCH (u:User)-[:PURCHASED]->(p:Product) WITH u, COUNT(p) AS purchase_count WHERE purchase_count > 10 RETURN u.name, purchase_count; // AFTER: Filter during traversal MATCH (u:User)-[:PURCHASED]->(p:Product) WITH u, p WHERE u.account_status = 'active' WITH u, COUNT(p) AS purchase_count WHERE purchase_count > 10 RETURN u.name, purchase_count; </code></pre></div>Join Elimination: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// BEFORE: Unnecessary self-join MATCH (u1:User)-[:FOLLOWS]->(u2:User) MATCH (u2)-[:POSTS]->(p:Post) WHERE u1.id = 'user123' RETURN p; // AFTER: Direct path MATCH (u:User {id: 'user123'})-[:FOLLOWS]->()-[:POSTS]->(p:Post) RETURN p; </code></pre></div> <h4 id="aggregation-optimization" class="position-relative d-flex align-items-center group"> Aggregation 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="aggregation-optimization" aria-haspopup="dialog" aria-label="Share link: Aggregation Optimization"> Share link </button> </h4>Optimize aggregation queries for large datasets: Incremental Aggregation: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Use WITH to aggregate incrementally MATCH (u:User)-[:PURCHASED]->(p:Product)-[:IN_CATEGORY]->(c:Category) WHERE u.region = 'West' WITH c, SUM(p.price) AS category_total WHERE category_total > 1000 RETURN c.name, category_total ORDER BY category_total DESC; </code></pre></div>Pre-Aggregated Data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Maintain aggregates for fast access MATCH (u:User) SET u.total_purchases = size((u)-[:PURCHASED]->()); // Query uses pre-computed value MATCH (u:User) WHERE u.total_purchases > 100 RETURN u.name, u.total_purchases; </code></pre></div> <h4 id="index-coverage" class="position-relative d-flex align-items-center group"> Index Coverage <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-coverage" aria-haspopup="dialog" aria-label="Share link: Index Coverage"> Share link </button> </h4>Design indexes that cover entire queries: Covering Index Example: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Create covering index CREATE INDEX user_profile_idx ON User(city, state, age, name); // Query uses index without accessing node MATCH (u:User) WHERE u.city = 'Seattle' AND u.state = 'WA' AND u.age > 25 RETURN u.name; // All data comes from index, no node lookup needed </code></pre></div> <h3 id="performance-tools" class="position-relative d-flex align-items-center group"> Performance Tools <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-tools" aria-haspopup="dialog" aria-label="Share link: Performance Tools"> Share link </button> </h3> <h4 id="explain-command" class="position-relative d-flex align-items-center group"> EXPLAIN Command <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="explain-command" aria-haspopup="dialog" aria-label="Share link: EXPLAIN Command"> Share link </button> </h4>Analyze query execution plans before running queries: Basic Usage: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// See execution plan without running query EXPLAIN MATCH (u:User)-[:FOLLOWS*1..3]->(friend:User) WHERE u.name = 'Alice' RETURN friend.name; </code></pre></div>Plan Interpretation: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">QueryPlan: - NodeIndexSeek: User(name = 'Alice') -> u Estimated rows: 1 Index: user_name_idx - VariableLengthExpand: (u)-[:FOLLOWS*1..3]->(friend) Estimated rows: 150 Strategy: BFS traversal Max depth: 3 - Projection: friend.name Estimated rows: 150 </code></pre></div> <h4 id="profile-command" class="position-relative d-flex align-items-center group"> PROFILE Command <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="profile-command" aria-haspopup="dialog" aria-label="Share link: PROFILE Command"> Share link </button> </h4>Measure actual runtime performance: Runtime Analysis: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Execute query and collect performance metrics PROFILE MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.region = 'East' AND p.price > 100 RETURN u.name, p.name, p.price LIMIT 100; </code></pre></div>Profile Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Execution Profile: Total time: 45ms NodeIndexSeek (User.region = 'East'): Time: 2ms Rows: 15,234 Index: user_region_idx Expand (PURCHASED): Time: 28ms Rows: 45,678 Filter (p.price > 100): Time: 12ms Input rows: 45,678 Output rows: 12,345 Projection + Limit: Time: 3ms Rows: 100 </code></pre></div> <h4 id="query-metrics" class="position-relative d-flex align-items-center group"> Query Metrics <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-metrics" aria-haspopup="dialog" aria-label="Share link: Query Metrics"> Share link </button> </h4>Monitor query performance in production: Key Metrics: <ul> <li>Execution Time: Total query runtime</li> <li>Rows Examined: Total nodes/edges accessed</li> <li>Rows Returned: Result set size</li> <li>Index Hits: Index usage count</li> <li>Cache Efficiency: Hot data access rate</li> <li>Memory Usage: Query memory footprint</li> </ul> <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> <h4 id="index-design" class="position-relative d-flex align-items-center group"> Index Design <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-design" aria-haspopup="dialog" aria-label="Share link: Index Design"> Share link </button> </h4>Create indexes strategically: High-Impact Indexes: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// 1. Unique identifiers CREATE UNIQUE INDEX user_id_idx ON User(user_id); // 2. Foreign key equivalents CREATE INDEX order_user_idx ON Order(user_id); // 3. Common filter columns CREATE INDEX product_category_idx ON Product(category); // 4. Sort columns CREATE INDEX event_timestamp_idx ON Event(timestamp); // 5. Composite for complex queries CREATE INDEX user_search_idx ON User(status, region, created_at); </code></pre></div>Index Maintenance: <ul> <li>Avoid Over-Indexing: Each index adds write overhead</li> <li>Monitor Usage: Remove unused indexes</li> <li>Update Statistics: Keep optimizer statistics current</li> <li>Rebuild When Needed: Maintain index health</li> </ul> <h4 id="query-structure" class="position-relative d-flex align-items-center group"> Query 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="query-structure" aria-haspopup="dialog" aria-label="Share link: Query Structure"> Share link </button> </h4>Write efficient query patterns: Efficiency Guidelines: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// ✓ Good: Filter early with indexes MATCH (u:User {status: 'active'})-[:PURCHASED]->(p:Product) WHERE p.category = 'Electronics' RETURN u.name, COUNT(p); // ✗ Bad: Late filtering forces full scan MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.status = 'active' AND p.category = 'Electronics' RETURN u.name, COUNT(p); // ✓ Good: Limit early when possible MATCH (u:User)-[:RECENT_LOGIN]->(l:Login) WHERE u.region = 'West' WITH u, l ORDER BY l.timestamp DESC LIMIT 10 RETURN u.name, l.timestamp; // ✗ Bad: Sort entire result set MATCH (u:User)-[:RECENT_LOGIN]->(l:Login) WHERE u.region = 'West' RETURN u.name, l.timestamp ORDER BY l.timestamp DESC LIMIT 10; </code></pre></div> <h4 id="traversal-optimization" class="position-relative d-flex align-items-center group"> Traversal 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="traversal-optimization" aria-haspopup="dialog" aria-label="Share link: Traversal Optimization"> Share link </button> </h4>Optimize graph traversal queries: Traversal Strategies: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Bounded depth prevents runaway queries MATCH (u:User)-[:FOLLOWS*1..3]->(friend) WHERE u.id = 'user123' RETURN DISTINCT friend.name; // Directed traversals when possible MATCH (u:User)-[:FOLLOWS]->(friend) // Better // vs MATCH (u:User)-[:FOLLOWS]-(friend) // Checks both directions // Prune paths early MATCH path = (u:User)-[:FOLLOWS*1..5]->(influencer:User) WHERE ALL(n IN nodes(path) WHERE n.account_status = 'active') AND influencer.follower_count > 10000 RETURN influencer.name; </code></pre></div> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <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="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> Share link </button> </h3> <h4 id="slow-query-diagnosis" class="position-relative d-flex align-items-center group"> Slow Query Diagnosis <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-diagnosis" aria-haspopup="dialog" aria-label="Share link: Slow Query Diagnosis"> Share link </button> </h4>Systematic approach to finding bottlenecks: Step 1: Get Baseline: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Measure current performance PROFILE MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.region = 'West' RETURN u.name, COUNT(p) AS purchases ORDER BY purchases DESC LIMIT 20; </code></pre></div>Step 2: Analyze Plan: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Check execution strategy EXPLAIN MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.region = 'West' RETURN u.name, COUNT(p) AS purchases ORDER BY purchases DESC LIMIT 20; // Look for: // - Full scans (missing indexes) // - Large intermediate results // - Cartesian products // - Late filtering </code></pre></div>Step 3: Add Indexes: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Address index gaps CREATE INDEX user_region_idx ON User(region); // Re-measure PROFILE MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.region = 'West' RETURN u.name, COUNT(p) AS purchases ORDER BY purchases DESC LIMIT 20; </code></pre></div> <h4 id="common-issues" class="position-relative d-flex align-items-center group"> Common Issues <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="common-issues" aria-haspopup="dialog" aria-label="Share link: Common Issues"> Share link </button> </h4>Issue: Full Table Scans: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Problem: No index on filter column MATCH (p:Product) WHERE p.sku = 'ABC123' RETURN p; // Shows: FullScan (Product) in EXPLAIN // Solution: Add index CREATE INDEX product_sku_idx ON Product(sku); </code></pre></div>Issue: Cartesian Products: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Problem: Disconnected patterns MATCH (u:User), (p:Product) WHERE u.region = 'West' AND p.category = 'Books' RETURN u.name, p.name; // Generates u_count * p_count rows // Solution: Add relationship MATCH (u:User)-[:INTERESTED_IN]->(c:Category {name: 'Books'})<-[:IN_CATEGORY]-(p:Product) WHERE u.region = 'West' RETURN u.name, p.name; </code></pre></div>Issue: Expensive Aggregations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Problem: Aggregating too late MATCH (u:User)-[:PURCHASED]->(p:Product) WITH u, COUNT(p) AS purchase_count WHERE purchase_count > 50 RETURN u.name, purchase_count; // Solution: Filter before aggregating MATCH (u:User)-[:PURCHASED]->(p:Product) WHERE u.account_type = 'premium' // Reduces input set WITH u, COUNT(p) AS purchase_count WHERE purchase_count > 50 RETURN u.name, purchase_count; </code></pre></div> <h3 id="production-optimization" class="position-relative d-flex align-items-center group"> Production 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="production-optimization" aria-haspopup="dialog" aria-label="Share link: Production Optimization"> Share link </button> </h3> <h4 id="monitoring" class="position-relative d-flex align-items-center group"> Monitoring <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="monitoring" aria-haspopup="dialog" aria-label="Share link: Monitoring"> Share link </button> </h4>Track query performance continuously: Key Queries to Monitor: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Identify slow queries SELECT query_text, avg_duration, execution_count FROM system.query_stats WHERE avg_duration > 1000 -- milliseconds ORDER BY avg_duration DESC LIMIT 20; // Find missing indexes SELECT table_name, column_name, scan_count FROM system.column_stats WHERE scan_count > 1000 AND index_exists = false ORDER BY scan_count DESC; </code></pre></div> <h4 id="capacity-planning" class="position-relative d-flex align-items-center group"> Capacity Planning <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"> Share link </button> </h4>Plan for growth: Scaling Considerations: <ul> <li>Data Growth: Test queries at 2x, 5x, 10x current size</li> <li>Concurrent Users: Validate performance under load</li> <li>Index Memory: Ensure hot indexes fit in memory</li> <li>Query Mix: Optimize for actual workload patterns</li> <li>Caching: Leverage query result caching when appropriate</li> </ul> <h4 id="query-tuning-workflow" class="position-relative d-flex align-items-center group"> Query Tuning Workflow <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-tuning-workflow" aria-haspopup="dialog" aria-label="Share link: Query Tuning Workflow"> Share link </button> </h4>Systematic optimization process: <ol> <li>Identify Slow Queries: Use monitoring to find problems</li> <li>Analyze Execution Plans: Understand current strategy</li> <li>Create Targeted Indexes: Address access pattern gaps</li> <li>Rewrite Inefficient Queries: Apply optimization patterns</li> <li>Measure Improvements: Validate changes with PROFILE</li> <li>Deploy and Monitor: Track production performance</li> <li>Iterate: Continuously refine based on real usage</li> </ol> <h3 id="advanced-techniques" class="position-relative d-flex align-items-center group"> Advanced 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-techniques" aria-haspopup="dialog" aria-label="Share link: Advanced Techniques"> Share link </button> </h3> <h4 id="materialized-views" class="position-relative d-flex align-items-center group"> Materialized Views <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="materialized-views" aria-haspopup="dialog" aria-label="Share link: Materialized Views"> Share link </button> </h4>Pre-compute expensive queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Create materialized aggregation CREATE GRAPH SCHEMA popular_products AS MATCH (p:Product)<-[:PURCHASED]-(u:User) WITH p, COUNT(u) AS purchase_count WHERE purchase_count > 100 RETURN p.id AS product_id, p.name AS product_name, purchase_count; // Query uses pre-computed results MATCH (mp:popular_products) WHERE mp.purchase_count > 500 RETURN mp.product_name, mp.purchase_count; </code></pre></div> <h4 id="query-hints" class="position-relative d-flex align-items-center group"> Query Hints <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-hints" aria-haspopup="dialog" aria-label="Share link: Query Hints"> Share link </button> </h4>Guide optimizer when needed: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Force index usage MATCH (u:User) USING INDEX user_email_idx WHERE u.email = 'user@example.com' RETURN u; // Control join strategy MATCH (u:User)-[:PURCHASED]->(p:Product) USING JOIN hash_join WHERE u.region = 'West' RETURN u.name, p.name; </code></pre></div> <h4 id="batch-processing" class="position-relative d-flex align-items-center group"> Batch Processing <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="batch-processing" aria-haspopup="dialog" aria-label="Share link: Batch Processing"> Share link </button> </h4>Optimize bulk operations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">// Process in batches to control memory MATCH (u:User) WHERE u.status = 'inactive' WITH u LIMIT 1000 SET u.archived = true RETURN COUNT(u); // Repeat until all processed </code></pre></div> <h3 id="integration-with-geode" class="position-relative d-flex align-items-center group"> Integration with Geode <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="integration-with-geode" aria-haspopup="dialog" aria-label="Share link: Integration with Geode"> Share link </button> </h3>Query optimization integrates with other Geode features: <ul> <li>Transactions: Optimize within transaction boundaries</li> <li>Concurrency: Design for concurrent query execution</li> <li>Caching: Leverage Geode’s query cache effectively</li> <li>Monitoring: Use built-in metrics for continuous improvement</li> <li>Security: Ensure RLS policies don’t impede performance</li> </ul> <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>EXPLAIN Command: Detailed execution plan analysis</li> <li>PROFILE Command: Runtime performance profiling</li> <li>Indexes: Index design and management</li> <li>Query Performance: Overall performance considerations</li> <li>Monitoring: Production query monitoring</li> <li>Best Practices: General optimization guidelines</li> <li>Troubleshooting: Debugging performance issues</li> </ul> <hr> Browse the tagged content below to discover comprehensive guides, tutorials, and best practices for query optimization in Geode. Master the tools and techniques needed to build high-performance graph applications that scale to production workloads.

Popular

Related Articles

Query Optimization

Query Profiling with EXPLAIN and PROFILE

Query Optimization