Skip site navigation (1) Skip section navigation (2)

road.thepath no longer in pg_stats?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: road.thepath no longer in pg_stats?
Date: 2010-04-27 23:45:15
Message-ID: 20100427234515.GM5237@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

I just noticed that the road.thepath column in the regression database
is no longer in pg_stats for some reason after ANALYZE, so the example
in section 14.2 in the docs (Statistics Used by the Planner) is now
wrong.

What I'm trying to do is replace that exceedingly wide output with
something along these lines instead:

SELECT attname, n_distinct, array_to_string(most_common_vals, E'\n') as most_common_vals
FROM pg_stats
WHERE tablename = 'road';

but this is failing because of missing values for that column, as well
as there being two rows for the column that is there (stainherint=f
producing the other one)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Responses

pgsql-hackers by date

Next:From: Jehan-Guillaume (ioguix) de RorthaisDate: 2010-04-27 23:45:34
Subject: providing tokenized version of parsed SQL script (was: nodeToString format and exporting the SQL parser)
Previous:From: Alvaro HerreraDate: 2010-04-27 23:28:29
Subject: Re: Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group