pgsql: Fix definition of pg_statio_all_tables view

From: Alexander Korotkov <akorotkov(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix definition of pg_statio_all_tables view
Date: 2020-04-28 08:30:49
Message-ID: E1jTLdh-0004MY-7j@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix definition of pg_statio_all_tables view

pg_statio_all_tables view appears to have a wrong grouping. As the result
numbers of toast index blocks read and hit were multiplied to the number of
table indexes. This commit fixes the view definition.

Backpatching this appears difficult. We don't have a mechanism to patch a
system catalog of existing instances in minor upgrade. We can write a
release notes instruction to do this manually. But per discussion this is
probably not so critical bug for doing such an intrusive fix.

Reported-by: Andrei Zubkov
Discussion: https://postgr.es/m/CAPpHfdtMYkkNudLMG9G0dxX_B%3Dn5sfKzOyxxrvWYtSicaGW0Lw%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ef11051bbe96ea2d06583e4b3b9daaa02657dd42

Modified Files
--------------
src/backend/catalog/system_views.sql | 8 ++++----
src/test/regress/expected/rules.out | 6 +++---
2 files changed, 7 insertions(+), 7 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2020-04-28 11:38:03 pgsql: Add missing gettext triggers
Previous Message Michael Paquier 2020-04-27 22:58:53 pgsql: Add more TAP coverage for archive status with crash recovery of