MIME-Version: 1.0
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Sun, 29 Mar 2026 18:42:46 +0200
Message-ID: 
 <CAFj8pRD2MOak45s8=bex3BcncJf2jt9ukx=i9pKmWB1SepZu6g@mail.gmail.com>
Subject: PoC - psql - emphases line with table name in verbose output
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000b1ee9e064e2c6e5d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFj8pRD2MOak45s8%3Dbex3BcncJf2jt9ukx%3Di9pKmWB1SepZu6g%40mail.gmail.com>
Precedence: bulk

--000000000000b1ee9e064e2c6e5d
Content-Type: multipart/alternative; boundary="000000000000b1ee9d064e2c6e5b"

--000000000000b1ee9d064e2c6e5b
Content-Type: text/plain; charset="UTF-8"

Hi

Sometimes I have to run vacuum verbose in environments with hundreds of
tables. The result is pretty unreadable. Attached patch try introduce some
emphasis of interesting lines from INFO output. It is proof concept if some
game with output has some benefits or not.

What do you think about this?

Regards

Pavel

--000000000000b1ee9d064e2c6e5b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi</div><div><br></div><div>Sometimes I have to run v=
acuum verbose in environments with hundreds of tables. The result=C2=A0is p=
retty unreadable. Attached patch try introduce some emphasis of interesting=
 lines from INFO output. It is proof concept if some game with output has s=
ome benefits or not.=C2=A0</div><div><br></div><div>What=C2=A0do you think =
about this?</div><div><br></div><div>Regards</div><div><br></div><div>Pavel=
</div></div>

--000000000000b1ee9d064e2c6e5b--

--000000000000b1ee9e064e2c6e5d
Content-Type: text/x-patch; charset="US-ASCII"; name="0001-initial.patch"
Content-Disposition: attachment; filename="0001-initial.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mnbzgz0t0>
X-Attachment-Id: f_mnbzgz0t0

RnJvbSBhYmMzNzIxNmFlY2I5YjAyMDFhOGZhODhkNjQyZDRlM2NmZDMwNDMyIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiAib2tib2JAZ2l0aHViLmNvbSIgPHBhdmVsLnN0ZWh1bGVAZ21h
aWwuY29tPgpEYXRlOiBTdW4sIDI5IE1hciAyMDI2IDE4OjAxOjE2ICswMjAwClN1YmplY3Q6IFtQ
QVRDSF0gaW5pdGlhbAoKLS0tCiBzcmMvY29tbW9uL2xvZ2dpbmcuYyB8IDE3ICsrKysrKysrKysr
KysrKystCiAxIGZpbGUgY2hhbmdlZCwgMTYgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoK
ZGlmZiAtLWdpdCBhL3NyYy9jb21tb24vbG9nZ2luZy5jIGIvc3JjL2NvbW1vbi9sb2dnaW5nLmMK
aW5kZXggNTIwNjk0OWU1ZDguLmM2MjI5OTQwZjRmIDEwMDY0NAotLS0gYS9zcmMvY29tbW9uL2xv
Z2dpbmcuYworKysgYi9zcmMvY29tbW9uL2xvZ2dpbmcuYwpAQCAtMzAsMTEgKzMwLDEzIEBAIHN0
YXRpYyBjb25zdCBjaGFyICpzZ3JfZXJyb3IgPSBOVUxMOwogc3RhdGljIGNvbnN0IGNoYXIgKnNn
cl93YXJuaW5nID0gTlVMTDsKIHN0YXRpYyBjb25zdCBjaGFyICpzZ3Jfbm90ZSA9IE5VTEw7CiBz
dGF0aWMgY29uc3QgY2hhciAqc2dyX2xvY3VzID0gTlVMTDsKK3N0YXRpYyBjb25zdCBjaGFyICpz
Z3JfaW5mb19jb21tYW5kID0gTlVMTDsKIAogI2RlZmluZSBTR1JfRVJST1JfREVGQVVMVCAiMDE7
MzEiCiAjZGVmaW5lIFNHUl9XQVJOSU5HX0RFRkFVTFQgIjAxOzM1IgogI2RlZmluZSBTR1JfTk9U
RV9ERUZBVUxUICIwMTszNiIKICNkZWZpbmUgU0dSX0xPQ1VTX0RFRkFVTFQgIjAxIgorI2RlZmlu
ZSBTR1JfSU5GT19DT01NQU5EX0RFRkFVTFQgIjA3IgogCiAjZGVmaW5lIEFOU0lfRVNDQVBFX0ZN
VCAiXHgxYlslc20iCiAjZGVmaW5lIEFOU0lfRVNDQVBFX1JFU0VUICJceDFiWzBtIgpAQCAtMTQz
LDYgKzE0NSw4IEBAIHBnX2xvZ2dpbmdfaW5pdChjb25zdCBjaGFyICphcmd2MCkKIAkJCQkJCQlz
Z3Jfbm90ZSA9IHN0cmR1cCh2YWx1ZSk7CiAJCQkJCQlpZiAoc3RyY21wKG5hbWUsICJsb2N1cyIp
ID09IDApCiAJCQkJCQkJc2dyX2xvY3VzID0gc3RyZHVwKHZhbHVlKTsKKwkJCQkJCWlmIChzdHJj
bXAobmFtZSwgImluZm9fY29tbWFuZCIpID09IDApCisJCQkJCQkJc2dyX2luZm9fY29tbWFuZCA9
IHN0cmR1cCh2YWx1ZSk7CiAJCQkJCX0KIAkJCQl9CiAKQEAgLTE1NSw2ICsxNTksNyBAQCBwZ19s
b2dnaW5nX2luaXQoY29uc3QgY2hhciAqYXJndjApCiAJCQlzZ3Jfd2FybmluZyA9IFNHUl9XQVJO
SU5HX0RFRkFVTFQ7CiAJCQlzZ3Jfbm90ZSA9IFNHUl9OT1RFX0RFRkFVTFQ7CiAJCQlzZ3JfbG9j
dXMgPSBTR1JfTE9DVVNfREVGQVVMVDsKKwkJCXNncl9pbmZvX2NvbW1hbmQgPSBTR1JfSU5GT19D
T01NQU5EX0RFRkFVTFQ7CiAJCX0KIAl9CiB9CkBAIC0zMzEsNyArMzM2LDE3IEBAIHBnX2xvZ19n
ZW5lcmljX3YoZW51bSBwZ19sb2dfbGV2ZWwgbGV2ZWwsIGVudW0gcGdfbG9nX3BhcnQgcGFydCwK
IAlpZiAocmVxdWlyZWRfbGVuID49IDIgJiYgYnVmW3JlcXVpcmVkX2xlbiAtIDJdID09ICdcbicp
CiAJCWJ1ZltyZXF1aXJlZF9sZW4gLSAyXSA9ICdcMCc7CiAKLQlmcHJpbnRmKHN0ZGVyciwgIiVz
XG4iLCBidWYpOworCWlmIChsZXZlbCA9PSBQR19MT0dfSU5GTyAmJiBzZ3JfaW5mb19jb21tYW5k
ICYmCisJCShzdHJuY21wKGJ1ZiwgIklORk86ICB2YWN1dW1pbmciLCBzdHJsZW4oIklORk86ICB2
YWN1dW1pbmciKSkgPT0gMCB8fAorCQkgc3RybmNtcChidWYsICJJTkZPOiAgcmVwYWNraW5nIiwg
c3RybGVuKCJJTkZPOiAgdmFjdXVtaW5nIikpID09IDAgfHwKKwkJIHN0cm5jbXAoYnVmLCAiSU5G
TzogIGFuYWx5emluZyIsIHN0cmxlbigiSU5GTzogIHZhY3V1bWluZyIpKSA9PSAwKSkKKwl7CisJ
CWZwcmludGYoc3RkZXJyLCBBTlNJX0VTQ0FQRV9GTVQsIHNncl9pbmZvX2NvbW1hbmQpOworCQlm
cHJpbnRmKHN0ZGVyciwgIiVzXG4iLCBidWYpOworCQlmcHJpbnRmKHN0ZGVyciwgQU5TSV9FU0NB
UEVfUkVTRVQpOworCX0KKwllbHNlCisJCWZwcmludGYoc3RkZXJyLCAiJXNcbiIsIGJ1Zik7CiAK
IAlmcmVlKGJ1Zik7CiB9Ci0tIAoyLjUzLjAKCg==
--000000000000b1ee9e064e2c6e5d--