Extracting GiST index structure stats?
Hi all, I am interested in getting simple statistics of a GiST index structure. For example, height of 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.
Regards,
Thomas
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers