diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2017-04-13 11:35:22 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2017-04-13 11:35:22 -0300 |
| commit | 3d5facfd9ab66c819ed583b2614b0560405a6aa2 (patch) | |
| tree | 9f9dae6b8970b4764141bd236c07a109d1470ea2 /doc/src | |
| parent | 06fc54cd4355caf8e271ffc864885ccaa879159e (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/planstats.sgml | 12 |
1 files changed, 5 insertions, 7 deletions
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; <para> Similarly to per-column statistics, extended statistics are stored in - a system catalog called <structname>pg_statistic_ext</structname>, but - there is also a more convenient view <structname>pg_stats_ext</structname>. + a system catalog called <structname>pg_statistic_ext</structname>. To inspect the statistics <literal>s1</literal> defined above, you may do this: <programlisting> -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) </programlisting> |