Sometimes things don’t work as expected. Sometimes it’s as simple as a syntax error. Sometimes it’s a little more complex like an index that should have been used but instead a full scan is done. Perhaps a sub-query with an IN needs to replace a join. Or a statement is taking a lot longer than it should.Finding out what is going on can be as simple as prefixing the statement with EXPLAIN VERBOSE.In any event, please feel free to contact Regatta support.
Was this page helpful?
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"Regatta","colors":{"primary":"#ff6600","light":"#FF6600","dark":"#ff6600"},"logo":{"light":"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_Black_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=80ecf4af831aaabfecd51ca1c1dab7a7","dark":"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_White_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=1be4bc683939b389d14aa1eeda3216d9"},"favicon":"https://mintcdn.com/regatta/xrn8wIqTNfsgHe4O/images/favicon.svg?fit=max\u0026auto=format\u0026n=xrn8wIqTNfsgHe4O\u0026q=85\u0026s=c025dcbef503c87e965049f809c4a3c4","background":{"color":{"light":"#f7f8fa","dark":"#041225"}},"navbar":{"links":[{"href":"https://rdbproject.atlassian.net/servicedesk/customer/portals","label":"Support"}],"primary":{"type":"button","label":"Start Coding","href":"https://regatta.dev/"}},"footer":{"socials":{"x":"https://twitter.com/regatta_data","linkedin":"https://www.linkedin.com/company/regatta-data"}},"fonts":{"family":"Inter"},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"regatta","hasAudioNarration":false,"actualSubdomain":"regatta","customDomains":["docs.regatta.dev"],"gitSource":{"type":"github","owner":"regattadata","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"ENABLED"},"CONTEXTUAL_FEEDBACK":{"status":"ENABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"ENABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af1eeb6572291321c9713bb","clientVersion":"0.0.4117","searchFilterCounts":[{"language":"default","tag":"SQL","count":84},{"language":"default","tag":"Self-Hosted Deployment","count":38},{"language":"default","tag":"Tuning Performance","count":20},{"language":"default","tag":"Regatta Deployment Tool","count":19},{"language":"default","tag":"Quickstart","count":18},{"language":"default","tag":"System Monitoring","count":18},{"language":"default","tag":"Drivers \u0026 Clients","count":16},{"language":"default","tag":"SQL Functions and Operators","count":15},{"language":"default","tag":"Kubernetes Deployment","count":13},{"language":"default","tag":"Hints","count":12}]},"assistantConfig":{},"basePath":"","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[{"filePath":"style.css","content":"body::-webkit-scrollbar{width:5px}body::-webkit-scrollbar-thumb{background-color:#888;border-radius:10px}body::-webkit-scrollbar-track{background-color:#f1f1f1}#sidebar-content::-webkit-scrollbar{display:none}table td:first-child,table th:first-child{max-width:16rem}table code{white-space:normal;overflow-wrap:break-word;word-break:break-word}"}],"page":{"pagePath":"tuning-performance/closing-remarks","slug":"/tuning-performance/closing-remarks","pageMetadata":{"title":"Closing remarks","description":null,"href":"/tuning-performance/closing-remarks"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,p:`p`,..._provideComponents(),...props.components};return _jsxs(_Fragment,{children:[_jsxs(_components.p,{children:[`Sometimes things don’t work as expected. Sometimes it’s as simple as a syntax error. Sometimes it’s a little more complex like an index that should have been used but instead a full scan is done. Perhaps a sub-query with an `,_jsx(_components.code,{children:`IN`}),` needs to replace a join. Or a statement is taking a lot longer than it should.`]}),`\n`,_jsxs(_components.p,{children:[`Finding out what is going on can be as simple as prefixing the statement with `,_jsx(_components.code,{children:`EXPLAIN VERBOSE`}),`.`]}),`\n`,_jsx(_components.p,{children:`In any event, please feel free to contact Regatta support.`})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Closing remarks","description":null,"href":"/tuning-performance/closing-remarks"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[],"codeExamples":{}},"jsLinks":[],"subdomain":"regatta","siteName":"Regatta","title":"Closing remarks - Regatta","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-07T10:13:17.113Z","originalFileLocation":"tuning-performance/closing-remarks.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Regatta\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Closing remarks - Regatta\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Regatta\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.regatta.dev/tuning-performance/closing-remarks\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Tuning+Performance\u0026amp;title=Closing+remarks\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=d5743709cdc2a4ec24c1a3705a5bc17251b36ba87ed6c4a3b61b10215b74eb1e\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Closing remarks - Regatta\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://regatta.mintlify.site/_mintlify/api/og/v2?division=Tuning+Performance\u0026amp;title=Closing+remarks\u0026amp;theme=acca279d31253fc5f4f921a2\u0026amp;signature=d5743709cdc2a4ec24c1a3705a5bc17251b36ba87ed6c4a3b61b10215b74eb1e\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/regatta/gm5LFpBlkeZD76CN/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Regatta\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#ff6600\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.regatta.dev/tuning-performance/closing-remarks\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/tuning-performance/closing-remarks.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.regatta.dev/#organization\",\"name\":\"Regatta\",\"url\":\"https://docs.regatta.dev\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/regatta/HR4-Kyi3p6WFSWx7/logo/Regatta_Logo_Colors_Black_RGB_1.svg?fit=max\u0026auto=format\u0026n=HR4-Kyi3p6WFSWx7\u0026q=85\u0026s=80ecf4af831aaabfecd51ca1c1dab7a7\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.regatta.dev#website\",\"name\":\"Regatta\",\"url\":\"https://docs.regatta.dev\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.regatta.dev/tuning-performance/closing-remarks#webpage\",\"url\":\"https://docs.regatta.dev/tuning-performance/closing-remarks\",\"name\":\"Closing remarks\",\"dateModified\":\"2026-10-07T10:13:17.113Z\",\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"},\"breadcrumb\":{\"@id\":\"https://docs.regatta.dev/tuning-performance/closing-remarks#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.regatta.dev/tuning-performance/closing-remarks#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Tuning Performance\",\"item\":\"https://docs.regatta.dev/tuning-performance/introduction/introduction\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Closing remarks\",\"item\":\"https://docs.regatta.dev/tuning-performance/closing-remarks\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.regatta.dev/tuning-performance/closing-remarks#article\",\"headline\":\"Closing remarks\",\"name\":\"Closing remarks\",\"url\":\"https://docs.regatta.dev/tuning-performance/closing-remarks\",\"mainEntityOfPage\":{\"@id\":\"https://docs.regatta.dev/tuning-performance/closing-remarks#webpage\"},\"dateModified\":\"2026-10-07T10:13:17.113Z\",\"publisher\":{\"@id\":\"https://docs.regatta.dev/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.regatta.dev#website\"}}]}\u003c/script>","agentPointerHref":"/tuning-performance/closing-remarks.md","siteName":"Regatta","nav":{"global":null,"anchors":[{"anchor":"Docs Home","icon":"house","pages":[{"title":"Docs Home","href":"/home"}]},{"anchor":"Quickstart","pages":[{"title":"Quickstart","href":"/getting-started/getting-started-using-regatta-cloud"}]},{"anchor":"SQL","icon":"code","pages":[{"title":"SQL","href":"/sql/introduction"}]},{"anchor":"Regatta Cloud","icon":"cloud","pages":[{"title":"Regatta Cloud","href":"/regatta-cloud/regatta-cloud/regatta-cloud"}]},{"anchor":"Self-Hosted Deployment","icon":"server","pages":[{"title":"Self-Hosted Deployment","href":"/self-hosted-deployment/prerequisites"}]},{"anchor":"Drivers \u0026 Clients","icon":"download","pages":[{"title":"Drivers \u0026 Clients","href":"/drivers-and-clients/connecting-applications-to-regatta"}]},{"anchor":"Tuning Performance","icon":"rocket","groups":[{"group":"Tuning Performance","pages":[{"group":"Introduction","pages":[{"title":"Introduction","href":"/tuning-performance/introduction/introduction"},{"title":"Structure of a Regatta cluster","href":"/tuning-performance/introduction/structure-regatta-cluster"},{"title":"Data distribution of a table","href":"/tuning-performance/introduction/data-distribution-table"},{"title":"Data distribution of an index","href":"/tuning-performance/introduction/data-distribution-index"},{"title":"How a SQL statement executes","href":"/tuning-performance/introduction/sql-statement"}]},{"title":"Distributing Tables","href":"/tuning-performance/distributing-tables"},{"title":"Distributing Indexes","href":"/tuning-performance/distributing-indexes"},{"title":"Other Index Consideration","href":"/tuning-performance/other-index"},{"title":"Other Limitations","description":null,"href":"/tuning-performance/other-limitations"},{"title":"Closing remarks","href":"/tuning-performance/closing-remarks"}]}]}]},"basePath":"","title":"Closing remarks - Regatta","buildId":"dpl_41S5Z2jG9QnfDRwN1KZrLdBwj7DM","deploymentId":"dpl_41S5Z2jG9QnfDRwN1KZrLdBwj7DM","dynamics":[],"chunks":[]}