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 1ufgNs-00AOLp-H5 for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 15:00:25 +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 1ufgNq-009uTa-BE for pgsql-general@arkaria.postgresql.org; Sat, 26 Jul 2025 15:00:22 +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.94.2) (envelope-from ) id 1ufgNp-009uTF-Vu for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 15:00:22 +0000 Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ufgNo-000tWr-1J for pgsql-general@lists.postgresql.org; Sat, 26 Jul 2025 15:00:21 +0000 Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-e8dee33b5d8so1353988276.0 for ; Sat, 26 Jul 2025 08:00:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1753542019; x=1754146819; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Arf+vURULPM5kXFBwX4H9FoReHIyU+Nky6PNnCoGV88=; b=Ey3A+UEAYV7SlGxvRnMG6Hn4YR4U/ed1m95bzAJ3ls7OgvmjMxKDRBkwLFPw84uOMu iH1IKPI0tLX17Eoh+8kziD/i1fWr5MALL/OhcETP9TB+zJvHspB/l3iVq/VNJ+ut54iT wd5V9bHQ75qS8SGMN0CsEw7OXm7yBofcwaXUsHkLNJshLeTKXO+bfITpMsj9KJe+Z/4e fnKIalVuld3WFzVBA3HDw4G9TdXIhw3dp2Rp50iY2561Gz+5Z/iV4W6WvvmKTUgTY9+n +H3MZNhm+WXiJwEyfGrde6ErfsvS60ZbTzrA6rp85mb9lWG3x4BlIrdr0DT4Fi3561I2 D/Sw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1753542019; x=1754146819; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Arf+vURULPM5kXFBwX4H9FoReHIyU+Nky6PNnCoGV88=; b=EPXnIa2Gc20+gb//miWf8dLzZwJu+NgEXGnMBe1QEw3dukmCGiakR2EBUzY1Bz1Fl5 6gmb0vnJBcO76mvjmHBR2n5qr31kjQtCUVhB+UFa0EWRo3DX1c19rY3o20l0FlbYbed/ 9gP/rcvOQP6XtYZ56yQzp9kzoboTbjmiMNs/Pex1wvfcOgaM0yr8KKKL3/xBuHItIcau MapdUsnD8I2ub7IIhnUWCvLOTeGL+5GS7HsLqiF+dbMPuP/IwC8v447edyh+aVRvFaTZ 3Rdd+voo7hsa/v/hEYNNlgQcQT/73Dd2zmeUDgLAeS25YcDDpygii9SS2yoRTGQJcuha SQQg== X-Gm-Message-State: AOJu0YxTDEgHYSuKznX/kr5j+wHg3FQYyb+XP6q30ss1x6tBO/AqSbhS Mip1xL64lh2lY8vu7wjH8Ci8oYMAIUlftbi0qLdiFALU2JliQymiR62drQBjPrppUMXIILRRX6d jzsVf5thitTpFWFmHE1J/bgBQIkVTr6qh+AM4Gow= X-Gm-Gg: ASbGncvh98uU+Gxy+u1vjtg6XUgkGHqk0OVjeXa78zzuZhWqIZVX8gYqhmpvjNosC2W Q4URcwgyCkzzp4QRx2eXO6EXTlO2U2jkyVqjcW7Dsq0Zvqjz9SZ3gJfcR1XrcQcIxGvXZ9tj6a6 jl6tN/0mk50C8tTUQhHO+ISWDkJjfV/2Z9NmrZWQCDUI9SEjdpH9eWsMtsPymqmfdxIhzQWE9Nc /DPQG5GN/gy0nzzDI2tAg== X-Google-Smtp-Source: AGHT+IE81G7u2BfMm5lFw3wdDF9eUoyG6TXnX0R8+Tte89OF57CnLjHu4Uo/IDGk+2Gm2kqTfi6f5bHhMg7/1n9GbTQ= X-Received: by 2002:a05:690c:9992:b0:710:edf9:d93b with SMTP id 00721157ae682-719e32f2ea5mr57046627b3.11.1753542018612; Sat, 26 Jul 2025 08:00:18 -0700 (PDT) MIME-Version: 1.0 From: Igor Korot Date: Sat, 26 Jul 2025 10:00:05 -0500 X-Gm-Features: Ac12FXyb6WqjhQHBfC_p4Oiq65d-NQMSZJpEQf5JCN7mr52pO1kxG09aws-30ko Message-ID: Subject: Get info about the index To: "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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. Thank you.