| From: | Arthur Zakirov <a(dot)zakirov(at)postgrespro(dot)ru> |
|---|---|
| To: | Thomas Mercieca <tmercieca(at)msn(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Extracting GiST index structure stats? |
| Date: | 2017-04-17 08:33:01 |
| Message-ID: | b0d8a6bf-92cf-5e62-8c73-5620894ca19c@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yugo Nagata | 2017-04-17 08:50:42 | Re: [POC] hash partitioning |
| Previous Message | Kyotaro HORIGUCHI | 2017-04-17 08:23:24 | Re: Optimization for updating foreign tables in Postgres FDW |