Работает "приблизительно", сильно занижает реальный размер:
SELECT FIRST 10
rdb$relation_name,
count(*) as pagecount,
count(*) * (select mon$page_size from mon$database) / 1024
as pageKB
FROM rdb$relations
INNER JOIN rdb$pages
ON rdb$pages.rdb$relation_id=rdb$relations.rdb$relation_id
WHERE rdb$page_type in (4,5,6,7,8)
GROUP BY 1
ORDER BY 2 DESC, 1 ASC
SQL Справочник v0.05 © 2007-2025 Igor Salnikov aka SunDoctor