visualizing B-tree index coverage

From: "TJ O'Donnell" <tjo(at)acm(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <tjo(at)acm(dot)org>
Subject: visualizing B-tree index coverage
Date: 2005-01-25 22:19:17
Message-ID: 1383.209.223.166.104.1106691557.squirrel@gnova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Does anyone know of a tools that allows one to visualize
the tree created by a multi-column B-tree index?
A picture of a tree with branches, showing how "branchy" the
tree is would be great.
I'm wondering how well I've "clustered" the data in my table
using the multi-column index. In other words, do my
multi-columns sufficiently but not overly discriminate rows from each other?
Do I have too many with the same index? (not enough branches)
Do I have a unique index for each row? (way too many branches)

Thanks,
TJ

Browse pgsql-general by date

  From Date Subject
Next Message James Thompson 2005-01-25 22:29:02 Re: Data entry - forms design or other APIs etc. - what is there?
Previous Message Michael Fuhr 2005-01-25 22:15:01 Re: Size of data stored in bytea record?