From 3d5facfd9ab66c819ed583b2614b0560405a6aa2 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Thu, 13 Apr 2017 11:35:22 -0300 Subject: Remove pg_stats_ext view It was created as equivalent of pg_stats, but since the code underlying pg_statistic_ext is more convenient than the one for pg_statistic, pg_stats_ext is no longer useful. Author: David Rowley Reviewed-by: Tomas Vondra Discussion: https://postgr.es/m/CAKJS1f9zAkPUf9nQrqpFBAsrOHvb5eYa2FVNsmCJy1wegcO_TQ@mail.gmail.com --- doc/src/sgml/planstats.sgml | 12 +++++------- 1 file changed, 5 insertions(+), 7 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/planstats.sgml b/doc/src/sgml/planstats.sgml index f8af42f394a..a4f91c737af 100644 --- a/doc/src/sgml/planstats.sgml +++ b/doc/src/sgml/planstats.sgml @@ -520,17 +520,15 @@ EXPLAIN ANALYZE SELECT * FROM t WHERE a = 1 AND b = 1; Similarly to per-column statistics, extended statistics are stored in - a system catalog called pg_statistic_ext, but - there is also a more convenient view pg_stats_ext. + a system catalog called pg_statistic_ext. To inspect the statistics s1 defined above, you may do this: -SELECT tablename, staname, attnums, depsbytes - FROM pg_stats_ext WHERE staname = 's1'; - tablename | staname | attnums | depsbytes ------------+---------+---------+----------- - t | s1 | 1 2 | 40 +SELECT staname,stadependencies FROM pg_statistic_ext WHERE staname = 's1'; + staname | stadependencies +---------+-------------------------------------------- + s1 | [{1 => 2 : 1.000000}, {2 => 1 : 1.000000}] (1 row) -- cgit v1.2.3