Access this module in the TYPO3 backend under System > DB Check.
Gives you an overview of how many pages of which type and how many records of any table are present in the current system.
Gives an overview of the count of lost relations in select and group fields
Search the complete database or specific table / field combinations and offers you detail and edit links to jump directly to the records found.
Can be used on smaller installations to check or update the reference index.