Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w23IX-000py3-0u for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 08:27:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w23IW-008Mb6-1F for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Mar 2026 08:27:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w23IW-008May-08 for pgsql-hackers@lists.postgresql.org; Mon, 16 Mar 2026 08:27:36 +0000 Received: from mail-ot1-x32d.google.com ([2607:f8b0:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w23IU-00000000ON1-01y3 for pgsql-hackers@postgresql.org; Mon, 16 Mar 2026 08:27:36 +0000 Received: by mail-ot1-x32d.google.com with SMTP id 46e09a7af769-7d7b685faeeso38148a34.3 for ; Mon, 16 Mar 2026 01:27:33 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773649651; cv=none; d=google.com; s=arc-20240605; b=MH9ms01YDL57EX0y1FB+Ecwla6XjrcSR4K4QzuZyoRBuoYCVwcZseTdJBzmjiFdS6h EsJ4O9+xc6l1DabdU75yJhS9HB6OCuNQYehh0gaaRiXQ6rh6+MaHwdHz8pAZ0hcceltJ cgjstL6dbg+uVVWVjTwHQd7EIQ6E4Ed2c/cUcmyY5Xr0/vnS9nZa1IZQX14+KvKaK5y9 rQ4w+Krthr3IGUinl192n96zRzcnQX+iZOUcjUvoX3Otz62x7kjKkf8u3rgC3VQrM5EO 8gMEMm6XkbWLRUpe5q3vc20DdgBqh6TnGw/e/UGMjGVhH8dHkTK7hzEyoAHyD6xof1wj 5ZJQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=4AYJmf9TM3Sv5h+syIqpl2AeZpn/a8bjd2q4GxIjIaw=; fh=6RlhcHKMprORx2h9M0ImLhjkRcl3mNqLjpkZD7Kd0dA=; b=B8N8EOSQsVpmZytGTAgc/mjW96qSze6wc2JGc7xtnKwcDTI1zd3QsLyveULHnqFvDx Qz1XLofzHjblEaA1B7fcrRxJ1Lud6m+3dtyEBz236qb8xIKuXnD2WYBHxbjzafZMo2Gy VID1vDIs2TYcpBY6A/nRtqxmEjRUifEx74Muzs2GDxBAHS4H1CmfWMdxmNm28UfcJtMf EfvxEtY2dn8u+AxLFplMa1ZY724jOzJZkHr608K3Lb+TaYEfA31QGI/VV/V97y1eQ6KS nsCTlViMIPoDTKCYqfSaFk3d6rV+XpBww2t/bw8/Zh5OsvhXAATW1Kb+M4rPQh32GrKS oXpg==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1773649651; x=1774254451; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=4AYJmf9TM3Sv5h+syIqpl2AeZpn/a8bjd2q4GxIjIaw=; b=CbjeSu0pVqlNVRYQyqlrhRanpuwOlRVraXXmiVSc0szojpGqnUEvcPLuQTdEZMrIPi IEvGfE9Kjod7djak/UKlW+MKHo6A4qmpff3p1AB24Mgb1rf1ztJuASp88qWs3vNOola4 0bwm2BILVHBORPS8lXEr4OblRKCGMqV8+R1DAe6+sQgU9msNLyAwrhXa3QZYeZme8oA2 VNUX/QKtohasSS9Lz2AOn2Gh4hL8CyA27HDFKRFgKyP0dRQOmmbdeNrkiZ9bCeQUWTfk lYLgTILCU3L+G6Bh0k1V/bFWfPXZBW+0P4xzuoIhDJLiMNoE4+iBEI32GG38YpIXihUg FbxA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773649651; x=1774254451; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=4AYJmf9TM3Sv5h+syIqpl2AeZpn/a8bjd2q4GxIjIaw=; b=V8hycLj7zR821zmA8aMdVNZroUdSuhYjWQ2eDtMRhkl+y9QhcZNfyz4MhI4xQqOpfC EwaNP4jYCmYDgRGbEXK8TVQGG30CNIz8+GgW2SJkOOOwUZJxSxBXDNgkrmucTq1MFZRM sErO4H/Ga3Y6NIzMqHg72aD7dCSlkTuGOgGLN6d1XLxvuX6HGOw4k8X8cpY/5o9urW8M 59mpEh9oR6bukTmYNzOx5Lq/QcGuVFEoV/3Q9bpz6wMDZwIzI9DZuMRCI2xBuAZqs98N am1qn7UOugSqRuLr4g4ALl+56I1IoUJyXfrWoHh8VtINVqklZBzTmioiYFhTDTBV2ny/ 7s0Q== X-Gm-Message-State: AOJu0Yy6UvcAW/FGm48vldPTC8j56mto/Ig7P7m3FyWkRQM9vLcWTgzL 0CTRJZ7XzONid2UaLfNzB0XjKae/FsfY0kLQ+sJV9QEVFKB5V8ocYxCttxSPAfnlhyPE0jYlxQt vNbGSV4FqCzazMbXsvdGh1i2efUvCd7Y= X-Gm-Gg: ATEYQzxHZaTz+KzUIAjyPbSMRd4vYNNOBgNLODwLjTr0UqoyIVjxz6RzOO/FyIyNVgk TgCUmLWVerGYNeKYnMeFoVi6Ss6qt9uWkz2d9zpznveW0Rm4Ll7HVYHei7FVYSP4MqS9d+pQH1D hcHfHZgX6+pzdTFaiBGOQKYUuIRKPfc18I8JG0VNaNfrj0nzoMZc93oeJDnKRHWhhx8x6aEYaWD er2yz76EFoFy9HuVzZMTd3Ij+iU6pDaVTrWvR0FSL9MuZYfhnKBTITYZ29YvsJx7MRnmlqra7Ns 8I1oi2ZgMVNm7GfAAw9WVXrEmYWWtUZGB9A7q+z90A== X-Received: by 2002:a05:6820:160a:b0:67b:c99e:12e1 with SMTP id 006d021491bc7-67bdaa71379mr7299436eaf.52.1773649651338; Mon, 16 Mar 2026 01:27:31 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fujii Masao Date: Mon, 16 Mar 2026 17:27:19 +0900 X-Gm-Features: AaiRm52cgL-WEEDoIL8K9xMMusy1OMHvqB_lilPpzcGv7CimKIcgOffy3WwD6fQ Message-ID: Subject: Re: Add missing stats_reset column to pg_statio_all_sequences view To: Sami Imseih Cc: pgsql-hackers , shihao zhong Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 13, 2026 at 11:52=E2=80=AFAM Sami Imseih = wrote: > > > it would be better to verify that the stats of the specified sequence a= re > > actually reset by using pg_stat_reset_single_table_counters(). > > > > Also, the documentation for pg_stat_reset_single_table_counters() shoul= d > > mention that it can reset sequence statistics as well. > > good points. > > For the documentation of pg_stat_reset_single_table_counters(), I also > mentioned materialized views for completeness. Thanks for updating the patch! I made a few cosmetic changes and pushed the patch. Thanks! Regards, --=20 Fujii Masao