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 1vt66Y-002YSp-1H for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Feb 2026 15:38:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vt66X-0040aG-0V for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Feb 2026 15:38:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vt66W-0040a7-2P for pgsql-hackers@lists.postgresql.org; Thu, 19 Feb 2026 15:38:12 +0000 Received: from mail-dl1-x1236.google.com ([2607:f8b0:4864:20::1236]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vt66T-000000009Sb-2OwA for pgsql-hackers@lists.postgresql.org; Thu, 19 Feb 2026 15:38:11 +0000 Received: by mail-dl1-x1236.google.com with SMTP id a92af1059eb24-126ea4b77adso1341518c88.1 for ; Thu, 19 Feb 2026 07:38:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771515489; x=1772120289; darn=lists.postgresql.org; h=subject:to:from:message-id:date:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=NU2u83jVZ0PddX2/3261uPqXPd2e9zV8qYpHItveuCI=; b=Q3gy8lxIkDxD59Fa6f435a4h+3qe9nJH8z2ogmDjM6+EJNLgy2FWtbQNWrwlYNQO+u uzl9jxD1o5GXrR4wCBYDCcBZAxV/IyKJjftx7LVXu4PK1kv8cL7eEpaM4nviTXG3ql5B QWOiz0eSq4ry4FmfNyZlO55fVYIeggLrIBt6/WgNTfDCD/xq74fTlOcxJDiTvZNKpCRc oy0JOrPeMK63wADG/r47qn35yKtRWbdQbRk1MBbcuN8rKScjp2Upbw687V7M8yFbzThR U6Sx6ybd+GUsCuUVPBKA7lOocyK6HQLgqtyXs+kqWzPryjtcjABohWs6u9PmZk/fYGpt lHYQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771515489; x=1772120289; h=subject:to:from:message-id:date:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=NU2u83jVZ0PddX2/3261uPqXPd2e9zV8qYpHItveuCI=; b=uNVE7IsoBHmCu/JHXuqHOfvxa1KBXDF7H34I5AAnEdV5A3MVtoqgKSyk5xUafxPm51 YWh+HAX5TRIgV+4Ueo8ceM5jTpqoFCLLwM8h+/dmUQdh/vOUbGn9pg0N688gFvp8y30q YdlI5uEXwrMlSwRUkR4eXnArUS4OABM6QhpmbbAqUIpORKluqw10rjrzxA1uaqnAcZA6 3NN4k6ISslJyIGD2BOHq9NGuZQsq/4yBvKYW+iJTXFq1YylslpLnzzdoow72fvfMuJDT BTZ91xXxqtyOpiPugYivbxdUP6iWFd7GLA2gVyyxSa5MKxhIl+p4fWcCh6aaWABixwlp m2Dg== X-Gm-Message-State: AOJu0YxvV0v/j0CCkIGzYhOw/d40u3KZ/4zdTapun4khz9XYrHNGleLA EGQqBRRlYKDstI/K3aPF8n39IaTg6mQeBnu4EKkQrz2+VhYHlP8HG5WOoui+EQ== X-Gm-Gg: AZuq6aKhHIGP8tyqRQha22czS2F8MbRl7eThLankTQriIWzYpLf+Eqrwvk8YgxgsNtt SXwuu1z+eCmHa9CQkTOG+7EwtV+ADDqrxvp0TiLnQlEdxjXsoVt9rFkHNLLC+/IiLiKdljx5E8a 24P655QgF9MB3gZk5SrIH3wEZErpnta6Edgj4uHjL5eydio1wtHw1HZvM4RnH1mCJmySIR3JJTp dAOOeqMLDUDpnv8N50n0eCOVnWZRHX+IhlyiFJ+vvlHeQjoHh5Zn+CdlaHksqmfLJExER15Fx+l tiy/vvFpVeEHc44msT79I+4zCosD2xHr/aKzFBkqL0ZOst2Lpn6Uyeyr+sHsx1YnN+koljzKoLp JmfwIAHHlGxIrP1AhqDM6Q0hbSmwMBSGWvYA8xY9eOP2bo694RLXWftK2r9en3X1IGC22Xeh1WQ tADoas8jPRdqXHLxPuCHyiEyvHUZb4NuNKAmmdmudshRD3CGM/cA== X-Received: by 2002:a05:7022:2208:b0:123:3461:99a4 with SMTP id a92af1059eb24-127397b3963mr9160301c88.17.1771515489411; Thu, 19 Feb 2026 07:38:09 -0800 (PST) Received: from localhost ([2804:14d:328a:a59c:300f:55a:7205:4458]) by smtp.gmail.com with ESMTPSA id a92af1059eb24-12742b61ff7sm21328291c88.2.2026.02.19.07.38.08 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 19 Feb 2026 07:38:08 -0800 (PST) Content-Type: multipart/mixed; boundary=97ea0d9ef09e429568376a0f23ba4522b21a8726fc064cfce42b2cb5591e Mime-Version: 1.0 Date: Thu, 19 Feb 2026 12:38:06 -0300 Message-Id: From: "Matheus Alcantara" To: Subject: psql: Add verbose option (+) for \dX command X-Mailer: aerc 0.21.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --97ea0d9ef09e429568376a0f23ba4522b21a8726fc064cfce42b2cb5591e Content-Type: multipart/alternative; boundary=69cf18dfe526a303c29b6c071931f0da4d1513b36054a1ce274d940c972a --69cf18dfe526a303c29b6c071931f0da4d1513b36054a1ce274d940c972a Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Type: text/plain; charset=UTF-8 Hi, While I was reviewing another patch I noticed that we don't have the verbose option(+) on \dX command to get extended statistics comments. Althrought comments can be obtained using obj_description() perhaps it can be useful to have a verbose option on \dX to get this information. Thoughts? -- Matheus Alcantara EDB: https://www.enterprisedb.com --69cf18dfe526a303c29b6c071931f0da4d1513b36054a1ce274d940c972a-- --97ea0d9ef09e429568376a0f23ba4522b21a8726fc064cfce42b2cb5591e Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=v1-0001-psql-Add-verbose-option-for-dX-command.patch Content-Type: text/plain; charset=utf-8; name=v1-0001-psql-Add-verbose-option-for-dX-command.patch RnJvbSA5Nzg2ZDU3M2ZhYTA0OGYwYmE3MDVhMTJhMjQ5NjUyYzcwNGQyNmE0IE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBNYXRoZXVzIEFsY2FudGFyYSA8bXRocy5kZXZAcG0ubWU+CkRh dGU6IFRodSwgMTkgRmViIDIwMjYgMTA6NTU6MDAgLTAzMDAKU3ViamVjdDogW1BBVENIIHYxXSBw c3FsOiBBZGQgdmVyYm9zZSBvcHRpb24gKCspIGZvciBcZFggY29tbWFuZAoKLS0tCiBzcmMvYmlu L3BzcWwvY29tbWFuZC5jICB8ICAyICstCiBzcmMvYmluL3BzcWwvZGVzY3JpYmUuYyB8IDExICsr KysrKysrLS0tCiBzcmMvYmluL3BzcWwvZGVzY3JpYmUuaCB8ICAyICstCiBzcmMvYmluL3BzcWwv aGVscC5jICAgICB8ICAyICstCiA0IGZpbGVzIGNoYW5nZWQsIDExIGluc2VydGlvbnMoKyksIDYg ZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvc3JjL2Jpbi9wc3FsL2NvbW1hbmQuYyBiL3NyYy9i aW4vcHNxbC9jb21tYW5kLmMKaW5kZXggMjEzZDQ4NTAwZGUuLjM0MTJiMGUzZDI4IDEwMDY0NAot LS0gYS9zcmMvYmluL3BzcWwvY29tbWFuZC5jCisrKyBiL3NyYy9iaW4vcHNxbC9jb21tYW5kLmMK QEAgLTEyNzcsNyArMTI3Nyw3IEBAIGV4ZWNfY29tbWFuZF9kKFBzcWxTY2FuU3RhdGUgc2Nhbl9z dGF0ZSwgYm9vbCBhY3RpdmVfYnJhbmNoLCBjb25zdCBjaGFyICpjbWQpCiAJCQkJCXN1Y2Nlc3Mg PSBsaXN0RXh0ZW5zaW9ucyhwYXR0ZXJuKTsKIAkJCQlicmVhazsKIAkJCWNhc2UgJ1gnOgkJCS8q IEV4dGVuZGVkIFN0YXRpc3RpY3MgKi8KLQkJCQlzdWNjZXNzID0gbGlzdEV4dGVuZGVkU3RhdHMo cGF0dGVybik7CisJCQkJc3VjY2VzcyA9IGxpc3RFeHRlbmRlZFN0YXRzKHBhdHRlcm4sIHNob3df dmVyYm9zZSk7CiAJCQkJYnJlYWs7CiAJCQljYXNlICd5JzoJCQkvKiBFdmVudCBUcmlnZ2VycyAq LwogCQkJCXN1Y2Nlc3MgPSBsaXN0RXZlbnRUcmlnZ2VycyhwYXR0ZXJuLCBzaG93X3ZlcmJvc2Up OwpkaWZmIC0tZ2l0IGEvc3JjL2Jpbi9wc3FsL2Rlc2NyaWJlLmMgYi9zcmMvYmluL3BzcWwvZGVz Y3JpYmUuYwppbmRleCAzNTg0YzRlMTQyOC4uOWZjM2M1ZjlhZDQgMTAwNjQ0Ci0tLSBhL3NyYy9i aW4vcHNxbC9kZXNjcmliZS5jCisrKyBiL3NyYy9iaW4vcHNxbC9kZXNjcmliZS5jCkBAIC00ODkw LDcgKzQ4OTAsNyBAQCBsaXN0RXZlbnRUcmlnZ2Vycyhjb25zdCBjaGFyICpwYXR0ZXJuLCBib29s IHZlcmJvc2UpCiAgKiBEZXNjcmliZXMgZXh0ZW5kZWQgc3RhdGlzdGljcy4KICAqLwogYm9vbAot bGlzdEV4dGVuZGVkU3RhdHMoY29uc3QgY2hhciAqcGF0dGVybikKK2xpc3RFeHRlbmRlZFN0YXRz KGNvbnN0IGNoYXIgKnBhdHRlcm4sIGJvb2wgdmVyYm9zZSkKIHsKIAlQUUV4cEJ1ZmZlckRhdGEg YnVmOwogCVBHcmVzdWx0ICAgKnJlczsKQEAgLTQ5NDcsMTIgKzQ5NDcsMTcgQEAgbGlzdEV4dGVu ZGVkU3RhdHMoY29uc3QgY2hhciAqcGF0dGVybikKIAl7CiAJCWFwcGVuZFBRRXhwQnVmZmVyKCZi dWYsCiAJCQkJCQkgICIsXG5DQVNFIFdIRU4gIiBDcHBBc1N0cmluZzIoU1RBVFNfRVhUX01DVikg IiA9IGFueShlcy5zdHhraW5kKSBUSEVOICdkZWZpbmVkJyBcbiIKLQkJCQkJCSAgIkVORCBBUyBc IiVzXCIgIiwKKwkJCQkJCSAgIkVORCBBUyBcIiVzXCIiLAogCQkJCQkJICBnZXR0ZXh0X25vb3Ao Ik1DViIpKTsKIAl9CiAKKwlpZiAodmVyYm9zZSkKKwkJYXBwZW5kUFFFeHBCdWZmZXIoJmJ1ZiwK KwkJCQkJCSAgIixcbnBnX2NhdGFsb2cub2JqX2Rlc2NyaXB0aW9uKGVzLm9pZCwgJ3BnX3N0YXRp c3RpY19leHQnKSBBUyBcIiVzXCIiLAorCQkJCQkJICBnZXR0ZXh0X25vb3AoIkRlc2NyaXB0aW9u IikpOworCiAJYXBwZW5kUFFFeHBCdWZmZXJTdHIoJmJ1ZiwKLQkJCQkJCSAiIFxuRlJPTSBwZ19j YXRhbG9nLnBnX3N0YXRpc3RpY19leHQgZXMgXG4iKTsKKwkJCQkJCSAiXG5GUk9NIHBnX2NhdGFs b2cucGdfc3RhdGlzdGljX2V4dCBlc1xuIik7CiAKIAlpZiAoIXZhbGlkYXRlU1FMTmFtZVBhdHRl cm4oJmJ1ZiwgcGF0dGVybiwKIAkJCQkJCQkJZmFsc2UsIGZhbHNlLApkaWZmIC0tZ2l0IGEvc3Jj L2Jpbi9wc3FsL2Rlc2NyaWJlLmggYi9zcmMvYmluL3BzcWwvZGVzY3JpYmUuaAppbmRleCBiNjBh MmFkMGUxNC4uNDdmYWU1Y2VhZmIgMTAwNjQ0Ci0tLSBhL3NyYy9iaW4vcHNxbC9kZXNjcmliZS5o CisrKyBiL3NyYy9iaW4vcHNxbC9kZXNjcmliZS5oCkBAIC0xMTQsNyArMTE0LDcgQEAgZXh0ZXJu IGJvb2wgbGlzdEV4dGVuc2lvbnMoY29uc3QgY2hhciAqcGF0dGVybik7CiBleHRlcm4gYm9vbCBs aXN0RXh0ZW5zaW9uQ29udGVudHMoY29uc3QgY2hhciAqcGF0dGVybik7CiAKIC8qIFxkWCAqLwot ZXh0ZXJuIGJvb2wgbGlzdEV4dGVuZGVkU3RhdHMoY29uc3QgY2hhciAqcGF0dGVybik7CitleHRl cm4gYm9vbCBsaXN0RXh0ZW5kZWRTdGF0cyhjb25zdCBjaGFyICpwYXR0ZXJuLCBib29sIHZlcmJv c2UpOwogCiAvKiBcZHkgKi8KIGV4dGVybiBib29sIGxpc3RFdmVudFRyaWdnZXJzKGNvbnN0IGNo YXIgKnBhdHRlcm4sIGJvb2wgdmVyYm9zZSk7CmRpZmYgLS1naXQgYS9zcmMvYmluL3BzcWwvaGVs cC5jIGIvc3JjL2Jpbi9wc3FsL2hlbHAuYwppbmRleCBkZmQ5ZGQ3MzA3OC4uYmNmZGJiYmE1NzEg MTAwNjQ0Ci0tLSBhL3NyYy9iaW4vcHNxbC9oZWxwLmMKKysrIGIvc3JjL2Jpbi9wc3FsL2hlbHAu YwpAQCAtMjY3LDcgKzI2Nyw3IEBAIHNsYXNoVXNhZ2UodW5zaWduZWQgc2hvcnQgaW50IHBhZ2Vy KQogCUhFTFAwKCIgIFxcZHVbU3grXSBbUEFUVEVSTl0gICAgIGxpc3Qgcm9sZXNcbiIpOwogCUhF TFAwKCIgIFxcZHZbU3grXSBbUEFUVEVSTl0gICAgIGxpc3Qgdmlld3NcbiIpOwogCUhFTFAwKCIg IFxcZHhbeCtdICBbUEFUVEVSTl0gICAgIGxpc3QgZXh0ZW5zaW9uc1xuIik7Ci0JSEVMUDAoIiAg XFxkWFt4XSAgIFtQQVRURVJOXSAgICAgbGlzdCBleHRlbmRlZCBzdGF0aXN0aWNzXG4iKTsKKwlI RUxQMCgiICBcXGRYW3grXSAgW1BBVFRFUk5dICAgICBsaXN0IGV4dGVuZGVkIHN0YXRpc3RpY3Nc biIpOwogCUhFTFAwKCIgIFxcZHlbeCtdICBbUEFUVEVSTl0gICAgIGxpc3QgZXZlbnQgdHJpZ2dl cnNcbiIpOwogCUhFTFAwKCIgIFxcbFt4K10gICBbUEFUVEVSTl0gICAgIGxpc3QgZGF0YWJhc2Vz XG4iKTsKIAlIRUxQMCgiICBcXHNmWytdICAgRlVOQ05BTUUgICAgICBzaG93IGEgZnVuY3Rpb24n cyBkZWZpbml0aW9uXG4iKTsKLS0gCjIuNTIuMAoK --97ea0d9ef09e429568376a0f23ba4522b21a8726fc064cfce42b2cb5591e--