From 891a1d0bca262ca78564e0fea1eaa5ae544ea5ee Mon Sep 17 00:00:00 2001 From: Tomas Vondra Date: Sun, 17 Jan 2021 00:16:25 +0100 Subject: psql \dX: list extended statistics objects The new command lists extended statistics objects, possibly with their sizes. All past releases with extended statistics are supported. Author: Tatsuro Yamada Reviewed-by: Julien Rouhaud, Alvaro Herrera, Tomas Vondra Discussion: https://postgr.es/m/c027a541-5856-75a5-0868-341301e1624b%40nttcom.co.jp_1 --- doc/src/sgml/ref/psql-ref.sgml | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 221a967bfe6..aaf55df9215 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1918,6 +1918,28 @@ testdb=> + + + \dX [ pattern ] + + + Lists extended statistics. + If pattern + is specified, only those extended statistics whose names match the + pattern are listed. + If + is appended to the command name, each extended + statistics is listed with its size. + + + + The column of the kind of extended stats (e.g. Ndistinct) shows some statuses. + "requested" means that it needs to collect statistics by ANALYZE. + "built" means ANALYZE was + finished, and the planner can use it. NULL means that it doesn't exists. + + + \dy[+] [ pattern ] -- cgit v1.2.3