Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP6Ik-0006sC-K7 for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Nov 2018 13:42:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gP6Ij-00045z-4R for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Nov 2018 13:42:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP6Ii-00045r-Qd for pgsql-hackers@lists.postgresql.org; Tue, 20 Nov 2018 13:42:48 +0000 Received: from mail-qk1-x742.google.com ([2607:f8b0:4864:20::742]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gP6If-0002j9-Rl for pgsql-hackers@postgresql.org; Tue, 20 Nov 2018 13:42:48 +0000 Received: by mail-qk1-x742.google.com with SMTP id o125so2871294qkf.3 for ; Tue, 20 Nov 2018 05:42:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=j0BkgvJCvg/4WkSZYTtqCkZi+KgzvGaMmVQE2/ZieFM=; b=c1YpWB++oDIXIFjJ+Zio312+VacUYIiJLFrv6RfkQJ//8dn/00cmTD0RNuZtnAlEd6 EAef8EEWwg9y0bKjJv8osBjITjYcGiH0VjklXy6wELWRfeGQ5uq1oWxPSk8qe0IguWk+ 2ZSYDIz33O5mwGdybTXyBpW6gQ/o0Bucgo465iDvlbXY18MkHDOTjGUg7TDc0oA7tdWQ tHgV1aNKSRCI61KBfXLuZ+4/8HM7q4QTyiTvYyCZfY4Ja4Fc5KYXw70C54TXPheLhMQD Ql8Yp5jZAk7VZiDpvtjXSMTNq90+2aQUTViOMjDYtj2hRvZOrCxiAsZfciusR4P/9OeH y7dw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=j0BkgvJCvg/4WkSZYTtqCkZi+KgzvGaMmVQE2/ZieFM=; b=mDoUk7zvzjBeDPRfyLR4uRB4by6GTNwVhOJ9oqpwAD8UY55wBQsyVSCL4YcF9PYnhp nWmFdrSItX5uok9oylAoloJ+f8KKqc+vJjO7g5Avjr0ab2PGECGF6/TJjajmzx0LqRsu 5xfFERFl8pjPXjbjC6u18MEp7gmTruSNcK6iRbhLg2QUzoCXglNf4bvfNEBIafqxHT0i VBlQjOuleM5nXqxhRxma622IlJDAPUxMODOQU9X01VAEc9X+wQ53gIEe4PvgcIg1VQUB k/FFby+l49iwysJFsgbAlH0VttAElaDut4JSmMCmKvEDvvDGd6WrbfoVAbf6dDT/r5gA 5mhg== X-Gm-Message-State: AGRZ1gIVvcB3R9OefviA3S9qmSN9vbTBQtnJ1P67oD2Uqjsdxv2GXvv4 N2jGkQ/YAtZ+kZDgEZUrq4Uaj9/lOe0= X-Google-Smtp-Source: AJdET5cxGSbjwOwn8XrqeirzzvIXYrVxFW1Jt2SHqpnI8eo1wWGYNQGHYKy1ZOswPwffULB6HW56kg== X-Received: by 2002:ac8:5156:: with SMTP id h22mr1821463qtn.81.1542721364121; Tue, 20 Nov 2018 05:42:44 -0800 (PST) Received: from alvin.alvh.no-ip.org ([190.121.29.3]) by smtp.gmail.com with ESMTPSA id s34sm19132932qth.72.2018.11.20.05.42.43 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Tue, 20 Nov 2018 05:42:43 -0800 (PST) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id CC886640; Tue, 20 Nov 2018 10:42:41 -0300 (-03) Date: Tue, 20 Nov 2018 10:42:41 -0300 From: Alvaro Herrera To: s.cherkashin@postgrespro.ru Cc: Michael Paquier , Nikita Glukhov , pgsql-hackers@postgresql.org Subject: Re: Psql patch to show access methods info Message-ID: <20181120134241.36tjfswliqimvncv@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <64178681578cd2f1013db32bb7c00ddd@postgrespro.ru> User-Agent: NeoMutt/20180716 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2018-Nov-20, s.cherkashin@postgrespro.ru wrote: > Ok, I fixed this. Cool. I'm not sure this is a good idea: "c.relname::pg_catalog.regclass" I would use c.oid::pg_catalog.regclass instead. But before getting into those details, I think we should discuss the user interface that this patch is offering: \dip [am pattern] lists index properties (according to doc patch) * OK, but why do we need an AM pattern? ... reads regress output ... oh, actually it's an index name pattern, not an AM pattern. Please fix docs. \dicp [idx pattern] [column pattern] list index column properties * I think the column pattern part is pointless. \dA{f,p,fo,fp,oc} Please explain what these are. I think this is two patches -- one being the \dip/\dicp part, the other the \dA additions. Let's deal with them separately? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services