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 1prCuN-0004JH-0N for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Apr 2023 07:16:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1prCuL-0006D9-Q1 for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Apr 2023 07:16:13 +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 1prCuL-0006D0-Bg for pgsql-hackers@lists.postgresql.org; Tue, 25 Apr 2023 07:16:13 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1prCuG-001lpP-QS for pgsql-hackers@postgresql.org; Tue, 25 Apr 2023 07:16:12 +0000 Received: from [192.168.0.104] (unknown [62.217.188.228]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 70C7B21C8BF2; Tue, 25 Apr 2023 10:16:05 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1682406966; bh=P7T87TVKuchMJC255Ay1XIFafTjkX97s4GaeWQGjIZA=; h=Message-ID:Date:User-Agent:Subject:To:Cc:References:From: In-Reply-To:From; b=UCyw9Nr2WBts+eI0xPLS9yvCr6+cX/P2o8VckvH4ky4pKfpUKjTdmi2CGeiqRQVUu 170CDGuShWAJMPfNkQYFffGL8mLDdbmZJPIosnZgcT3Cgt/RyQPhVu6ETCbyS40xX+ ha82Gk0g0+lmyF/nNlAin/JH6C7WTvCcwbaA693XtleQTOUwBYeaT71rqTd6yGM6oD JTV9nBmvzggknuv6QuK0gWw86rgw1MfbTM+4sMpUwP8jljaOEQrOIa89RUE4g2Msk9 /K+C7FIxQ+HybzwWxFgLs2GQp/uKMw6H5Q8s6Ml8zmlQ9Kd4bmxs/MgC3kFd/73kWz U3Cz85c1G9WbQ== Message-ID: <892d6d93-bc91-7f9a-0dbb-bed8cb29c31e@postgrespro.ru> Date: Tue, 25 Apr 2023 10:16:05 +0300 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.7.1 Subject: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Content-Language: en-US To: Melanie Plageman Cc: Justin Pryzby , Andres Freund , Kyotaro Horiguchi , tgl@sss.pgh.pa.us, vignesh21@gmail.com, lukas@fittl.com, alvherre@alvh.no-ip.org, magnus@hagander.net, pgsql-hackers@postgresql.org, thomas.munro@gmail.com, m.sakrejda@gmail.com, Michael Paquier References: <20230306.152425.316894602450485455.horikyota.ntt@gmail.com> <20230306190919.ai6mxdq3sygyyths@awork3.anarazel.de> <20230306192409.daz5ivq4mbbr2ye7@liskov> <20230306193404.3btuacgc6um33mt2@awork3.anarazel.de> <20230307181844.hxnlfi3wa5lm7sm2@awork3.anarazel.de> <20230309194301.mjdddcoswgr6xoxa@awork3.anarazel.de> From: Pavel Luzanov In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 24.04.2023 23:53, Melanie Plageman wrote: > I copied the committer who most recently touched pg_stat_io (Michael > Paquier) to see if we could get someone interested in committing this > docs update. I can explain my motivation by suggesting this update. pg_stat_io is a very impressive feature. So I decided to try it. I see 4 rows for some 'standalone backend'  out of 30 total rows of the view. The attempt to find description of 'standalone backend' in the docs did not result in anything. pg_stat_io page references pg_stat_activity for backend types. But pg_stat_activity page doesn't say anything about 'standalone backend'. I think this question will be popular without clarifying in docs. -- Pavel Luzanov Postgres Professional: https://postgrespro.com