CODEWITHSUNDEEP
firebirdfirebird2.5
Lopez Lopez
Lopez Lopez

Reputation: 5

Firebird overgrow database file

Is there a way to check why my database is increasing its size so fast? I had a growth of 30GB in less than a week and all my process and procedures are so slow now, with the same amount of transactions as usual.

Or is there a way to check the size of the table?

Upvotes: 0

Views: 717

Answers (1)

Ed Mendez
Ed Mendez

Reputation: 1683

If you have a table that you suspect might be growing you can run the following command from the command line.

gstat <DATABASE NAME|ALIAS> -t <TABLE_NAME>

Additional information on gstat can be found here. https://firebirdsql.org/file/documentation/html/en/firebirddocs/gstat/firebird-gstat.html

You can have this command run on a schedule and save the results so you can see what is happening over time. Although, this command might take a while to run based on the size of the table.

Upvotes: 2

Related Questions