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 1nbLiM-0008Fg-PC for pgsql-docs@arkaria.postgresql.org; Mon, 04 Apr 2022 12:21:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nbLiK-00079d-R9 for pgsql-docs@arkaria.postgresql.org; Mon, 04 Apr 2022 12:21:44 +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 1nbLiK-00079U-H0 for pgsql-docs@lists.postgresql.org; Mon, 04 Apr 2022 12:21:44 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nbLiH-0005p9-Qc for pgsql-docs@lists.postgresql.org; Mon, 04 Apr 2022 12:21:44 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-2e5e9025c20so96670837b3.7 for ; Mon, 04 Apr 2022 05:21:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=fi6mCrrwg6ycM39kvWl//tOCh45gJ8WsAIeLAAliJJk=; b=KZYA2sBh91mMTDg6ZLRtiDTkN7Dyh60IiI2UW5n8hjRcFuz4TGsyqcLyce/neHVJkY 1L0StVHVm9lKCr8+tzqKDeFjs7DYFZVDYSXvkB6QurMuBPbm1+moujFCOEdutAemTs6i YmVsa+CA8EpKGA34K81huNVXLFXQyyjFqdiFwZOC34cvgz31SusfTV6DqxhoW7zw1vEl RRIo+F4hr0o6jIvV1ajxFw1WLd/zV9ALJQSwH7yjIS6TrV98P+XHewAnlT1NwzH52MBU nElfZjB8M3jD1bd8dJERM9LXOq+q+/K9m+ANlgmuNpDoclPqvahTI9TMeqty2pXzgDrW 4i6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=fi6mCrrwg6ycM39kvWl//tOCh45gJ8WsAIeLAAliJJk=; b=qLzngp5Z3OVttYGP1gXZyA2s28MabEjQc3JuoKMfRq6k19SNXhlDb7yETlDRdCfOJf rHKzQfGb8tq75MGO9I3K6Vij6EjFUWRUNo6+cdfLq+jxXIc3lkPGglVmpd1hLPGQbWdP TbGogVHGT31HNQW/c1aIC0k7Xm4gfv1nJfL5PuYq2pxegFY9Yt7y3uDFnR0uuH3f47v6 1e08Eh2mGVmuwPouuPMqBdyt0pnLec4OvotM9eehllBHYBkT73gu/at4zM5ZUjcuEHeH rmJgR4Z/ili3fC1t/rac9Cg730OTUvAWd7ahk4DA5XDJV99jEMDlu3cvgb2htMQg7SDs CX2w== X-Gm-Message-State: AOAM533U+1xb5LbY3wJqC0tNFwtxtWebG7xERc49/JxbaazOexkKhr09 lgezHGlkWby2BXduJXqWrWVmWPYXuk/r7JyvhbtzCzI5EgA= X-Google-Smtp-Source: ABdhPJx58CCwJsSQgEZlIf/fW8RdxEalb3Kt2nK/Hgris4JmK/npFbX1M6idGwLXZ79pNcU0JGqiy8RkhzPNbrbECxE= X-Received: by 2002:a0d:dbd5:0:b0:2eb:6760:743b with SMTP id d204-20020a0ddbd5000000b002eb6760743bmr4722815ywe.502.1649074900138; Mon, 04 Apr 2022 05:21:40 -0700 (PDT) MIME-Version: 1.0 From: Kouber Saparev Date: Mon, 4 Apr 2022 15:21:24 +0300 Message-ID: Subject: Indexes documentation bug To: pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000a1804a05dbd32b40" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a1804a05dbd32b40 Content-Type: text/plain; charset="UTF-8" Hello, I believe there is an error within this sentence in section https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-USER-FUNCTIONS-VIEW "Therefore, a bitmap scan increments the pg_stat_all_indexes.idx_tup_read count(s) for the index(es) it uses, and it increments the pg_stat_all_tables. idx_tup_fetch count for the table, but it does not affect pg_stat_all_indexes.idx_tup_fetch." There is repeated mentioning of pg_stat_all_indexes.idx_tup_fetch while I suppose one should read pg_stat_all_indexes.idx_scan instead the second time. I.e. bitmap scans do not increment idx_scan. Regards, -- Kouber Saparev --000000000000a1804a05dbd32b40 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello,

I bel= ieve there is an error within this sentence in section=C2=A0https://www.postgresql.org/docs/current/monitoring-s= tats.html#MONITORING-PG-STAT-USER-FUNCTIONS-VIEW

"Therefore, a bitmap scan increments the=C2=A0pg_stat_all_indexes= .idx_tup_read=C2=A0count(s) for= the index(es) it uses, and it increments the=C2=A0pg_stat_all_tables.idx_tup_fetch=C2=A0count for the table,= but it does not affect=C2=A0pg_stat_all_indexes.idx_tup_fetch<= /code>."

There is repeated=C2=A0mentioning = of=C2=A0pg_stat_all_indexes.idx_tup_fetch=C2=A0<= font color=3D"#0d0a0b" face=3D"Open Sans, sans-serif">while I suppose one should read=C2=A0=C2=A0pg_stat_all_indexes.idx_scan=C2=A0instead the second time. I.e. bitmap scans do not increment= idx_scan.

Regards,
--
Kouber Saparev
--000000000000a1804a05dbd32b40--