11

What kind of visualizations/statistics can I get from PostGIS' GiST index?

If we look at Wikipedia's R-tree entry, there are different R-tree variations and visualizations of bounding boxes of each using ELKI. GiST index is similar to R-Tree index. So is there some method/ extension for this kind of visualization (perhaps through QGIS)?

Edit: Here it is also visualized - how is this achieved?

Improve this question
3
  • 3
    Interesting question. For what it is worth, spatial indexes are actually implemented using GIST in Postgres (which is a generalization allow more specific indexes such as R-trees to be constructed), so you will probably need to drill down into some internals, which can get scary quite fast. For what is is worth, the Geohashing clustering outlined in the Boundless link actually uses B-tree indexing, it is just that geohashes tend to put things geographically close together, close together in their hash representation.
    – John Powell
    Commented Mar 6, 2017 at 7:17
  • Yes, GiST is used. But since it functions similar to R-tree on 2D data, I was hoping I could visualize at least that. QGIS can visualize some data so I was hoping this functionality existed.
    – audlift-bit
    Commented Mar 6, 2017 at 17:57
  • 1
    I think this is a much better question for Database Administrators
    – Evan Carroll
    Commented May 9, 2017 at 16:34

1 Answer 1

Reset to default
2

The Gevel contrib module provides several functions useful for analyzing GIN and GiST indexes.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.