> Yesterday i had a database with 100mb, and today morning it had 9GB.
>
> I'm pretty sure this growth was caused by some recursive trigger or
> procedure that was kept running for a loong time and then aborted, but
> i would like to investigate the specific cause of this problem to fix
> my application.
>
> I did a backup/restore and the restored database is with 100MB again.
>
> I have a copy of the 9GB database. Is there some way to see what happened there?

gstat -r or IBAnalyst if you prefer GUI.
It seems you have a lot of record versions (garbage)

Regards,
Vlad