1<!DOCTYPE html><html lang="en"><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=5, viewport-fit=cover"><meta name="theme-color" content="#0A1229"><title>Welcome to the pganalyze documentation! · pganalyze</title><meta name="description" content="DBAs and developers use pganalyze to identify the root cause of performance issues, optimize queries and to get alerts about critical issues. Sign up for free!"><link rel="canonical" href="https://pganalyze.com/docs"><link rel="icon" type="image/png" href="/favicon-32x32.png" sizes="32x32"><link rel="manifest" href="/manifest.webmanifest"><meta name="astro-view-transitions-enabled" content="true"><meta name="astro-view-transitions-fallback" content="swap">
1<script type="module" src="/_astro/ClientRouter.astro_astro_type_script_index_0_lang.B2LpM-Q1.js"></script>
1<meta property="og:title" content="Welcome to the pganalyze documentation! · pganalyze"><meta property="og:type" content="article"><meta property="og:locale" content="en_US"><meta property="og:site_name" content="pganalyze"><meta property="og:article:section" content="PostgreSQL"><meta name="twitter:card" content="summary_large_image"><meta name="twitter:title" content="Welcome to the pganalyze documentation! · pganalyze">
vendor: 63 bytes, line 1
1<script async src="https://www.googletagmanager.com/gtag/js?id=
1G-JC1695MR60
vendor: 11 bytes, line 1
1"></script>
1<script> 2
vendor: 162 bytes, lines 2-7
2window.dataLayer = window.dataLayer || []; 3 function gtag() { 4 dataLayer.push(arguments); 5 } 6 gtag("js", new Date()); 7 gtag("config", "
7AW-792224255
vendor: 10 bytes, lines 7-8
7"); 8
8gtag("config", "UA-38000103-1"); 9 gtag("config", "G-JC1695MR60"); 10 </script>
10<script id="hs-script-loader" async defer src="https://js.hs-scripts.com/2591017.js"></script>
10<script type="module">function e(){if(window.location.hash){var e=decodeURIComponent(window.location.hash.slice(1));setTimeout(function(){var t=document.getElementById(e);t&&t.scrollIntoView()},0)}}document.addEventListener(`astro:page-load`,e),document.addEventListener(`astro:after-swap`,function(){var e=window.location.pathname+window.location.search;typeof window.gtag==`function`&&window.gtag(`event`,`page_view`,{page_title:document.title,page_location:window.location.href,page_path:e}),window._hsq=window._hsq||[],window._hsq.push([`setPath`,e]),window._hsq.push([`trackPageView`])});</script>
10<style>.E-czsa_teaser{max-width:790px;font-size:15px}.E-czsa_teaser a{min-height:120px;color:inherit;background-color:#f0f0f0;border-radius:5px;flex-direction:column;align-items:flex-start;padding:15px;text-decoration:none;display:flex;color:inherit!important}@media (width>=481px){.E-czsa_teaser a{background-image:url(/_astro/screenshot_query_details.z7LKrqYR.png);background-position:100% 100%;background-repeat:no-repeat;background-size:contain;padding-right:260px}}.E-czsa_teaser a h3{font-size:18px;line-height:1em!important}.E-czsa_teaser a p{max-width:500px!important;margin:10px 20px 12px 0!important}.E-czsa_teaser a .E-czsa_teaserButton{color:#fff;background-color:#4ba64b;border-radius:3px;padding:7px 25px} 11._Ei7JG_teaser{max-width:790px;font-size:15px}._Ei7JG_teaser a{min-height:120px;color:inherit;background-color:#f0f0f0;border-radius:5px;flex-direction:column;align-items:flex-start;padding:15px;text-decoration:none;display:flex;color:inherit!important}@media (width>=481px){._Ei7JG_teaser a{background-image:url(/_astro/explain_schema_reference.BpEwA-TD.png);background-position:115% bottom;background-repeat:no-repeat;background-size:contain;border-right:1px solid #f0f0f0;padding-right:280px}}._Ei7JG_teaser a h3{margin-bottom:5px;font-size:18px;line-height:1em!important}._Ei7JG_teaser a p{max-width:500px!important;margin:10px 20px 12px 0!important}._Ei7JG_teaser a ._Ei7JG_teaserButton{color:#fff;background-color:#4ba64b;border-radius:3px;padding:7px 25px} 12</style><link rel="stylesheet" href="/_astro/Footer.D5zThaES.css"><link rel="stylesheet" href="/_astro/DocsLayout.CuHjTasZ.css"><style>.W_cs5G_faIcon{width:1em;height:1em} 13.L8lE7q_headerBackground{background-color:var(--noctis-500);padding-top:calc(106px + env(safe-area-inset-top));z-index:-1;position:relative;overflow:hidden}.L8lE7q_headerBackground:after{content:"";background:linear-gradient(to bottom, transparent, var(--noctis-500));z-index:-1;pointer-events:none;width:100%;height:90%;position:absolute;bottom:0;left:0}@media (width<=1279px){.L8lE7q_headerBackground{padding-top:calc(72px + env(safe-area-inset-top))}}.L8lE7q_headerBackground h1,.L8lE7q_headerBackground p{color:#fff;text-align:center}.L8lE7q_headerBackground h1{letter-spacing:0;opacity:.9;font-size:26px;font-weight:600;line-height:32px}@media (width<=1279px){.L8lE7q_headerBackground h1{margin-top:16px}}.L8lE7q_headerBackground p{letter-spacing:0;opacity:.9;max-width:750px;margin:0 auto 32px;font-size:18px;line-height:1.4em}.L8lE7q_headerBackgroundGradient,.L8lE7q_headerBackgroundImage{z-index:-1;width:100%;height:1000px;position:absolute;top:0;left:0}.L8lE7q_headerBackgroundGradient{background:var(--gradient-aurora)}.L8lE7q_headerBackgroundImage{background-image:url(/_astro/pattern.BV53rgXL.svg);background-position:top;background-repeat:repeat-x}@media (width<=1279px){.L8lE7q_headerBackgroundImage{background-image:none}}.L8lE7q_secondaryNavParent{margin:0;position:relative}.L8lE7q_secondaryScrolled{z-index:1;width:100%;position:fixed;top:106px}@media (width<=1279px){.L8lE7q_secondaryScrolled{position:relative;top:auto}}.L8lE7q_headerCTAActions{text-align:center;z-index:1;margin-bottom:40px;position:relative}.L8lE7q_headerCTAActions .btn{border:2px solid var(--stardust-500);color:var(--stardust-500);background:0 0;border-radius:8px;margin:5px 10px 0 0}.L8lE7q_headerCTAActions .btn:hover{background-color:var(--stardust-500);color:var(--noctis-500)}.L8lE7q_headerCTAActions .btn-success{background-color:var(--stardust-500);color:var(--noctis-500);border-color:var(--stardust-500)}.L8lE7q_headerCTAActions .btn-success:hover{background-color:var(--stardust-400);border-color:var(--stardust-400)}.L8lE7q_secondaryNavGrouped{flex-wrap:wrap;justify-content:center;align-items:center;gap:0;padding:0 16px;display:flex}.L8lE7q_secondaryNavGroup{align-items:center;display:inline-flex}.L8lE7q_secondaryNavGroup a{color:#fff;text-shadow:none;opacity:.75;white-space:nowrap;padding:10px 8px 9px;font-size:13px;text-decoration:none;transition:opacity .15s}.L8lE7q_secondaryNavGroup a:hover{opacity:1;text-decoration:none}.L8lE7q_secondaryNavGroup a.active-secondary{opacity:1;font-weight:600}.L8lE7q_secondaryNavDivider{background-color:#fff3;flex-shrink:0;width:1px;height:16px;margin:0 4px}@media (width<=1150px){.L8lE7q_secondaryNavGrouped{padding:0 8px}.L8lE7q_secondaryNavGroup a{padding:10px 5px 9px;font-size:12px}}@media (width<=1024px){.L8lE7q_secondaryNavGrouped{gap:0;padding:0 8px}.L8lE7q_secondaryNavGroup a{padding:6px 5px;font-size:12px}.L8lE7q_secondaryNavDivider{height:14px;margin:0 2px}}@media (width<=979px){.L8lE7q_secondaryNavGrouped{flex-wrap:nowrap;justify-content:flex-start;padding:0 12px}.L8lE7q_secondaryNavGroup a{padding:10px 10px 9px;font-size:13px}.L8lE7q_secondaryNavDivider{height:16px;margin:0 4px}} 14</style>
14<script type="module" src="/_astro/page.BXhJUpbf.js"></script>
14<style>.x2QBhG_noWrap{white-space:nowrap}.x2QBhG_recommendationsList{padding-left:8px}.x2QBhG_recommendationsList dt{float:left;max-width:30%;margin-right:10%;font-weight:400;line-height:24px}.x2QBhG_recommendationsList dd{margin-bottom:4px;margin-left:50%;font-family:monospace}.x2QBhG_recommendationsList dd:after{content:" ";clear:left;display:block}.x2QBhG_settingsTable{width:100%}.x2QBhG_descriptionPopupIcon{margin-left:4px;font-size:14px}.x2QBhG_statusIcon{margin-left:auto;margin-right:auto;font-size:18px;display:block}.x2QBhG_okayIcon{color:#93bf3b}.x2QBhG_changeRequiredIcon{color:#ffa700}.x2QBhG_infoIcon{color:#4682b4}.x2QBhG_externalLinkIcon{margin-left:4px;font-size:12px}.x2QBhG_secureIcon{color:#5cb85c;vertical-align:baseline;margin-right:4px;font-size:12px}.x2QBhG_copyBlock{position:relative}.x2QBhG_copyBlock .x2QBhG_copyIcon{color:#c8c8c8;background-color:gray;border:1px solid #f2f2f2;border-radius:5px;padding:2px 6px;font-size:16px;display:block;position:absolute;top:8px;right:8px}.x2QBhG_copyBlock .x2QBhG_copyIcon:hover{color:#f6f6f6} 15</style><style>.vC7sGW_overviewInstallChoice,.vC7sGW_overviewFeatureChoice{grid-template-columns:1fr;gap:12px;margin-top:15px;display:grid}.vC7sGW_overviewInstallChoice+h2,.vC7sGW_overviewFeatureChoice+h2{margin-top:32px}.vC7sGW_overviewInstallChoiceStep,.vC7sGW_overviewFeatureChoiceStep{color:inherit;background-color:#f8f8f8;border:1px solid #e8e8e8;border-radius:6px;flex-direction:column;font-size:14px;display:flex}.vC7sGW_overviewInstallChoiceStep:hover,.vC7sGW_overviewFeatureChoiceStep:hover{color:inherit;background-color:#f0f0f0;border-color:#e0e0e0}.vC7sGW_overviewInstallChoiceStep{align-items:flex-start;gap:12px;padding:12px}.vC7sGW_overviewInstallChoiceStep .vC7sGW_overviewInstallChoiceProvider{flex-direction:row;align-items:center;gap:12px;height:44px;padding:0;font-size:16px;font-weight:600;line-height:19px;display:flex}.vC7sGW_overviewInstallChoiceStep .vC7sGW_overviewInstallChoiceProvider img{border:none;width:44px;height:auto;margin:0;padding:0}.vC7sGW_overviewInstallChoiceStep .vC7sGW_overviewInstallChoiceProviderText{vertical-align:middle;align-items:center;line-height:19px;display:flex}.vC7sGW_overviewFeatureChoiceStep{padding:8px 10px;display:flex}.vC7sGW_overviewFeatureChoiceStep:last-child{margin-right:0}.vC7sGW_overviewFeatureChoiceStep p{margin:0}.vC7sGW_overviewFeatureChoiceStep strong{font-size:16px;font-weight:600;display:block}@media (width>=640px){.vC7sGW_overviewFeatureChoice{gap:20px}.vC7sGW_overviewInstallChoice,.vC7sGW_overviewFeatureChoice{grid-template-columns:1fr 1fr;margin-bottom:10px}.vC7sGW_overviewInstallChoiceProviderText{min-height:38px}}@media (width>=768px){.vC7sGW_overviewInstallChoice{grid-template-columns:1fr 1fr 1fr}}.vC7sGW_nav{margin-bottom:0;padding-left:0;list-style:none}.vC7sGW_nav>li{display:block;position:relative}.vC7sGW_nav>li>a{padding:10px 15px;display:block;position:relative}.vC7sGW_nav>li>a:hover,.vC7sGW_nav>li>a:focus{background-color:#eee;text-decoration:none}.vC7sGW_nav>li.vC7sGW_disabled>a{color:#777}.vC7sGW_nav>li.vC7sGW_disabled>a:hover,.vC7sGW_nav>li.vC7sGW_disabled>a:focus{color:#777;cursor:not-allowed;background-color:#0000;text-decoration:none}.vC7sGW_nav .vC7sGW_open>a,.vC7sGW_nav .vC7sGW_open>a:hover,.vC7sGW_nav .vC7sGW_open>a:focus{background-color:#eee;border-color:#337ab7}.vC7sGW_nav .vC7sGW_nav-divider{background-color:#e5e5e5;height:1px;margin:9px 0;overflow:hidden}.vC7sGW_nav>li>a>img{max-width:none}.vC7sGW_nav:before,.vC7sGW_nav:after{content:" ";display:table}.vC7sGW_nav:after{clear:both}.vC7sGW_navTabs{border-bottom:1px solid #ddd;margin-left:0!important}.vC7sGW_navTabs>li{float:left;margin-bottom:-1px}.vC7sGW_navTabs>li>button{font:inherit;color:#337ab7;cursor:pointer;background:0 0;border:1px solid #0000;border-radius:4px 4px 0 0;margin-right:2px;padding:10px 15px;line-height:1.42857}.vC7sGW_navTabs>li>button:hover{color:#555;background-color:#eee;border-color:#eee #eee #ddd}.vC7sGW_navTabs .vC7sGW_navLink.vC7sGW_active,.vC7sGW_navTabs .vC7sGW_navItem.vC7sGW_show .vC7sGW_navLink{color:#555;background-color:#fff;border-color:#ddd #ddd #0000}.vC7sGW_tabContent>.vC7sGW_tabPane{display:none}.vC7sGW_tabContent>.vC7sGW_active{display:block}.vC7sGW_tabPanelTextContent{margin:24px 0} 16</style></head><body class="docs"><div style="position: relative; z-index: 0;"><style>astro-island,astro-slot,astro-static-slot{display:contents}</style>
16<script>(()=>{var e=async t=>{await(await t())()};(self.Astro||(self.Astro={})).only=e;window.dispatchEvent(new Event("astro:only"));})();</script>
16<script>(()=>{var g=Object.defineProperty;var w=(c,s,d)=>s in c?g(c,s,{enumerable:!0,configurable:!0,writable:!0,value:d}):c[s]=d;var l=(c,s,d)=>w(c,typeof s!="symbol"?s+"":s,d);var E=new Set(["__proto__","constructor","prototype"]);{let c={0:t=>y(t),1:t=>d(t),2:t=>new RegExp(t),3:t=>new Date(t),4:t=>new Map(d(t)),5:t=>new Set(d(t)),6:t=>BigInt(t),7:t=>new URL(t),8:t=>new Uint8Array(t),9:t=>new Uint16Array(t),10:t=>new Uint32Array(t),11:t=>Number.POSITIVE_INFINITY*t},s=t=>{let[p,e]=t;return p in c?c[p](e):void 0},d=t=>t.map(s),y=t=>typeof t!="object"||t===null?t:Object.fromEntries(Object.entries(t).map(([p,e])=>[p,s(e)]));class f extends HTMLElement{constructor(){super(...arguments);l(this,"Component");l(this,"hydrator");l(this,"hydrate",async()=>{var b;if(!this.hydrator||!this.isConnected)return;let e=(b=this.parentElement)==null?void 0:b.closest("astro-island[ssr]");if(e){e.addEventListener("astro:hydrate",this.hydrate,{once:!0});return}let n=this.querySelectorAll("astro-slot"),r={},i=this.querySelectorAll("template[data-astro-template]");for(let o of i){let a=o.closest(this.tagName);a!=null&&a.isSameNode(this)&&(r[o.getAttribute("data-astro-template")||"default"]=o.innerHTML,o.remove())}for(let o of n){let a=o.closest(this.tagName);a!=null&&a.isSameNode(this)&&(r[o.getAttribute("name")||"default"]=o.innerHTML)}let u;try{u=this.hasAttribute("props")?y(JSON.parse(this.getAttribute("props"))):{}}catch(o){let a=this.getAttribute("component-url")||"<unknown>",v=this.getAttribute("component-export");throw v&&(a+=` (export ${v})`),console.error(`[hydrate] Error parsing props for component ${a}`,this.getAttribute("props"),o),o}let h;await this.hydrator(this)(this.Component,u,r,{client:this.getAttribute("client")}),this.removeAttribute("ssr"),this.dispatchEvent(new CustomEvent("astro:hydrate"))});l(this,"unmount",()=>{this.isConnected||this.dispatchEvent(new CustomEvent("astro:unmount"))})}disconnectedCallback(){document.removeEventListener("astro:after-swap",this.unmount),document.addEventListener("astro:after-swap",this.unmount,{once:!0})}connectedCallback(){if(!this.hasAttribute("await-children")||document.readyState==="interactive"||document.readyState==="complete")this.childrenConnectedCallback();else{let e=()=>{document.removeEventListener("DOMContentLoaded",e),n.disconnect(),this.childrenConnectedCallback()},n=new MutationObserver(()=>{var r;((r=this.lastChild)==null?void 0:r.nodeType)===Node.COMMENT_NODE&&this.lastChild.nodeValue==="astro:end"&&(this.lastChild.remove(),e())});n.observe(this,{childList:!0}),document.addEventListener("DOMContentLoaded",e)}}async childrenConnectedCallback(){let e=this.getAttribute("before-hydration-url");e&&await import(e),this.start()}getRetryImportUrl(e){let n=new URL(e,document.baseURI),r=`astro-retry=${Date.now()}`,i=n.hash.replace(/^#/,"");return n.hash=i?`${i}&${r}`:r,n.toString()}async importWithRetry(e){try{return await import(e)}catch(n){return await new Promise(r=>setTimeout(r,1e3)),import(this.getRetryImportUrl(e))}}handleHydrationError(e){let n=this.getAttribute("component-url"),r=new CustomEvent("astro:hydration-error",{cancelable:!0,bubbles:!0,composed:!0,detail:{error:e,componentUrl:n}});this.dispatchEvent(r)&&console.error(`[astro-island] Error hydrating ${n}`,e)}async start(){let e=JSON.parse(this.getAttribute("opts")),n=this.getAttribute("client");if(Astro[n]===void 0){window.addEventListener(`astro:${n}`,()=>this.start(),{once:!0});return}try{await Astro[n](async()=>{let r=this.getAttribute("renderer-url");try{let[i,{default:u}]=await Promise.all([this.importWithRetry(this.getAttribute("component-url")),r?this.importWithRetry(r):Promise.resolve({default:()=>()=>{}})]),h=this.getAttribute("component-export")||"default";if(h.includes(".")){this.Component=i;for(let m of h.split(".")){if(E.has(m)||!this.Component||typeof this.Component!="object"&&typeof this.Component!="function"||!Object.hasOwn(this.Component,m))throw new Error(`Invalid component export path: ${h}`);this.Component=this.Component[m]}}else{if(E.has(h))throw new Error(`Invalid component export path: ${h}`);this.Component=i[h]}return this.hydrator=u,this.hydrate}catch(i){return this.handleHydrationError(i),()=>{}}},e,this)}catch(r){this.handleHydrationError(r)}}attributeChangedCallback(){this.hydrate()}}l(f,"observedAttributes",["props"]),customElements.get("astro-island")||customElements.define("astro-island",f)}})();</script>
16<astro-island uid="Z2bqbn1" component-url="/_astro/index.tTIRg0ao.js" component-export="default" renderer-url="/_astro/client.Dqz2Vqct.js" props="{}" ssr client="only" opts="{"name":"RememberUtmValues","value":"react"}"></astro-island>
16<script>(()=>{var e=async t=>{await(await t())()};(self.Astro||(self.Astro={})).load=e;window.dispatchEvent(new Event("astro:load"));})();</script>
16<astro-island uid="jSNmn" prefix="r24" component-url="/_astro/index.CJ0Id8yR.js" component-export="default" renderer-url="/_astro/client.Dqz2Vqct.js" props="{"currentPath":[0,"/docs/"]}" ssr client="load" opts="{"name":"Header","value":true}" await-children><div class="tw-scope"><a href="#main-navigation" class="absolute left-4 top-3 z-[2000] -translate-y-[200%] rounded-md bg-stardust-500 px-4 py-2 focus:translate-y-0"><span class="text-[16px] font-medium text-noctis-500">Skip to navigation</span></a></div><div><div class="promotion-banner">Live webinar with Lukas Fittl on Oct. 8:<!-- --> <a href="https://events.zoom.us/ev/AsXj0LVsn854soaGi3b-j0JEYhvcypdQZVI0ZfuwsqC6orzI-lGs~AqqX62I9SGJ5gPoVMXNOu8G_M8Ym0xigeoMr9gH0B8XCrbSjG4rR5TGhoYVhPSggnvXr4ZQqvwyG1E9UJVmsFTf7Cg" target="_blank" rel="noopener"><strong>Postgres 19 in practice: what shipped, what got cut, and how to test it</strong></a></div><div class="tw-scope"><div class="nav-bar"><nav aria-label="Main" id="main-navigation" tabindex="-1" class="nav-shell"><a href="/" class="shrink-0 rounded-md focus-visible:bg-white/10"><img src="/_astro/pga_rect_light.C_LAdX-o.svg" alt="pganalyze" class="h-[40px] w-auto xl:h-[50px]"/></a><ul class="hidden items-center gap-1 xl:flex"><li><a href="/docs" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10 bg-white/10"><span class="text-[16px]/[1.3] group-hover:text-stardust-500 group-focus-visible:text-stardust-500 text-stardust-500">Docs</span></a></li><li class="relative"><button type="button" aria-haspopup="true" aria-expanded="false" aria-controls="nav-panel-features" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10 cursor-pointer border-0 bg-transparent"><span class="text-[16px]/[1.3] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500">Features</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[12px] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="absolute left-0 top-full z-10 pt-1 hidden"><div id="nav-panel-features" class="rounded-md bg-sand-500 p-4 shadow-dropdown w-[433px]"><div class="mb-3 font-cera-mono text-[12px] uppercase tracking-[0.6px] text-noctis-300">Our Key Features</div><div class="flex flex-col gap-1"><a href="/postgres-query-advisor" class="group flex items-start gap-2 rounded-md p-3 hover:bg-white focus-visible:bg-white"><span class="flex h-8 w-8 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="code-pull-request-draft" class="svg-inline--fa fa-code-pull-request-draft W_cs5G_faIcon text-[24px]" role="img" viewBox="0 0 384 512" aria-hidden="true"><path fill="currentColor" d="M80 48a32 32 0 1 1 0 64 32 32 0 1 1 0-64zm24 108.3c32.5-10.2 56-40.5 56-76.3 0-44.2-35.8-80-80-80S0 35.8 0 80c0 35.8 23.5 66.1 56 76.3l0 199.3c-32.5 10.2-56 40.5-56 76.3 0 44.2 35.8 80 80 80s80-35.8 80-80c0-35.8-23.5-66.1-56-76.3l0-199.3zM112 432c0 17.7-14.3 32-32 32s-32-14.3-32-32 14.3-32 32-32 32 14.3 32 32zm224 0c0 17.7-14.3 32-32 32s-32-14.3-32-32 14.3-32 32-32 32 14.3 32 32zm48 0c0-44.2-35.8-80-80-80s-80 35.8-80 80 35.8 80 80 80 80-35.8 80-80zM344 80a40 40 0 1 0 -80 0 40 40 0 1 0 80 0zM304 272a40 40 0 1 0 0-80 40 40 0 1 0 0 80z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium group-hover:text-stratos-500 group-focus-visible:text-stratos-500 text-noctis-500">Query Advisor</span><span class="text-[14px] text-noctis-300">Detect and fix Postgres query plan problems</span></span></a><a href="/postgres-index-advisor" class="group flex items-start gap-2 rounded-md p-3 hover:bg-white focus-visible:bg-white"><span class="flex h-8 w-8 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="radar" class="svg-inline--fa fa-radar W_cs5G_faIcon text-[24px]" role="img" viewBox="0 0 512 512" aria-hidden="true">
16<path fill="currentColor" d="M304.8 173.3c-14.3-8.4-31-13.3-48.8-13.3-53 0-96 43-96 96s43 96 96 96 96-43 96-96l48 0c0 79.5-64.5 144-144 144s-144-64.5-144-144 64.5-144 144-144c31.1 0 59.9 9.9 83.4 26.6l45.7-45.7C349.7 64.8 304.8 48 256 48 141.1 48 48 141.1 48 256s93.1 208 208 208 208-93.1 208-208l48 0c0 141.4-114.6 256-256 256S0 397.4 0 256 114.6 0 256 0c62.1 0 118.9 22.1 163.3 58.8L463 15c9.4-9.4 24.6-9.4 33.9 0s9.4 24.6 0 33.9L273 273c-9.4 9.4-24.6 9.4-33.9 0s-9.4-24.6 0-33.9l65.7-65.7z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium group-hover:text-stratos-500 group-focus-visible:text-stratos-500 text-noctis-500">Index Advisor</span><span class="text-[14px] text-noctis-300">Faster queries, less guesswork</span></span></a><a href="/postgres-vacuum-advisor" class="group flex items-start gap-2 rounded-md p-3 hover:bg-white focus-visible:bg-white"><span class="flex h-8 w-8 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="circle-notch" class="svg-inline--fa fa-circle-notch W_cs5G_faIcon text-[24px]" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M223.2 25C226.4 37.9 218.6 50.9 205.7 54.1 115.1 76.6 48 158.5 48 256 48 370.9 141.1 464 256 464s208-93.1 208-208c0-97.5-67.1-179.4-157.7-201.9-12.9-3.2-20.7-16.2-17.5-29.1S305 4.3 317.9 7.5C429.4 35.2 512 135.9 512 256 512 397.4 397.4 512 256 512S0 397.4 0 256C0 135.9 82.6 35.2 194.1 7.5 207 4.3 220 12.2 223.2 25z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium group-hover:text-stratos-500 group-focus-visible:text-stratos-500 text-noctis-500">VACUUM Advisor</span><span class="text-[14px] text-noctis-300">Optimize bloat, freezing and VACUUM performance</span></span></a><a href="/postgres-query-tuning-workbooks" class="group flex items-start gap-2 rounded-md p-3 hover:bg-white focus-visible:bg-white"><span class="flex h-8 w-8 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="books" class="svg-inline--fa fa-books W_cs5G_faIcon text-[24px]" role="img" viewBox="0 0 576 512" aria-hidden="true"><path fill="currentColor" d="M96.3 48l48 0c8.8 0 16 7.2 16 16l0 32-80 0 0-32c0-8.8 7.2-16 16-16zm-16 96l80 0 0 224-80 0 0-224zm128-78l0-2c0-35.3-28.7-64-64-64l-48 0c-35.3 0-64 28.7-64 64l0 384c0 35.3 28.7 64 64 64l48 0c15.1 0 29-5.3 40-14 11 8.8 24.9 14 40 14l48 0c35.3 0 64-28.7 64-64l0-164.4 48.6 181.2c9.1 34.1 44.2 54.4 78.4 45.3l46.4-12.4c34.1-9.1 54.4-44.2 45.3-78.4L455.4 48.3C446.3 14.2 411.2-6.1 377 3.1L330.7 15.5c-24.4 6.5-41.8 26.4-46.3 49.7-3.9-.8-8-1.1-12.1-1.1l-48 0c-5.5 0-10.9 .7-16 2zm0 62c0-8.8 7.2-16 16-16l48 0c8.8 0 16 7.2 16 16l0 320c0 8.8-7.2 16-16 16l-48 0c-8.8 0-16-7.2-16-16l0-320zm-48 320c0 8.8-7.2 16-16 16l-48 0c-8.8 0-16-7.2-16-16l0-32 80 0 0 32zM389.5 49.4c8.5-2.3 17.3 2.8 19.6 11.3l8.3 30.9-77.3 20.7-8.3-30.9c-2.3-8.5 2.8-17.3 11.3-19.6l46.4-12.4zm21 325.7l-58-216.4 77.3-20.7 58 216.4-77.3 20.7zm12.4 46.4l77.3-20.7 8.3 30.9c2.3 8.5-2.8 17.3-11.3 19.6l-46.4 12.4c-8.5 2.3-17.3-2.8-19.6-11.3l-8.3-30.9z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium group-hover:text-stratos-500 group-focus-visible:text-stratos-500 text-noctis-500">Workbooks</span><span class="text-[14px] text-noctis-300">Dedicated environment for query optimization</span></span></a></div><a href="/postgres-query-advisor" class="group mt-4 flex items-center justify-center rounded-md bg-noctis-500 py-2.5 hover:bg-noctis-400 focus-visible:bg-noctis-400"><span class="flex items-center gap-2 text-[16px] font-medium text-sand-100">All features<svg data-prefix="far" data-icon="arrow-right" class="svg-inline--fa fa-arrow-right W_cs5G_faIcon text-[14px]" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M505 273c9.4-9.4 9.4-24.6 0-33.9L337 71c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l127 127-406.1 0c-13.3 0-24 10.7-24 24s10.7 24 24 24l406.1 0-127 127c-9.4 9.4-9.4 24.6 0 33.9s24.6 9.4 33.9 0L505 273z"></path></svg></span></a></div></div></li><li class="relative"><button type="button" aria-haspopup="true" aria-expanded="false" aria-controls="nav-panel-solutions" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10 cursor-pointer border-0 bg-transparent"><span class="text-[16px]/[1.3] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500">Solutions</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[12px] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500" role="img" viewBox="0 0 448 512" aria-hidden="true">
16<path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="absolute left-0 top-full z-10 pt-1 hidden"><div id="nav-panel-solutions" class="rounded-md bg-sand-500 p-4 shadow-dropdown w-[220px]"><div class="flex flex-col gap-3"><a href="/solutions/slow-postgres-queries" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Fix Slow Queries</span></a><a href="/enterprise-postgres-monitoring" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Enterprise Scale</span></a></div></div></div></li><li><a href="/pricing" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10"><span class="text-[16px]/[1.3] group-hover:text-stardust-500 group-focus-visible:text-stardust-500 text-sand-100">Pricing</span></a></li><li><a href="/blog" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10"><span class="text-[16px]/[1.3] group-hover:text-stardust-500 group-focus-visible:text-stardust-500 text-sand-100">Blog</span></a></li><li class="relative"><button type="button" aria-haspopup="true" aria-expanded="false" aria-controls="nav-panel-resources" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10 cursor-pointer border-0 bg-transparent"><span class="text-[16px]/[1.3] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500">Resources</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[12px] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="absolute left-0 top-full z-10 pt-1 hidden"><div id="nav-panel-resources" class="rounded-md bg-sand-500 p-4 shadow-dropdown w-[220px]"><div class="flex flex-col gap-3"><a href="/resources/webinars" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Webinars</span></a><a href="/resources/ebooks" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">eBooks</span></a><a href="/resources/tools" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Tools</span></a><a href="/customers" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Customer Stories</span></a><a href="/blog" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Blog</span></a><a href="/newsletter" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Newsletter</span></a></div></div></div></li><li class="relative"><button type="button" aria-haspopup="true" aria-expanded="false" aria-controls="nav-panel-company" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10 cursor-pointer border-0 bg-transparent"><span class="text-[16px]/[1.3] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500">Company</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[12px] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500" role="img" viewBox="0 0 448 512" aria-hidden="true">
16<path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="absolute left-0 top-full z-10 pt-1 hidden"><div id="nav-panel-company" class="rounded-md bg-sand-500 p-4 shadow-dropdown w-[220px]"><div class="flex flex-col gap-3"><a href="/about" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">About us</span></a><a href="/careers" class="group block"><span class="text-[16px] group-hover:text-stratos-500 group-hover:underline group-hover:decoration-stratos-500/50 group-focus-visible:text-stratos-500 group-focus-visible:underline group-focus-visible:decoration-stratos-500/50 text-noctis-500">Careers</span></a></div></div></div></li><li><a href="/contact" class="group flex items-center gap-1 rounded-md px-2.5 py-1 hover:bg-white/10 focus-visible:bg-white/10"><span class="text-[16px]/[1.3] group-hover:text-stardust-500 group-focus-visible:text-stardust-500 text-sand-100">Contact</span></a></li></ul><div class="flex items-center"><div class="hidden items-center gap-6 xl:flex"><a href="https://app.pganalyze.com/users/sign_in" class="group flex items-center rounded-md px-2 py-1 hover:bg-white/10 focus-visible:bg-white/10"><span class="text-[16px]/[1.3] text-sand-100 group-hover:text-stardust-500 group-focus-visible:text-stardust-500">Login</span></a><a href="https://app.pganalyze.com/users/sign_up" class="rounded-md bg-stardust-500 px-3.5 py-2 hover:bg-stardust-400 focus-visible:bg-stardust-400"><span class="text-[16px] font-medium text-noctis-500">Free Trial</span></a></div><button type="button" aria-expanded="false" class="flex cursor-pointer items-center gap-1.5 rounded-md border-0 bg-transparent p-2 text-sand-100 focus-visible:bg-white/10 xl:hidden"><svg data-prefix="far" data-icon="bars" class="svg-inline--fa fa-bars W_cs5G_faIcon text-[20px]" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M0 88C0 74.7 10.7 64 24 64l400 0c13.3 0 24 10.7 24 24s-10.7 24-24 24L24 112C10.7 112 0 101.3 0 88zM0 256c0-13.3 10.7-24 24-24l400 0c13.3 0 24 10.7 24 24s-10.7 24-24 24L24 280c-13.3 0-24-10.7-24-24zM448 424c0 13.3-10.7 24-24 24L24 448c-13.3 0-24-10.7-24-24s10.7-24 24-24l400 0c13.3 0 24 10.7 24 24z"></path></svg><span class="text-[16px]">Menu</span></button></div></nav></div><div class="tw-scope fixed inset-0 z-[1030] flex flex-col font-cera xl:hidden bg-noctis-500 hidden"><div class="flex shrink-0 items-center justify-between bg-noctis-500 px-4 pb-4 pt-[calc(1rem_+_env(safe-area-inset-top))]"><a href="/" class="shrink-0"><img src="/_astro/pga_rect_light.C_LAdX-o.svg" alt="pganalyze" class="h-[40px] w-auto"/></a><button type="button" class="flex cursor-pointer items-center gap-1.5 rounded-md border-0 bg-transparent p-2 text-sand-100 focus-visible:bg-white/10"><svg data-prefix="far" data-icon="xmark" class="svg-inline--fa fa-xmark W_cs5G_faIcon text-[20px]" role="img" viewBox="0 0 384 512" aria-hidden="true"><path fill="currentColor" d="M7.5 105c-9.4-9.4-9.4-24.6 0-33.9s24.6-9.4 33.9 0l151 151 151-151c9.4-9.4 24.6-9.4 33.9 0s9.4 24.6 0 33.9l-151 151 151 151c9.4 9.4 9.4 24.6 0 33.9s-24.6 9.4-33.9 0l-151-151-151 151c-9.4 9.4-24.6 9.4-33.9 0s-9.4-24.6 0-33.9l151-151-151-151z"></path></svg><span class="text-[16px]">Close</span></button></div><div class="relative flex grow flex-col gap-8 overflow-y-auto rounded-t-3xl bg-sand-500 px-4 pt-4 pb-24 nav-sheet-in"><nav aria-label="Mobile" class="relative z-10 flex flex-col gap-2"><a href="/docs" class="block rounded-lg bg-white p-4 text-[18px] focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500"><span class="font-medium text-noctis-500">Docs</span></a><div class="overflow-hidden rounded-lg bg-white"><button type="button" aria-expanded="false" class="flex w-full cursor-pointer items-center justify-between border-0 p-4 text-left focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 bg-transparent"><span class="text-[18px] text-noctis-500">Features</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[16px] text-noctis-500" role="img" viewBox="0 0 448 512" aria-hidden="true">
16<path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="nav-drawer"><div class="px-4"><a href="/postgres-query-advisor" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 flex items-start gap-3"><span class="flex h-6 w-6 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="code-pull-request-draft" class="svg-inline--fa fa-code-pull-request-draft W_cs5G_faIcon text-[20px]" role="img" viewBox="0 0 384 512" aria-hidden="true"><path fill="currentColor" d="M80 48a32 32 0 1 1 0 64 32 32 0 1 1 0-64zm24 108.3c32.5-10.2 56-40.5 56-76.3 0-44.2-35.8-80-80-80S0 35.8 0 80c0 35.8 23.5 66.1 56 76.3l0 199.3c-32.5 10.2-56 40.5-56 76.3 0 44.2 35.8 80 80 80s80-35.8 80-80c0-35.8-23.5-66.1-56-76.3l0-199.3zM112 432c0 17.7-14.3 32-32 32s-32-14.3-32-32 14.3-32 32-32 32 14.3 32 32zm224 0c0 17.7-14.3 32-32 32s-32-14.3-32-32 14.3-32 32-32 32 14.3 32 32zm48 0c0-44.2-35.8-80-80-80s-80 35.8-80 80 35.8 80 80 80 80-35.8 80-80zM344 80a40 40 0 1 0 -80 0 40 40 0 1 0 80 0zM304 272a40 40 0 1 0 0-80 40 40 0 1 0 0 80z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium text-noctis-500">Query Advisor</span><span class="text-[14px] text-noctis-300">Detect and fix Postgres query plan problems</span></span></a><a href="/postgres-index-advisor" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 flex items-start gap-3"><span class="flex h-6 w-6 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="radar" class="svg-inline--fa fa-radar W_cs5G_faIcon text-[20px]" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M304.8 173.3c-14.3-8.4-31-13.3-48.8-13.3-53 0-96 43-96 96s43 96 96 96 96-43 96-96l48 0c0 79.5-64.5 144-144 144s-144-64.5-144-144 64.5-144 144-144c31.1 0 59.9 9.9 83.4 26.6l45.7-45.7C349.7 64.8 304.8 48 256 48 141.1 48 48 141.1 48 256s93.1 208 208 208 208-93.1 208-208l48 0c0 141.4-114.6 256-256 256S0 397.4 0 256 114.6 0 256 0c62.1 0 118.9 22.1 163.3 58.8L463 15c9.4-9.4 24.6-9.4 33.9 0s9.4 24.6 0 33.9L273 273c-9.4 9.4-24.6 9.4-33.9 0s-9.4-24.6 0-33.9l65.7-65.7z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium text-noctis-500">Index Advisor</span><span class="text-[14px] text-noctis-300">Faster queries, less guesswork</span></span></a><a href="/postgres-vacuum-advisor" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 flex items-start gap-3"><span class="flex h-6 w-6 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="circle-notch" class="svg-inline--fa fa-circle-notch W_cs5G_faIcon text-[20px]" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M223.2 25C226.4 37.9 218.6 50.9 205.7 54.1 115.1 76.6 48 158.5 48 256 48 370.9 141.1 464 256 464s208-93.1 208-208c0-97.5-67.1-179.4-157.7-201.9-12.9-3.2-20.7-16.2-17.5-29.1S305 4.3 317.9 7.5C429.4 35.2 512 135.9 512 256 512 397.4 397.4 512 256 512S0 397.4 0 256C0 135.9 82.6 35.2 194.1 7.5 207 4.3 220 12.2 223.2 25z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium text-noctis-500">VACUUM Advisor</span><span class="text-[14px] text-noctis-300">Optimize bloat, freezing and VACUUM performance</span></span></a><a href="/postgres-query-tuning-workbooks" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 flex items-start gap-3"><span class="flex h-6 w-6 shrink-0 items-center justify-center text-stratos-500"><svg data-prefix="far" data-icon="books" class="svg-inline--fa fa-books W_cs5G_faIcon text-[20px]" role="img" viewBox="0 0 576 512" aria-hidden="true">
16<path fill="currentColor" d="M96.3 48l48 0c8.8 0 16 7.2 16 16l0 32-80 0 0-32c0-8.8 7.2-16 16-16zm-16 96l80 0 0 224-80 0 0-224zm128-78l0-2c0-35.3-28.7-64-64-64l-48 0c-35.3 0-64 28.7-64 64l0 384c0 35.3 28.7 64 64 64l48 0c15.1 0 29-5.3 40-14 11 8.8 24.9 14 40 14l48 0c35.3 0 64-28.7 64-64l0-164.4 48.6 181.2c9.1 34.1 44.2 54.4 78.4 45.3l46.4-12.4c34.1-9.1 54.4-44.2 45.3-78.4L455.4 48.3C446.3 14.2 411.2-6.1 377 3.1L330.7 15.5c-24.4 6.5-41.8 26.4-46.3 49.7-3.9-.8-8-1.1-12.1-1.1l-48 0c-5.5 0-10.9 .7-16 2zm0 62c0-8.8 7.2-16 16-16l48 0c8.8 0 16 7.2 16 16l0 320c0 8.8-7.2 16-16 16l-48 0c-8.8 0-16-7.2-16-16l0-320zm-48 320c0 8.8-7.2 16-16 16l-48 0c-8.8 0-16-7.2-16-16l0-32 80 0 0 32zM389.5 49.4c8.5-2.3 17.3 2.8 19.6 11.3l8.3 30.9-77.3 20.7-8.3-30.9c-2.3-8.5 2.8-17.3 11.3-19.6l46.4-12.4zm21 325.7l-58-216.4 77.3-20.7 58 216.4-77.3 20.7zm12.4 46.4l77.3-20.7 8.3 30.9c2.3 8.5-2.8 17.3-11.3 19.6l-46.4 12.4c-8.5 2.3-17.3-2.8-19.6-11.3l-8.3-30.9z"></path></svg></span><span class="flex flex-col gap-0.5"><span class="text-[16px] font-medium text-noctis-500">Workbooks</span><span class="text-[14px] text-noctis-300">Dedicated environment for query optimization</span></span></a><div class="py-4"><a href="/postgres-query-advisor" class="flex items-center justify-center gap-1.5 rounded-md bg-noctis-500 px-3.5 py-2.5 hover:bg-noctis-400 focus-visible:bg-noctis-400"><span class="text-[16px] font-medium text-sand-100">See all features</span><svg data-prefix="far" data-icon="arrow-right" class="svg-inline--fa fa-arrow-right W_cs5G_faIcon text-[16px] text-sand-100" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M505 273c9.4-9.4 9.4-24.6 0-33.9L337 71c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l127 127-406.1 0c-13.3 0-24 10.7-24 24s10.7 24 24 24l406.1 0-127 127c-9.4 9.4-9.4 24.6 0 33.9s24.6 9.4 33.9 0L505 273z"></path></svg></a></div></div></div></div><div class="overflow-hidden rounded-lg bg-white"><button type="button" aria-expanded="false" class="flex w-full cursor-pointer items-center justify-between border-0 p-4 text-left focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 bg-transparent"><span class="text-[18px] text-noctis-500">Solutions</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[16px] text-noctis-500" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="nav-drawer"><div class="px-4"><a href="/solutions/slow-postgres-queries" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Fix Slow Queries</span></a><a href="/enterprise-postgres-monitoring" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Enterprise Scale</span></a></div></div></div><a href="/pricing" class="block rounded-lg bg-white p-4 text-[18px] focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500"><span class="text-noctis-500">Pricing</span></a><a href="/blog" class="block rounded-lg bg-white p-4 text-[18px] focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500"><span class="text-noctis-500">Blog</span></a><div class="overflow-hidden rounded-lg bg-white"><button type="button" aria-expanded="false" class="flex w-full cursor-pointer items-center justify-between border-0 p-4 text-left focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 bg-transparent"><span class="text-[18px] text-noctis-500">Resources</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[16px] text-noctis-500" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="nav-drawer"><div class="px-4"><a href="/resources/webinars" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Webinars</span></a><a href="/resources/ebooks" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">eBooks</span></a><a href="/resources/tools" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Tools</span></a><a href="/customers" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Customer Stories</span></a><a href="/blog" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Blog</span></a><a href="/newsletter" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Newsletter</span></a></div></div></div><div class="overflow-hidden rounded-lg bg-white"><button type="button" aria-expanded="false" class="flex w-full cursor-pointer items-center justify-between border-0 p-4 text-left focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 bg-transparent"><span class="text-[18px] text-noctis-500">Company</span><svg data-prefix="far" data-icon="chevron-down" class="svg-inline--fa fa-chevron-down W_cs5G_faIcon text-[16px] text-noctis-500" role="img" viewBox="0 0 448 512" aria-hidden="true">
16<path fill="currentColor" d="M207.5 409c9.4 9.4 24.6 9.4 33.9 0l200-200c9.4-9.4 9.4-24.6 0-33.9s-24.6-9.4-33.9 0l-183 183-183-183c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l200 200z"></path></svg></button><div class="nav-drawer"><div class="px-4"><a href="/about" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">About us</span></a><a href="/careers" class="py-4 border-b border-noctis-100 last:border-b-0 focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500 block"><span class="text-[18px] text-noctis-500">Careers</span></a></div></div></div><a href="/contact" class="block rounded-lg bg-white p-4 text-[18px] focus-visible:ring-2 focus-visible:ring-inset focus-visible:ring-stratos-500"><span class="text-noctis-500">Contact</span></a></nav><div class="relative z-10 flex flex-col gap-3"><a href="https://app.pganalyze.com/users/sign_up" class="flex h-12 items-center justify-center rounded-md bg-noctis-500 hover:bg-noctis-400 focus-visible:bg-noctis-400"><span class="text-[18px] font-medium text-sand-100">Free Trial</span></a><a href="https://app.pganalyze.com/users/sign_in" class="group flex items-center justify-center gap-2 rounded-md py-2 focus-visible:bg-noctis-100"><span class="flex items-center gap-2 text-[18px] text-noctis-500 group-hover:text-stratos-500 group-focus-visible:text-stratos-500">Log in<svg data-prefix="far" data-icon="arrow-right" class="svg-inline--fa fa-arrow-right W_cs5G_faIcon text-[14px]" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M505 273c9.4-9.4 9.4-24.6 0-33.9L337 71c-9.4-9.4-24.6-9.4-33.9 0s-9.4 24.6 0 33.9l127 127-406.1 0c-13.3 0-24 10.7-24 24s10.7 24 24 24l406.1 0-127 127c-9.4 9.4-9.4 24.6 0 33.9s24.6 9.4 33.9 0L505 273z"></path></svg></span></a></div><div aria-hidden="true" class="pointer-events-none absolute inset-x-0 bottom-0 z-0 h-64 overflow-hidden"><img src="/_astro/solutions-comparison-cloud2.CHaNQbXM.svg" alt="" class="absolute -left-12 bottom-4 w-72 aspect-[497/249] opacity-70"/><img src="/_astro/solutions-comparison-cloud1.zLAVRHrb.svg" alt="" class="absolute -right-10 bottom-16 w-56 aspect-[497/249] opacity-60"/><svg class="absolute bottom-28 left-12" width="14" height="20" viewBox="0 0 14 20" fill="none" aria-hidden="true"><path d="M7 0L7 20" stroke="var(--stratos-500)" stroke-width="0.75"></path><path d="M0 10.375H13.8704" stroke="var(--stratos-500)" stroke-width="0.75"></path><path d="M2.03326 5.47168L11.8411 15.2795" stroke="var(--stratos-500)" stroke-width="0.75"></path><path d="M2.03027 15.2798L11.8381 5.47195" stroke="var(--stratos-500)" stroke-width="0.75"></path></svg><svg class="absolute bottom-10 right-20" width="14" height="20" viewBox="0 0 14 20" fill="none" aria-hidden="true"><path d="M7 0L7 20" stroke="var(--stardust-500)" stroke-width="0.75"></path><path d="M0 10.375H13.8704" stroke="var(--stardust-500)" stroke-width="0.75"></path><path d="M2.03326 5.47168L11.8411 15.2795" stroke="var(--stardust-500)" stroke-width="0.75"></path><path d="M2.03027 15.2798L11.8381 5.47195" stroke="var(--stardust-500)" stroke-width="0.75"></path></svg><svg class="absolute bottom-36 right-10" width="14" height="20" viewBox="0 0 14 20" fill="none" aria-hidden="true"><path d="M7 0L7 20" stroke="var(--redshift-500)" stroke-width="0.75"></path><path d="M0 10.375H13.8704" stroke="var(--redshift-500)" stroke-width="0.75"></path><path d="M2.03326 5.47168L11.8411 15.2795" stroke="var(--redshift-500)" stroke-width="0.75"></path><path d="M2.03027 15.2798L11.8381 5.47195" stroke="var(--redshift-500)" stroke-width="0.75"></path></svg></div></div></div></div></div><div class="L8lE7q_headerBackground"><div class="L8lE7q_headerBackgroundGradient"></div></div><!--astro:end--></astro-island><div class="pga-container page-container"><div class="page-content"><div class="page-content--inner EW9ujq_docsPageContent"><astro-island uid="2gyUeS" prefix="r25" component-url="/_astro/index.D0vhgz8d.js" component-export="default" renderer-url="/_astro/client.Dqz2Vqct.js" props="{"rootItems":[1,[[0,{"name":[0,"Overview"],"href":[0,""]}],[0,{"name":[0,"Installation Guide"],"href":[0,"install"]}],[0,{"name":[0,"pganalyze Collector"],"href":[0,"collector"]}],[0,{"name":[0,"Query Performance"],"href":[0,"query-performance"]}],[0,{"name":[0,"Query Advisor"],"href":[0,"query-advisor"]}],[0,{"name":[0,"EXPLAIN Plans"],"href":[0,"explain"]}],[0,{"name":[0,"Workbooks"],"href":[0,"workbooks"]}],[0,{"name":[0,"Index Advisor"],"href":[0,"index-advisor"]}],[0,{"name":[0,"Indexing Engine"],"href":[0,"indexing-engine"]}],[0,{"name":[0,"VACUUM Advisor"],"href":[0,"vacuum-advisor"]}],[0,{"name":[0,"Schema Statistics"],"href":[0,"schema-statistics"]}],[0,{"name":[0,"Log Insights"],"href":[0,"log-insights"]}],[0,{"name":[0,"Connections"],"href":[0,"connections"]}],[0,{"name":[0,"Alerts & Check-Up"],"href":[0,"checks"]}],[0,{"name":[0,"Account Management"],"href":[0,"accounts"]}],[0,{"name":[0,"MCP Server (Preview)"],"href":[0,"mcp"]}],[0,{"name":[0,"OpenTelemetry Integration"],"href":[0,"opentelemetry"]}],[0,{"name":[0,"pganalyze Enterprise Server"],"href":[0,"enterprise"]}],[0,{"name":[0,"pganalyze GraphQL API"],"href":[0,"api"]}],[0,{"name":[0,"Open-Source Components"],"href":[0,"open_source_components"]}]]],"itemsByParent":[0,{"accounts":[1,[[0,{"name":[0,"Overview"],"href":[0,"accounts"]}],[0,{"name":[0,"Billing"],"href":[0,"accounts/billing"]}],[0,{"name":[0,"Permissions and Roles"],"href":[0,"accounts/permissions"]}],[0,{"name":[0,"Server Groups"],"href":[0,"accounts/server_groups"]}],[0,{"name":[0,"Single Sign-On"],"href":[0,"accounts/sso"]}]]],"accounts/sso":[1,[[0,{"name":[0,"Overview"],"href":[0,"accounts/sso"]}],[0,{"name":[0,"Okta integration"],"href":[0,"accounts/sso/okta"]}],[0,{"name":[0,"Azure integration"],"href":[0,"accounts/sso/azure"]}],[0,{"name":[0,"Custom SAML 2.0 integration"],"href":[0,"accounts/sso/saml2"]}]]],"api":[1,[[0,{"name":[0,"Overview"],"href":[0,"api"]}],[0,{"name":[0,"Authentication"],"href":[0,"api/authentication"]}],[0,{"name":[0,"Queries"],"href":[0,"api/queries"]}],[0,{"name":[0,"Mutations"],"href":[0,"api/mutations"]}]]],"api/authentication":[1,[[0,{"name":[0,"Overview"],"href":[0,"api/authentication"]}],[0,{"name":[0,"Personal access tokens"],"href":[0,"api/personal-access-tokens"]}],[0,{"name":[0,"API keys"],"href":[0,"api/create-api-key"]}]]],"api/mutations":[1,[[0,{"name":[0,"addServer"],"href":[0,"api/mutations/addServer"]}],[0,{"name":[0,"updateServer"],"href":[0,"api/mutations/updateServer"]}],[0,{"name":[0,"deleteServer"],"href":[0,"api/mutations/deleteServer"]}]]],"api/queries":[1,[[0,{"name":[0,"getServers"],"href":[0,"api/queries/getServers"]}],[0,{"name":[0,"getIssues"],"href":[0,"api/queries/getIssues"]}],[0,{"name":[0,"getQueryStats"],"href":[0,"api/queries/getQueryStats"]}]]],"checks":[1,[[0,{"name":[0,"Overview"],"href":[0,"checks/"]}],[0,{"name":[0,"Queries"],"href":[0,"checks/queries"]}],[0,{"name":[0,"Connections"],"href":[0,"checks/connections"]}],[0,{"name":[0,"Index Advisor"],"href":[0,"checks/index_advisor"]}],[0,{"name":[0,"Schema"],"href":[0,"checks/schema"]}],[0,{"name":[0,"Settings"],"href":[0,"checks/settings"]}],[0,{"name":[0,"System"],"href":[0,"checks/system"]}],[0,{"name":[0,"Replication"],"href":[0,"checks/replication"]}],[0,{"name":[0,"Vacuum"],"href":[0,"checks/vacuum"]}]]],"checks/queries":[1,[[0,{"name":[0,"New Slow Queries"],"href":[0,"checks/queries/slowness"]}],[0,{"name":[0,"Advisor Insights"],"href":[0,"checks/queries/advisor_insight"]}]]],"checks/connections":[1,[[0,{"name":[0,"Active Queries"],"href":[0,"checks/connections/active_query"]}],[0,{"name":[0,"Idle Transactions"],"href":[0,"checks/connections/idle_transaction"]}],[0,{"name":[0,"Blocking Queries"],"href":[0,"checks/connections/blocking_query"]}]]],"checks/index_advisor":[1,[[0,{"name":[0,"Missing Index"],"href":[0,"checks/index_advisor/indexing_engine"]}]]],"checks/schema":[1,[[0,{"name":[0,"Invalid Indexes"],"href":[0,"
16checks/schema/index_invalid"]}],[0,{"name":[0,"Unused Indexes"],"href":[0,"checks/schema/index_unused"]}]]],"checks/settings":[1,[[0,{"name":[0,"Config - Disabled features"],"href":[0,"checks/settings/enable_features"]}],[0,{"name":[0,"Config - Disabled fsync"],"href":[0,"checks/settings/fsync"]}],[0,{"name":[0,"Config - Too small shared_buffers"],"href":[0,"checks/settings/shared_buffers"]}],[0,{"name":[0,"Config - Disabled stats collection"],"href":[0,"checks/settings/stats"]}],[0,{"name":[0,"Config - Too small work_mem"],"href":[0,"checks/settings/work_mem"]}]]],"checks/system":[1,[[0,{"name":[0,"Out of Disk Space"],"href":[0,"checks/system/storage_space"]}]]],"checks/replication":[1,[[0,{"name":[0,"Replication - High Lag"],"href":[0,"checks/replication/high_lag"]}],[0,{"name":[0,"Replication - Missing HA Follower"],"href":[0,"checks/replication/follower_missing"]}]]],"checks/vacuum":[1,[[0,{"name":[0,"Performance - Inefficient Index Phase"],"href":[0,"checks/vacuum/inefficient_index_phase"]}],[0,{"name":[0,"Bloat - Insufficient VACUUM Frequency"],"href":[0,"checks/vacuum/insufficient_vacuum_frequency"]}],[0,{"name":[0,"Bloat - VACUUM Blocked by Xmin Horizon"],"href":[0,"checks/vacuum/xmin_horizon"]}],[0,{"name":[0,"Freezing - Approaching Transaction ID Wraparound"],"href":[0,"checks/vacuum/txid_wraparound"]}],[0,{"name":[0,"Freezing - Approaching Multixact ID Wraparound"],"href":[0,"checks/vacuum/mxid_wraparound"]}]]],"collector":[1,[[0,{"name":[0,"Overview"],"href":[0,"collector"]}],[0,{"name":[0,"Packages"],"href":[0,"collector/packages"]}],[0,{"name":[0,"Configuration Settings"],"href":[0,"collector/settings"]}],[0,{"name":[0,"Server Identity"],"href":[0,"collector/server-identity"]}],[0,{"name":[0,"Upgrading"],"href":[0,"collector/upgrading"]}],[0,{"name":[0,"PII Filtering"],"href":[0,"collector/pii-filtering"]}],[0,{"name":[0,"Uninstalling"],"href":[0,"collector/uninstalling"]}]]],"enterprise":[1,[[0,{"name":[0,"Overview"],"href":[0,"enterprise"]}],[0,{"name":[0,"Setup instructions"],"href":[0,"enterprise/setup"]}],[0,{"name":[0,"Upgrade instructions"],"href":[0,"enterprise/upgrade"]}],[0,{"name":[0,"Container settings"],"href":[0,"enterprise/settings"]}],[0,{"name":[0,"Release changelog"],"href":[0,"enterprise/releases"]}],[0,{"name":[0,"Reference architecture"],"href":[0,"enterprise/architecture"]}],[0,{"name":[0,"Integrating PostGIS"],"href":[0,"enterprise/postgis"]}],[0,{"name":[0,"Troubleshooting"],"href":[0,"enterprise/troubleshooting"]}]]],"enterprise/releases":[1,[[0,{"name":[0,"2026.08.1 Release"],"href":[0,"enterprise/releases/2026-08-1"]}],[0,{"name":[0,"2026.08.0 Release"],"href":[0,"enterprise/releases/2026-08-0"]}],[0,{"name":[0,"2026.05.1 Release"],"href":[0,"enterprise/releases/2026-05-1"]}],[0,{"name":[0,"2026.05.0 Release"],"href":[0,"enterprise/releases/2026-05-0"]}],[0,{"name":[0,"2026.02.1 Release"],"href":[0,"enterprise/releases/2026-02-1"]}],[0,{"name":[0,"2026.02.0 Release"],"href":[0,"enterprise/releases/2026-02-0"]}],[0,{"name":[0,"2026.01.1 Release"],"href":[0,"enterprise/releases/2026-01-1"]}],[0,{"name":[0,"2026.01.0 Release"],"href":[0,"enterprise/releases/2026-01-0"]}],[0,{"name":[0,"2025.03.6 Release"],"href":[0,"enterprise/releases/2025-03-6"]}],[0,{"name":[0,"2025.03.5 Release"],"href":[0,"enterprise/releases/2025-03-5"]}],[0,{"name":[0,"2025.03.4 Release"],"href":[0,"enterprise/releases/2025-03-4"]}],[0,{"name":[0,"2025.03.3 Release"],"href":[0,"enterprise/releases/2025-03-3"]}],[0,{"name":[0,"2025.03.2 Release"],"href":[0,"enterprise/releases/2025-03-2"]}],[0,{"name":[0,"2025.03.1 Release"],"href":[0,"enterprise/releases/2025-03-1"]}],[0,{"name":[0,"2025.03.0 Release"],"href":[0,"enterprise/releases/2025-03-0"]}],[0,{"name":[0,"2024.10.0 Release"],"href":[0,"enterprise/releases/2024-10-0"]}],[0,{"name":[0,"2024.04.5 Release"],"href":[0,"enterprise/releases/2024-04-5"]}],[0,{"name":[0,"2024.04.4 Release"],"href":[0,"enterprise/releases/2024-04-4"]}],[0,{"name":[0,"2024.04.3 Release"],"href":[0,"enterprise/releases/2024-04-3"]}],[0,{"name":[0,"2024.04.2 Release"],"href":[0,"enterprise/releases/2024-04-2"]}],[0,{"name":[0,"2024.04.1 Release"],"href":[0,"enterprise/releases/2024-04-1"]}],[0,{"name":[0,"2024.04.0 Release"],"href":[0,"enterprise/releases/2024-04-0"]}],[0,{"name":[0,"2023.08.0 Release"],"href":[0,"enterprise/releases/2023-08-0"]}],[0,{"name":[0,"2023.07.0 Release"],"href":[0,"enterprise/releases/2023-07-0"]}],[0,{"name":[0,"2023.06.0 Release"],"href":[0,"enterprise/releases/2023-06-0"]}],[0,{"name":[0,"2023.03.1 Release"],"href":[0,"enterprise/releases/2023-03-1"]}],[0,{"name":[0,"2023.03.0 Release"],"href":[0,"enterprise/releases/2023-03-0"]}],[0,{"name":[0,"2022.08.1 Release"],"href":[0,"enterprise/releases/2022-08-1"]}],[0,{"name":[0,"2022.08.0 Release"],"href":[0,"enterprise/releases/2022-08-0"]}],[0,{"name":[0,"2022.05.1 Release"],"href":[0,"enterprise/releases/2022-05-1"]}],[0,{"name":[0,"2022.05.0 Release"],"href":[0,"enterprise/releases/2022-05-0"]}],[0,{"name":[0,"2021.12.1 Release"],"href":[0,"enterprise/releases/2021-12-1"]}],[0,{"name":[0,"2021.12.0 Release"],"href":[0,"enterprise/releases/2021-12-0"]}],[0,{"name":[0,"2021.06.0 Release"],"href":[0,"enterprise/releases/2021-06-0"]}],[0,{"name":[0,"2021.02.0 Release"],"href":[0,"enterprise/releases/2021-02-0"]}],[0,{"name":[0,"2020.09.0 Release"],"href":[0,"
16enterprise/releases/2020-09-0"]}],[0,{"name":[0,"2020.07.2 Release"],"href":[0,"enterprise/releases/2020-07-2"]}],[0,{"name":[0,"2020.07.1 Release"],"href":[0,"enterprise/releases/2020-07-1"]}],[0,{"name":[0,"2020.07.0 Release"],"href":[0,"enterprise/releases/2020-07-0"]}],[0,{"name":[0,"2019.04.1 Release"],"href":[0,"enterprise/releases/2019-04-1"]}],[0,{"name":[0,"2019.04.0 Release"],"href":[0,"enterprise/releases/2019-04-0"]}],[0,{"name":[0,"2018.09.0 Release"],"href":[0,"enterprise/releases/2018-09-0"]}],[0,{"name":[0,"2018.08.2 Release"],"href":[0,"enterprise/releases/2018-08-2"]}],[0,{"name":[0,"2018.08.1 Release"],"href":[0,"enterprise/releases/2018-08-1"]}],[0,{"name":[0,"2018.08.0 Release"],"href":[0,"enterprise/releases/2018-08-0"]}],[0,{"name":[0,"2018.07.0 Release"],"href":[0,"enterprise/releases/2018-07-0"]}],[0,{"name":[0,"2018.02.4 Release"],"href":[0,"enterprise/releases/2018-02-4"]}],[0,{"name":[0,"2018.02.3 Release"],"href":[0,"enterprise/releases/2018-02-3"]}],[0,{"name":[0,"2018.02.2 Release"],"href":[0,"enterprise/releases/2018-02-2"]}],[0,{"name":[0,"2018.02.1 Release"],"href":[0,"enterprise/releases/2018-02-1"]}],[0,{"name":[0,"2018.02.0 Release"],"href":[0,"enterprise/releases/2018-02-0"]}],[0,{"name":[0,"2017.12.0 Release"],"href":[0,"enterprise/releases/2017-12-0"]}],[0,{"name":[0,"2017.11.0 Release"],"href":[0,"enterprise/releases/2017-11-0"]}],[0,{"name":[0,"2017.10.0 Release"],"href":[0,"enterprise/releases/2017-10-0"]}],[0,{"name":[0,"2017.08.0 Release"],"href":[0,"enterprise/releases/2017-08-0"]}]]],"enterprise/setup":[1,[[0,{"name":[0,"Setup overview"],"href":[0,"enterprise/setup"]}],[0,{"name":[0,"Docker on a VM"],"href":[0,"enterprise/setup/docker"]}],[0,{"name":[0,"Initial setup on Kubernetes (Amazon EKS)"],"href":[0,"enterprise/setup/kubernetes_amazon_eks"]}],[0,{"name":[0,"Initial setup on Kubernetes (Azure AKS)"],"href":[0,"enterprise/setup/kubernetes_azure_aks"]}],[0,{"name":[0,"Initial setup on Kubernetes (non-root)"],"href":[0,"enterprise/setup/kubernetes_as_non_root"]}],[0,{"name":[0,"Separate collector installation"],"href":[0,"enterprise/setup/separate-collector-install"]}],[0,{"name":[0,"Google Auth setup"],"href":[0,"enterprise/google-auth"]}],[0,{"name":[0,"Firewall configuration"],"href":[0,"enterprise/setup/firewall-configuration"]}],[0,{"name":[0,"PagerDuty and Slack integration setup"],"href":[0,"enterprise/integrations"]}]]],"enterprise/upgrade":[1,[[0,{"name":[0,"Upgrade overview"],"href":[0,"enterprise/upgrade"]}],[0,{"name":[0,"Docker on a VM"],"href":[0,"enterprise/upgrade/docker"]}],[0,{"name":[0,"Kubernetes (Amazon EKS)"],"href":[0,"enterprise/upgrade/kubernetes_amazon_eks"]}],[0,{"name":[0,"Kubernetes (Azure AKS)"],"href":[0,"enterprise/upgrade/kubernetes_azure_aks"]}]]],"explain":[1,[[0,{"name":[0,"Overview"],"href":[0,"explain"]}],[0,{"name":[0,"The Basics of Postgres Query Planning"],"href":[0,"explain/basics-of-postgres-query-planning"]}],[0,{"name":[0,"EXPLAIN Grid view"],"href":[0,"explain/grid"]}],[0,{"name":[0,"Comparing EXPLAIN plans"],"href":[0,"explain/plan-comparison"]}],[0,{"name":[0,"Insights"],"href":[0,"explain/insights"]}],[0,{"name":[0,"Scan nodes"],"href":[0,"explain/scan-nodes"]}],[0,{"name":[0,"Join nodes"],"href":[0,"explain/join-nodes"]}],[0,{"name":[0,"Other nodes"],"href":[0,"explain/other-nodes"]}]]],"explain/insights":[1,[[0,{"name":[0,"Disk Sort"],"href":[0,"explain/insights/disk-sort"]}],[0,{"name":[0,"Hash Batches"],"href":[0,"explain/insights/hash-batches"]}],[0,{"name":[0,"Inefficient Index"],"href":[0,"explain/insights/inefficient-index"]}],[0,{"name":[0,"Large Offset"],"href":[0,"explain/insights/large-offset"]}],[0,{"name":[0,"Lossy Bitmaps"],"href":[0,"explain/insights/lossy-bitmaps"]}],[0,{"name":[0,"Mis-Estimate"],"href":[0,"explain/insights/mis-estimate"]}],[0,{"name":[0,"Slow Scan"],"href":[0,"explain/insights/slow-scan"]}],[0,{"name":[0,"Stale Stats"],"href":[0,"explain/insights/stale-stats"]}]]],"explain/join-nodes":[1,[[0,{"name":[0,"Hash Join"],"href":[0,"explain/join-nodes/hash-join"]}],[0,{"name":[0,"Merge Join"],"href":[0,"explain/join-nodes/merge-join"]}],[0,{"name":[0,"Nested Loop"],"href":[0,"explain/join-nodes/nested-loop"]}]]],"explain/other-nodes":[1,[[0,{"name":[0,"Aggregate"],"href":[0,"explain/other-nodes/aggregate"]}],[0,{"name":[0,"Append"],"href":[0,"explain/other-nodes/append"]}],[0,{"name":[0,"Bitmap And"],"href":[0,"explain/other-nodes/bitmap-and"]}],[0,{"name":[0,"Bitmap Or"],"href":[0,"explain/other-nodes/bitmap-or"]}],[0,{"name":[0,"Gather Merge"],"href":[0,"explain/other-nodes/gather-merge"]}],[0,{"name":[0,"Gather"],"href":[0,"explain/other-nodes/gather"]}],[0,{"name":[0,"Group"],"href":[0,"explain/other-nodes/group"]}],[0,{"name":[0,"Hash"],"href":[0,"explain/other-nodes/hash"]}],[0,{"name":[0,"Limit"],"href":[0,"explain/other-nodes/limit"]}],[0,{"name":[0,"Lock Rows"],"href":[0,"explain/other-nodes/lock-rows"]}],[0,{"name":[0,"Materialize"],"href":[0,"explain/other-nodes/materialize"]}],[0,{"name":[0,"Merge Append"],"href":[0,"explain/other-nodes/merge-append"]}],[0,{"name":[0,"Modify Table"],"href":[0,"explain/other-nodes/modify-table"]}],[0,{"name":[0,"Project Set"],"href":[0,"explain/other-nodes/project-set"]}],[0,{"name":[0,"Recursive Union"],"href":[0,"explain/other-nodes/recursive-union"]}],[0,{"name":[0,"Result"],"href":[0,"explain/other-nodes/result"]}],[0,{"name":[0,"SetOp"],"href":[0,"explain/other-nodes/set-op"]}],[0,{"name":[0,"Sort"],"href":[0,"explain/other-nodes/sort"]}],[0,{"name":[0,"Unique"],"href":[0,"explain/other-nodes/unique"]}],[0,{"name":[0,"Window Aggregate"],"href":[0,"explain/other-nodes/window-aggregate"]}]]],"explain/scan-nodes":[1,[[0,{"name":[0,"Sequential Scan"],"href":[0,"explain/scan-nodes/sequential-scan"]}],[0,{"name":[0,"Index Scan"],"href":[0,"explain/scan-nodes/index-scan"]}],[0,{"name":[0,"Index-Only Scan"],"href":[0,"explain/scan-nodes/index-only-scan"]}],[0,{"name":[0,"Bitmap Heap Scan"],"href":[0,"explain/scan-nodes/bitmap-heap-scan"]}],[0,{"name":[0,"Bitmap Index Scan"],"href":[0,"explain/scan-nodes/bitmap-index-scan"]}],[0,{"name":[0,"CTE Scan"],"href":[0,"explain/scan-nodes/cte-scan"]}],[0,{"name":[0,"Custom Scan"],"href":[0,"explain/scan-nodes/custom-scan"]}],[0,{"name":[0,"Foreign Scan"],"href":[0,"explain/scan-nodes/foreign-scan"]}],[0,{"name":[0,"Function Scan"],"href":[0,"explain/scan-nodes/function-scan"]}],[0,{"name":[0,"Subquery Scan"],"href":[0,"explain/scan-nodes/subquery-scan"]}],[0,{"name":[0,"Table Sample Scan"],"href":[0,"explain/scan-nodes/table-sample-scan"]}],[0,{"name":[0,"Tid Scan"],"href":[0,"explain/scan-nodes/tid-scan"]}],[0,{"name":[0,"Values Scan"],"href":[0,"explain/scan-nodes/values-scan"]}],[0,{"name":[0,"Work Table Scan"],"href":[0,"explain/scan-nodes/work-table-scan"]}]]],"explain/setup":[1,[[0,{"name":[0,"Overview"],"href":[0,"explain/setup"]}],[0,{"name":[0,"auto_explain"],"href":[0,"explain/setup/auto_explain"]}],[0,{"name":[0,"Log-based EXPLAIN"],"href":[0,"explain/setup/log_explain"]}]]],"explain/setup/auto_explain":[1,[[0,{"name":[0,"Overview"],"href":[0,"explain/setup/auto_explain"]}],[0,{"name":[0,"Amazon RDS & Amazon Aurora"],"href":[0,"explain/setup/amazon_rds"]}],[0,{"name":[0,"Azure Database for PostgreSQL"],"href":[0,"explain/setup/azure_database"]}],[0,{"name":[0,"Google Cloud SQL"],"href":[0,"explain/setup/google_cloud_sql"]}],[0,{"name":[0,"Supabase"],"href":[0,"explain/setup/supabase"]}],[0,{"name":[0,"Crunchy Bridge"],"href":[0,"explain/setup/crunchy_bridge"]}],[0,{"name":[0,"Heroku Postgres"],"href":[0,"explain/setup/heroku"]}],[0,{"name":[0,"Self-Managed Server"],"href":[0,"explain/setup/self_managed"]}]]],"explain/setup/log_explain":[1,[[0,{"name":[0,"Overview"],"href":[0,"explain/setup/log_explain"]}],[0,{"name":[0,"Other platforms"],"href":[0,"explain/setup/log_explain/"]}]]],"explain/setup/amazon_rds":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/amazon_rds/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/amazon_rds/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/amazon_rds/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and Verify"],"href":[0,"explain/setup/amazon_rds/04_test_and_verify"]}]]],"explain/setup/azure_database":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/azure_database/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/azure_database/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/azure_database/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and Verify"],"href":[0,"explain/setup/azure_database/04_test_and_verify"]}]]],"explain/setup/crunchy_bridge":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/crunchy_bridge/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/crunchy_bridge/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/crunchy_bridge/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and Verify"],"href":[0,"explain/setup/crunchy_bridge/04_test_and_verify"]}]]],"explain/setup/google_cloud_sql":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/google_cloud_sql/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/google_cloud_sql/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/google_cloud_sql/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and Verify"],"href":[0,"explain/setup/google_cloud_sql/04_test_and_verify"]}]]],"explain/setup/heroku":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/heroku/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/heroku/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/heroku/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and verify"],"href":[0,"explain/setup/heroku/04_test_and_verify"]}]]],"explain/setup/log_explain/":[1,[[0,{"name":[0,"Step 1: Create helper functions"],"href":[0,"explain/setup/log_explain/01_create_helper_functions"]}],[0,{"name":[0,"Step 2: Enable log-based EXPLAIN"],"href":[0,"explain/setup/log_explain/02_enable_log_explain"]}],[0,{"name":[0,"Step 3: Test and verify"],"href":[0,"explain/setup/log_explain/03_test_and_verify"]}]]],"explain/setup/self_managed":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/self_managed/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/self_managed/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/self_managed/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and Verify"],"href":[0,"explain/setup/self_managed/04_test_and_verify"]}]]],"explain/setup/supabase":[1,[[0,{"name":[0,"Step 1: Check for auto_explain"],"href":[0,"explain/setup/s
16upabase/01_auto_explain_check"]}],[0,{"name":[0,"Step 2: Enable auto_explain"],"href":[0,"explain/setup/supabase/02_enable_auto_explain"]}],[0,{"name":[0,"Step 3: Review auto_explain settings"],"href":[0,"explain/setup/supabase/03_review_settings"]}],[0,{"name":[0,"Step 4: Test and Verify"],"href":[0,"explain/setup/supabase/04_test_and_verify"]}]]],"index-advisor":[1,[[0,{"name":[0,"Getting Started"],"href":[0,"index-advisor/getting-started"]}],[0,{"name":[0,"How to Reason About Missing Index Insights"],"href":[0,"index-advisor/reason-about-insights"]}],[0,{"name":[0,"Experimenting With Different Configurations"],"href":[0,"index-advisor/configuration"]}],[0,{"name":[0,"How to Test Missing Index Insights"],"href":[0,"index-advisor/test-insights"]}],[0,{"name":[0,"Track Index Insights With Alerts"],"href":[0,"index-advisor/checks-and-alerts"]}],[0,{"name":[0,"Consolidation Insights"],"href":[0,"index-advisor/consolidation"]}]]],"indexing-engine":[1,[[0,{"name":[0,"Overview"],"href":[0,"indexing-engine"]}],[0,{"name":[0,"Phase 1: Query Analysis"],"href":[0,"indexing-engine-phase-1"]}],[0,{"name":[0,"Phase 2: Scan Cost Estimation through Hypothetical Indexes"],"href":[0,"indexing-engine-phase-2"]}],[0,{"name":[0,"Phase 3: Index Selection using the Constraint Programming Model"],"href":[0,"indexing-engine/cp-model"]}],[0,{"name":[0,"Index Write Overhead"],"href":[0,"indexing-engine/index-write-overhead"]}],[0,{"name":[0,"Limitations"],"href":[0,"indexing-engine/limitations"]}]]],"indexing-engine-phase-1":[1,[[0,{"name":[0,"Query To Scan Breakdown"],"href":[0,"indexing-engine/query-to-scan-breakdown"]}]]],"indexing-engine-phase-2":[1,[[0,{"name":[0,"Extracting Index Element Candidates"],"href":[0,"indexing-engine/index-element-extraction"]}],[0,{"name":[0,"Multi-Column Index Combinations"],"href":[0,"
16indexing-engine/multi-column-indexes"]}],[0,{"name":[0,"What If? Analysis"],"href":[0,"indexing-engine/what-if-analysis"]}]]],"indexing-engine/cp-model":[1,[[0,{"name":[0,"How The Model Works"],"href":[0,"indexing-engine/cp-model"]}],[0,{"name":[0,"Built-in Configurations"],"href":[0,"indexing-engine/cp-model/built-in-configs"]}],[0,{"name":[0,"Custom Configuration"],"href":[0,"indexing-engine/cp-model/settings"]}],[0,{"name":[0,"Custom Configuration - Goals"],"href":[0,"indexing-engine/cp-model/goals"]}],[0,{"name":[0,"Custom Configuration - Rules"],"href":[0,"indexing-engine/cp-model/rules"]}]]],"install":[1,[[0,{"name":[0,"Overview"],"href":[0,"install"]}],[0,{"name":[0,"Initial Setup"],"href":[0,"install/"]}],[0,{"name":[0,"Log Insights Setup"],"href":[0,"log-insights/setup"]}],[0,{"name":[0,"Automated EXPLAIN Setup"],"href":[0,"explain/setup"]}],[0,{"name":[0,"Troubleshooting"],"href":[0,"install/troubleshooting"]}]]],"install/":[1,[[0,{"name":[0,"Amazon RDS and Amazon Aurora"],"href":[0,"install/amazon_rds"]}],[0,{"name":[0,"Azure Database for PostgreSQL"],"href":[0,"install/azure_database"]}],[0,{"name":[0,"Google Cloud SQL and AlloyDB"],"href":[0,"install/google_cloud_sql"]}],[0,{"name":[0,"Crunchy Bridge"],"href":[0,"install/crunchy_bridge"]}],[0,{"name":[0,"Heroku Postgres"],"href":[0,"install/heroku_postgres"]}],[0,{"name":[0,"Aiven"],"href":[0,"install/aiven"]}],[0,{"name":[0,"Supabase"],"href":[0,"install/supabase"]}],[0,{"name":[0,"Neon"],"href":[0,"install/neon"]}],[0,{"name":[0,"Self-managed (and other hosted Postgres)"],"href":[0,"install/self_managed"]}]]],"install/aiven":[1,[[0,{"name":[0,"Step 1: Create Monitoring User"],"href":[0,"install/aiven/01_create_monitoring_user"]}],[0,{"name":[0,"Step 2: Enable pg_stat_statements"],"href":[0,"install/aiven/02_enable_pg_stat_statements"]}],[0,{"name":[0,"Step 3: Create pg_stat_statements Helpers"],"href":[0,"install/aiven/03_create_pg_stat_statements_helpers"]}],[0,{"name":[0,"Step 4: Install the Collector"],"href":[0,"install/aiven/04_install_the_collector"]}],[0,{"name":[0,"Step 5: Configure the Collector"],"href":[0,"install/aiven/05_configure_the_collector"]}]]],"install/aiven/04_install_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/aiven/04_install_the_collector"]}],[0,{"name":[0,"Step 4: Install the Collector (Package)"],"href":[0,"install/aiven/04_install_the_collector_package"]}],[0,{"name":[0,"Step 4: Install the Collector (Docker)"],"href":[0,"install/aiven/04_install_the_collector_docker"]}]]],"install/aiven/05_configure_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/aiven/05_configure_the_collector"]}],[0,{"name":[0,"Step 5: Configure the Collector (Package)"],"href":[0,"install/aiven/05_configure_the_collector_package"]}],[0,{"name":[0,"Step 5: Configure the Collector (Docker)"],"href":[0,"install/aiven/05_configure_the_collector_docker"]}]]],"install/amazon_rds":[1,[[0,{"name":[0,"Step 0: Overview"],"href":[0,"install/amazon_rds/00_overview"]}],[0,{"name":[0,"Step 1: Configure RDS Instance"],"href":[0,"install/amazon_rds/01_configure_rds_instance"]}],[0,{"name":[0,"Step 2: Create Monitoring User"],"href":[0,"install/amazon_rds/02_create_monitoring_user"]}],[0,{"name":[0,"Step 3: Install the Collector"],"href":[0,"install/amazon_rds/03_install_collector"]}],[0,{"name":[0,"Step 4: Configure the Collector"],"href":[0,"install/amazon_rds/04_configure_the_collector"]}]]],"install/amazon_rds/03_install_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/amazon_rds/03_install_collector"]}],[0,{"name":[0,"Amazon EC2"],"href":[0,"install/amazon_rds/03_install_collector_ec2"]}],[0,{"name":[0,"Amazon ECS"],"href":[0,"install/amazon_rds/03_install_collector_ecs"]}],[0,{"name":[0,"Amazon EKS"],"href":[0,"install/amazon_rds/03_install_collector_eks"]}],[0,{"name":[0,"Docker"],"href":[0,"install/amazon_rds/03_install_collector_docker"]}]]],"install/amazon_rds/04_configure_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/amazon_rds/04_configure_the_collector"]}],[0,{"name":[0,"Amazon EC2"],"href":[0,"install/amazon_rds/04_configure_the_collector_ec2"]}],[0,{"name":[0,"Amazon ECS"],"href":[0,"install/amazon_rds/04_configure_the_collector_ecs"]}],[0,{"name":[0,"Amazon EKS"],"href":[0,"install/amazon_rds/04_configure_the_collector_eks"]}],[0,{"name":[0,"Docker"],"href":[0,"install/amazon_rds/04_configure_the_collector_docker"]}]]],"install/azure_database":[1,[[0,{"name":[0,"Step 1: Configure Azure Instance"],"href":[0,"install/azure_database/01_configure_azure_instance"]}],[0,{"name":[0,"Step 2: Create Monitoring User"],"href":[0,"install/azure_database/02_create_monitoring_user"]}],[0,{"name":[0,"Step 3: Install the Collector"],"href":[0,"install/azure_database/03_install_the_collector"]}],[0,{"name":[0,"Step 4: Configure the Collector"],"href":[0,"
16install/azure_database/04_configure_the_collector"]}]]],"install/azure_database/03_install_the_collector":[1,[[0,{"name":[0,"Choose platform"],"href":[0,"install/azure_database/03_install_the_collector"]}],[0,{"name":[0,"Ubuntu & Debian"],"href":[0,"install/azure_database/03_install_the_collector_deb"]}],[0,{"name":[0,"RHEL, CentOS & Fedora"],"href":[0,"install/azure_database/03_install_the_collector_yum"]}],[0,{"name":[0,"Docker"],"href":[0,"install/azure_database/03_install_the_collector_docker"]}]]],"install/azure_database/04_configure_the_collector":[1,[[0,{"name":[0,"Choose platform"],"href":[0,"install/azure_database/04_configure_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/azure_database/04_configure_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/azure_database/04_configure_the_collector_docker"]}]]],"install/crunchy_bridge":[1,[[0,{"name":[0,"Step 1: Deploy The Collector"],"href":[0,"install/crunchy_bridge/01_deploy_the_collector"]}]]],"install/google_cloud_sql":[1,[[0,{"name":[0,"Step 1: Create Monitoring User"],"href":[0,"install/google_cloud_sql/01_create_monitoring_user"]}],[0,{"name":[0,"Step 2: Install the Collector"],"href":[0,"install/google_cloud_sql/02_install_the_collector"]}],[0,{"name":[0,"Step 3: Configure the Collector"],"href":[0,"install/google_cloud_sql/03_configure_the_collector"]}]]],"install/google_cloud_sql/02_install_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/google_cloud_sql/02_install_the_collector"]}],[0,{"name":[0,"Ubuntu & Debian"],"href":[0,"install/google_cloud_sql/02_install_the_collector_deb"]}],[0,{"name":[0,"RHEL, CentOS & Fedora"],"href":[0,"install/google_cloud_sql/02_install_the_collector_yum"]}],[0,{"name":[0,"Docker"],"href":[0,"install/google_cloud_sql/02_install_the_collector_docker"]}]]],"install/google_cloud_sql/03_configure_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/google_cloud_sql/03_configure_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/google_cloud_sql/03_configure_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/google_cloud_sql/03_configure_the_collector_docker"]}]]],"install/heroku_postgres":[1,[[0,{"name":[0,"Step 1: Deploy the Collector"],"href":[0,"install/heroku_postgres/01_deploy_the_collector"]}],[0,{"name":[0,"Step 2: Create Credential and Attach Databases"],"href":[0,"install/heroku_postgres/02_attach_databases"]}],[0,{"name":[0,"Step 3: Verify Configuration"],"href":[0,"install/heroku_postgres/03_verify_configuration"]}]]],"install/neon":[1,[[0,{"name":[0,"Step 1: Enable pg_stat_statements"],"href":[0,"install/neon/01_enable_pg_stat_statements"]}],[0,{"name":[0,"Step 2: Create Monitoring User"],"href":[0,"install/neon/02_create_monitoring_user"]}],[0,{"name":[0,"Step 3: Install the Collector"],"href":[0,"install/neon/03_install_the_collector"]}],[0,{"name":[0,"Step 4: Configure the Collector"],"href":[0,"install/neon/04_configure_the_collector"]}]]],"install/neon/03_install_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/neon/03_install_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/neon/03_install_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/neon/03_install_the_collector_docker"]}]]],"install/neon/04_configure_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/neon/04_configure_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/neon/04_configure_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/neon/04_configure_the_collector_docker"]}]]],"install/self_managed":[1,[[0,{"name":[0,"Choose Setup Method"],"href":[0,"install/self_managed/00_choose_setup_method"]}],[0,{"name":[0,"Guided Setup"],"href":[0,"install/self_managed/01_guided_setup"]}],[0,{"name":[0,"Manual Setup"],"href":[0,"install/self_managed/"]}]]],"install/self_managed/":[1,[[0,{"name":[0,"Step 1: Create Monitoring User"],"href":[0,"install/self_managed/01_create_monitoring_user"]}],[0,{"name":[0,"Step 2: Enable pg_stat_statements"],"href":[0,"install/self_managed/02_enable_pg_stat_statements"]}],[0,{"name":[0,"Step 3: Install the collector"],"href":[0,"install/self_managed/03_install_the_collector"]}],[0,{"name":[0,"Step 4: Configure the collector"],"href":[0,"install/self_managed/04_configure_the_collector"]}]]],"install/self_managed/02_enable_pg_stat_statements":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/self_managed/02_enable_pg_stat_statements"]}],[0,{"name":[0,"Ubuntu & Debian"],"href":[0,"install/self_managed/02_enable_pg_stat_statements_deb"]}],[0,{"name":[0,"RHEL, CentOS & Fedora"],"href":[0,"install/self_managed/02_enable_pg_stat_statements_yum"]}],[0,{"name":[0,"Docker"],"href":[0,"install/self_managed/02_enable_pg_stat_statements_docker"]}]]],"install/self_managed/03_install_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/self_managed/03_install_the_collector"]}],[0,{"name":[0,"Ubuntu & Debian"],"href":[0,"install/self_managed/03_install_the_collector_deb"]}],[0,{"name":[0,"RHEL, CentOS & Fedora"],"href":[0,"install/self_managed/03_install_the_collector_yum"]}],[0,{"name":[0,"Docker"],"href":[0,"install/self_managed/03_install_the_collector_docker"]}]]],"install/self_managed/04_configure_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/self_managed/04_configure_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/self_managed/04_configure_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/self_managed/04_configure_the_collector_docker"]}]]],"install/supabase":[1,[[0,{"name":[0,"Step 1: Enable pg_stat_statements"],"href":[0,"install/supabase/01_enable_pg_stat_statements"]}],[0,{"name":[0,"Step 2: Create Monitoring User"],"href":[0,"install/supabase/02_create_monitoring_user"]}],[0,{"name":[0,"Step 3: Install the Collector"],"href":[0,"install/supabase/03_install_the_collector"]}],[0,{"name":[0,"Step 4: Configure the Collector"],"href":[0,"
16install/supabase/04_configure_the_collector"]}]]],"install/supabase/03_install_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/supabase/03_install_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/supabase/03_install_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/supabase/03_install_the_collector_docker"]}]]],"install/supabase/04_configure_the_collector":[1,[[0,{"name":[0,"Choose deployment"],"href":[0,"install/supabase/04_configure_the_collector"]}],[0,{"name":[0,"Package-based"],"href":[0,"install/supabase/04_configure_the_collector_package"]}],[0,{"name":[0,"Docker"],"href":[0,"install/supabase/04_configure_the_collector_docker"]}]]],"install/troubleshooting":[1,[[0,{"name":[0,"Collector crashes"],"href":[0,"install/troubleshooting/collector_crash"]}],[0,{"name":[0,"Query text unavailable and reducing memory usage"],"href":[0,"install/troubleshooting/reset_stat_statements"]}],[0,{"name":[0,"Resolving the \"Limited access to table column statistics\" warning"],"href":[0,"install/troubleshooting/column_stats_helper"]}],[0,{"name":[0,"Resolving the \"missing extended stats monitoring helper functions\" warning"],"href":[0,"install/troubleshooting/ext_stats_helper"]}],[0,{"name":[0,"Resolving the 'permission denied to create extension \"pg_stat_statements\"' error"],"href":[0,"install/troubleshooting/pg_stat_statements"]}],[0,{"name":[0,"Amazon RDS: Resolving the \"pg_stat_statements must be loaded via shared_preload_libraries\" error"],"href":[0,"install/troubleshooting/rds_pg_stat_statements_shared_preload_libraries"]}],[0,{"name":[0,"Adding the pg_read_file helper"],"href":[0,"install/troubleshooting/pg_read_file_helper"]}]]],"log-insights":[1,[[0,{"name":[0,"Overview"],"href":[0,"log-insights"]}],[0,{"name":[0,"Tuning Log Config Settings"],"href":[0,"log-insights/setup/tuning-log-config-settings"]}],[0,{"name":[0,"Limits"],"href":[0,"log-insights/limits"]}],[0,{"name":[0,"Classifications"],"href":[0,"log-insights/classifications"]}]]],"log-insights/classifications":[1,[[0,{"name":[0,"Server"],"href":[0,"log-insights/server"]}],[0,{"name":[0,"Connections"],"href":[0,"log-insights/connections"]}],[0,{"name":[0,"WAL & Checkpoints"],"href":[0,"log-insights/wal-checkpoints"]}],[0,{"name":[0,"Maintenance"],"href":[0,"log-insights/maintenance"]}],[0,{"name":[0,"Locks"],"href":[0,"log-insights/locks"]}],[0,{"name":[0,"Statements"],"href":[0,"log-insights/statements"]}],[0,{"name":[0,"Standby Servers"],"href":[0,"log-insights/standby"]}],[0,{"name":[0,"Constraint Violations"],"href":[0,"log-insights/constraint-violations"]}],[0,{"name":[0,"Application Errors"],"href":[0,"log-insights/app-errors"]}]]],"log-insights/setup":[1,[[0,{"name":[0,"Overview"],"href":[0,"log-insights/setup"]}],[0,{"name":[0,"Amazon RDS and Amazon Aurora"],"href":[0,"log-insights/setup/amazon-rds"]}],[0,{"name":[0,"Azure Database for PostgreSQL"],"href":[0,"log-insights/setup/azure-database"]}],[0,{"name":[0,"Google Cloud SQL and AlloyDB"],"href":[0,"log-insights/setup/google-cloud-sql"]}],[0,{"name":[0,"Heroku Postgres"],"href":[0,"log-insights/setup/heroku-postgres"]}],[0,{"name":[0,"Crunchy Bridge"],"href":[0,"log-insights/setup/crunchy-bridge"]}],[0,{"name":[0,"Aiven"],"href":[0,"log-insights/setup/aiven"]}],[0,{"name":[0,"Supabase"],"href":[0,"log-insights/setup/supabase"]}],[0,{"name":[0,"Neon"],"href":[0,"log-insights/setup/neon"]}],[0,{"name":[0,"Self-Managed Server"],"href":[0,"log-insights/setup/self-managed"]}],[0,{"name":[0,"Receive logs using Syslog"],"href":[0,"log-insights/setup/syslog-server"]}],[0,{"name":[0,"Receive logs using OpenTelemetry"],"href":[0,"log-insights/setup/opentelemetry"]}],[0,{"name":[0,"Troubleshooting"],"href":[0,"log-insights/setup/troubleshooting"]}]]],"log-insights/setup/troubleshooting":[1,[[0,{"name":[0,"Azure Database for PostgreSQL"],"href":[0,"log-insights/setup/azure-database/troubleshooting"]}],[0,{"name":[0,"Google Cloud SQL and AlloyDB"],"href":[0,"log-insights/setup/google-cloud-sql/troubleshooting"]}],[0,{"name":[0,"Self-Managed Server"],"href":[0,"log-insights/setup/self-managed/troubleshooting"]}]]],"log-insights/setup/aiven":[1,[[0,{"name":[0,"Step 1: Move Database into VPC"],"href":[0,"log-insights/setup/aiven/01_move_database_into_vpc"]}],[0,{"name":[0,"Step 2: Configure VPC Peering"],"href":[0,"log-insights/setup/aiven/02_configure_vpc_peering"]}],[0,{"name":[0,"Step 3: Configure the Collector"],"href":[0,"log-insights/setup/aiven/03_configure_collector"]}],[0,{"name":[0,"Step 4: Configure Service Integration"],"href":[0,"log-insights/setup/aiven/04_configure_service_integration"]}]]],"log-insights/setup/amazon-rds":[1,[[0,{"name":[0,"Step 1: Test Log Download"],"href":[0,"log-insights/setup/amazon-rds/01_test_log_download"]}]]],"log-insights/setup/azure-database":[1,[[0,{"name":[0,"Step 1: Set up Managed Identity"],"href":[0,"log-insights/setup/azure-database/01_set_up_managed_identity"]}],[0,{"name":[0,"Step 2: Set up Azure Event Hub"],"href":[0,"log-insights/setup/azure-database/02_set_up_azure_event_hub"]}],[0,{"name":[0,"Step 3: Stream Postgres Logs into Azure Event Hub"],"href":[0,"log-insights/setup/azure-database/03_stream_logs_into_event_hub"]}],[0,{"name":[0,"Step 4: Adjust Postgres log_line_prefix"],"href":[0,"
16log-insights/setup/azure-database/04_adjust_log_line_prefix"]}],[0,{"name":[0,"Step 5: Configure Collector"],"href":[0,"log-insights/setup/azure-database/05_configure_collector"]}]]],"log-insights/setup/crunchy-bridge":[1,[[0,{"name":[0,"Step 1: Create helper function and test"],"href":[0,"log-insights/setup/crunchy-bridge/01_create_helper_function_and_test"]}]]],"log-insights/setup/google-cloud-sql":[1,[[0,{"name":[0,"Step 1: Create Topic and Subscriber"],"href":[0,"log-insights/setup/google-cloud-sql/01_create_topic_and_subscriber"]}],[0,{"name":[0,"Step 2: Configure Log Routing"],"href":[0,"log-insights/setup/google-cloud-sql/02_configure_log_routing"]}],[0,{"name":[0,"Step 3: Set Up Service Account"],"href":[0,"log-insights/setup/google-cloud-sql/03_set_up_service_account"]}],[0,{"name":[0,"Step 4: Configure Collector"],"href":[0,"log-insights/setup/google-cloud-sql/04_configure_collector"]}]]],"log-insights/setup/heroku-postgres":[1,[[0,{"name":[0,"Step 1: Add Log Drain"],"href":[0,"log-insights/setup/heroku-postgres/01_add_log_drain"]}],[0,{"name":[0,"Step 2: Verify Log Drain"],"href":[0,"log-insights/setup/heroku-postgres/02_verify_log_drain"]}],[0,{"name":[0,"Step 3: Restart Collector"],"href":[0,"log-insights/setup/heroku-postgres/03_restart_collector"]}]]],"log-insights/setup/neon":[1,[[0,{"name":[0,"Step 1: Set up OpenTelemetry Logs"],"href":[0,"log-insights/setup/neon/01_set_up_opentelemetry_logs"]}]]],"log-insights/setup/opentelemetry":[1,[[0,{"name":[0,"Overview"],"href":[0,"log-insights/setup/opentelemetry"]}],[0,{"name":[0,"Fluent Bit"],"href":[0,"log-insights/setup/opentelemetry/fluentbit"]}],[0,{"name":[0,"Vector"],"href":[0,"log-insights/setup/opentelemetry/vector"]}]]],"log-insights/setup/self-managed":[1,[[0,{"name":[0,"Step 1: Determine Log Location"],"href":[0,"log-insights/setup/self-managed/01_determine_log_location"]}],[0,{"name":[0,"Step 2: Configure Collector"],"href":[0,"log-insights/setup/self-managed/02_configure_collector"]}]]],"log-insights/setup/supabase":[1,[[0,{"name":[0,"Step 1: Set up Log Drain"],"href":[0,"log-insights/setup/supabase/01_set_up_log_drain"]}]]],"opentelemetry":[1,[[0,{"name":[0,"Overview"],"href":[0,"opentelemetry"]}],[0,{"name":[0,"Set up traceparent query tag"],"href":[0,"opentelemetry/traceparent"]}],[0,{"name":[0,"Integrating with Honeycomb"],"href":[0,"opentelemetry/honeycomb"]}],[0,{"name":[0,"Integrating with Datadog APM"],"href":[0,"opentelemetry/datadog"]}],[0,{"name":[0,"Integrating with New Relic"],"href":[0,"opentelemetry/newrelic"]}]]],"query-advisor":[1,[[0,{"name":[0,"Getting Started"],"href":[0,"query-advisor/getting-started"]}],[0,{"name":[0,"From Insight to Conclusion"],"href":[0,"query-advisor/from-insight-to-conclusion"]}],[0,{"name":[0,"Insights"],"href":[0,"query-advisor/insights"]}],[0,{"name":[0,"Alerts for New Insights"],"href":[0,"query-advisor/alerts"]}]]],"query-advisor/":[1,[[0,{"name":[0,"Overview"],"href":[0,"insights"]}],[0,{"name":[0,"Inefficient Nested Loops"],"href":[0,"insights/inefficient-nested-loops"]}],[0,{"name":[0,"ORDER BY + LIMIT Problems"],"href":[0,"insights/order-by-limit"]}]]],"query-advisor/insights":[1,[[0,{"name":[0,"Overview"],"href":[0,"query-advisor/insights"]}],[0,{"name":[0,"Inefficient Nested Loops"],"href":[0,"query-advisor/insights/inefficient-nested-loops"]}],[0,{"name":[0,"Wrong Index Due To ORDER BY"],"href":[0,"query-advisor/insights/wrong-index-order-by"]}],[0,{"name":[0,"Inefficient Index Use"],"href":[0,"query-advisor/insights/inefficient-index-use"]}],[0,{"name":[0,"Late Join Filter with OR"],"href":[0,"query-advisor/insights/late-join-filter-with-or"]}],[0,{"name":[0,"Disk Spill Due To Low work_mem"],"href":[0,"query-advisor/insights/disk-spill-work-mem"]}]]],"query-performance":[1,[[0,{"name":[0,"Overview"],"href":[0,"query-performance"]}],[0,{"name":[0,"Query Tags"],"href":[0,"query-performance/query-tags"]}]]],"schema-statistics":[1,[[0,{"name":[0,"Overview"],"href":[0,"schema-statistics"]}],[0,{"name":[0,"Column Statistics / HOT Updates"],"href":[0,"schema-statistics/columns-hot-updates"]}],[0,{"name":[0,"Buffer Cache Statistics"],"href":[0,"schema-statistics/buffer-cache"]}]]],"vacuum-advisor":[1,[[0,{"name":[0,"Overview"],"href":[0,"vacuum-advisor"]}],[0,{"name":[0,"Getting Started"],"href":[0,"vacuum-advisor/getting-started"]}],[0,{"name":[0,"Bloat"],"href":[0,"vacuum-advisor/bloat"]}],[0,{"name":[0,"Freezing"],"href":[0,"vacuum-advisor/freezing"]}],[0,{"name":[0,"Performance"],"href":[0,"vacuum-advisor/performance"]}],[0,{"name":[0,"Activity"],"href":[0,"vacuum-advisor/activity"]}],[0,{"name":[0,"Per Table Activity"],"href":[0,"vacuum-advisor/per-table-activity"]}],[0,{"name":[0,"VACUUM Simulator"],"href":[0,"vacuum-advisor/vacuum-simulator"]}]]],"vacuum-advisor/bloat":[1,[[0,{"name":[0,"Bloat in VACUUM Advisor"],"href":[0,"vacuum-advisor/bloat"]}],[0,{"name":[0,"What is Bloat?"],"href":[0,"vacuum-advisor/what-is-bloat"]}]]],"vacuum-advisor/freezing":[1,[[0,{"name":[0,"Freezing in VACUUM Advisor"],"href":[0,"vacuum-advisor/freezing"]}],[0,{"name":[0,"What is Freezing?"],"href":[0,"vacuum-advisor/what-is-freezing"]}]]],"vacuum-advisor/performance":[1,[[0,{"name":[0,"Performance in VACUUM Advisor"],"href":[0,"vacuum-advisor/performance"]}],[0,{"name":[0,"How does the VACUUM cost model work?"],"href":[0,"vacuum-advisor/how-does-the-vacuum-cost-model-work"]}]]],"workbooks":[1,[[0,{"name":[0,"Overview"],"href":[0,"workbooks"]}],[0,{"name":[0,"How to Optimize Slow Queries with Workbooks"],"href":[0,"workbooks/how-to-use-workbooks"]}],[0,{"name":[0,"Query Optimization Examples"],"href":[0,"workbooks/query-optimization-examples"]}],[0,{"name":[0,"Optimizing Queries with Planner Settings and Planner Hints"],"href":[0,"workbooks/planner-settings-and-hints"]}],[0,{"name":[0,"Setting up the Collector Workflow"],"href":[0,"workbooks/collector-workflow"]}],[0,{"name":[0,"Security & Privacy Considerations"],"href":[0,"workbooks/security-privacy"]}],[0,{"name":[0,"Enabling pg_hint_plan"],"href":[0,"workbooks/enabling_pg_hint_plan"]}]]],"log-insights/app-errors":[1,[[0,{"name":[0,"U110: Syntax error"],"href":[0,"log-insights/app-errors/U110"]}],[0,{"name":[0,"U111: Invalid input syntax"],"href":[0,"log-insights/app-errors/U111"]}],[0,{"name":[0,"U112: Value too long for type"],"href":[0,"log-insights/app-errors/U112"]}],[0,{"name":[0,"U113: Invalid value"],"href":[0,"log-insights/app-errors/U113"]}],[0,{"name":[0,"U114: Malformed array literal"],"href":[0,"log-insights/app-errors/U114"]}],[0,{"name":[0,"U115: Subquery in FROM must have alias"],"href":[0,"log-insights/app-errors/U115"]}],[0,{"name":[0,"U116: INSERT does not match target columns"],"href":[0,"log-insights/app-errors/U116"]}],[0,{"name":[0,"U117: Op ANY/ALL (array) requires array"],"href":[0,"log-insights/app-errors/U117"]}],[0,{"name":[0,"U118: Column must appear in the GROUP BY clause"],"href":[0,"log-insights/app-errors/U118"]}],[0,{"name":[0,"U119: Relation does not exist"],"href":[0,"log-insights/app-errors/U119"]}],[0,{"name":[0,"U120: Column does not exist"],"href":[0,"log-insights/app-errors/U120"]}],[0,{"name":[0,"U121: Operator does not exist"],"href":[0,"log-insights/app-errors/U121"]}],[0,{"name":[0,"U122: Column reference is ambiguous"],"href":[0,"log-insights/app-errors/U122"]}],[0,{"name":[0,"U123: Permission denied"],"href":[0,"log-insights/app-errors/U123"]}],[0,{"name":[0,"U124: Current transaction is aborted"],"href":[0,"log-insights/app-errors/U124"]}],[0,{"name":[0,"U125: Unmatched ON CONFLICT specification"],"href":[0,"log-insights/app-errors/U125"]}],[0,{"name":[0,"U126: ON CONFLICT DO UPDATE affected row twice"],"href":[0,"log-insights/app-errors/U126"]}],[0,{"name":[0,"U127: Column cannot be cast to type"],"href":[0,"log-insights/app-errors/U127"]}],[0,{"name":[0,"U128: Division by zero"],"href":[0,"log-insights/app-errors/U128"]}],[0,{"name":[0,"U129: Cannot drop object"],"href":[0,"log-insights/app-errors/U129"]}],[0,{"name":[0,"U130: Integer out of range"],"href":[0,"log-insights/app-errors/U130"]}],[0,{"name":[0,"U131: Invalid regular expression"],"href":[0,"log-insights/app-errors/U131"]}],[0,{"name":[0,"U132: There is no parameter $n"],"href":[0,"log-insights/app-errors/U132"]}],[0,{"name":[0,"U133: Function does not exist"],"href":[0,"log-insights/app-errors/U133"]}],[0,{"name":[0,"U134: No such savepoint"],"href":[0,"log-insights/app-errors/U134"]}],[0,{"name":[0,"U135: Unterminated quoted string"],"href":[0,"log-insights/app-errors/U135"]}],[0,{"name":[0,"U136: Unterminated quoted identifier"],"href":[0,"log-insights/app-errors/U136"]}],[0,{"name":[0,"U137: Invalid byte sequence for encoding"],"href":[0,"log-insights/app-errors/U137"]}],[0,{"name":[0,"U138: Could not serialize access: concurrent update"],"href":[0,"log-insights/app-errors/U138"]}],[0,{"name":[0,"U139: Could not serialize access: read/write dependencies"],"href":[0,"log-insights/app-errors/U139"]}],[0,{"name":[0,"U140: Inconsistent range bounds"],"href":[0,"log-insights/app-errors/U140"]}],[0,{"name":[0,"U141: Value out of range"],"href":[0,"log-insights/app-errors/U141"]}],[0,{"name":[0,"U142: Object does not exist"],"href":[0,"log-insights/app-errors/U142"]}],[0,{"name":[0,"U143: Row-level security violation"],"href":[0,"log-insights/app-errors/U143"]}],[0,{"name":[0,"U144: View check option violation"],"href":[0,"log-insights/app-errors/U144"]}],[0,{"name":[0,"U145: Cannot modify view"],"href":[0,"log-insights/app-errors/U145"]}],[0,{"name":[0,"U146: SQL/JSON error"],"href":[0,"log-insights/app-errors/U146"]}],[0,{"name":[0,"U147: Partitioning error"],"href":[0,"log-insights/app-errors/U147"]}],[0,{"name":[0,"U148: Object already exists"],"href":[0,"log-insights/app-errors/U148"]}],[0,{"name":[0,"U149: Wrong object type"],"href":[0,"log-insights/app-errors/U149"]}]]],"log-insights/connections":[1,[[0,{"name":[0,"C20: Connection received"],"href":[0,"log-insights/connections/C20"]}],[0,{"name":[0,"C21: Connection authorized"],"href":[0,"log-insights/connections/C21"]}],[0,{"name":[0,"C22: Authentication failed"],"href":[0,"log-insights/connections/C22"]}],[0,{"name":[0,"C23: Disconnection"],"href":[0,"log-insights/connections/C23"]}],[0,{"name":[0,"C24: Client failed to connect"],"href":[0,"log-insights/connections/C24"]}],[0,{"name":[0,"C25: Connection to client lost"],"href":[0,"log-insights/connections/C25"]}],[0,{"name":[0,"C26: Connection with open transaction lost"],"href":[0,"log-insights/connections/C26"]}],[0,{"name":[0,"C27: Terminating connection"],"href":[0,"log-insights/connections/C27"]}],[0,{"name":[0,"C28: Too many connections"],"href":[0,"log-insights/connections/C28"]}],[0,{"name":[0,"C29: Too many connections for role"],"href":[0,"log-insights/connections/C29"]}],[0,{"name":[0,"C30: Could not accept SSL connection"],"href":[0,"log-insights/connections/C30"]}],[0,{"name":[0,"C31: Unsupported frontend protocol"],"href":[0,"log-insights/connections/C31"]}],[0,{"name":[0,"C32: Incomplete message from client"],"href":[0,"log-insights/connections/C32"]}],[0,{"name":[0,"C33: Too many connections for database"],"href":[0,"log-insights/connections/C33"]}]]],"log-insights/constraint-violations":[1,[[0,{"name":[0,"V100: Unique constraint violation"],"href":[0,"log-insights/constraint-violations/V100"]}],[0,{"name":[0,"V101: Foreign key constraint violation"],"href":[0,"log-insights/constraint-violations/V101"]}],[0,{"name":[0,"V102: Not-NULL constraint violation"],"href":[0,"log-insights
16/constraint-violations/V102"]}],[0,{"name":[0,"V103: Check constraint violation"],"href":[0,"log-insights/constraint-violations/V103"]}],[0,{"name":[0,"V104: Exclusion constraint violation"],"href":[0,"log-insights/constraint-violations/V104"]}]]],"log-insights/locks":[1,[[0,{"name":[0,"L70: Process acquired lock"],"href":[0,"log-insights/locks/L70"]}],[0,{"name":[0,"L71: Process still waiting for lock"],"href":[0,"log-insights/locks/L71"]}],[0,{"name":[0,"L72: Canceling statement due to lock timeout"],"href":[0,"log-insights/locks/L72"]}],[0,{"name":[0,"L73: Deadlock detected"],"href":[0,"log-insights/locks/L73"]}],[0,{"name":[0,"L74: Process avoided deadlock"],"href":[0,"log-insights/locks/L74"]}]]],"log-insights/maintenance":[1,[[0,{"name":[0,"A60: Canceling autovacuum task"],"href":[0,"log-insights/maintenance/A60"]}],[0,{"name":[0,"A61: TXID wraparound warning"],"href":[0,"log-insights/maintenance/A61"]}],[0,{"name":[0,"A62: TXID wraparound critical"],"href":[0,"log-insights/maintenance/A62"]}],[0,{"name":[0,"A63: Autovacuum launcher started"],"href":[0,"log-insights/maintenance/A63"]}],[0,{"name":[0,"A64: Autovacuum launcher stopped"],"href":[0,"log-insights/maintenance/A64"]}],[0,{"name":[0,"A65: Autovacuum completed"],"href":[0,"log-insights/maintenance/A65"]}],[0,{"name":[0,"A66: Autoanalyze completed"],"href":[0,"log-insights/maintenance/A66"]}],[0,{"name":[0,"A67: Skipping vacuum due to lock"],"href":[0,"log-insights/maintenance/A67"]}],[0,{"name":[0,"A68: Skipping analyze due to lock"],"href":[0,"log-insights/maintenance/A68"]}],[0,{"name":[0,"A69: Skipping maintenance due to permissions"],"href":[0,"log-insights/maintenance/A69"]}]]],"log-insights/server":[1,[[0,{"name":[0,"S1: Server process was terminated"],"href":[0,"log-insights/server/S1"]}],[0,{"name":[0,"S2: Database server starting"],"href":[0,"log-insights/server/S2"]}],[0,{"name":[0,"S3: Database system was interrupted"],"href":[0,"log-insights/server/S3"]}],[0,{"name":[0,"S4: Database system is shutting down"],"href":[0,"log-insights/server/S4"]}],[0,{"name":[0,"S5: Out of memory"],"href":[0,"log-insights/server/S5"]}],[0,{"name":[0,"S6: Data corrupted"],"href":[0,"log-insights/server/S6"]}],[0,{"name":[0,"S7: Temp file created"],"href":[0,"log-insights/server/S7"]}],[0,{"name":[0,"S8: Miscellaneous server notice"],"href":[0,"log-insights/server/S8"]}],[0,{"name":[0,"S9: Reloading configuration files"],"href":[0,"log-insights/server/S9"]}],[0,{"name":[0,"S10: Worker process exited"],"href":[0,"log-insights/server/S10"]}],[0,{"name":[0,"S11: Stats collector is not responding"],"href":[0,"log-insights/server/S11"]}]]],"log-insights/standby":[1,[[0,{"name":[0,"B90: Replayed WAL file from archive"],"href":[0,"log-insights/standby/B90"]}],[0,{"name":[0,"B91: Streaming WAL from primary"],"href":[0,"log-insights/standby/B91"]}],[0,{"name":[0,"B92: Could not receive WAL data"],"href":[0,"log-insights/standby/B92"]}],[0,{"name":[0,"B93: Terminating walreceiver"],"href":[0,"log-insights/standby/B93"]}],[0,{"name":[0,"B94: Consistent recovery state reached"],"href":[0,"log-insights/standby/B94"]}],[0,{"name":[0,"B95: Canceling statement due to recovery conflict"],"href":[0,"log-insights/standby/B95"]}]]],"log-insights/statements":[1,[[0,{"name":[0,"T80: Slow query"],"href":[0,"log-insights/statements/T80"]}],[0,{"name":[0,"T81: Canceling statement due to timeout"],"href":[0,"log-insights/statements/T81"]}],[0,{"name":[0,"T82: Canceling statement due to request"],"href":[0,"log-insights/statements/T82"]}],[0,{"name":[0,"T83: Statement notice"],"href":[0,"log-insights/statements/T83"]}],[0,{"name":[0,"T84: EXPLAIN plan for slow query"],"href":[0,"log-insights/statements/T84"]}]]],"log-insights/unknown":[1,[[0,{"name":[0,"Z00: Unknown event"],"href":[0,"log-insights/unknown/Z00"]}],[0,{"name":[0,"Z1000: pganalyze-collector identification"],"href":[0,"log-insights/unknown/Z1000"]}]]],"log-insights/wal-checkpoints":[1,[[0,{"name":[0,"W40: Checkpoint starting"],"href":[0,"log-insights/wal-checkpoints/W40"]}],[0,{"name":[0,"W41: Checkpoint complete"],"href":[0,"log-insights/wal-checkpoints/W41"]}],[0,{"name":[0,"W42: Checkpoints too frequent"],"href":[0,"log-insights/wal-checkpoints/W42"]}],[0,{"name":[0,"W43: Restartpoint starting"],"href":[0,"log-insights/wal-checkpoints/W43"]}],[0,{"name":[0,"W44: Restartpoint complete"],"href":[0,"log-insights/wal-checkpoints/W44"]}],[0,{"name":[0,"W45: Recovery restart point"],"href":[0,"log-insights/wal-checkpoints/W45"]}],[0,{"name":[0,"W46: Invalid WAL timeline"],"href":[0,"log-insights/wal-checkpoints/W46"]}],[0,{"name":[0,"W50: Invalid record length"],"href":[0,"log-insights/wal-checkpoints/W50"]}],[0,{"name":[0,"W51: Redo starts / redo done"],"href":[0,"log-insights/wal-checkpoints/W51"]}],[0,{"name":[0,"W52: Archive command failed"],"href":[0,"log-insights/wal-checkpoints/W52"]}],[0,{"name":[0,"W53: Backup complete"],"href":[0,"log-insights/wal-checkpoints/W53"]}]]]}],"hrefToAllParents":[0,{"accounts/billing":[1,[[0,"accounts"]]],"accounts/permissions":[1,[[0,"accounts"]]],"accounts/server_groups":[1,[[0,"accounts"]]],"accounts/sso":[1,[[0,"accounts"]]],"accounts/sso/okta":[1,[[0,"accounts/sso"],[0,"accounts"]]],"accounts/sso/azure":[1,[[0,"accounts/sso"],[0,"accounts"]]],"accounts/sso/saml2":[1,[[0,"accounts/sso"],[0,"accounts"]]],"api/authentication":[1,[[0,"api"]]],"api/queries":[1,[[0,"api"]]],"api/mutations":[1,[[0,"api"]]],"api/personal-access-tokens":[1,[[0,"api/authentication"],[0,"api"]]],"api/create-api-key":[1,[[0,"api/authentication"],[0,"api"]]],"api/mutations/addServer":[1,[[0,"api/mutations"],[0,"api"]]],"api/mutations/updateServer":[1,[[0,"api/mutations"],[0,"api"]]],"api/mutations/deleteServer":[1,[[0,"api/mutations"],[0,"api"]]],"api/queries/getServers":[1,[[0,"api/queries"],[0,"api"]]],"api/queries/getIssues":[1,[[0,"api/queries"],[0,"api"]]],"api/queries/getQueryStats":[1,[[0,"api/queries"],[0,"api"]]],"checks/":[1,[[0,"checks"]]],"checks/queries":[1,[[0,"checks"]]],"checks/connections":[1,[[0,"checks"]]],"checks/index_advisor":[1,[[0,"checks"]]],"checks/schema":[1,[[0,"checks"]]],"checks/settings":[1,[[0,"checks"]]],"checks/system":[1,[[0,"checks"]]],"checks/replication":[1,[[0,"checks"]]],"checks/vacuum":[1,[[0,"checks"]]],"checks/queries/slowness":[1,[[0,"checks/queries"],[0,"checks"]]],"checks/queries/advisor_insight":[1,[[0,"checks/queries"],[0,"checks"]]],"checks/connections/active_query":[1,[[0,"checks/connections"],[0,"checks"]]],"checks/connections/idle_transaction":[1,[[0,"checks/connections"],[0,"checks"]]],"checks/connections/blocking_query":[1,[[0,"checks/connections"],[0,"checks"]]],"checks/index_advisor/indexing_engine":[1,[[0,"checks/index_advisor"],[0,"checks"]]],"
16checks/schema/index_invalid":[1,[[0,"checks/schema"],[0,"checks"]]],"checks/schema/index_unused":[1,[[0,"checks/schema"],[0,"checks"]]],"checks/settings/enable_features":[1,[[0,"checks/settings"],[0,"checks"]]],"checks/settings/fsync":[1,[[0,"checks/settings"],[0,"checks"]]],"checks/settings/shared_buffers":[1,[[0,"checks/settings"],[0,"checks"]]],"checks/settings/stats":[1,[[0,"checks/settings"],[0,"checks"]]],"checks/settings/work_mem":[1,[[0,"checks/settings"],[0,"checks"]]],"checks/system/storage_space":[1,[[0,"checks/system"],[0,"checks"]]],"checks/replication/high_lag":[1,[[0,"checks/replication"],[0,"checks"]]],"checks/replication/follower_missing":[1,[[0,"checks/replication"],[0,"checks"]]],"checks/vacuum/inefficient_index_phase":[1,[[0,"checks/vacuum"],[0,"checks"]]],"checks/vacuum/insufficient_vacuum_frequency":[1,[[0,"checks/vacuum"],[0,"checks"]]],"checks/vacuum/xmin_horizon":[1,[[0,"checks/vacuum"],[0,"checks"]]],"checks/vacuum/txid_wraparound":[1,[[0,"checks/vacuum"],[0,"checks"]]],"checks/vacuum/mxid_wraparound":[1,[[0,"checks/vacuum"],[0,"checks"]]],"collector/packages":[1,[[0,"collector"]]],"collector/settings":[1,[[0,"collector"]]],"collector/server-identity":[1,[[0,"collector"]]],"collector/upgrading":[1,[[0,"collector"]]],"collector/pii-filtering":[1,[[0,"collector"]]],"collector/uninstalling":[1,[[0,"collector"]]],"enterprise/setup":[1,[[0,"enterprise"]]],"enterprise/upgrade":[1,[[0,"enterprise"]]],"enterprise/settings":[1,[[0,"enterprise"]]],"enterprise/releases":[1,[[0,"enterprise"]]],"enterprise/architecture":[1,[[0,"enterprise"]]],"enterprise/postgis":[1,[[0,"enterprise"]]],"enterprise/troubleshooting":[1,[[0,"enterprise"]]],"enterprise/releases/2026-08-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-08-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-05-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-05-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-02-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-02-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-01-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2026-01-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-6":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-5":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-4":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-3":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-2":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2025-03-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-10-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-04-5":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-04-4":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-04-3":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-04-2":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-04-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2024-04-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2023-08-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2023-07-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2023-06-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2023-03-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2023-03-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2022-08-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2022-08-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2022-05-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2022-05-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2021-12-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2021-12-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2021-06-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2021-02-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"
16enterprise/releases/2020-09-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2020-07-2":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2020-07-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2020-07-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2019-04-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2019-04-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-09-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-08-2":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-08-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-08-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-07-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-02-4":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-02-3":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-02-2":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-02-1":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2018-02-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2017-12-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2017-11-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2017-10-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/releases/2017-08-0":[1,[[0,"enterprise/releases"],[0,"enterprise"]]],"enterprise/setup/docker":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/setup/kubernetes_amazon_eks":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/setup/kubernetes_azure_aks":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/setup/kubernetes_as_non_root":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/setup/separate-collector-install":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/google-auth":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/setup/firewall-configuration":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/integrations":[1,[[0,"enterprise/setup"],[0,"enterprise"]]],"enterprise/upgrade/docker":[1,[[0,"enterprise/upgrade"],[0,"enterprise"]]],"enterprise/upgrade/kubernetes_amazon_eks":[1,[[0,"enterprise/upgrade"],[0,"enterprise"]]],"enterprise/upgrade/kubernetes_azure_aks":[1,[[0,"enterprise/upgrade"],[0,"enterprise"]]],"explain/basics-of-postgres-query-planning":[1,[[0,"explain"]]],"explain/grid":[1,[[0,"explain"]]],"explain/plan-comparison":[1,[[0,"explain"]]],"explain/insights":[1,[[0,"explain"]]],"explain/scan-nodes":[1,[[0,"explain"]]],"explain/join-nodes":[1,[[0,"explain"]]],"explain/other-nodes":[1,[[0,"explain"]]],"explain/insights/disk-sort":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/hash-batches":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/inefficient-index":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/large-offset":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/lossy-bitmaps":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/mis-estimate":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/slow-scan":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/insights/stale-stats":[1,[[0,"explain/insights"],[0,"explain"]]],"explain/join-nodes/hash-join":[1,[[0,"explain/join-nodes"],[0,"explain"]]],"explain/join-nodes/merge-join":[1,[[0,"explain/join-nodes"],[0,"explain"]]],"explain/join-nodes/nested-loop":[1,[[0,"explain/join-nodes"],[0,"explain"]]],"explain/other-nodes/aggregate":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/append":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/bitmap-and":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/bitmap-or":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/gather-merge":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/gather":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/group":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/hash":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/limit":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/lock-rows":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/materialize":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/merge-append":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/modify-table":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/project-set":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/recursive-union":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/result":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/set-op":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/sort":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/unique":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/other-nodes/window-aggregate":[1,[[0,"explain/other-nodes"],[0,"explain"]]],"explain/scan-nodes/sequential-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/index-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/index-only-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/bitmap-heap-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/bitmap-index-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/cte-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/custom-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/foreign-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/function-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/subquery-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/table-sample-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/tid-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/values-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/scan-nodes/work-table-scan":[1,[[0,"explain/scan-nodes"],[0,"explain"]]],"explain/setup/auto_explain":[1,[[0,"explain/setup"],[0,"install"]]],"explain/setup/log_explain":[1,[[0,"explain/setup"],[0,"install"]]],"explain/setup/amazon_rds":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/azure_database":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/google_cloud_sql":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/supabase":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/crunchy_bridge":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/heroku":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/self_managed":[1,[[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/log_explain/":[1,[[0,"explain/setup/log_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/amazon_rds/01_auto_explain_check":[1,[[0,"explain/setup/amazon_rds"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/amazon_rds/02_enable_auto_explain":[1,[[0,"explain/setup/amazon_rds"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/amazon_rds/03_review_settings":[1,[[0,"explain/setup/amazon_rds"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/amazon_rds/04_test_and_verify":[1,[[0,"explain/setup/amazon_rds"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/azure_database/01_auto_explain_check":[1,[[0,"explain/setup/azure_database"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/azure_database/02_enable_auto_explain":[1,[[0,"explain/setup/azure_database"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/azure_database/03_review_settings":[1,[[0,"explain/setup/azure_database"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/azure_database/04_test_and_verify":[1,[[0,"explain/setup/azure_database"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/crunchy_bridge/01_auto_explain_check":[1,[[0,"explain/setup/crunchy_bridge"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/crunchy_bridge/02_enable_auto_explain":[1,[[0,"explain/setup/crunchy_bridge"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/crunchy_bridge/03_review_settings":[1,[[0,"explain/setup/crunchy_bridge"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/crunchy_bridge/04_test_and_verify":[1,[[0,"explain/setup/crunchy_bridge"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/google_cloud_sql/01_auto_explain_check":[1,[[0,"explain/setup/google_cloud_sql"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/google_cloud_sql/02_enable_auto_explain":[1,[[0,"explain/setup/google_cloud_sql"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/google_cloud_sql/03_review_settings":[1,[[0,"explain/setup/google_cloud_sql"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/google_cloud_sql/04_test_and_verify":[1,[[0,"explain/setup/google_cloud_sql"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/heroku/01_auto_explain_check":[1,[[0,"explain/setup/heroku"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/heroku/02_enable_auto_explain":[1,[[0,"explain/setup/heroku"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/heroku/03_review_settings":[1,[[0,"explain/setup/heroku"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/heroku/04_test_and_verify":[1,[[0,"explain/setup/heroku"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/log_explain/01_create_helper_functions":[1,[[0,"explain/setup/log_explain/"],[0,"explain/setup/log_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/log_explain/02_enable_log_explain":[1,[[0,"explain/setup/log_explain/"],[0,"explain/setup/log_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/log_explain/03_test_and_verify":[1,[[0,"explain/setup/log_explain/"],[0,"explain/setup/log_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/self_managed/01_auto_explain_check":[1,[[0,"explain/setup/self_managed"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/self_managed/02_enable_auto_explain":[1,[[0,"explain/setup/self_managed"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/self_managed/03_review_settings":[1,[[0,"explain/setup/self_managed"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/self_managed/04_test_and_verify":[1,[[0,"explain/setup/self_managed"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/supabase/01_auto_explain_check":[1,[[0,"explain/setup/supabase"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/supabase/02_enable_auto_explain":[1,[[0,"explain/setup/supabase"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/supabase/03_review_settings":[1,[[0,"explain/setup/supabase"],[0,"explain/setup/auto_explain"],[0,"explain/setup"],[0,"install"]]],"explain/setup/supabase/04_test_and_verify":[1,[[0,"explain/setup/supabase"],[0,"explain/setup/auto_explain"],[0,"
16;explain/setup"],[0,"install"]]],"index-advisor/getting-started":[1,[[0,"index-advisor"]]],"index-advisor/reason-about-insights":[1,[[0,"index-advisor"]]],"index-advisor/configuration":[1,[[0,"index-advisor"]]],"index-advisor/test-insights":[1,[[0,"index-advisor"]]],"index-advisor/checks-and-alerts":[1,[[0,"index-advisor"]]],"index-advisor/consolidation":[1,[[0,"index-advisor"]]],"indexing-engine-phase-1":[1,[[0,"indexing-engine"]]],"indexing-engine-phase-2":[1,[[0,"indexing-engine"]]],"indexing-engine/cp-model":[1,[[0,"indexing-engine"]]],"indexing-engine/index-write-overhead":[1,[[0,"indexing-engine"]]],"indexing-engine/limitations":[1,[[0,"indexing-engine"]]],"indexing-engine/query-to-scan-breakdown":[1,[[0,"indexing-engine-phase-1"],[0,"indexing-engine"]]],"indexing-engine/index-element-extraction":[1,[[0,"indexing-engine-phase-2"],[0,"indexing-engine"]]],"
16indexing-engine/multi-column-indexes":[1,[[0,"indexing-engine-phase-2"],[0,"indexing-engine"]]],"indexing-engine/what-if-analysis":[1,[[0,"indexing-engine-phase-2"],[0,"indexing-engine"]]],"indexing-engine/cp-model/built-in-configs":[1,[[0,"indexing-engine/cp-model"],[0,"indexing-engine"]]],"indexing-engine/cp-model/settings":[1,[[0,"indexing-engine/cp-model"],[0,"indexing-engine"]]],"indexing-engine/cp-model/goals":[1,[[0,"indexing-engine/cp-model"],[0,"indexing-engine"]]],"indexing-engine/cp-model/rules":[1,[[0,"indexing-engine/cp-model"],[0,"indexing-engine"]]],"install/":[1,[[0,"install"]]],"log-insights/setup":[1,[[0,"install"]]],"explain/setup":[1,[[0,"install"]]],"install/troubleshooting":[1,[[0,"install"]]],"install/amazon_rds":[1,[[0,"install/"],[0,"install"]]],"install/azure_database":[1,[[0,"install/"],[0,"install"]]],"install/google_cloud_sql":[1,[[0,"install/"],[0,"install"]]],"install/crunchy_bridge":[1,[[0,"install/"],[0,"install"]]],"install/heroku_postgres":[1,[[0,"install/"],[0,"install"]]],"install/aiven":[1,[[0,"install/"],[0,"install"]]],"install/supabase":[1,[[0,"install/"],[0,"install"]]],"install/neon":[1,[[0,"install/"],[0,"install"]]],"install/self_managed":[1,[[0,"install/"],[0,"install"]]],"install/aiven/01_create_monitoring_user":[1,[[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/02_enable_pg_stat_statements":[1,[[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/03_create_pg_stat_statements_helpers":[1,[[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/04_install_the_collector":[1,[[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/05_configure_the_collector":[1,[[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/04_install_the_collector_package":[1,[[0,"install/aiven/04_install_the_collector"],[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/04_install_the_collector_docker":[1,[[0,"install/aiven/04_install_the_collector"],[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/05_configure_the_collector_package":[1,[[0,"install/aiven/05_configure_the_collector"],[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/aiven/05_configure_the_collector_docker":[1,[[0,"install/aiven/05_configure_the_collector"],[0,"install/aiven"],[0,"install/"],[0,"install"]]],"install/amazon_rds/00_overview":[1,[[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/01_configure_rds_instance":[1,[[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/02_create_monitoring_user":[1,[[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/03_install_collector":[1,[[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/04_configure_the_collector":[1,[[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/03_install_collector_ec2":[1,[[0,"install/amazon_rds/03_install_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/03_install_collector_ecs":[1,[[0,"install/amazon_rds/03_install_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/03_install_collector_eks":[1,[[0,"install/amazon_rds/03_install_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/03_install_collector_docker":[1,[[0,"install/amazon_rds/03_install_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/04_configure_the_collector_ec2":[1,[[0,"install/amazon_rds/04_configure_the_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/04_configure_the_collector_ecs":[1,[[0,"install/amazon_rds/04_configure_the_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/04_configure_the_collector_eks":[1,[[0,"install/amazon_rds/04_configure_the_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/amazon_rds/04_configure_the_collector_docker":[1,[[0,"install/amazon_rds/04_configure_the_collector"],[0,"install/amazon_rds"],[0,"install/"],[0,"install"]]],"install/azure_database/01_configure_azure_instance":[1,[[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/02_create_monitoring_user":[1,[[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/03_install_the_collector":[1,[[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"
16install/azure_database/04_configure_the_collector":[1,[[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/03_install_the_collector_deb":[1,[[0,"install/azure_database/03_install_the_collector"],[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/03_install_the_collector_yum":[1,[[0,"install/azure_database/03_install_the_collector"],[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/03_install_the_collector_docker":[1,[[0,"install/azure_database/03_install_the_collector"],[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/04_configure_the_collector_package":[1,[[0,"install/azure_database/04_configure_the_collector"],[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/azure_database/04_configure_the_collector_docker":[1,[[0,"install/azure_database/04_configure_the_collector"],[0,"install/azure_database"],[0,"install/"],[0,"install"]]],"install/crunchy_bridge/01_deploy_the_collector":[1,[[0,"install/crunchy_bridge"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/01_create_monitoring_user":[1,[[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/02_install_the_collector":[1,[[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/03_configure_the_collector":[1,[[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/02_install_the_collector_deb":[1,[[0,"install/google_cloud_sql/02_install_the_collector"],[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/02_install_the_collector_yum":[1,[[0,"install/google_cloud_sql/02_install_the_collector"],[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/02_install_the_collector_docker":[1,[[0,"install/google_cloud_sql/02_install_the_collector"],[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/03_configure_the_collector_package":[1,[[0,"install/google_cloud_sql/03_configure_the_collector"],[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/google_cloud_sql/03_configure_the_collector_docker":[1,[[0,"install/google_cloud_sql/03_configure_the_collector"],[0,"install/google_cloud_sql"],[0,"install/"],[0,"install"]]],"install/heroku_postgres/01_deploy_the_collector":[1,[[0,"install/heroku_postgres"],[0,"install/"],[0,"install"]]],"install/heroku_postgres/02_attach_databases":[1,[[0,"install/heroku_postgres"],[0,"install/"],[0,"install"]]],"install/heroku_postgres/03_verify_configuration":[1,[[0,"install/heroku_postgres"],[0,"install/"],[0,"install"]]],"install/neon/01_enable_pg_stat_statements":[1,[[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/02_create_monitoring_user":[1,[[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/03_install_the_collector":[1,[[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/04_configure_the_collector":[1,[[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/03_install_the_collector_package":[1,[[0,"install/neon/03_install_the_collector"],[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/03_install_the_collector_docker":[1,[[0,"install/neon/03_install_the_collector"],[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/04_configure_the_collector_package":[1,[[0,"install/neon/04_configure_the_collector"],[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/neon/04_configure_the_collector_docker":[1,[[0,"install/neon/04_configure_the_collector"],[0,"install/neon"],[0,"install/"],[0,"install"]]],"install/self_managed/00_choose_setup_method":[1,[[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/01_guided_setup":[1,[[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/":[1,[[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/01_create_monitoring_user":[1,[[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/02_enable_pg_stat_statements":[1,[[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/03_install_the_collector":[1,[[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/04_configure_the_collector":[1,[[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/02_enable_pg_stat_statements_deb":[1,[[0,"install/self_managed/02_enable_pg_stat_statements"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/02_enable_pg_stat_statements_yum":[1,[[0,"install/self_managed/02_enable_pg_stat_statements"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/02_enable_pg_stat_statements_docker":[1,[[0,"install/self_managed/02_enable_pg_stat_statements"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/03_install_the_collector_deb":[1,[[0,"install/self_managed/03_install_the_collector"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/03_install_the_collector_yum":[1,[[0,"install/self_managed/03_install_the_collector"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/03_install_the_collector_docker":[1,[[0,"install/self_managed/03_install_the_collector"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/04_configure_the_collector_package":[1,[[0,"install/self_managed/04_configure_the_collector"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/self_managed/04_configure_the_collector_docker":[1,[[0,"install/self_managed/04_configure_the_collector"],[0,"install/self_managed/"],[0,"install/self_managed"],[0,"install/"],[0,"install"]]],"install/supabase/01_enable_pg_stat_statements":[1,[[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/supabase/02_create_monitoring_user":[1,[[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/supabase/03_install_the_collector":[1,[[0,"install/supabase"],[0,"install/"],[0,"install"]]],"
16install/supabase/04_configure_the_collector":[1,[[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/supabase/03_install_the_collector_package":[1,[[0,"install/supabase/03_install_the_collector"],[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/supabase/03_install_the_collector_docker":[1,[[0,"install/supabase/03_install_the_collector"],[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/supabase/04_configure_the_collector_package":[1,[[0,"install/supabase/04_configure_the_collector"],[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/supabase/04_configure_the_collector_docker":[1,[[0,"install/supabase/04_configure_the_collector"],[0,"install/supabase"],[0,"install/"],[0,"install"]]],"install/troubleshooting/collector_crash":[1,[[0,"install/troubleshooting"],[0,"install"]]],"install/troubleshooting/reset_stat_statements":[1,[[0,"install/troubleshooting"],[0,"install"]]],"install/troubleshooting/column_stats_helper":[1,[[0,"install/troubleshooting"],[0,"install"]]],"install/troubleshooting/ext_stats_helper":[1,[[0,"install/troubleshooting"],[0,"install"]]],"install/troubleshooting/pg_stat_statements":[1,[[0,"install/troubleshooting"],[0,"install"]]],"install/troubleshooting/rds_pg_stat_statements_shared_preload_libraries":[1,[[0,"install/troubleshooting"],[0,"install"]]],"install/troubleshooting/pg_read_file_helper":[1,[[0,"install/troubleshooting"],[0,"install"]]],"log-insights/setup/tuning-log-config-settings":[1,[[0,"log-insights"]]],"log-insights/limits":[1,[[0,"log-insights"]]],"log-insights/classifications":[1,[[0,"log-insights"]]],"log-insights/server":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/locks":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/statements":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/constraint-violations":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors":[1,[[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/setup/amazon-rds":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/azure-database":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/google-cloud-sql":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/heroku-postgres":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/crunchy-bridge":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/aiven":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/supabase":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/neon":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/self-managed":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/syslog-server":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/opentelemetry":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/troubleshooting":[1,[[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/azure-database/troubleshooting":[1,[[0,"log-insights/setup/troubleshooting"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/google-cloud-sql/troubleshooting":[1,[[0,"log-insights/setup/troubleshooting"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/self-managed/troubleshooting":[1,[[0,"log-insights/setup/troubleshooting"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/aiven/01_move_database_into_vpc":[1,[[0,"log-insights/setup/aiven"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/aiven/02_configure_vpc_peering":[1,[[0,"log-insights/setup/aiven"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/aiven/03_configure_collector":[1,[[0,"log-insights/setup/aiven"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/aiven/04_configure_service_integration":[1,[[0,"log-insights/setup/aiven"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/amazon-rds/01_test_log_download":[1,[[0,"log-insights/setup/amazon-rds"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/azure-database/01_set_up_managed_identity":[1,[[0,"log-insights/setup/azure-database"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/azure-database/02_set_up_azure_event_hub":[1,[[0,"log-insights/setup/azure-database"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/azure-database/03_stream_logs_into_event_hub":[1,[[0,"log-insights/setup/azure-database"],[0,"log-insights/setup"],[0,"install"]]],"
16log-insights/setup/azure-database/04_adjust_log_line_prefix":[1,[[0,"log-insights/setup/azure-database"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/azure-database/05_configure_collector":[1,[[0,"log-insights/setup/azure-database"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/crunchy-bridge/01_create_helper_function_and_test":[1,[[0,"log-insights/setup/crunchy-bridge"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/google-cloud-sql/01_create_topic_and_subscriber":[1,[[0,"log-insights/setup/google-cloud-sql"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/google-cloud-sql/02_configure_log_routing":[1,[[0,"log-insights/setup/google-cloud-sql"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/google-cloud-sql/03_set_up_service_account":[1,[[0,"log-insights/setup/google-cloud-sql"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/google-cloud-sql/04_configure_collector":[1,[[0,"log-insights/setup/google-cloud-sql"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/heroku-postgres/01_add_log_drain":[1,[[0,"log-insights/setup/heroku-postgres"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/heroku-postgres/02_verify_log_drain":[1,[[0,"log-insights/setup/heroku-postgres"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/heroku-postgres/03_restart_collector":[1,[[0,"log-insights/setup/heroku-postgres"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/neon/01_set_up_opentelemetry_logs":[1,[[0,"log-insights/setup/neon"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/opentelemetry/fluentbit":[1,[[0,"log-insights/setup/opentelemetry"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/opentelemetry/vector":[1,[[0,"log-insights/setup/opentelemetry"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/self-managed/01_determine_log_location":[1,[[0,"log-insights/setup/self-managed"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/self-managed/02_configure_collector":[1,[[0,"log-insights/setup/self-managed"],[0,"log-insights/setup"],[0,"install"]]],"log-insights/setup/supabase/01_set_up_log_drain":[1,[[0,"log-insights/setup/supabase"],[0,"log-insights/setup"],[0,"install"]]],"opentelemetry/traceparent":[1,[[0,"opentelemetry"]]],"opentelemetry/honeycomb":[1,[[0,"opentelemetry"]]],"opentelemetry/datadog":[1,[[0,"opentelemetry"]]],"opentelemetry/newrelic":[1,[[0,"opentelemetry"]]],"query-advisor/getting-started":[1,[[0,"query-advisor"]]],"query-advisor/from-insight-to-conclusion":[1,[[0,"query-advisor"]]],"query-advisor/insights":[1,[[0,"query-advisor"]]],"query-advisor/alerts":[1,[[0,"query-advisor"]]],"insights":[1,[[0,"query-advisor/"]]],"insights/inefficient-nested-loops":[1,[[0,"query-advisor/"]]],"insights/order-by-limit":[1,[[0,"query-advisor/"]]],"query-advisor/insights/inefficient-nested-loops":[1,[[0,"query-advisor/insights"],[0,"query-advisor"]]],"query-advisor/insights/wrong-index-order-by":[1,[[0,"query-advisor/insights"],[0,"query-advisor"]]],"query-advisor/insights/inefficient-index-use":[1,[[0,"query-advisor/insights"],[0,"query-advisor"]]],"query-advisor/insights/late-join-filter-with-or":[1,[[0,"query-advisor/insights"],[0,"query-advisor"]]],"query-advisor/insights/disk-spill-work-mem":[1,[[0,"query-advisor/insights"],[0,"query-advisor"]]],"query-performance/query-tags":[1,[[0,"query-performance"]]],"schema-statistics/columns-hot-updates":[1,[[0,"schema-statistics"]]],"schema-statistics/buffer-cache":[1,[[0,"schema-statistics"]]],"vacuum-advisor/getting-started":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/bloat":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/freezing":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/performance":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/activity":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/per-table-activity":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/vacuum-simulator":[1,[[0,"vacuum-advisor"]]],"vacuum-advisor/what-is-bloat":[1,[[0,"vacuum-advisor/bloat"],[0,"vacuum-advisor"]]],"vacuum-advisor/what-is-freezing":[1,[[0,"vacuum-advisor/freezing"],[0,"vacuum-advisor"]]],"vacuum-advisor/how-does-the-vacuum-cost-model-work":[1,[[0,"vacuum-advisor/performance"],[0,"vacuum-advisor"]]],"workbooks/how-to-use-workbooks":[1,[[0,"workbooks"]]],"workbooks/query-optimization-examples":[1,[[0,"workbooks"]]],"workbooks/planner-settings-and-hints":[1,[[0,"workbooks"]]],"workbooks/collector-workflow":[1,[[0,"workbooks"]]],"workbooks/security-privacy":[1,[[0,"workbooks"]]],"workbooks/enabling_pg_hint_plan":[1,[[0,"workbooks"]]],"log-insights/app-errors/U110":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U111":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U112":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U113":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U114":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U115":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U116":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U117":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U118":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U119":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U120":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U121":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U122":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U123":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U124":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U125":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U126":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U127":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U128":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U129":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U130":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U131":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U132":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U133":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U134":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U135":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U136":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U137":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U138":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U139":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U140":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U141":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U142":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U143":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U144":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U145":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U146":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U147":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U148":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/app-errors/U149":[1,[[0,"log-insights/app-errors"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C20":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C21":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C22":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C23":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C24":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C25":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C26":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C27":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C28":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C29":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C30":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C31":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C32":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/connections/C33":[1,[[0,"log-insights/connections"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/constraint-violations/V100":[1,[[0,"log-insights/constraint-violations"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/constraint-violations/V101":[1,[[0,"log-insights/constraint-violations"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/constraint-violations/V102":[1,[[0,"log-insights/constraint-violations"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/constraint-violations/V103":[1,[[0,"log-insights/constraint-violations"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/constraint-violations/V104":[1,[[0,"log-insights/constraint-violations"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/locks/L70":[1,[[0,"log-insights/locks"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/locks/L71":[1,[[0,"log-insights/locks"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/locks/L72":[1,[[0,"log-insights/locks"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/locks/L73":[1,[[0,"log-insights/locks"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/locks/L74":[1,[[0,"log-insights/locks"],[0,"log-insights/classifications"],[0,"log-insights"]]],&qu
16ot;log-insights/maintenance/A60":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A61":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A62":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A63":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A64":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A65":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A66":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A67":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A68":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/maintenance/A69":[1,[[0,"log-insights/maintenance"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S1":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S2":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S3":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S4":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S5":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S6":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S7":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S8":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S9":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S10":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/server/S11":[1,[[0,"log-insights/server"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby/B90":[1,[[0,"log-insights/standby"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby/B91":[1,[[0,"log-insights/standby"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby/B92":[1,[[0,"log-insights/standby"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby/B93":[1,[[0,"log-insights/standby"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby/B94":[1,[[0,"log-insights/standby"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/standby/B95":[1,[[0,"log-insights/standby"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/statements/T80":[1,[[0,"log-insights/statements"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/statements/T81":[1,[[0,"log-insights/statements"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/statements/T82":[1,[[0,"log-insights/statements"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/statements/T83":[1,[[0,"log-insights/statements"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/statements/T84":[1,[[0,"log-insights/statements"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/unknown/Z00":[1,[[0,"log-insights/unknown"]]],"log-insights/unknown/Z1000":[1,[[0,"log-insights/unknown"]]],"log-insights/wal-checkpoints/W40":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W41":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W42":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W43":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W44":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W45":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W46":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W50":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W51":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W52":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]],"log-insights/wal-checkpoints/W53":[1,[[0,"log-insights/wal-checkpoints"],[0,"log-insights/classifications"],[0,"log-insights"]]]}],"parentHrefToLinkablePage":[0,{"accounts":[0,"accounts"],"accounts/sso":[0,"accounts/sso"],"api":[0,"api"],"api/authentication":[0,"api/authentication"],"api/mutations":[0,"api/mutations/addServer"],"api/queries":[0,"api/queries/getServers"],"checks":[0,"checks/"],"checks/queries":[0,"checks/queries/slowness"],"checks/connections":[0,"checks/connections/active_query"],"checks/index_advisor":[0,"checks/index_advisor/indexing_engine"],"checks/schema":[0,"
16checks/schema/index_invalid"],"checks/settings":[0,"checks/settings/enable_features"],"checks/system":[0,"checks/system/storage_space"],"checks/replication":[0,"checks/replication/high_lag"],"checks/vacuum":[0,"checks/vacuum/inefficient_index_phase"],"collector":[0,"collector"],"enterprise":[0,"enterprise"],"enterprise/releases":[0,"enterprise/releases/2026-08-1"],"enterprise/setup":[0,"enterprise/setup"],"enterprise/upgrade":[0,"enterprise/upgrade"],"explain":[0,"explain"],"explain/insights":[0,"explain/insights/disk-sort"],"explain/join-nodes":[0,"explain/join-nodes/hash-join"],"explain/other-nodes":[0,"explain/other-nodes/aggregate"],"explain/scan-nodes":[0,"explain/scan-nodes/sequential-scan"],"explain/setup":[0,"explain/setup"],"explain/setup/auto_explain":[0,"explain/setup/auto_explain"],"explain/setup/log_explain":[0,"explain/setup/log_explain"],"explain/setup/amazon_rds":[0,"explain/setup/amazon_rds/01_auto_explain_check"],"explain/setup/azure_database":[0,"explain/setup/azure_database/01_auto_explain_check"],"explain/setup/crunchy_bridge":[0,"explain/setup/crunchy_bridge/01_auto_explain_check"],"explain/setup/google_cloud_sql":[0,"explain/setup/google_cloud_sql/01_auto_explain_check"],"explain/setup/heroku":[0,"explain/setup/heroku/01_auto_explain_check"],"explain/setup/log_explain/":[0,"explain/setup/log_explain/01_create_helper_functions"],"explain/setup/self_managed":[0,"explain/setup/self_managed/01_auto_explain_check"],"explain/setup/supabase":[0,"explain/setup/supabase/01_auto_explain_check"],"index-advisor":[0,"index-advisor/getting-started"],"indexing-engine":[0,"indexing-engine"],"indexing-engine-phase-1":[0,"indexing-engine/query-to-scan-breakdown"],"indexing-engine-phase-2":[0,"indexing-engine/index-element-extraction"],"indexing-engine/cp-model":[0,"indexing-engine/cp-model"],"install":[0,"install"],"install/":[0,"install/amazon_rds/00_overview"],"install/aiven":[0,"install/aiven/01_create_monitoring_user"],"install/aiven/04_install_the_collector":[0,"install/aiven/04_install_the_collector"],"install/aiven/05_configure_the_collector":[0,"install/aiven/05_configure_the_collector"],"install/amazon_rds":[0,"install/amazon_rds/00_overview"],"install/amazon_rds/03_install_collector":[0,"install/amazon_rds/03_install_collector"],"install/amazon_rds/04_configure_the_collector":[0,"install/amazon_rds/04_configure_the_collector"],"install/azure_database":[0,"install/azure_database/01_configure_azure_instance"],"install/azure_database/03_install_the_collector":[0,"install/azure_database/03_install_the_collector"],"install/azure_database/04_configure_the_collector":[0,"install/azure_database/04_configure_the_collector"],"install/crunchy_bridge":[0,"install/crunchy_bridge/01_deploy_the_collector"],"install/google_cloud_sql":[0,"install/google_cloud_sql/01_create_monitoring_user"],"install/google_cloud_sql/02_install_the_collector":[0,"install/google_cloud_sql/02_install_the_collector"],"install/google_cloud_sql/03_configure_the_collector":[0,"install/google_cloud_sql/03_configure_the_collector"],"install/heroku_postgres":[0,"install/heroku_postgres/01_deploy_the_collector"],"install/neon":[0,"install/neon/01_enable_pg_stat_statements"],"install/neon/03_install_the_collector":[0,"install/neon/03_install_the_collector"],"install/neon/04_configure_the_collector":[0,"install/neon/04_configure_the_collector"],"install/self_managed":[0,"install/self_managed/00_choose_setup_method"],"install/self_managed/":[0,"install/self_managed/01_create_monitoring_user"],"install/self_managed/02_enable_pg_stat_statements":[0,"install/self_managed/02_enable_pg_stat_statements"],"install/self_managed/03_install_the_collector":[0,"install/self_managed/03_install_the_collector"],"install/self_managed/04_configure_the_collector":[0,"install/self_managed/04_configure_the_collector"],"install/supabase":[0,"install/supabase/01_enable_pg_stat_statements"],"install/supabase/03_install_the_collector":[0,"install/supabase/03_install_the_collector"],"
16install/supabase/04_configure_the_collector":[0,"install/supabase/04_configure_the_collector"],"install/troubleshooting":[0,"install/troubleshooting/collector_crash"],"log-insights":[0,"log-insights"],"log-insights/classifications":[0,"log-insights/server/S1"],"log-insights/setup":[0,"log-insights/setup"],"log-insights/setup/troubleshooting":[0,"log-insights/setup/azure-database/troubleshooting"],"log-insights/setup/aiven":[0,"log-insights/setup/aiven/01_move_database_into_vpc"],"log-insights/setup/amazon-rds":[0,"log-insights/setup/amazon-rds/01_test_log_download"],"log-insights/setup/azure-database":[0,"log-insights/setup/azure-database/01_set_up_managed_identity"],"log-insights/setup/crunchy-bridge":[0,"log-insights/setup/crunchy-bridge/01_create_helper_function_and_test"],"log-insights/setup/google-cloud-sql":[0,"log-insights/setup/google-cloud-sql/01_create_topic_and_subscriber"],"log-insights/setup/heroku-postgres":[0,"log-insights/setup/heroku-postgres/01_add_log_drain"],"log-insights/setup/neon":[0,"log-insights/setup/neon/01_set_up_opentelemetry_logs"],"log-insights/setup/opentelemetry":[0,"log-insights/setup/opentelemetry"],"log-insights/setup/self-managed":[0,"log-insights/setup/self-managed/01_determine_log_location"],"log-insights/setup/supabase":[0,"log-insights/setup/supabase/01_set_up_log_drain"],"opentelemetry":[0,"opentelemetry"],"query-advisor":[0,"query-advisor/getting-started"],"query-advisor/":[0,"insights"],"query-advisor/insights":[0,"query-advisor/insights"],"query-performance":[0,"query-performance"],"schema-statistics":[0,"schema-statistics"],"vacuum-advisor":[0,"vacuum-advisor"],"vacuum-advisor/bloat":[0,"vacuum-advisor/bloat"],"vacuum-advisor/freezing":[0,"vacuum-advisor/freezing"],"vacuum-advisor/performance":[0,"vacuum-advisor/performance"],"workbooks":[0,"workbooks"],"log-insights/app-errors":[0,"log-insights/app-errors/U110"],"log-insights/connections":[0,"log-insights/connections/C20"],"log-insights/constraint-violations":[0,"log-insights/constraint-violations/V100"],"log-insights/locks":[0,"log-insights/locks/L70"],"log-insights/maintenance":[0,"log-insights/maintenance/A60"],"log-insights/server":[0,"log-insights/server/S1"],"log-insights/standby":[0,"log-insights/standby/B90"],"log-insights/statements":[0,"log-insights/statements/T80"],"log-insights/unknown":[0,"log-insights/unknown/Z00"],"log-insights/wal-checkpoints":[0,"log-insights/wal-checkpoints/W40"]}],"currentPath":[0,"/docs/"]}" ssr client="load" opts="{"name":"DocsNavigation","value":true}" await-children><div class="EW9ujq_docsNavigationOuter"><div class="EW9ujq_docsNavigationInner"><form class="EW9ujq_docsSearchbox" method="get" id="search" action="https://duckduckgo.com/" role="search"><input type="hidden" name="sites" value="pganalyze.com/docs"/><input type="text" name="q" autoComplete="off" maxLength="255" placeholder="Search the docsâ¦" aria-label="Search the docs" value=""/><button type="submit" aria-label="Search"><svg data-prefix="fal" data-icon="magnifying-glass" class="svg-inline--fa fa-magnifying-glass" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M384 208a176 176 0 1 0 -352 0 176 176 0 1 0 352 0zM343.3 366C307 397.2 259.7 416 208 416 93.1 416 0 322.9 0 208S93.1 0 208 0 416 93.1 416 208c0 51.7-18.8 99-50 135.3L507.3 484.7c6.2 6.2 6.2 16.4 0 22.6s-16.4 6.2-22.6 0L343.3 366z"></path></svg></button></form><div class="docs-toc-toggle EW9ujq_docsTocToggle"><button class="btn-link">Show<!-- --> table of contents</button></div><nav class="EW9ujq_docsTocList"><ul><ul><li class="EW9ujq_docsNavigationCurrent"><a href="/docs/" aria-current="page">Overview</a></li><li><a href="/docs/install" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true">
16<path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Installation Guide</a></li><li><a href="/docs/collector" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>pganalyze Collector</a></li><li><a href="/docs/query-performance" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Query Performance</a></li><li><a href="/docs/query-advisor/getting-started" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Query Advisor</a></li><li><a href="/docs/explain" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>EXPLAIN Plans</a></li><li><a href="/docs/workbooks" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Workbooks</a></li><li><a href="/docs/index-advisor/getting-started" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Index Advisor</a></li><li><a href="/docs/indexing-engine" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Indexing Engine</a></li><li><a href="/docs/vacuum-advisor" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>VACUUM Advisor</a></li><li><a href="/docs/schema-statistics" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Schema Statistics</a></li><li><a href="/docs/log-insights" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true">
16<path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Log Insights</a></li><li><a href="/docs/connections">Connections</a></li><li><a href="/docs/checks/" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Alerts & Check-Up</a></li><li><a href="/docs/accounts" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>Account Management</a></li><li><a href="/docs/mcp">MCP Server (Preview)</a></li><li><a href="/docs/opentelemetry" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>OpenTelemetry Integration</a></li><li><a href="/docs/enterprise" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>pganalyze Enterprise Server</a></li><li><a href="/docs/api" class="EW9ujq_docsNavigationExpandLink"><svg data-prefix="fal" data-icon="angle-right" class="svg-inline--fa fa-angle-right" role="img" viewBox="0 0 256 512" aria-hidden="true"><path fill="currentColor" d="M235.3 244.7c6.2 6.2 6.2 16.4 0 22.6l-160 160c-6.2 6.2-16.4 6.2-22.6 0s-6.2-16.4 0-22.6L201.4 256 52.7 107.3c-6.2-6.2-6.2-16.4 0-22.6s16.4-6.2 22.6 0l160 160z"></path></svg>pganalyze GraphQL API</a></li><li><a href="/docs/open_source_components">Open-Source Components</a></li></ul></ul></nav></div></div><!--astro:end--></astro-island><div class="long-content"><h1>Welcome to the pganalyze documentation!</h1><div><p>Learn more about how pganalyze works, and how to connect it with your Postgres database. pganalyze enables you to deliver consistent PostgreSQL performance and availability, at any scale.</p> 17<h2 id="installation-guides"><a href="#installation-guides" data-anchor="true" aria-hidden="true" tabindex="-1"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512" aria-hidden="true" role="img"><path fill="currentColor" d="M419.5 96c-16.6 0-32.7 4.5-46.8 12.7-15.8-16-34.2-29.4-54.5-39.5 28.2-24 64.1-37.2 101.3-37.2 86.4 0 156.5 70 156.5 156.5 0 41.5-16.5 81.3-45.8 110.6l-71.1 71.1c-29.3 29.3-69.1 45.8-110.6 45.8-86.4 0-156.5-70-156.5-156.5 0-1.5 0-3 .1-4.5 .5-17.7 15.2-31.6 32.9-31.1s31.6 15.2 31.1 32.9c0 .9 0 1.8 0 2.6 0 51.1 41.4 92.5 92.5 92.5 24.5 0 48-9.7 65.4-27.1l71.1-71.1c17.3-17.3 27.1-40.9 27.1-65.4 0-51.1-41.4-92.5-92.5-92.5zM275.2 173.3c-1.9-.8-3.8-1.9-5.5-3.1-12.6-6.5-27-10.2-42.1-10.2-24.5 0-48 9.7-65.4 27.1L91.1 258.2c-17.3 17.3-27.1 40.9-27.1 65.4 0 51.1 41.4 92.5 92.5 92.5 16.5 0 32.6-4.4 46.7-12.6 15.8 16 34.2 29.4 54.6 39.5-28.2 23.9-64 37.2-101.3 37.2-86.4 0-156.5-70-156.5-156.5 0-41.5 16.5-81.3 45.8-110.6l71.1-71.1c29.3-29.3 69.1-45.8 110.6-45.8 86.6 0 156.5 70.6 156.5 156.9 0 1.3 0 2.6 0 3.9-.4 17.7-15.1 31.6-32.8 31.2s-31.6-15.1-31.2-32.8c0-.8 0-1.5 0-2.3 0-33.7-18-63.3-44.8-79.6z"></path></svg></a>Installation guides</h2> 18<p>In order to use pganalyze you need to install the pganalyze collector in your environment, either on the database server directly, or a container / VM that can connect to it when using managed database services. The collector sends query data and other statistics on a continuous basis â to the pganalyze cloud service, or to your pganalyze Enterprise Server installation.</p> 19<p>
19To continue, select in which environment you are running your Postgres database:</p> 20<div class="vC7sGW_overviewInstallChoice"><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/amazon_rds/00_overview"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="data:image/svg+xml,%3c?xml%20version='1.0'%20encoding='UTF-8'?%3e%3c!--%20Generator:%20Adobe%20Illustrator%2019.0.1,%20SVG%20Export%20Plug-In%20.%20SVG%20Version:%206.00%20Build%200)%20--%3e%3csvg%20version='1.1'%20id='Layer_1'%20xmlns='http://www.w3.org/2000/svg'%20xmlns:xlink='http://www.w3.org/1999/xlink'%20x='0px'%20y='0px'%20viewBox='0%200%20304%20182'%20style='enable-background:new%200%200%20304%20182;'%20xml:space='preserve'%3e%3cstyle%20type='text/css'%3e%20.st0{fill:%23252F3E;}%20.st1{fill-rule:evenodd;clip-rule:evenodd;fill:%23FF9900;}%20%3c/style%3e%3cg%3e%3cpath%20class='st0'%20d='M86.4,66.4c0,3.7,0.4,6.7,1.1,8.9c0.8,2.2,1.8,4.6,3.2,7.2c0.5,0.8,0.7,1.6,0.7,2.3c0,1-0.6,2-1.9,3l-6.3,4.2%20c-0.9,0.6-1.8,0.9-2.6,0.9c-1,0-2-0.5-3-1.4C76.2,90,75,88.4,74,86.8c-1-1.7-2-3.6-3.1-5.9c-7.8,9.2-17.6,13.8-29.4,13.8%20c-8.4,0-15.1-2.4-20-7.2c-4.9-4.8-7.4-11.2-7.4-19.2c0-8.5,3-15.4,9.1-20.6c6.1-5.2,14.2-7.8,24.5-7.8c3.4,0,6.9,0.3,10.6,0.8%20c3.7,0.5,7.5,1.3,11.5,2.2v-7.3c0-7.6-1.6-12.9-4.7-16c-3.2-3.1-8.6-4.6-16.3-4.6c-3.5,0-7.1,0.4-10.8,1.3c-3.7,0.9-7.3,2-10.8,3.4%20c-1.6,0.7-2.8,1.1-3.5,1.3c-0.7,0.2-1.2,0.3-1.6,0.3c-1.4,0-2.1-1-2.1-3.1v-4.9c0-1.6,0.2-2.8,0.7-3.5c0.5-0.7,1.4-1.4,2.8-2.1%20c3.5-1.8,7.7-3.3,12.6-4.5c4.9-1.3,10.1-1.9,15.6-1.9c11.9,0,20.6,2.7,26.2,8.1c5.5,5.4,8.3,13.6,8.3,24.6V66.4z%20M45.8,81.6%20c3.3,0,6.7-0.6,10.3-1.8c3.6-1.2,6.8-3.4,9.5-6.4c1.6-1.9,2.8-4,3.4-6.4c0.6-2.4,1-5.3,1-8.7v-4.2c-2.9-0.7-6-1.3-9.2-1.7%20c-3.2-0.4-6.3-0.6-9.4-0.6c-6.7,0-11.6,1.3-14.9,4c-3.3,2.7-4.9,6.5-4.9,11.5c0,4.7,1.2,8.2,3.7,10.6%20C37.7,80.4,41.2,81.6,45.8,81.6z%20M126.1,92.4c-1.8,0-3-0.3-3.8-1c-0.8-0.6-1.5-2-2.1-3.9L96.7,10.2c-0.6-2-0.9-3.3-0.9-4%20c0-1.6,0.8-2.5,2.4-2.5h9.8c1.9,0,3.2,0.3,3.9,1c0.8,0.6,1.4,2,2,3.9l16.8,66.2l15.6-66.2c0.5-2,1.1-3.3,1.9-3.9c0.8-0.6,2.2-1,4-1%20h8c1.9,0,3.2,0.3,4,1c0.8,0.6,1.5,2,1.9,3.9l15.8,67l17.3-67c0.6-2,1.3-3.3,2-3.9c0.8-0.6,2.1-1,3.9-1h9.3c1.6,0,2.5,0.8,2.5,2.5%20c0,0.5-0.1,1-0.2,1.6c-0.1,0.6-0.3,1.4-0.7,2.5l-24.1,77.3c-0.6,2-1.3,3.3-2.1,3.9c-0.8,0.6-2.1,1-3.8,1h-8.6c-1.9,0-3.2-0.3-4-1%20c-0.8-0.7-1.5-2-1.9-4L156,23l-15.4,64.4c-0.5,2-1.1,3.3-1.9,4c-0.8,0.7-2.2,1-4,1H126.1z%20M254.6,95.1c-5.2,0-10.4-0.6-15.4-1.8%20c-5-1.2-8.9-2.5-11.5-4c-1.6-0.9-2.7-1.9-3.1-2.8c-0.4-0.9-0.6-1.9-0.6-2.8v-5.1c0-2.1,0.8-3.1,2.3-3.1c0.6,0,1.2,0.1,1.8,0.3%20c0.6,0.2,1.5,0.6,2.5,1c3.4,1.5,7.1,2.7,11,3.5c4,0.8,7.9,1.2,11.9,1.2c6.3,0,11.2-1.1,14.6-3.3c3.4-2.2,5.2-5.4,5.2-9.5%20c0-2.8-0.9-5.1-2.7-7c-1.8-1.9-5.2-3.6-10.1-5.2L246,52c-7.3-2.3-12.7-5.7-16-10.2c-3.3-4.4-5-9.3-5-14.5c0-4.2,0.9-7.9,2.7-11.1%20c1.8-3.2,4.2-6,7.2-8.2c3-2.3,6.4-4,10.4-5.2c4-1.2,8.2-1.7,12.6-1.7c2.2,0,4.5,0.1,6.7,0.4c2.3,0.3,4.4,0.7,6.5,1.1%20c2,0.5,3.9,1,5.7,1.6c1.8,0.6,3.2,1.2,4.2,1.8c1.4,0.8,2.4,1.6,3,2.5c0.6,0.8,0.9,1.9,0.9,3.3v4.7c0,2.1-0.8,3.2-2.3,3.2%20c-0.8,0-2.1-0.4-3.8-1.2c-5.7-2.6-12.1-3.9-19.2-3.9c-5.7,0-10.2,0.9-13.3,2.8c-3.1,1.9-4.7,4.8-4.7,8.9c0,2.8,1,5.2,3,7.1%20c2,1.9,5.7,3.8,11,5.5l14.2,4.5c7.2,2.3,12.4,5.5,15.5,9.6c3.1,4.1,4.6,8.8,4.6,14c0,4.3-0.9,8.2-2.6,11.6%20c-1.8,3.4-4.2,6.4-7.3,8.8c-3.1,2.5-6.8,4.3-11.1,5.6C264.4,94.4,259.7,95.1,254.6,95.1z'/%3e%3cg%3e%3cpath%20class='st1'%20d='M273.5,143.7c-32.9,24.3-80.7,37.2-121.8,37.2c-57.6,0-109.5-21.3-148.7-56.7c-3.1-2.8-0.3-6.6,3.4-4.4%20c42.4,24.6,94.7,39.5,148.8,39.5c36.5,0,76.6-7.6,113.5-23.2C274.2,133.6,278.9,139.7,273.5,143.7z'/%3e%3cpath%20class='st1'%20d='M287.2,128.1c-4.2-5.4-27.8-2.6-38.5-1.3c-3.2,0.4-3.7-2.4-0.8-4.5c18.8-13.2,49.7-9.4,53.3-5%20c3.6,4.5-1,35.4-18.6,50.2c-2.7,2.3-5.3,1.1-4.1-1.9C282.5,155.7,291.4,133.4,287.2,128.1z'/%3e%3c/g%3e%3c/g%3e%3c/svg%3e" alt="Logo of Amazon Web Services"/>Amazon Web Services</div><div class="vC7sGW_overviewInstallChoiceProviderText">RDS and Aurora</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/azure_database/01_configure_azure_instance"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="data:image/svg+xml,%3csvg%20width='150'%20height='150'%20viewBox='0%200%2096%2096'%20xmlns='http://www.w3.org/2000/svg'%3e%3cdefs%3e%3clinearGradient%20id='e399c19f-b68f-429d-b176-18c2117ff73c'%20x1='-1032.172'%20x2='-1059.213'%20y1='145.312'%20y2='65.426'%20gradientTransform='matrix(1%200%200%20-1%201075%20158)'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-color='%23114a8b'/%3e%3cstop%20offset='1'%20stop-color='%230669bc'/%3e%3c/linearGradient%3e%3clinearGradient%20id='ac2a6fc2-ca48-4327-9a3c-d4dcc3256e15'%20x1='-1023.725'%20x2='-1029.98'%20y1='108.083'%20y2='105.968'%20gradientTransform='matrix(1%200%200%20-1%201075%20158)'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-opacity='.3'/%3e%3cstop%20offset='.071'%20stop-opacity='.2'/%3e%3cstop%20offset='.321'%20stop-opacity='.1'/%3e%3cstop%20offset='.623'%20stop-opacity='.05'/%3e%3cstop%20offset='1'%20stop-opacity='0'/%3e%3c/linearGradient%3e%3clinearGradient%20id='a7fee970-a784-4bb1-af8d-63d18e5f7db9'%20x1='-1027.165'%20x2='-997.482'%20y1='147.642'%20y2='68.561'%20gradientTransform='matrix(1%200%200%20-1%201075%20158)'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20offset='0'%20stop-color='%233ccbf4'/%3e%3cstop%20offset='1'%20stop-color='%232892df'/%3e%3c/linearGradient%3e%3c/defs%3e%3cpath%20fill='url(%23e399c19f-b68f-429d-b176-18c2117ff73c)'%20d='M33.338%206.544h26.038l-27.03%2080.087a4.152%204.152%200%200%201-3.933%202.824H8.149a4.145%204.145%200%200%201-3.928-5.47L29.404%209.368a4.152%204.152%200%200%201%203.934-2.825z'/%3e%3cpath%20fill='%230078d4'%20d='M71.175%2060.261h-41.29a1.911%201.911%200%200%200-1.305%203.309l26.532%2024.764a4.171%204.171%200%200%200%202.846%201.121h23.38z'/%3e%3cpath%20fill='url(%23ac2a6fc2-ca48-4327-9a3c-d4dcc3256e15)'%20d='M33.338%206.544a4.118%204.118%200%200%200-3.943%202.879L4.252%2083.917a4.14%204.14%200%200%200%203.908%205.538h20.787a4.443%204.443%200%200%200%203.41-2.9l5.014-14.777%2017.91%2016.705a4.237%204.237%200%200%200%202.666.972H81.24L71.024%2060.261l-29.781.007L59.47%206.544z'/%3e%3cpath%20fill='url(%23a7fee970-a784-4bb1-af8d-63d18e5f7db9)'%20d='M66.595%209.364a4.145%204.145%200%200%200-3.928-2.82H33.648a4.146%204.146%200%200%201%203.928%202.82l25.184%2074.62a4.146%204.146%200%200%201-3.928%205.472h29.02a4.146%204.146%200%200%200%203.927-5.472z'/%3e%3c/svg%3e" alt="Logo of Microsoft Azure"/>Microsoft Azure</div><div class="vC7sGW_overviewInstallChoiceProviderText">Flexible Server</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/google_cloud_sql/01_create_monitoring_user"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="data:image/svg+xml,%3csvg%20height='206'%20preserveAspectRatio='xMidYMid'%20viewBox='0%200%20256%20206'%20width='256'%20xmlns='http://www.w3.org/2000/svg'%3e%3cpath%20d='m170.2517%2056.8186%2022.253-22.253%201.483-9.37c-40.551-36.873-105.012-32.692-141.567%208.724-10.154%2011.503-17.687%2025.844-21.704%2040.653l7.97-1.123%2044.505-7.339%203.436-3.514c19.797-21.742%2053.27-24.667%2076.128-6.168z'%20fill='%23ea4335'/%3e%3cpath%20d='m224.2048%2073.9182c-5.115-18.836-15.616-35.769-30.217-48.722l-31.232%2031.232c13.188%2010.776%2020.701%2027.01%2020.379%2044.037v5.544c15.351%200%2027.797%2012.445%2027.797%2027.796%200%2015.352-12.446%2027.485-27.797%2027.485h-55.671l-5.466%205.934v33.34l5.466%205.231h55.671c39.93.311%2072.552-31.494%2072.863-71.424.188-24.203-11.745-46.893-31.793-60.453'%20fill='%234285f4'/%3e%3cpath%20d='m71.8704%20205.7957h55.593v-44.506h-55.593c-3.961-.001-7.797-.852-11.399-2.498l-7.887%202.42-22.409%2022.253-1.952%207.574c12.567%209.489%2027.9%2014.825%2043.647%2014.757'%20fill='%2334a853'/%3e%3cpath%20d='
20m71.8704%2061.4255c-39.931.238-72.107%2032.802-71.869%2072.732.133%2022.298%2010.547%2043.288%2028.222%2056.881l32.248-32.247c-13.991-6.321-20.208-22.786-13.887-36.776%206.32-13.99%2022.786-20.207%2036.775-13.887%206.165%202.785%2011.102%207.723%2013.887%2013.887l32.248-32.247c-13.721-17.937-35.041-28.424-57.624-28.343'%20fill='%23fbbc05'/%3e%3c/svg%3e" alt="Logo of Google Cloud"/>Google Cloud</div><div class="vC7sGW_overviewInstallChoiceProviderText">Cloud SQL and AlloyDB</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/self_managed/00_choose_setup_method"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="/_astro/logo_postgres.BpcazhJg.svg" alt="Logo of Self-Managed"/>Self-Managed</div><div class="vC7sGW_overviewInstallChoiceProviderText">VM, Container, On-Premise</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/heroku_postgres/01_deploy_the_collector"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="data:image/svg+xml,%3csvg%20xmlns='http://www.w3.org/2000/svg'%20width='72'%20height='80'%20viewBox='0%200%2072%2080'%3e%3cpath%20fill='%23430098'%20d='M64.8,0%20L7.2,0%20C3.224,0%200,3.224%200,7.2%20L0,72.8%20C0,76.776%203.224,80%207.2,80%20L64.8,80%20C68.776,80%2072,76.776%2072,72.8%20L72,7.2%20C72,3.224%2068.776,0%2064.8,0%20Z%20M18,68%20L18,52%20L27,60%20L18,68%20Z%20M46,68%20L46,44.11%20C45.961,42.243%2045.062,40%2041,40%20C32.866,40%2023.742,44.091%2023.651,44.132%20L18,46.692%20L18,12%20L26,12%20L26,34.711%20C29.994,33.411%2035.577,32%2041,32%20C45.945,32%2048.905,33.944%2050.517,35.575%20C53.958,39.055%2054.005,43.488%2054.0002258,44%20L54.0002258,68%20L46,68%20Z%20M48,25%20L40,25%20C43.144,20.875%2045.118,16.534%2046,12%20L54,12%20C53.46,16.544%2051.618,20.9%2048,25%20Z'/%3e%3c/svg%3e" alt="Logo of Heroku"/>Heroku</div><div class="vC7sGW_overviewInstallChoiceProviderText">Heroku Postgres</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/crunchy_bridge/01_deploy_the_collector"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="/_astro/logo_crunchy_bridge.CovypjLG.svg" alt="Logo of Crunchy Data"/>Crunchy Data</div><div class="vC7sGW_overviewInstallChoiceProviderText">Crunchy Bridge</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/aiven/01_create_monitoring_user"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="/_astro/logo_aiven.rq0lg_xj.svg" alt="Logo of Aiven"/>Aiven</div><div class="vC7sGW_overviewInstallChoiceProviderText">Managed PostgreSQL</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/supabase/01_enable_pg_stat_statements"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="data:image/svg+xml,%3csvg%20role='img'%20viewBox='0%200%2024%2024'%20xmlns='http://www.w3.org/2000/svg'%3e%3ctitle%3eSupabase%3c/title%3e%3cpath%20fill='%233ECF8E'%20d='M11.9%201.036c-.015-.986-1.26-1.41-1.874-.637L.764%2012.05C-.33%2013.427.65%2015.455%202.409%2015.455h9.579l.113%207.51c.014.985%201.259%201.408%201.873.636l9.262-11.653c1.093-1.375.113-3.403-1.645-3.403h-9.642z'/%3e%3c/svg%3e" alt="Logo of Supabase"/>Supabase</div><div class="vC7sGW_overviewInstallChoiceProviderText">Managed Postgres Platform</div></a><a class="vC7sGW_overviewInstallChoiceStep" href="/docs/install/neon/01_enable_pg_stat_statements"><div class="vC7sGW_overviewInstallChoiceProvider"><img src="data:image/svg+xml,%3csvg%20width='64'%20height='64'%20viewBox='0%200%2064%2064'%20fill='none'%20xmlns='http://www.w3.org/2000/svg'%3e%3cpath%20d='M63%200.0177909V63.5526L38.4178%2042.2501V63.5526H0V0L63%200.0177909ZM7.72251%2055.8389H30.6953V25.3238L55.2779%2047.0476V7.72922L7.72251%207.71559V55.8389Z'%20fill='%2337C38F'/%3e%3c/svg%3e" alt="Logo of Neon"/>Neon</div><div class="vC7sGW_overviewInstallChoiceProviderText">Serverless Postgres</div></a></div> 21 22<p>If youâre interested in integrating pganalyze with your database hosting provider but donât see it listed as officially supported, you can follow the <a href="docs/install/self_managed/01_create_monitoring_user">manual installation guide for self-managed databases</a>. You will need to run the pganalyze collector on a server with network connectivity to your database in order to monitor your database. Note that system-level statistics (memory usage, I/O, etc.) cannot be collected this way and will not be available in pganalyze. <a href="/docs/log-insights">Log Insights</a> (and the features that depend on it) is only available if your provider exports Postgres logs for your database server <a href="/docs/log-insights/setup/syslog-server">via syslog</a>.</p> 23<h2 id="explore-how-pganalyze-works"><a href="#explore-how-pganalyze-works" data-anchor="true" aria-hidden="true" tabindex="-1"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512" aria-hidden="true" role="img">
23<path fill="currentColor" d="M419.5 96c-16.6 0-32.7 4.5-46.8 12.7-15.8-16-34.2-29.4-54.5-39.5 28.2-24 64.1-37.2 101.3-37.2 86.4 0 156.5 70 156.5 156.5 0 41.5-16.5 81.3-45.8 110.6l-71.1 71.1c-29.3 29.3-69.1 45.8-110.6 45.8-86.4 0-156.5-70-156.5-156.5 0-1.5 0-3 .1-4.5 .5-17.7 15.2-31.6 32.9-31.1s31.6 15.2 31.1 32.9c0 .9 0 1.8 0 2.6 0 51.1 41.4 92.5 92.5 92.5 24.5 0 48-9.7 65.4-27.1l71.1-71.1c17.3-17.3 27.1-40.9 27.1-65.4 0-51.1-41.4-92.5-92.5-92.5zM275.2 173.3c-1.9-.8-3.8-1.9-5.5-3.1-12.6-6.5-27-10.2-42.1-10.2-24.5 0-48 9.7-65.4 27.1L91.1 258.2c-17.3 17.3-27.1 40.9-27.1 65.4 0 51.1 41.4 92.5 92.5 92.5 16.5 0 32.6-4.4 46.7-12.6 15.8 16 34.2 29.4 54.6 39.5-28.2 23.9-64 37.2-101.3 37.2-86.4 0-156.5-70-156.5-156.5 0-41.5 16.5-81.3 45.8-110.6l71.1-71.1c29.3-29.3 69.1-45.8 110.6-45.8 86.6 0 156.5 70.6 156.5 156.9 0 1.3 0 2.6 0 3.9-.4 17.7-15.1 31.6-32.8 31.2s-31.6-15.1-31.2-32.8c0-.8 0-1.5 0-2.3 0-33.7-18-63.3-44.8-79.6z"></path></svg></a>Explore how pganalyze works</h2> 24<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/index-advisor/getting-started" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>pganalyze Index Advisor</strong> 25Automatically finds missing indexes and unused index insights</p></a><a href="/docs/indexing-engine" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Indexing Engine</strong> 26Extracts table scans and identifies missing indexes using âWhat If?â analysis</p></a></div> 27<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/vacuum-advisor" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>pganalyze VACUUM Advisor</strong> 28Workload-aware autovacuum tuning and insights for Postgres</p></a><a href="/docs/checks" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Alerts & Check-Up</strong> 29Detects common database problems and notifies via email, Slack and PagerDuty</p></a></div> 30<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/connections" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Connections</strong> 31Monitors wait events, lock problems and other activity in near-realtime</p></a><a href="/docs/explain" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>EXPLAIN</strong> 32Collects query plans for slow Postgres queries and finds insights</p></a></div> 33<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/schema-statistics" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Schema Statistics</strong> 34Tracks workload patterns, schema and data model design, as well as changes over time</p></a><a href="/docs/query-performance" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Query Performance</strong> 35Identify slowdowns for specific queries over time</p></a></div> 36<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/log-insights" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Log Insights</strong> 37Continuously monitors your Postgres error log for unexpected events</p></a></div> 38<h2 id="manage-your-pganalyze-installation"><a href="#manage-your-pganalyze-installation" data-anchor="true" aria-hidden="true" tabindex="-1"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 576 512" aria-hidden="true" role="img"><path fill="currentColor" d="M419.5 96c-16.6 0-32.7 4.5-46.8 12.7-15.8-16-34.2-29.4-54.5-39.5 28.2-24 64.1-37.2 101.3-37.2 86.4 0 156.5 70 156.5 156.5 0 41.5-16.5 81.3-45.8 110.6l-71.1 71.1c-29.3 29.3-69.1 45.8-110.6 45.8-86.4 0-156.5-70-156.5-156.5 0-1.5 0-3 .1-4.5 .5-17.7 15.2-31.6 32.9-31.1s31.6 15.2 31.1 32.9c0 .9 0 1.8 0 2.6 0 51.1 41.4 92.5 92.5 92.5 24.5 0 48-9.7 65.4-27.1l71.1-71.1c17.3-17.3 27.1-40.9 27.1-65.4 0-51.1-41.4-92.5-92.5-92.5zM275.2 173.3c-1.9-.8-3.8-1.9-5.5-3.1-12.6-6.5-27-10.2-42.1-10.2-24.5 0-48 9.7-65.4 27.1L91.1 258.2c-17.3 17.3-27.1 40.9-27.1 65.4 0 51.1 41.4 92.5 92.5 92.5 16.5 0 32.6-4.4 46.7-12.6 15.8 16 34.2 29.4 54.6 39.5-28.2 23.9-64 37.2-101.3 37.2-86.4 0-156.5-70-156.5-156.5 0-41.5 16.5-81.3 45.8-110.6l71.1-71.1c29.3-29.3 69.1-45.8 110.6-45.8 86.6 0 156.5 70.6 156.5 156.9 0 1.3 0 2.6 0 3.9-.4 17.7-15.1 31.6-32.8 31.2s-31.6-15.1-31.2-32.8c0-.8 0-1.5 0-2.3 0-33.7-18-63.3-44.8-79.6z"></path></svg></a>Manage your pganalyze installation</h2> 39<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/accounts" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>Account Management & SSO</strong> 40Manage accounts with different roles, and enable Single Sign-On through SAML</p></a><a href="/docs/enterprise" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>
40pganalyze Enterprise Server</strong> 41Install pganalyze as a fully self-hosted version behind your firewall</p></a></div> 42<div class="vC7sGW_overviewFeatureChoice"><a href="/docs/collector" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>pganalyze collector</strong> 43Configure the agent that runs within your environment to collect data</p></a><a href="/docs/api" class="vC7sGW_overviewFeatureChoiceStep"><p><strong>GraphQL API</strong> 44Retrieve data that is available in pganalyze programmatically</p></a></div></div><div class="docs-page-appendix"><hr>Couldn't find what you were looking for or want to talk about something specific?<br><a href="/contact">Start a conversation with us â</a></div></div><div id="docs-search-panel" role="region" aria-label="Search results"></div><p id="docs-search-live" class="docs-search-sr-only" role="status"></p></div></div></div><footer class="i3PfeG_footer"><div class="i3PfeG_footerMain pga-container"><div class="row"><div class="span8"><img width="180" src="/_astro/pga_rect_light.C_LAdX-o.svg" alt="Logo" class="i3PfeG_logo"><ul><li><a href="/contact">Contact</a></li><li><a href="/pricing">Plans & Pricing</a></li><li><a href="/resources">Resources</a></li><li><a href="/enterprise-postgres-monitoring">Enterprise</a></li><li><a href="/docs">Documentation</a></li><li><a href="/customers">Customer Stories</a></li><li><a href="/careers">Careers</a></li><li><a href="/index-advisor">Index Advisor</a></li><li><a href="/security">Security</a></li><li><a href="https://status.pganalyze.com">Status</a></li><li><a href="/format">Postgres Query Formatter</a></li><li><a href="/comparison">Compare pganalyze</a></li><li><a href="/terms">Terms of Service</a></li><li><a href="/privacy">Privacy Policy</a></li><li><a href="/newsletter">Newsletter</a></li><li><a href="/soc2">SOC 2 Type 2</a></li><li><a href="/do-not-sell-my-personal-information">Do Not Sell My Personal Information</a></li></ul></div><div class="span4"><h3>Get in touch</h3>Use the <a style="text-decoration: underline" href="/contact">contact us form</a> or email sales:<br><svg data-prefix="fas" data-icon="envelope" class="svg-inline--fa fa-envelope W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M48 64c-26.5 0-48 21.5-48 48 0 15.1 7.1 29.3 19.2 38.4l208 156c17.1 12.8 40.5 12.8 57.6 0l208-156c12.1-9.1 19.2-23.3 19.2-38.4 0-26.5-21.5-48-48-48L48 64zM0 196L0 384c0 35.3 28.7 64 64 64l384 0c35.3 0 64-28.7 64-64l0-188-198.4 148.8c-34.1 25.6-81.1 25.6-115.2 0L0 196z"></path></svg> <a href="mailto:[email protected]">[email protected]</a><br><br><h3>SOC 2 certification</h3> pganalyze is SOC 2 Type 2 certified<br><br><a href="https://www.aicpa.org/soc4so"><img src="/_astro/21972-312_SOC_NonCPA.Ds7liiik_tTX3V.webp" alt="pganalyze is SOC 2 Type 2 certified" loading="lazy" decoding="async" width="180" height="180" class="i3PfeG_soc2logo"></a></div></div></div><div class="i3PfeG_footerExtra"><div class="pga-container">© 2026 Duboce Labs, Inc.</div></div></footer></div></body></html>
44<script type="module" src="/_astro/DocsLayout.astro_astro_type_script_index_0_lang.BStI4kbJ.js"></script>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.