Carlos Henrique Reimer <carlosreimer@xxxxxxxxxxxx> writes: > I would like to know how much clustered is a table related to some index.... How can I discover? You could do select ctid from mytable order by indexcolumns and then do whatever sort of calculation strikes your fancy on the sequence of page numbers. (It's probably fair to ignore the row numbers, considering an index to be fully clustered if the page reference sequence is perfect.) regards, tom lane
