Index Structure in postgreSQL

Question

After creating an index in pgAdmin, is it possible to view the structure of the index in order to see how the column (s) have been sorted? I want to be able to see the B tree data structure. Thanks for any suggestions!

B tree data structure is a internal datastructure representation and not a view level representation. — Rahul
– Rahul, Commented Jun 16, 2014 at 21:07

Craig Ringer · Accepted Answer · 2014-06-17 02:26:20Z

2

No, you can't view the b-tree backing an index in PgAdmin-III. It's a low-level on-disk data structure that's entirely internal to the database backend.

You'll need to write some C code that runs inside the PostgreSQL server to explore the btree, or use the pageinspect extension.

answered Jun 17, 2014 at 2:26

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Index Structure in postgreSQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related