[GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема [GENERAL] unnest-like pg_stats.most_common_values and pg_stats.most_common_freqs
Дата
Msg-id CAKoxK+4d8cssGCTjsbLQNxCMaSND2FYvx92X3_moT_rPrfL65g@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] unnest-like pg_stats.most_common_values andpg_stats.most_common_freqs  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-general
Hi all,
maybe this is trivial, but I need an hint on a way to see a table form
of the MCVs and MCFs out of pg_stats with a query. Is it possible to
get a set of rows each with a most common value on one column and the
corresponding column on the the other? (assuming I can cast the array
of MCVs to the right type array)

Thanks,
Luca


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] mild modification to pg_dump
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: [GENERAL] unnest-like pg_stats.most_common_values andpg_stats.most_common_freqs