Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nG1cV-0000Y4-DA for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Feb 2022 16:39:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nG1cT-0000oG-4o for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Feb 2022 16:39:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nG1cS-0000n7-An for pgsql-hackers@lists.postgresql.org; Fri, 04 Feb 2022 16:39:32 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nG1cK-0001to-Is for pgsql-hackers@lists.postgresql.org; Fri, 04 Feb 2022 16:39:30 +0000 Received: by mail-oo1-xc36.google.com with SMTP id o192-20020a4a2cc9000000b00300af40d795so5242491ooo.13 for ; Fri, 04 Feb 2022 08:39:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=OFAl1y/f5eWb/iSVsGyDai22ghy9ZnVe8AMWhvcailQ=; b=QKI65oCb5QbA0MIxrSuRzTp9Bd5vyXuIs+iNxJKYhoX8UBrNj3bjVfWKEUV39ZJNr7 aJFP7ASBnZ1tbzWHGCWnIgRTnH3cCaTRa0urf9RCohEiYRs6W2SEkV4dJZzUbE/5uHGc SaqALrujr8WOnZBV2/vKee/PX3zNGzTMp2eywFkoe3+AjRqTEmq2DyATXxvf0rvt9qZF OOflHxpXtasYrEWyaaFqVlc+yHUGtJp0XlCJEqcqo9aum+scUPr7PqkhN4FfVTqlg63G ZH4W91yo7+cIvXko4MvTm7EZId6GGVv3m+18hbj2alACE1dl1gKEoqpV5x6k7hoUxuGJ A3tw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=OFAl1y/f5eWb/iSVsGyDai22ghy9ZnVe8AMWhvcailQ=; b=G/A1v+hzEu+8AecK4sjVIE7CChTMBJTKUPTypUvkTvCLHeVXY7rYQTfTDoBOXva9hO qYTmwS49+F28IYlH56OQ7rHC852kmAvpeaySznyil/5zXp+/CHsPCcsQ76fWyApOptd8 r66gYik0wXtdFxUPYMCQrD8/HWqya3U7mflmPfqaRxWg7AW4z6dJaZ4G8P3CJP/xZRFV GZHWAebGlCzvgL8Vkqofy8g1vjGR9PnPIYJZVXThonXpV6+oh+Tc9tz/5/Le1lqeNkEA yc9xiXVD62PejS/rpQTIRs51NeCCBtOHiiUZh6SlbGlJZcDYJxq3SrJna1uPu1wWQ5JU 2chw== X-Gm-Message-State: AOAM532vqScmVYr32S2wm6PjAlC/+bZrOJxisqWAnKgk0pwsAeqAkEcb ZNLOU7D1oZiPOw4BkgjfX0Xpqoyge9UCrCbDieA1sXZoEIrinmP9aKUS2YD9RXSn3jLv0vK74xc ssGhemDTcWyFGPXIit1y+NU+ZX8jIlzXeejWNxCWG+x6lYv1Yb8LmArB5YR/cHd+yoDc6u4Ek1V WPYgf5NzdRphaFuD75Xt21YRwNPd+Bv0Fa3dnGAdhoQRtkxEeaj6ld1E3w83qLh00wXvhX X-Google-Smtp-Source: ABdhPJwQPcuNiDYh9GZxTyEPSst73V5j1UXHOnZOQKCEht4B2WH/CPQ01PNGhJbWW+lnG+uUO/RICm2zMlib6qjMuho= X-Received: by 2002:a05:6870:a556:: with SMTP id p22mr633781oal.19.1643992763691; Fri, 04 Feb 2022 08:39:23 -0800 (PST) MIME-Version: 1.0 References: <20201031014617.ukvqjlis7tkdo5ib@development> In-Reply-To: From: John Naylor Date: Fri, 4 Feb 2022 11:39:12 -0500 Message-ID: Subject: Re: Stats collector's idx_blks_hit value is highly misleading in practice To: Peter Geoghegan Cc: Tomas Vondra , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Feb 4, 2022 at 11:19 AM Peter Geoghegan wrote: > > On Thu, Feb 3, 2022 at 7:08 PM John Naylor wrote: > > Is this a TODO candidate? What would be a succinct title for it? > > I definitely think that it's worth working on. I suppose it follows > that it should go on the TODO list. Added TODO item "Teach stats collector to differentiate between internal and leaf index pages" -- John Naylor EDB: http://www.enterprisedb.com