Commit3d5facf

committed

Remove pg_stats_ext view

It was created as equivalent of pg_stats, but since the code underlyingpg_statistic_ext is more convenient than the one for pg_statistic,pg_stats_ext is no longer useful.Author: David RowleyReviewed-by: Tomas VondraDiscussion:https://postgr.es/m/CAKJS1f9zAkPUf9nQrqpFBAsrOHvb5eYa2FVNsmCJy1wegcO_TQ@mail.gmail.com

1 parent06fc54c commit3d5facfCopy full SHA for 3d5facf

File tree

-27

lines changed

doc/src/sgml
- planstats.sgml
src
- backend/catalog
  - system_views.sql
- test/regress/expected
  - rules.out

-27

lines changed

Lines changed: 5 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -520,17 +520,15 @@ EXPLAIN ANALYZE SELECT * FROM t WHERE a = 1 AND b = 1;`
`520`	`520`
`521`	`521`	`<para>`
`522`	`522`	`Similarly to per-column statistics, extended statistics are stored in`
`523`		`- a system catalog called <structname>pg_statistic_ext</structname>, but`
`524`		`- there is also a more convenient view <structname>pg_stats_ext</structname>.`
	`523`	`+ a system catalog called <structname>pg_statistic_ext</structname>.`
`525`	`524`	`To inspect the statistics <literal>s1</literal> defined above,`
`526`	`525`	`you may do this:`
`527`	`526`
`528`	`527`	`<programlisting>`
`529`		`-SELECT tablename, staname, attnums, depsbytes`
`530`		`- FROM pg_stats_ext WHERE staname = 's1';`
`531`		`- tablename \| staname \| attnums \| depsbytes`
`532`		`------------+---------+---------+-----------`
`533`		`- t \| s1 \| 1 2 \| 40`
	`528`	`+SELECT staname,stadependencies FROM pg_statistic_ext WHERE staname = 's1';`
	`529`	`+ staname \| stadependencies`
	`530`	`+---------+--------------------------------------------`
	`531`	`+ s1 \| [{1 => 2 : 1.000000}, {2 => 1 : 1.000000}]`
`534`	`532`	`(1 row)`
`535`	`533`	`</programlisting>`
`536`	`534`

Lines changed: 0 additions & 11 deletions

Original file line number	Diff line number	Diff line change
`@@ -186,17 +186,6 @@ CREATE OR REPLACE VIEW pg_sequences AS`
`186`	`186`	`WHERE NOT pg_is_other_temp_schema(N.oid)`
`187`	`187`	`AND relkind='S';`
`188`	`188`
`189`		`-CREATEVIEWpg_stats_extAS`
`190`		`-SELECT`
`191`		`-N.nspnameAS schemaname,`
`192`		`-C.relnameAS tablename,`
`193`		`-S.stanameAS staname,`
`194`		`-S.stakeysAS attnums,`
`195`		`- length(s.standistinct::bytea)AS ndistbytes,`
`196`		`- length(S.stadependencies::bytea)AS depsbytes`
`197`		`-FROM (pg_statistic_ext SJOIN pg_class CON (C.oid=S.starelid))`
`198`		`-LEFT JOIN pg_namespace NON (N.oid=C.relnamespace);`
`199`		`-`
`200`	`189`	`CREATEVIEWpg_stats WITH (security_barrier)AS`
`201`	`190`	`SELECT`
`202`	`191`	`nspnameAS schemaname,`

Lines changed: 0 additions & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -2188,15 +2188,6 @@ pg_stats\| SELECT n.nspname AS schemaname,`
`2188`	`2188`	`JOIN pg_attribute a ON (((c.oid = a.attrelid) AND (a.attnum = s.staattnum))))`
`2189`	`2189`	`LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)))`
`2190`	`2190`	`WHERE ((NOT a.attisdropped) AND has_column_privilege(c.oid, a.attnum, 'select'::text) AND ((c.relrowsecurity = false) OR (NOT row_security_active(c.oid))));`
`2191`		`-pg_stats_ext\| SELECT n.nspname AS schemaname,`
`2192`		`- c.relname AS tablename,`
`2193`		`- s.staname,`
`2194`		`- s.stakeys AS attnums,`
`2195`		`- length((s.standistinct)::bytea) AS ndistbytes,`
`2196`		`- length((s.stadependencies)::bytea) AS depsbytes`
`2197`		`- FROM ((pg_statistic_ext s`
`2198`		`- JOIN pg_class c ON ((c.oid = s.starelid)))`
`2199`		`- LEFT JOIN pg_namespace n ON ((n.oid = c.relnamespace)));`
`2200`	`2191`	`pg_tables\| SELECT n.nspname AS schemaname,`
`2201`	`2192`	`c.relname AS tablename,`
`2202`	`2193`	`pg_get_userbyid(c.relowner) AS tableowner,`

Comments

(0)