Re: [HACKERS] Extracting GiST index structure stats? - Mailing list pgsql-hackers

From Arthur Zakirov
Subject Re: [HACKERS] Extracting GiST index structure stats?
Date
Msg-id b0d8a6bf-92cf-5e62-8c73-5620894ca19c@postgrespro.ru
Whole thread Raw
In response to [HACKERS] Extracting GiST index structure stats?  (Thomas Mercieca <tmercieca@msn.com>)
List 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 by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: [HACKERS] Optimization for updating foreign tables in PostgresFDW
Next
From: Yugo Nagata
Date:
Subject: Re: [HACKERS] [POC] hash partitioning