PageSourceSearch

https://pganalyze.com/

html pganalyze.com collected 2026-10-02 04:43:54 UTC 81,998 bytes, 13 lines download raw bytes

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>Postgres performance at any scale | PostgreSQL Tuning - 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/"><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="Postgres performance at any scale | PostgreSQL Tuning - pganalyze"><meta property="og:description" content="Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Start with a free trial today."><meta property="og:url" content="https://pganalyze.com"><meta property="og:image" content="https://pganalyze.com/og/pganalyze_OG_brand-any-scale.png"><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="Postgres performance at any scale | PostgreSQL Tuning - pganalyze"><meta name="twitter:description" content="Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Start with a free trial today."><meta name="twitter:image" content="https://pganalyze.com/og/pganalyze_OG_brand-any-scale.png">
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<link rel="stylesheet" href="/_astro/Footer.D5zThaES.css"><style>.W_cs5G_faIcon{width:1em;height:1em}
11.xM2mAG_customerLogos{justify-content:space-between;align-items:center;padding:20px;display:flex;position:absolute;left:0;right:0;overflow:hidden}.xM2mAG_customerLogosOuter{height:100px}@media (width<=979px){.xM2mAG_customerLogos{text-align:center;display:block;position:static}.xM2mAG_customerLogos div{margin-bottom:10px}.xM2mAG_customerLogosOuter{height:auto}}.xM2mAG_customerLogos img{flex-shrink:0;max-width:200px;max-height:50px;margin:0 30px;object-fit:contain!important}@media (width<=979px){.xM2mAG_customerLogos img{margin:0 auto;padding:15px;display:block}}.xM2mAG_customerLogos .xM2mAG_ipsy,.xM2mAG_customerLogos .xM2mAG_ipsyWhite{max-width:100px;margin-top:12px;opacity:.6!important}.xM2mAG_customerLogos .xM2mAG_productboard,.xM2mAG_customerLogos .xM2mAG_productboardWhite{opacity:.6!important}@media (width<=979px){.xM2mAG_customerLogos .xM2mAG_productboard{margin-top:5px;margin-bottom:10px}}.xM2mAG_customerLogos .xM2mAG_salsify,.xM2mAG_customerLogos .xM2mAG_salsifyWhite,.xM2mAG_customerLogos .xM2mAG_autotrader,.xM2mAG_customerLogos .xM2mAG_autotraderWhite,.xM2mAG_customerLogos .xM2mAG_fivetran,.xM2mAG_customerLogos .xM2mAG_fivetranWhite,.xM2mAG_customerLogos .xM2mAG_doorDash,.xM2mAG_customerLogos .xM2mAG_doorDashWhite{opacity:.6!important}.xM2mAG_customerLogos .xM2mAG_fuboTv,.xM2mAG_customerLogos .xM2mAG_fuboTvWhite{max-width:90px;height:50px;margin-bottom:5px;opacity:.6!important}.xM2mAG_customerLogos .xM2mAG_moodys,.xM2mAG_customerLogos .xM2mAG_moodysWhite{max-width:120px;height:50px;margin-bottom:3px;opacity:.6!important}.xM2mAG_customerLogos .xM2mAG_seniorLink,.xM2mAG_customerLogos .xM2mAG_seniorLinkWhite{max-width:150px;opacity:.6!important}.xM2mAG_customerLogos .xM2mAG_counterPath,.xM2mAG_customerLogos .xM2mAG_counterPathWhite{max-width:180px;margin-bottom:10px;opacity:.6!important}
12.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}}
13</style>
13<script type="module" src="/_astro/page.BXhJUpbf.js"></script>
13</head><body class="index"><div style="position: relative; z-index: 0;"><style>astro-island,astro-slot,astro-static-slot{display:contents}</style>
13<script>(()=>{var e=async t=>{await(await t())()};(self.Astro||(self.Astro={})).only=e;window.dispatchEvent(new Event("astro:only"));})();</script>
13<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>
13<astro-island uid="Z2bqbn1" component-url="/_astro/index.tTIRg0ao.js" component-export="default" renderer-url="/_astro/client.Dqz2Vqct.js" props="{}" ssr client="only" opts="{&quot;name&quot;:&quot;RememberUtmValues&quot;,&quot;value&quot;:&quot;react&quot;}"></astro-island>
13<script>(()=>{var e=async t=>{await(await t())()};(self.Astro||(self.Astro={})).load=e;window.dispatchEvent(new Event("astro:load"));})();</script>
13<astro-island uid="Z9Usot" prefix="r3" component-url="/_astro/island.BVbcwnRW.js" component-export="default" renderer-url="/_astro/client.Dqz2Vqct.js" props="{&quot;title&quot;:[0,&quot;Postgres performance at any scale&quot;],&quot;description&quot;:[0,&quot;Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling.&quot;],&quot;currentPath&quot;:[0,&quot;/&quot;],&quot;images&quot;:[0,{&quot;explainPlan&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/explain_plan.CFVEDHAb_Z50fPy.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/explain_plan.CFVEDHAb_ZnugQT.webp 800w, /_astro/explain_plan.CFVEDHAb_BVBwG.webp 1600w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,500]}],&quot;indexAdvisor&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/pganalyze_index_advisor.26Wcploh_Z2124oW.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/pganalyze_index_advisor.26Wcploh_Cd7Sq.webp 800w, /_astro/pganalyze_index_advisor.26Wcploh_2kh33y.webp 1600w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,500]}],&quot;queryDetails&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/query_details2.Bq3vaU6a_Z90qMS.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/query_details2.Bq3vaU6a_1hMPRN.webp 800w, /_astro/query_details2.Bq3vaU6a_Z90qMS.webp 1342w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,720]}],&quot;autovacuum&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/autovacuum_monitoring.BGQKfopp_hBQCM.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/autovacuum_monitoring.BGQKfopp_Z1I4JTj.webp 800w, /_astro/autovacuum_monitoring.BGQKfopp_2tRpaN.webp 1600w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,588]}],&quot;logInsights&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/log_insights.D3s9SA5k_lMdr5.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/log_insights.D3s9SA5k_Z1u52XY.webp 800w, /_astro/log_insights.D3s9SA5k_ZymAId.webp 1600w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,531]}],&quot;datePicker&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/pganalyze_query_performance_date_picker.DwamE5z3_ZGPApC.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/pganalyze_query_performance_date_picker.DwamE5z3_mHgPW.webp 800w, /_astro/pganalyze_query_performance_date_picker.DwamE5z3_Z2j2RVx.webp 1600w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,384]}],&quot;architecture&quot;:[0,{&quot;src&quot;:[0,&quot;/_astro/architecture_diagram.KD-ruegI_Z1IyWdy.webp&quot;],&quot;srcSet&quot;:[0,&quot;/_astro/architecture_diagram.KD-ruegI_Z13DQEm.webp 800w, /_astro/architecture_diagram.KD-ruegI_Z1IyWdy.webp 1476w&quot;],&quot;sizes&quot;:[0,&quot;800px&quot;],&quot;width&quot;:[0,800],&quot;height&quot;:[0,624]}]}]}" ssr client="load" opts="{&quot;name&quot;:&quot;FeaturePageMainIsland&quot;,&quot;value&quot;: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"><span class="text-[16px]/[1.3] group-hover:text-stardust-500 group-focus-visible:text-stardust-500 text-sand-100">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">
13<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"><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">
13<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"><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">
13<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"><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">
13Free 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="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"><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">
13<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"><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">
13<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"><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">
13Free 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="landing-index--top"><div class="content--grid"><div class="landing-index--teaser"><h1 class="landing-index--heading">Postgres performance at any scale</h1><p>Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling.</p><div class="landing-index--actions"><a href="https://app.pganalyze.com/users/sign_up" class="btn btn-success"><strong>Start Free Trial</strong></a><a href="/product-tour" class="btn"><strong>Tour the Product</strong></a></div><small>Integrates with Amazon Web Services, Google Cloud Platform, Microsoft Azure, and more.</small></div><div class="content--feature-image content--feature-image--right"><div class="svg-animation-wrapper"><div class="svg-container illustration-query-performance"><img src="/_astro/illustration_query_performance.Bdx9FTz6.svg" alt="Illustration Query Performance"/></div><div class="svg-container illustration-explain-plan"><img src="/_astro/illustration_explain_plan.CsPaz6iv.svg" alt="Illustration EXPLAIN Plan"/></div><div class="svg-container illustration-index-advisor"><img src="/_astro/illustration_index_advisor_missing_index.DoU3TOET.svg" alt="Illustration Index Advisor Missing Index"/></div></div></div><div class="landing-index--satellite"><img src="/_astro/key-illu-satelite.r65X0Gvd.svg" alt=""/></div><div class="landing-index--customer-logos"><div class="xM2mAG_customerLogosOuter"><div class="xM2mAG_customerLogos"><div><img class="xM2mAG_productboardWhite" src="/_astro/productboard_white.BboGVWlk.png" alt="Productboard" width="200" height="25" loading="lazy"/></div><div><img class="xM2mAG_autotraderWhite" src="/_astro/autotrader_white.InoI7Agr.png" alt="Autotrader" width="200" height="24" loading="lazy"/></div><div><img class="xM2mAG_moodysWhite" src="/_astro/moodys_white.CCkzCvGf.png" alt="Moody’s" width="240" height="50" loading="lazy"/></div><div><img class="xM2mAG_salsifyWhite" src="/_astro/salsify_white.DJCj94XK.png" alt="Salsify" width="200" height="53" loading="lazy"/></div><div><img class="xM2mAG_fivetranWhite" src="/_astro/fivetran_white.v11BW2MA.png" alt="Fivetran" width="160" height="45" loading="lazy"/></div><div><img class="xM2mAG_fuboTvWhite" src="/_astro/fubotv_white.BtLFHOwx.png" alt="fuboTv" width="177" height="60" loading="lazy"/></div></div></div></div></div></div>
13<div class="L8lE7q_headerBackgroundGradient"></div><div class="L8lE7q_headerBackgroundImage"></div></div><div class="pga-container page-container"><div class="landing-index"><div class="page-content"><div class="content--grid"><div class="content--feature-text"><h3>Take control of your Postgres workload and query plans</h3><a href="/postgres-explain">Learn more about automatic collection and insights into Postgres Query Plans →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="magnifying-glass" class="svg-inline--fa fa-magnifying-glass W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376C296.3 401.1 253.9 416 208 416 93.1 416 0 322.9 0 208S93.1 0 208 0 416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg>In-depth Postgres observability</h4><p>Drill down into detailed per-query statistics and benefit from insights into your query performance history to detect slow queries.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="diagram-project" class="svg-inline--fa fa-diagram-project W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M0 80C0 53.5 21.5 32 48 32l96 0c26.5 0 48 21.5 48 48l0 16 128 0 0-16c0-26.5 21.5-48 48-48l96 0c26.5 0 48 21.5 48 48l0 96c0 26.5-21.5 48-48 48l-96 0c-26.5 0-48-21.5-48-48l0-16-128 0 0 16c0 7.3-1.7 14.3-4.6 20.5l68.6 91.5 80 0c26.5 0 48 21.5 48 48l0 96c0 26.5-21.5 48-48 48l-96 0c-26.5 0-48-21.5-48-48l0-96c0-7.3 1.7-14.3 4.6-20.5L128 224 48 224c-26.5 0-48-21.5-48-48L0 80z"></path></svg>Analyze EXPLAIN plans over time</h4><p>Automatically collect your EXPLAIN plans with auto_explain, and get detailed insights based on query plans gathered from your database.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="radar" class="svg-inline--fa fa-radar W_cs5G_faIcon" 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>Find root causes of slow queries</h4><p>Understand why a query is slow and get tuning recommendations on how to make the query faster.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="server" class="svg-inline--fa fa-server W_cs5G_faIcon" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M64 32C28.7 32 0 60.7 0 96l0 64c0 35.3 28.7 64 64 64l320 0c35.3 0 64-28.7 64-64l0-64c0-35.3-28.7-64-64-64L64 32zm216 72a24 24 0 1 1 0 48 24 24 0 1 1 0-48zm56 24a24 24 0 1 1 48 0 24 24 0 1 1 -48 0zM64 288c-35.3 0-64 28.7-64 64l0 64c0 35.3 28.7 64 64 64l320 0c35.3 0 64-28.7 64-64l0-64c0-35.3-28.7-64-64-64L64 288zm216 72a24 24 0 1 1 0 48 24 24 0 1 1 0-48zm56 24a24 24 0 1 1 48 0 24 24 0 1 1 -48 0z"></path></svg>Resolve database slowdowns</h4><p>Identify slowdowns for specific queries over time, I/O vs CPU time spent, and buffer cache hit ratio for each query.</p></div></div></div><div class="content--feature-image content--feature-image--right"><div class="content--feature-image--inner"><img src="/_astro/explain_plan.CFVEDHAb_Z50fPy.webp" srcSet="/_astro/explain_plan.CFVEDHAb_ZnugQT.webp 800w, /_astro/explain_plan.CFVEDHAb_BVBwG.webp 1600w" sizes="800px" width="800" height="500" alt="Screenshot of Query Plan visualization" loading="lazy"/></div></div><div class="content--feature-image content--feature-image--left"><div class="content--feature-image--inner">
13<img src="/_astro/pganalyze_index_advisor.26Wcploh_Z2124oW.webp" srcSet="/_astro/pganalyze_index_advisor.26Wcploh_Cd7Sq.webp 800w, /_astro/pganalyze_index_advisor.26Wcploh_2kh33y.webp 1600w" sizes="800px" width="800" height="500" alt="Screenshot of pganalyze Index Advisor for Postgres" loading="lazy"/></div></div><div class="content--feature-text"><h3>Discover tuning opportunities with automatic advisors</h3><a href="/postgres-index-advisor">Learn more about Postgres index recommendations with pganalyze Index Advisor →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="list" class="svg-inline--fa fa-list W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M40 48C26.7 48 16 58.7 16 72l0 48c0 13.3 10.7 24 24 24l48 0c13.3 0 24-10.7 24-24l0-48c0-13.3-10.7-24-24-24L40 48zM192 64c-17.7 0-32 14.3-32 32s14.3 32 32 32l288 0c17.7 0 32-14.3 32-32s-14.3-32-32-32L192 64zm0 160c-17.7 0-32 14.3-32 32s14.3 32 32 32l288 0c17.7 0 32-14.3 32-32s-14.3-32-32-32l-288 0zm0 160c-17.7 0-32 14.3-32 32s14.3 32 32 32l288 0c17.7 0 32-14.3 32-32s-14.3-32-32-32l-288 0zM16 232l0 48c0 13.3 10.7 24 24 24l48 0c13.3 0 24-10.7 24-24l0-48c0-13.3-10.7-24-24-24l-48 0c-13.3 0-24 10.7-24 24zM40 368c-13.3 0-24 10.7-24 24l0 48c0 13.3 10.7 24 24 24l48 0c13.3 0 24-10.7 24-24l0-48c0-13.3-10.7-24-24-24l-48 0z"></path></svg>pganalyze Index Advisor</h4><p>Automatically detects missing indexes and recommends single and multi-column indexes that improve query performance across your databases.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="diagram-project" class="svg-inline--fa fa-diagram-project W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M0 80C0 53.5 21.5 32 48 32l96 0c26.5 0 48 21.5 48 48l0 16 128 0 0-16c0-26.5 21.5-48 48-48l96 0c26.5 0 48 21.5 48 48l0 96c0 26.5-21.5 48-48 48l-96 0c-26.5 0-48-21.5-48-48l0-16-128 0 0 16c0 7.3-1.7 14.3-4.6 20.5l68.6 91.5 80 0c26.5 0 48 21.5 48 48l0 96c0 26.5-21.5 48-48 48l-96 0c-26.5 0-48-21.5-48-48l0-96c0-7.3 1.7-14.3 4.6-20.5L128 224 48 224c-26.5 0-48-21.5-48-48L0 80z"></path></svg>Based on reproducible logic</h4><p>The<!-- --> <a href="/postgres-indexing-engine">pganalyze Indexing Engine</a> <!-- -->tries out hundreds of index combinations using its &quot;What If?&quot; analysis &amp; surfaces the most impactful opportunities.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="circle-notch" class="svg-inline--fa fa-circle-notch W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M222.7 32.1c5 16.9-4.6 34.8-21.5 39.8-79.3 23.6-137.1 97.1-137.1 184.1 0 106 86 192 192 192s192-86 192-192c0-86.9-57.8-160.4-137.1-184.1-16.9-5-26.6-22.9-21.5-39.8s22.9-26.6 39.8-21.5C434.9 42.1 512 140 512 256 512 397.4 397.4 512 256 512S0 397.4 0 256c0-116 77.1-213.9 182.9-245.4 16.9-5 34.8 4.6 39.8 21.5z"></path></svg>pganalyze VACUUM Advisor</h4><p>Provides per-table recommendations for autovacuum settings to optimize table bloat, freezing, VACUUM performance, and more.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="lightbulb" class="svg-inline--fa fa-lightbulb W_cs5G_faIcon" role="img" viewBox="0 0 384 512" aria-hidden="true"><path fill="currentColor" d="M296.5 291.1C321 265.2 336 230.4 336 192 336 112.5 271.5 48 192 48S48 112.5 48 192c0 38.4 15 73.2 39.5 99.1 21.3 22.4 44.9 54 53.3 92.9l102.4 0c8.4-39 32-70.5 53.3-92.9zm34.8 33C307.7 349 288 379.4 288 413.7l0 18.3c0 44.2-35.8 80-80 80l-32 0c-44.2 0-80-35.8-80-80l0-18.3C96 379.4 76.3 349 52.7 324.1 20 289.7 0 243.2 0 192 0 86 86 0 192 0S384 86 384 192c0 51.2-20 97.7-52.7 132.1zM144 184c0 13.3-10.7 24-24 24s-24-10.7-24-24c0-48.6 39.4-88 88-88 13.3 0 24 10.7 24 24s-10.7 24-24 24c-22.1 0-40 17.9-40 40z"></path></svg>Smart configuration tuning</h4><p>Discover effective config settings tailored to your database workload that enable you to achieve consistent Postgres performance and availability.</p></div></div></div><div class="content--feature-text"><h3>Empower all development teams to fix slow queries</h3><a href="/postgres-analyze-query-performance">
13Learn more about Postgres query analysis with pganalyze →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="chart-line" class="svg-inline--fa fa-chart-line W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M64 64c0-17.7-14.3-32-32-32S0 46.3 0 64L0 400c0 44.2 35.8 80 80 80l400 0c17.7 0 32-14.3 32-32s-14.3-32-32-32L80 416c-8.8 0-16-7.2-16-16L64 64zm406.6 86.6c12.5-12.5 12.5-32.8 0-45.3s-32.8-12.5-45.3 0L320 210.7 262.6 153.4c-12.5-12.5-32.8-12.5-45.3 0l-96 96c-12.5 12.5-12.5 32.8 0 45.3s32.8 12.5 45.3 0l73.4-73.4 57.4 57.4c12.5 12.5 32.8 12.5 45.3 0l128-128z"></path></svg>Greater developer productivity</h4><p>Give product and infrastructure engineers the right tool to understand and solve query performance issues.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="object-ungroup" class="svg-inline--fa fa-object-ungroup W_cs5G_faIcon" role="img" viewBox="0 0 640 512" aria-hidden="true"><path fill="currentColor" d="M48.2 66.8c-.1-.8-.2-1.7-.2-2.5l0-.2c0-8.8 7.2-16 16-16 .9 0 1.9 .1 2.8 .2 7.5 1.3 13.2 7.9 13.2 15.8 0 8.8-7.2 16-16 16-7.9 0-14.5-5.7-15.8-13.2zM0 64c0 26.9 16.5 49.9 40 59.3l0 105.3c-23.5 9.5-40 32.5-40 59.3 0 35.3 28.7 64 64 64 26.9 0 49.9-16.5 59.3-40l201.3 0c9.5 23.5 32.5 40 59.3 40 35.3 0 64-28.7 64-64 0-26.9-16.5-49.9-40-59.3l0-105.3c23.5-9.5 40-32.5 40-59.3 0-35.3-28.7-64-64-64-26.9 0-49.9 16.5-59.3 40L123.3 40C113.9 16.5 90.9 0 64 0 28.7 0 0 28.7 0 64zm368 0a16 16 0 1 1 32 0 16 16 0 1 1 -32 0zM324.7 88c6.5 16 19.3 28.9 35.3 35.3l0 105.3c-16 6.5-28.9 19.3-35.3 35.3l-201.3 0c-6.5-16-19.3-28.9-35.3-35.3l0-105.3c16-6.5 28.9-19.3 35.3-35.3l201.3 0zM384 272a16 16 0 1 1 0 32 16 16 0 1 1 0-32zM80 288c0 7.9-5.7 14.5-13.2 15.8-.8 .1-1.7 .2-2.5 .2l-.2 0c-8.8 0-16-7.2-16-16 0-.9 .1-1.9 .2-2.8 1.3-7.5 7.9-13.2 15.8-13.2 8.8 0 16 7.2 16 16zm436.7-40c6.5 16 19.3 28.9 35.3 35.3l0 105.3c-16 6.5-28.9 19.3-35.3 35.3l-201.3 0c-6.5-16-19.3-28.9-35.3-35.3l0-20.7-48 0 0 20.7c-23.5 9.5-40 32.5-40 59.3 0 35.3 28.7 64 64 64 26.9 0 49.9-16.5 59.3-40l201.3 0c9.5 23.5 32.5 40 59.3 40 35.3 0 64-28.7 64-64 0-26.9-16.5-49.9-40-59.3l0-105.3c23.5-9.5 40-32.5 40-59.3 0-35.3-28.7-64-64-64-26.9 0-49.9 16.5-59.3 40l-52.7 0 0 9.6c10.7 10.9 19.1 23.9 24.6 38.4l28 0zm59.3-8a16 16 0 1 1 0-32 16 16 0 1 1 0 32zM271.8 450.7a16 16 0 1 1 -31.5-5.5 16 16 0 1 1 31.5 5.5zm301.5 13c-7.5-1.3-13.2-7.9-13.2-15.8 0-8.8 7.2-16 16-16 7.9 0 14.5 5.7 15.8 13.2l0 .1c.1 .9 .2 1.8 .2 2.7 0 8.8-7.2 16-16 16-.9 0-1.9-.1-2.8-.2z"></path></svg>Prevent information silos</h4><p>Slow queries can be hidden by ORM calls in the application code. Identify them with query tags in pganalyze.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="radar" class="svg-inline--fa fa-radar W_cs5G_faIcon" 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>Pinpoint slow queries</h4><p>Help your teams understand why a query is slow &amp; get recommendations on how to make the query faster.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="user" class="svg-inline--fa fa-user W_cs5G_faIcon" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M144 128a80 80 0 1 1 160 0 80 80 0 1 1 -160 0zm208 0a128 128 0 1 0 -256 0 128 128 0 1 0 256 0zM48 480c0-70.7 57.3-128 128-128l96 0c70.7 0 128 57.3 128 128l0 8c0 13.3 10.7 24 24 24s24-10.7 24-24l0-8c0-97.2-78.8-176-176-176l-96 0C78.8 304 0 382.8 0 480l0 8c0 13.3 10.7 24 24 24s24-10.7 24-24l0-8z"></path></svg>Collaborate without limits</h4><p>Enable all your teams to work on improving Postgres performance with Single Sign-On and unlimited users.</p></div></div></div><div class="content--feature-image content--feature-image--right"><div class="content--feature-image--inner"><img src="/_astro/query_details2.Bq3vaU6a_Z90qMS.webp" srcSet="/_astro/query_details2.Bq3vaU6a_1hMPRN.webp 800w, /_astro/query_details2.Bq3vaU6a_Z90qMS.webp 1342w" sizes="800px" width="800" height="720" alt="Screenshot of Query Details page" loading="lazy"/></div></div><div class="content--feature-image content--feature-image--left"><div class="content--feature-image--inner"><img src="/_astro/autovacuum_monitoring.BGQKfopp_hBQCM.webp" srcSet="/_astro/autovacuum_monitoring.BGQKfopp_Z1I4JTj.webp 800w, /_astro/autovacuum_monitoring.BGQKfopp_2tRpaN.webp 1600w" sizes="800px" width="800" height="588" alt="Screenshot of Autovacuum Monitoring" loading="lazy"/></div></div><div class="content--feature-text"><h3>Database visualization and sophisticated dashboards</h3><a href="/postgresql-database-performance-visualization">Learn more about Postgres monitoring with pganalyze →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="terminal" class="svg-inline--fa fa-terminal W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true">
13<path fill="currentColor" d="M9.4 118.6c-12.5-12.5-12.5-32.8 0-45.3s32.8-12.5 45.3 0l160 160c12.5 12.5 12.5 32.8 0 45.3l-160 160c-12.5 12.5-32.8 12.5-45.3 0s-12.5-32.8 0-45.3L146.7 256 9.4 118.6zM224 384l256 0c17.7 0 32 14.3 32 32s-14.3 32-32 32l-256 0c-17.7 0-32-14.3-32-32s14.3-32 32-32z"></path></svg>Avoid CLI tools</h4><p>Uncover root causes to issues in minutes and stop wasting time with command line tools.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="laptop" class="svg-inline--fa fa-laptop W_cs5G_faIcon" role="img" viewBox="0 0 640 512" aria-hidden="true"><path fill="currentColor" d="M128 32C92.7 32 64 60.7 64 96l0 240 64 0 0-240 384 0 0 240 64 0 0-240c0-35.3-28.7-64-64-64L128 32zM19.2 384C8.6 384 0 392.6 0 403.2 0 445.6 34.4 480 76.8 480l486.4 0c42.4 0 76.8-34.4 76.8-76.8 0-10.6-8.6-19.2-19.2-19.2L19.2 384z"></path></svg>One single platform</h4><p>View your logs and query statistics in one single platform and monitor your key metrics in real-time.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="chart-line" class="svg-inline--fa fa-chart-line W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M64 64c0-17.7-14.3-32-32-32S0 46.3 0 64L0 400c0 44.2 35.8 80 80 80l400 0c17.7 0 32-14.3 32-32s-14.3-32-32-32L80 416c-8.8 0-16-7.2-16-16L64 64zm406.6 86.6c12.5-12.5 12.5-32.8 0-45.3s-32.8-12.5-45.3 0L320 210.7 262.6 153.4c-12.5-12.5-32.8-12.5-45.3 0l-96 96c-12.5 12.5-12.5 32.8 0 45.3s32.8 12.5 45.3 0l73.4-73.4 57.4 57.4c12.5 12.5 32.8 12.5 45.3 0l128-128z"></path></svg>Trend analysis</h4><p>Analyze meaningful trends and get insights into your query performance history.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="wrench" class="svg-inline--fa fa-wrench W_cs5G_faIcon" role="img" viewBox="0 0 576 512" aria-hidden="true"><path fill="currentColor" d="M509.4 98.6c7.6-7.6 20.3-5.7 24.1 4.3 6.8 17.7 10.5 37 10.5 57.1 0 88.4-71.6 160-160 160-17.5 0-34.4-2.8-50.2-8L146.9 498.9c-28.1 28.1-73.7 28.1-101.8 0s-28.1-73.7 0-101.8L232 210.2c-5.2-15.8-8-32.6-8-50.2 0-88.4 71.6-160 160-160 20.1 0 39.4 3.7 57.1 10.5 10 3.8 11.8 16.5 4.3 24.1l-88.7 88.7c-3 3-4.7 7.1-4.7 11.3l0 41.4c0 8.8 7.2 16 16 16l41.4 0c4.2 0 8.3-1.7 11.3-4.7l88.7-88.7z"></path></svg>Tuning recommendations</h4><p>Collect detailed insights and receive tuning recommendations for your per-table autovacuum configuration.</p></div></div></div><div class="content--feature-text"><h3>Clear understanding of logs with pganalyze Log Insights</h3><a href="/log-insights">Learn more about pganalyze Log Insights →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="list" class="svg-inline--fa fa-list W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M40 48C26.7 48 16 58.7 16 72l0 48c0 13.3 10.7 24 24 24l48 0c13.3 0 24-10.7 24-24l0-48c0-13.3-10.7-24-24-24L40 48zM192 64c-17.7 0-32 14.3-32 32s14.3 32 32 32l288 0c17.7 0 32-14.3 32-32s-14.3-32-32-32L192 64zm0 160c-17.7 0-32 14.3-32 32s14.3 32 32 32l288 0c17.7 0 32-14.3 32-32s-14.3-32-32-32l-288 0zm0 160c-17.7 0-32 14.3-32 32s14.3 32 32 32l288 0c17.7 0 32-14.3 32-32s-14.3-32-32-32l-288 0zM16 232l0 48c0 13.3 10.7 24 24 24l48 0c13.3 0 24-10.7 24-24l0-48c0-13.3-10.7-24-24-24l-48 0c-13.3 0-24 10.7-24 24zM40 368c-13.3 0-24 10.7-24 24l0 48c0 13.3 10.7 24 24 24l48 0c13.3 0 24-10.7 24-24l0-48c0-13.3-10.7-24-24-24l-48 0z"></path></svg>Structured data</h4><p>Log Insights automatically extracts the logs into structured data, and filters any sensitive information.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="plug" class="svg-inline--fa fa-plug W_cs5G_faIcon" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M128-32c17.7 0 32 14.3 32 32l0 96 128 0 0-96c0-17.7 14.3-32 32-32s32 14.3 32 32l0 96 64 0c17.7 0 32 14.3 32 32s-14.3 32-32 32l0 64c0 95.1-69.2 174.1-160 189.3l0 66.7c0 17.7-14.3 32-32 32s-32-14.3-32-32l0-66.7C101.2 398.1 32 319.1 32 224l0-64c-17.7 0-32-14.3-32-32S14.3 96 32 96l64 0 0-96c0-17.7 14.3-32 32-32z"></path></svg>auto_explain integration</h4><p>Automatically extract the output for the auto_explain extension that comes bundled with Postgres.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="eye" class="svg-inline--fa fa-eye W_cs5G_faIcon" role="img" viewBox="0 0 576 512" aria-hidden="true">
13<path fill="currentColor" d="M288 80C222.8 80 169.2 109.6 128.1 147.7 89.6 183.5 63 226 49.4 256 63 286 89.6 328.5 128.1 364.3 169.2 402.4 222.8 432 288 432s118.8-29.6 159.9-67.7C486.4 328.5 513 286 526.6 256 513 226 486.4 183.5 447.9 147.7 406.8 109.6 353.2 80 288 80zM95.4 112.6C142.5 68.8 207.2 32 288 32s145.5 36.8 192.6 80.6c46.8 43.5 78.1 95.4 93 131.1 3.3 7.9 3.3 16.7 0 24.6-14.9 35.7-46.2 87.7-93 131.1-47.1 43.7-111.8 80.6-192.6 80.6S142.5 443.2 95.4 399.4c-46.8-43.5-78.1-95.4-93-131.1-3.3-7.9-3.3-16.7 0-24.6 14.9-35.7 46.2-87.7 93-131.1zM288 336c44.2 0 80-35.8 80-80 0-29.6-16.1-55.5-40-69.3-1.4 59.7-49.6 107.9-109.3 109.3 13.8 23.9 39.7 40 69.3 40zm-79.6-88.4c2.5 .3 5 .4 7.6 .4 35.3 0 64-28.7 64-64 0-2.6-.2-5.1-.4-7.6-37.4 3.9-67.2 33.7-71.1 71.1zm45.6-115c10.8-3 22.2-4.5 33.9-4.5 8.8 0 17.5 .9 25.8 2.6 .3 .1 .5 .1 .8 .2 57.9 12.2 101.4 63.7 101.4 125.2 0 70.7-57.3 128-128 128-61.6 0-113-43.5-125.2-101.4-1.8-8.6-2.8-17.5-2.8-26.6 0-11 1.4-21.8 4-32 .2-.7 .3-1.3 .5-1.9 11.9-43.4 46.1-77.6 89.5-89.5z"></path></svg>Postgres vacuum monitoring</h4><p>Automatically combine information about vacuum logs with statistics data, and see it in one unified interface.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="filter" class="svg-inline--fa fa-filter W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M32 64C19.1 64 7.4 71.8 2.4 83.8S.2 109.5 9.4 118.6L192 301.3 192 416c0 8.5 3.4 16.6 9.4 22.6l64 64c9.2 9.2 22.9 11.9 34.9 6.9S320 492.9 320 480l0-178.7 182.6-182.6c9.2-9.2 11.9-22.9 6.9-34.9S492.9 64 480 64L32 64z"></path></svg>Careful PII filtering</h4><p>Thanks to over 100 log filters, pganalyze filters PII from the log messages before it gets stored.</p></div></div></div><div class="content--feature-image content--feature-image--right"><div class="content--feature-image--inner"><img src="/_astro/log_insights.D3s9SA5k_lMdr5.webp" srcSet="/_astro/log_insights.D3s9SA5k_Z1u52XY.webp 800w, /_astro/log_insights.D3s9SA5k_ZymAId.webp 1600w" sizes="800px" width="800" height="531" alt="Example of Log Insights" loading="lazy"/></div></div><div class="content--feature-image content--feature-image--left"><div class="content--feature-image--inner"><img src="/_astro/pganalyze_query_performance_date_picker.DwamE5z3_ZGPApC.webp" srcSet="/_astro/pganalyze_query_performance_date_picker.DwamE5z3_mHgPW.webp 800w, /_astro/pganalyze_query_performance_date_picker.DwamE5z3_Z2j2RVx.webp 1600w" sizes="800px" width="800" height="384" alt="Screenshot of Query Performance Dashboard with date picker" loading="lazy"/></div></div><div class="content--feature-text"><h3>Performance optimization for your Postgres databases</h3><a href="/postgres-performance-optimization">Learn more about Postgres performance optimization with pganalyze →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="chart-line" class="svg-inline--fa fa-chart-line W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true"><path fill="currentColor" d="M64 64c0-17.7-14.3-32-32-32S0 46.3 0 64L0 400c0 44.2 35.8 80 80 80l400 0c17.7 0 32-14.3 32-32s-14.3-32-32-32L80 416c-8.8 0-16-7.2-16-16L64 64zm406.6 86.6c12.5-12.5 12.5-32.8 0-45.3s-32.8-12.5-45.3 0L320 210.7 262.6 153.4c-12.5-12.5-32.8-12.5-45.3 0l-96 96c-12.5 12.5-12.5 32.8 0 45.3s32.8 12.5 45.3 0l73.4-73.4 57.4 57.4c12.5 12.5 32.8 12.5 45.3 0l128-128z"></path></svg>Comparison over time</h4><p>Get easy access to historic data, and zoom into specific moments of your database server performance.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="wrench" class="svg-inline--fa fa-wrench W_cs5G_faIcon" role="img" viewBox="0 0 576 512" aria-hidden="true"><path fill="currentColor" d="M509.4 98.6c7.6-7.6 20.3-5.7 24.1 4.3 6.8 17.7 10.5 37 10.5 57.1 0 88.4-71.6 160-160 160-17.5 0-34.4-2.8-50.2-8L146.9 498.9c-28.1 28.1-73.7 28.1-101.8 0s-28.1-73.7 0-101.8L232 210.2c-5.2-15.8-8-32.6-8-50.2 0-88.4 71.6-160 160-160 20.1 0 39.4 3.7 57.1 10.5 10 3.8 11.8 16.5 4.3 24.1l-88.7 88.7c-3 3-4.7 7.1-4.7 11.3l0 41.4c0 8.8 7.2 16 16 16l41.4 0c4.2 0 8.3-1.7 11.3-4.7l88.7-88.7z"></path></svg>Tuning recommendations</h4><p>Set up automated checks that analyze your Postgres configuration and suggest optimizations.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="magnifying-glass" class="svg-inline--fa fa-magnifying-glass W_cs5G_faIcon" role="img" viewBox="0 0 512 512" aria-hidden="true">
13<path fill="currentColor" d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376C296.3 401.1 253.9 416 208 416 93.1 416 0 322.9 0 208S93.1 0 208 0 416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg>Per-table detection</h4><p>pganalyze detects per-table configuration, for example for table-specific autovacuum settings.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="chart-pie" class="svg-inline--fa fa-chart-pie W_cs5G_faIcon" role="img" viewBox="0 0 576 512" aria-hidden="true"><path fill="currentColor" d="M512.4 240l-176 0c-17.7 0-32-14.3-32-32l0-176c0-17.7 14.4-32.2 31.9-29.9 107 14.2 191.8 99 206 206 2.3 17.5-12.2 31.9-29.9 31.9zM222.6 37.2c18.1-3.8 33.8 11 33.8 29.5l0 197.3c0 5.6 2 11 5.5 15.3L394 438.7c11.7 14.1 9.2 35.4-6.9 44.1-34.1 18.6-73.2 29.2-114.7 29.2-132.5 0-240-107.5-240-240 0-115.5 81.5-211.9 190.2-234.8zM477.8 288l64 0c18.5 0 33.3 15.7 29.5 33.8-10.2 48.4-35 91.4-69.6 124.2-12.3 11.7-31.6 9.2-42.4-3.9L374.9 340.4c-17.3-20.9-2.4-52.4 24.6-52.4l78.2 0z"></path></svg>Buffer cache hit ratio</h4><p>Easily get insights into your buffer cache hit ratio for each query, over time.</p></div></div></div><div class="content--feature-text"><h3>Secure Postgres monitoring</h3><a href="/postgresql-security">Learn more about secure database monitoring with pganalyze →</a><div class="content--feature-benefit--container"><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="server" class="svg-inline--fa fa-server W_cs5G_faIcon" role="img" viewBox="0 0 448 512" aria-hidden="true"><path fill="currentColor" d="M64 32C28.7 32 0 60.7 0 96l0 64c0 35.3 28.7 64 64 64l320 0c35.3 0 64-28.7 64-64l0-64c0-35.3-28.7-64-64-64L64 32zm216 72a24 24 0 1 1 0 48 24 24 0 1 1 0-48zm56 24a24 24 0 1 1 48 0 24 24 0 1 1 -48 0zM64 288c-35.3 0-64 28.7-64 64l0 64c0 35.3 28.7 64 64 64l320 0c35.3 0 64-28.7 64-64l0-64c0-35.3-28.7-64-64-64L64 288zm216 72a24 24 0 1 1 0 48 24 24 0 1 1 0-48zm56 24a24 24 0 1 1 48 0 24 24 0 1 1 -48 0z"></path></svg>Running on-premise</h4><p>pganalyze can be run on-premise inside a Docker container behind your firewall, on your own servers.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="file-contract" class="svg-inline--fa fa-file-contract W_cs5G_faIcon" role="img" viewBox="0 0 384 512" aria-hidden="true"><path fill="currentColor" d="M0 64C0 28.7 28.7 0 64 0L213.5 0c17 0 33.3 6.7 45.3 18.7L365.3 125.3c12 12 18.7 28.3 18.7 45.3L384 448c0 35.3-28.7 64-64 64L64 512c-35.3 0-64-28.7-64-64L0 64zm208-5.5l0 93.5c0 13.3 10.7 24 24 24L325.5 176 208 58.5zM88 64C74.7 64 64 74.7 64 88s10.7 24 24 24l48 0c13.3 0 24-10.7 24-24s-10.7-24-24-24L88 64zm0 96c-13.3 0-24 10.7-24 24s10.7 24 24 24l48 0c13.3 0 24-10.7 24-24s-10.7-24-24-24l-48 0zm70.3 160c-11.3 0-21.9 5.1-28.9 13.9L69.3 409c-8.3 10.3-6.6 25.5 3.7 33.7s25.5 6.6 33.7-3.8l47.1-58.8 15.2 50.7c3 10.2 12.4 17.1 23 17.1l104 0c13.3 0 24-10.7 24-24s-10.7-24-24-24l-86.1 0-16.1-53.6c-4.7-15.7-19.1-26.4-35.5-26.4z"></path></svg>Comply with local policies</h4><p>Retain your database statistics data in the correct region of the world to comply with local policies.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="fas" data-icon="file-signature" class="svg-inline--fa fa-file-signature W_cs5G_faIcon" role="img" viewBox="0 0 640 512" aria-hidden="true"><path fill="currentColor" d="M64.1 64c0-35.3 28.7-64 64-64L277.6 0c17 0 33.3 6.7 45.3 18.7L429.3 125.3c12 12 18.7 28.3 18.7 45.3l0 97.5-132 132-42.1 0-16.1-53.6c-4.7-15.7-19.1-26.4-35.5-26.4-11.3 0-21.9 5.1-28.9 13.9L133.3 409c-8.3 10.3-6.6 25.5 3.7 33.7s25.5 6.6 33.7-3.8l47.1-58.8 15.2 50.7c3 10.2 12.4 17.1 23 17.1l31.5 0c-.9 3.1-1.7 6.3-2.3 9.5l-10.9 54.5-146.2 0c-35.3 0-64-28.7-64-64l0-384zm208-5.5l0 93.5c0 13.3 10.7 24 24 24l93.5 0-117.5-117.5zm60.2 408.4c2.5-12.4 8.6-23.8 17.5-32.7l118.9-118.9 80 80-118.9 118.9c-8.9 8.9-20.3 15-32.7 17.5l-59.6 11.9c-.9 .2-1.9 .3-2.9 .3-8 0-14.6-6.5-14.6-14.6 0-1 .1-1.9 .3-2.9l11.9-59.6zm267.8-123l-28.8 28.8-80-80 28.8-28.8c22.1-22.1 57.9-22.1 80 0s22.1 57.9 0 80z"></path></svg>Sensitive data</h4><p>pganalyze normalizes query information so that only structural data is stored and presented.</p></div><div class="content--feature-benefit"><h4><svg data-prefix="far" data-icon="user" class="svg-inline--fa fa-user W_cs5G_faIcon" role="img" viewBox="0 0 448 512" aria-hidden="true">
13<path fill="currentColor" d="M144 128a80 80 0 1 1 160 0 80 80 0 1 1 -160 0zm208 0a128 128 0 1 0 -256 0 128 128 0 1 0 256 0zM48 480c0-70.7 57.3-128 128-128l96 0c70.7 0 128 57.3 128 128l0 8c0 13.3 10.7 24 24 24s24-10.7 24-24l0-8c0-97.2-78.8-176-176-176l-96 0C78.8 304 0 382.8 0 480l0 8c0 13.3 10.7 24 24 24s24-10.7 24-24l0-8z"></path></svg>SSO integration</h4><p>pganalyze integrates with your Active Directory, LDAP, Okta or Google Apps setup.</p></div></div></div><div class="content--feature-image content--feature-image--right"><div class="content--feature-image--inner"><img src="/_astro/architecture_diagram.KD-ruegI_Z1IyWdy.webp" srcSet="/_astro/architecture_diagram.KD-ruegI_Z13DQEm.webp 800w, /_astro/architecture_diagram.KD-ruegI_Z1IyWdy.webp 1476w" sizes="800px" width="800" height="624" alt="Architecture pganalyze" class="img-pganalyze-achitecture" loading="lazy"/></div></div></div></div><div class="landing-index--section landing-index--footer-cta--container"><div class="landing-index--footer-cta"><p class="cta">Achieve Peak PostgreSQL Performance</p><p class="cta"><a class="btn btn-success btn-large" href="/product-tour"><strong>Tour the Product</strong></a></p><p style="font-size:90%">or<!-- --> <a style="font-weight:bold" href="https://app.pganalyze.com/users/sign_up">signup directly</a>.</p></div></div></div></div><!--astro:end--></astro-island><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 &amp; 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>&nbsp;<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">&copy; 2026 Duboce Labs, Inc.</div></div></footer></div></body></html>

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.