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 1ui3Gk-0079Pk-BC for pgsql-general@arkaria.postgresql.org; Sat, 02 Aug 2025 03:50:50 +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 1ui3Gh-00Ag9F-Uz for pgsql-general@arkaria.postgresql.org; Sat, 02 Aug 2025 03:50:47 +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 1ui3Gh-00Ag97-KM for pgsql-general@lists.postgresql.org; Sat, 02 Aug 2025 03:50:47 +0000 Received: from mail-yw1-x112b.google.com ([2607:f8b0:4864:20::112b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ui3Ge-000IWe-1W for pgsql-general@lists.postgresql.org; Sat, 02 Aug 2025 03:50:46 +0000 Received: by mail-yw1-x112b.google.com with SMTP id 00721157ae682-71a34087749so17192687b3.2 for ; Fri, 01 Aug 2025 20:50:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754106644; x=1754711444; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=MotHW4WCIo8fTeDgDovPFHWtoDd1csmIH94aunTz/Tw=; b=fPCQHspe1Le+gB/1gHZjqhuzOKNFYHtimE0QZz9JmRiw+K29XhUoJ96gx5V9OlQlzO ZT5F/EuSux7eIH761qu4Wu9JFfbYPuZU+50K0wMra40Y7qgtDInFtW9hQPjTXvPS6cl9 cJLBxMhIsWZ7sD6oNEbPzgB1ipBLdFChtwwcTDbSbPTZSnw5c6uk5CUt4Pnc26vd/b3I cgOwXtWdWdI7fE+K8h3MJQFln7mPJFHzmU/rpPRG7bQ2PlykHfsOtFZF8fUIDBNU9rac FwOnmX6yFEJ8EM9VF8V7LH4Nht2/fviwL0RRVifmrFmpJ+UGtp5kuQ/j39LM2yd3mz4+ fG2Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754106644; x=1754711444; h=content-transfer-encoding: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=MotHW4WCIo8fTeDgDovPFHWtoDd1csmIH94aunTz/Tw=; b=qkLstwuVJrRSkaQ35F0Mhu9og2+BT/D8WKKlpMRqE5MB2oYEqR1v0A6Pdzh5YthWxZ QHwT7oOOe5gT/YbMsg+b7hoVm4F5b39p+ChB0UwbjCFvV6/DR74nMqOT49R7svyw4KDG xAv8ksiu69fmXfStxgQmuEdod/pA21+F0HaGKwod1JFFzgAKfezo5PMdm6Q8m5YGnGYV 8e8rnuCAQYFRiv1PlYjTT98ZXRwbSToC6L9z+gbMeKf6Jk/+/EKYQtImG3sit80kbHDW /Vvux3yXCvKtHEmlfkc52EWEwBXGNRrMLaus3DlWCFCyTRBt+I8h2sGS2svRfJyu1ZdG zFKw== X-Forwarded-Encrypted: i=1; AJvYcCVNJmaniYPEc8rYXslxUe9ZyeqkXCY+DCU7yv9xQiD92fNk5pmJth92e16Q2ESwENIGA1kGDnwl/v4gMqsQ@lists.postgresql.org X-Gm-Message-State: AOJu0YyV9xnk6+Gpc5ofneXN2kciK/L0k6WcgdfadxLCAVJF/TH5NY+t 4/2sTmHXc1uF8T4k9/6GM+xDofl6c0Un6CPF+OEF7l5AC55JnwiLjz3TG7pNwfqXjqGXL0IakYx lnLo4nG8oB6vg9dDMjDE0hwzKIk1m7dA= X-Gm-Gg: ASbGnctRYzDR76JEuFXQ2mQhWwywtiVX6mhc3EqYgrCruwzW0mo0R3c1gV/INtp5MAg xEZ6B3s3fAHm7GM11ISvGXE/0Ghe6/CJkCsBbYrqEOb/ebOHR2j2ln6qnW+YsREeplJRv3A4BnF ooANFqqzejLUIXGh+Ruv/ULNxK1rs0NOtjmzz3FhdffRByvynkxw+h+8Hz4PAzzFI44HCsYwKP2 ZXYtTDKLKhq1V0OJuhAh+8lIijx3egbA1VU/W9j9CVt2mXmRA== X-Google-Smtp-Source: AGHT+IE6S7xO8yl13KfhXXc0jLY2kaTTYeXRNThtCSnPuAA4FYHho/lLiWDo1WAfzWQda1askbvvQlC4/1LZkWwIwtw= X-Received: by 2002:a05:690c:f10:b0:71a:1445:b418 with SMTP id 00721157ae682-71b7f5e138cmr28298327b3.8.1754106644240; Fri, 01 Aug 2025 20:50:44 -0700 (PDT) MIME-Version: 1.0 References: <090d8588-e74e-4436-8f69-05ce8624379b@aklaver.com> <0BC8BEBF-3B1F-4E69-A1B9-CCCDF9617168@thebuild.com> <7281c379994ffc70cebb68423f5b8ba339d0d75f.camel@cybertec.at> <2fad4427bff83bc73f9b4215e284a76343f046f2.camel@cybertec.at> In-Reply-To: From: Igor Korot Date: Fri, 1 Aug 2025 23:50:15 -0400 X-Gm-Features: Ac12FXzgwWiGS4mA6WzHEX5Q8KI6zkyIZaV47J0Lxv8_6Ll9q8vfUzUZWaFu4BM Message-ID: Subject: Re: Get info about the index To: Adrian Klaver Cc: Laurenz Albe , David Barbour , Jon Zeppieri , Christophe Pettus , "pgsql-generallists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Adrian, On Fri, Aug 1, 2025 at 8:13=E2=80=AFPM Adrian Klaver wrote: > > On 8/1/25 17:06, Igor Korot wrote: > > Hi, Laurenz, > > > > > I'm looking at the pg_index table and I see it has: > > > > [quote] > > indisexclusion bool > > > > If true, this index supports an exclusion constraint > > [/quote] > > > > If I read the docs correctly, this field indicates whether the > > WHERE condition is actually present. > > > > Am I right? > > No, it refers to: > > https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAI= NTS-EXCLUSION Thx for clarification. But is there a field that I'm referencing above? Thank you. > > > > > Thank you. > > > >> > >> Yours, > >> Laurenz Albe > > > -- > Adrian Klaver > adrian.klaver@aklaver.com