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 1jYt2i-0006ul-UA for pgsql-docs@arkaria.postgresql.org; Wed, 13 May 2020 15:11:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jYt2h-0005bM-PC for pgsql-docs@arkaria.postgresql.org; Wed, 13 May 2020 15:11:31 +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 1jYt2h-0005Lz-JL for pgsql-docs@lists.postgresql.org; Wed, 13 May 2020 15:11:31 +0000 Received: from oss.nttdata.com ([49.212.34.109]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jYt2b-0004dw-8K for pgsql-docs@postgresql.org; Wed, 13 May 2020 15:11:30 +0000 Received: from hnk.local (p2358024-ipbf2221funabasi.chiba.ocn.ne.jp [114.177.56.24]) by oss.nttdata.com (Postfix) with ESMTPSA id DDE58604CB for ; Thu, 14 May 2020 00:11:22 +0900 (JST) X-Virus-Status: Clean X-Virus-Scanned: clamav-milter 0.102.2 at oss.nttdata.com To: pgsql-docs@postgresql.org From: Fujii Masao Subject: The order of columns about WAL activity in pg_stat_statements Message-ID: Date: Thu, 14 May 2020 00:11:22 +0900 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:68.0) Gecko/20100101 Thunderbird/68.8.0 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------018944669ABAE0CD874DAD72" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------018944669ABAE0CD874DAD72 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hi, https://www.postgresql.org/docs/devel/pgstatstatements.html In pg_stat_statements docs, the columns about WAL activity are put in the table in the order of wal_bytes, wal_records and wal_fpi. But in the definition of pg_stat_statements view, wal_bytes is put last. So I think that it's better to reorder those columns in a consistent with the view definition. Patch attached. Thought? Regards, -- Fujii Masao Advanced Computing Technology Center Research and Development Headquarters NTT DATA CORPORATION --------------018944669ABAE0CD874DAD72 Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0"; name="pgss_docs.patch" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="pgss_docs.patch" ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9wZ3N0YXRzdGF0ZW1lbnRzLnNnbWwgYi9kb2Mv c3JjL3NnbWwvcGdzdGF0c3RhdGVtZW50cy5zZ21sCmluZGV4IGIxZDVmM2QxZGMuLmVkYWNk YTk3MWYgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9wZ3N0YXRzdGF0ZW1lbnRzLnNnbWwK KysrIGIvZG9jL3NyYy9zZ21sL3Bnc3RhdHN0YXRlbWVudHMuc2dtbApAQCAtMjY0LDE1ICsy NjQsNiBAQAogICAgICAgPC9lbnRyeT4KICAgICAgPC9yb3c+CiAKLSAgICAgPHJvdz4KLSAg ICAgIDxlbnRyeT48c3RydWN0ZmllbGQ+d2FsX2J5dGVzPC9zdHJ1Y3RmaWVsZD48L2VudHJ5 PgotICAgICAgPGVudHJ5Pjx0eXBlPm51bWVyaWM8L3R5cGU+PC9lbnRyeT4KLSAgICAgIDxl bnRyeT48L2VudHJ5PgotICAgICAgPGVudHJ5PgotICAgICAgICBUb3RhbCBhbW91bnQgb2Yg V0FMIGJ5dGVzIGdlbmVyYXRlZCBieSB0aGUgc3RhdGVtZW50Ci0gICAgICA8L2VudHJ5Pgot ICAgICA8L3Jvdz4KLQogICAgICA8cm93PgogICAgICAgPGVudHJ5PjxzdHJ1Y3RmaWVsZD53 YWxfcmVjb3Jkczwvc3RydWN0ZmllbGQ+PC9lbnRyeT4KICAgICAgIDxlbnRyeT48dHlwZT5i aWdpbnQ8L3R5cGU+PC9lbnRyeT4KQEAgLTI5MSw2ICsyODIsMTUgQEAKICAgICAgIDwvZW50 cnk+CiAgICAgIDwvcm93PgogCisgICAgIDxyb3c+CisgICAgICA8ZW50cnk+PHN0cnVjdGZp ZWxkPndhbF9ieXRlczwvc3RydWN0ZmllbGQ+PC9lbnRyeT4KKyAgICAgIDxlbnRyeT48dHlw ZT5udW1lcmljPC90eXBlPjwvZW50cnk+CisgICAgICA8ZW50cnk+PC9lbnRyeT4KKyAgICAg IDxlbnRyeT4KKyAgICAgICAgVG90YWwgYW1vdW50IG9mIFdBTCBieXRlcyBnZW5lcmF0ZWQg YnkgdGhlIHN0YXRlbWVudAorICAgICAgPC9lbnRyeT4KKyAgICAgPC9yb3c+CisKICAgICA8 L3Rib2R5PgogICAgPC90Z3JvdXA+CiAgIDwvdGFibGU+Cg== --------------018944669ABAE0CD874DAD72--