Re: [HACKERS] Extracting GiST index structure stats?

Поиск
Список
Период
Сортировка
От Arthur Zakirov
Тема Re: [HACKERS] Extracting GiST index structure stats?
Дата
Msg-id b0d8a6bf-92cf-5e62-8c73-5620894ca19c@postgrespro.ru
обсуждение исходный текст
Ответ на [HACKERS] Extracting GiST index structure stats?  (Thomas Mercieca <tmercieca@msn.com>)
Список pgsql-hackers
Hello,

On 15.04.2017 20:38, Thomas Mercieca wrote:
> Hi all, I am interested in getting simple statistics of a GiST index 
> structure. For example, heightof tree.
> 
> 
> It seems that the other indexes have a metapage for this. I am still 
> unsure but it looks to me like the GiST access method internal does not 
> work exactly in this way so it is a bit more complicated to extract this 
> data. Is this correct? If I wanted to extract this kind of stat (back to 
> the height of tree example) what would be the right approach? Thanks a lot.
> 
> 

Have you tried the 'gevel' module? You can find it here:
http://www.sai.msu.su/~megera/wiki/Gevel

-- 
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company



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

Предыдущее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] Optimization for updating foreign tables in PostgresFDW
Следующее
От: Yugo Nagata
Дата:
Сообщение: Re: [HACKERS] [POC] hash partitioning