On Tue, Jan 31, 2012 at 2:36 PM, Marc Mamin <m.ma...@intershop.de> wrote: > But this raises an interesting question on how/where does Postgres store > statistics on functional indexes. > in pg_statistics there are information on the column content, but I couldn't > find stats on the function result which is fully computed only during the > index creation.
Look for rows where starelid is equal to the OID of the index. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance