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 1nsBjn-0002dG-PR for pgsql-hackers@arkaria.postgresql.org; Fri, 20 May 2022 23:08:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nsBjm-0007PS-F6 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 May 2022 23:08:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nsBjm-0007PJ-5g for pgsql-hackers@lists.postgresql.org; Fri, 20 May 2022 23:08:50 +0000 Received: from mail-pl1-x634.google.com ([2607:f8b0:4864:20::634]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nsBjf-0001su-NC for pgsql-hackers@postgresql.org; Fri, 20 May 2022 23:08:49 +0000 Received: by mail-pl1-x634.google.com with SMTP id m12so8495112plb.4 for ; Fri, 20 May 2022 16:08:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=Y+y1ZjgKiirHBgHjbHsbA6oml7tC7fwX2OSAo4Y8BGY=; b=kleZtSHSoBYoAk1emQ5TqB/blt9oudlU2Vx8kkmCXEMdNW7OwJ5T0mCr5eCF5EktDw 0VnoE5a/QNkOOjRDQQkWrBzq9jdIVLEY18ch9WZ9tYXPi8+rv4E8ChOY7/gny9+FmpEe K/BKXTnOa8KpOvT2j5XOgXhwwyaf+Oc5Kakl7PxQ6I8OoqxlWLfi3iT0odU9V9jv8FjA bAJ5f7B80uMlfvN4W1Z/7koJVfptwcEG3mzopXYepIpEVJm+83iWeottUYWNHSZkKZG2 tEZ43yD7MxFtP+f2n1qB29XD6Gtc9mBWIlmmfFERgbsynwHHkQFmGXQ0Sf6QKgCPVUu8 AD9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=Y+y1ZjgKiirHBgHjbHsbA6oml7tC7fwX2OSAo4Y8BGY=; b=3J1OrocYrwGc+04RXbweCh/J+LhF57pWMAH/dxd9VxBDMZm1aURXifwtc053Lwlo4q 7WPonyg9W0Yj6pax47+1/Nd+fFC1HNhccVkkDaMqgPPqbVO2ZHlB2lMAnSKlhpGaIoBp 8P/xwhIYEC2O/lEFygp5JedAy2HpK/hwDCaM3DmMMJ/SV6BawYQ3MjvpJdY/WgV/L9Jp c1NqRg1LqAzPkPWNtnyuz1NdsrLAOhbjAIfuEdFIDP++NqK+H2X6E59pgSQbwRQF6s/E DvY7yFmzOMPEWGGdv0IPLCA716mxs88bCylc1VSkkPZTzBSBY+TMSzMfAoKx18zyT0Sp 2YDQ== X-Gm-Message-State: AOAM533kTz56rKG7SQclyFuAmc+z4TpLyFD5wTM+0fC9v7YuFErkW/4V 3In+LQHStZytZFFcwGuYz56WFIUQx8Y= X-Google-Smtp-Source: ABdhPJzT6vgCAsyXAfhd9NNB/fPeRjGHISk1zY4YUGR3u4DvMIcddVdJD+/c//K+3vNoQUxqAd8jdw== X-Received: by 2002:a17:90a:4fe1:b0:1de:fc11:331e with SMTP id q88-20020a17090a4fe100b001defc11331emr13371065pjh.145.1653088121643; Fri, 20 May 2022 16:08:41 -0700 (PDT) Received: from nathanxps13 ([50.54.155.70]) by smtp.gmail.com with ESMTPSA id d7-20020a17090a2a4700b001deb92de665sm2441388pjg.46.2022.05.20.16.08.40 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 May 2022 16:08:41 -0700 (PDT) Date: Fri, 20 May 2022 16:08:37 -0700 From: Nathan Bossart To: Ian Lawrence Barwick Cc: pgsql-hackers Subject: Re: docs: mention "pg_read_all_stats" in "track_activities" description Message-ID: <20220520230837.GB877934@nathanxps13> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, May 20, 2022 at 03:17:29PM +0900, Ian Lawrence Barwick wrote: > It seems reasonable to mention here that the information is also visible to > members of "pg_read_all_stats", similar to what is done in the > pg_stat_statements > docs [2]. > > [2] https://www.postgresql.org/docs/current/pgstatstatements.html#PGSTATSTATEMENTS-COLUMNS > > Suggested wording: > >> Note that even when enabled, this information is only visible to superusers, >> members of the pg_read_all_stats role and the user owning >> the session being reported on, so it should not represent a security risk. > > Patch (for HEAD) with suggested wording attached; the change should > IMO be applied > all the way back to v10 (though as-is the patch only applies to HEAD, > can provide > others if needed). LGTM -- Nathan Bossart Amazon Web Services: https://aws.amazon.com