• Bruce Momjian's avatar
    Add index information to /contrib/pgstattuple: · dab42382
    Bruce Momjian authored
    This is an extension of pgstattuple to query information from indexes.
    It supports btree, hash and gist. Gin is not supported. It scans only
    index pages and does not read corresponding heap tuples. Therefore,
    'dead_tuple' means the number of tuples with LP_DELETE flag.
    
    Also, I added an experimental feature for btree indexes. It checks
    fragmentation factor of indexes. If an leaf has the right link on the
    next adjacent page in the file, it is assumed to be continuous (not
    fragmented). It will help us to decide when to REINDEX.
    
    ITAGAKI Takahiro
    dab42382
pgstattuple.c 13.1 KB