Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nbxo4-0000ZS-9R for pgsql-docs@arkaria.postgresql.org; Wed, 06 Apr 2022 05:02:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nbxo2-0007Rx-TI for pgsql-docs@arkaria.postgresql.org; Wed, 06 Apr 2022 05:02:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nbxo2-0007Rn-M2 for pgsql-docs@lists.postgresql.org; Wed, 06 Apr 2022 05:02:10 +0000 Received: from mail-yb1-xb29.google.com ([2607:f8b0:4864:20::b29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nbxo0-0001R2-8n for pgsql-docs@lists.postgresql.org; Wed, 06 Apr 2022 05:02:10 +0000 Received: by mail-yb1-xb29.google.com with SMTP id w134so2076027ybe.10 for ; Tue, 05 Apr 2022 22:02:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=THPnr45gZ7P0KJ/Bl25098YYFiMK9DrnWESUpZh9V28=; b=EXsqcR20624M+5dUdkkb0ScMi9AsM4H0FhLEd5gCN93HWTlzoYaqxiFhmGtJ8Gm2x0 fGFo6aZ6asFgjAnFX0fKMTqWVxg/QCQJqPqreGy9eP49F4RXWlrbNbHUWABIEH8dnosA NI5nfGHbxsSXEzF1nAGCtbRFE6n0OAWWl+kszqLgOcMIwgs0fi2tdFUiXy3ClzhXZ5Ca dNACS7wgcQpPpXtMUFk1lqG80Vii+UcjpxltpvzRYBCxmCADIoL7vQYQ5MNUYMZ+Q8XH apLf0rjpfNquzObQf/K/V7YIh9v/KazaIfDIgGZx71J+E5UikesjwQoGZClTgfuVR7xS Qoew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=THPnr45gZ7P0KJ/Bl25098YYFiMK9DrnWESUpZh9V28=; b=L8OaW/cQReQjQ18LI/FhMpYJhGzcQGA81KOxMBXHpyZc8KZ6+EnumHjh4+887muLl1 fqvR8x9RU+PBFxKu4pdOg36PZ/BvlgHft+pAlpzm5YaNuG5QTH7ohw3sR6Sj+ikeUIo2 l3ZxTOJLisOwUv5JrpMZX3mZwEQ6wyv6EzT1Nmng4j5L3D35mEiO/m5CjiqCd6zu2fpV ehgYEjAtSjH9KvCAPlqK0YWmzQlmV+aIhu53Hu4KtyLRRiMKAL+YqXiOo1oU4WG6gJrT U5XGTG+JpsJ4l20wtRhFIYoNtZSv3DTCx8LP4BhbWvS74QMkEUdbMEbNwAx8JDhSLJQg 8cLA== X-Gm-Message-State: AOAM533UNr+cJKdzm9Y2FOTFCrwAm1DBBAz7O1OJTvFLxIzLthZPIq6f dBvF1V6GD9OoMeFQ2o5I+8s2IxT3zHvqBMjOR1mZh98eIK2nWZal X-Google-Smtp-Source: ABdhPJy8kHDR4HcdFBSc2RHsI09dywPkpXCwCiWGSUueymZXATHRX5AG31X+VwBCVrQhth0B7baDyYFW5m9HvLi2A4g= X-Received: by 2002:a25:be02:0:b0:629:649a:f3af with SMTP id h2-20020a25be02000000b00629649af3afmr5131039ybk.238.1649221326315; Tue, 05 Apr 2022 22:02:06 -0700 (PDT) MIME-Version: 1.0 From: Jian He Date: Wed, 6 Apr 2022 10:31:55 +0530 Message-ID: Subject: stxkind only explain two elements. left two unexplained. To: pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000004fa45a05dbf54305" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000004fa45a05dbf54305 Content-Type: text/plain; charset="UTF-8" PostgreSQL: Documentation: 10: 51.51. pg_statistic_ext > stxkind : An array containing codes for the enabled statistics kinds; > valid values are: d for n-distinct statistics, f for functional > dependency statistics select distinct stxkind from pg_statistic_ext ; return: stxkind > --------- > {d} > {m} > {f} > {e} > (4 rows) I guess *e *for expression statistics. Since I create the following statistics object. create statistics flight_expr1 on( extract (month from scheduled_departure at time zone 'Asia/Kolkata') ) from flights; select stxkind from pg_statistic_ext where stxname = 'flight_expr'; and it return *e.* But I am not sure what does *m *mean? It would be better to full explain all these four elements in the doc. --0000000000004fa45a05dbf54305 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
stxkind :=C2=A0An array containing codes= for the enabled statistics kinds; valid values are:=C2=A0d=C2=A0for n= -distinct statistics,=C2=A0f=C2=A0for functional dependency statistics=
=C2=A0
select distinct stxkind from pg_s= tatistic_ext ;
return:

=C2=A0stxkind
---------
=C2=A0{d= }
=C2=A0{m}
=C2=A0{f}
=C2=A0{e}
(4 rows)

<= /div>
=C2=A0I guess e for expression=C2=A0statistics. Since I create the following statistics object.
create statistics flight_expr1 on(
    extract
    (month from scheduled_dep=
arture at time zone 'Asia/Kolkata')
    ) from flights;
select stxkind from pg_statistic_ext where=
 stxname =3D  'flight_expr';
and it return e.
But I a= m not sure what does m mean?=C2=A0

It would be better to full ex= plain all these four elements in the doc.=C2=A0
--0000000000004fa45a05dbf54305--