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.94.2) (envelope-from ) id 1ufga7-00AQJn-DU for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 15:13:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ufga6-00A6UT-8R for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 15:13:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ufga5-00A6UL-UW for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 15:13:02 +0000 Received: from mail-oo1-xc2b.google.com ([2607:f8b0:4864:20::c2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ufga2-000yYA-2N for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 15:13:01 +0000 Received: by mail-oo1-xc2b.google.com with SMTP id 006d021491bc7-615913ff67fso1638773eaf.0 for ; Sat, 26 Jul 2025 08:12:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1753542777; x=1754147577; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=OVWaVwkHcsWf5jk+PxL4/Mg8pWs0uA+lLDGz6UPm/iM=; b=ePeQRSKIkqx+taT8RbmqZl/MzGIh4ddpwBREKogN34wH6G02cO1+rGYGtkTboRce9D pyQl8Amuw7l0I/o7vaFFi26xbFCW57nv7hz4qlO6i2upQH6NJb9XQgNmgLV40rPd6k7l 0/ymq+FGuAV/JeujSE1k4vvYQv5k+wITmbIly3ET/0OM4G+GBdYdo3OA7nfTpUqpIScd eQaBNeEHBGrMxD9glZ7rqjFDI6IQz8fMJ9AKf5wJiT0sy++cvmtHGRwoQ9IZyKYdCHf+ HAq4H3LlXXIEHt7qXI/pEaytqs2Nuu3lTHRDWC8jL/y0sLz2zpCStI/ooGMefVv4PGif BdzA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1753542777; x=1754147577; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=OVWaVwkHcsWf5jk+PxL4/Mg8pWs0uA+lLDGz6UPm/iM=; b=E0CIIyQReBMR1/m29DScfy+Mx5DnOovWgq33RXvsAkFhmvCRylRUSjm2hAYNJQMY9P fEu+0g3dTCg4QxTKXqFIj0v2zdcO6owkXeuxQjSQLraud+dmLxsXYeEYYDlpXHr+ydJO 2JK9J+idk6g1yrRLmqzqjyRqxX0e0AherEU2I3cZU0FZtd23vFt3VMl8hWSKb4fLqBnC fmBrYJVrI3fw0/2arONWzmkoLpiRw2CPu507XnnhA616EJZuDVxU++XJGRTMWEsZIj8P oReadnlSp6QcxcjZGYAMmSZ/5GXrE6KYApoezvvXp8iXY4dQILLFLBR67FdVjoLpIPOx TxCQ== X-Gm-Message-State: AOJu0YzRBKmuKRnUZHabVdKz9VLCl7FWcogG0pW27piBwQN3hMg9oE7b T+FMpHVyP2EkBgUnXpvxh0wwA9pr66N6H5qVKfARcv3oeCT9ijvkvRl5amFeNplQL1rzse0CTIV 0Z5EIrvkb/z3x3R5rbsd+L/4pgDq1jXcnlw== X-Gm-Gg: ASbGnctaQZUvre2PlvQO51mRF3QQi4VAmf6LNO5pSK3M2FaanwOQDWqBBGLK6Aj9B4Z r86g2XVA2OyjaALkG8oPWWyzzj4DlMleUply9kfc74IZCvHOXwJ+u0xmhefNeuno/qFxYS47k7T aTSnN5cmti5fsR3xlHZmVPfNgRIwTpO/NcT642zfFtBbhKtIobCi3OI751dnuJ7p/SX+i4JmU4u UOGpw3dC1O8SsVKVRE= X-Google-Smtp-Source: AGHT+IGwyNShUI86uMnFyM3rmZsDxia5y/M5XzPFatqKNTIscKvFs1hb7WrDMEvXGSYcT/+o/7WGOTFSk0onyR04iiA= X-Received: by 2002:a05:6820:4417:b0:619:22ea:e11 with SMTP id 006d021491bc7-61922ea1511mr417334eaf.3.1753542777292; Sat, 26 Jul 2025 08:12:57 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: "David G. Johnston" Date: Sat, 26 Jul 2025 08:12:47 -0700 X-Gm-Features: Ac12FXwGED1hrbVq04JJc1rq8Dqb1NuCtnaXKQug7DFfhLu-pH_pbeX25UQeTxM Message-ID: Subject: Re: Get info about the index To: Igor Korot Cc: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000056cf3e063ad67efc" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000056cf3e063ad67efc Content-Type: text/plain; charset="UTF-8" On Sat, Jul 26, 2025, 08:00 Igor Korot wrote: > Hi, ALL, > Is there a better place to get the info about the index other than > https://www.postgresql.org/docs/current/view-pg-indexes.html > > That guy has a full blown CREATE INDEX command and I will need to > parse it to get the info I need. > Follow the foreign keys. All useful info does get parsed out into columns somewhere. The system doesn't parse a create index command everytime it needs to inspect the properties of the index. David J. --00000000000056cf3e063ad67efc Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Jul 26, 2025, 08:00 Igor Korot <ikorot01@gmail.com<= /a>> wrote:
Hi, ALL,
Is there a better place to get the info about the index other than
https://www.postgr= esql.org/docs/current/view-pg-indexes.html

That guy has a full blown CREATE INDEX command and I will need to
parse it to get the info I need.

Follow the foreign keys.

All useful info does get parsed out into c= olumns somewhere.=C2=A0 The system doesn't parse a create index command= everytime it needs to inspect the properties of the index.

David J.

<= /div>
--00000000000056cf3e063ad67efc--