10

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?

  • 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 Mar 6 '17 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 Mar 6 '17 at 17:57
  • 1
    I think this is a much better question for Database Administrators – Evan Carroll May 9 '17 at 16:34
1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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