No recent searches
Popular Articles
Sorry! nothing found for
GStat
Created by Russ Hartle, Modified on Tue, 11 Nov, 2025 at 10:28 AM by Russ Hartle
Gstat is one of the database utilities supplied with Firebird. It is used to display statistical details about the contents of a database. Gstat does not connect to the database as other utilities do, instead it opens the database file(s) directly and reads through the raw data. Because of this, gstat is not transactionally aware and some of the statistics it gathers may include data that have been deleted, for example, by normal database transactions. Complete Gstat information can be found here.
Common Command-Line Syntax
From the Firebird\…\bin directory run the following command: gstat -h -user sysdba -password j316fgsl “database path”
The database header results will be returned like below:
A breakdown of each header field can be found here.
The transaction limit for 2.1 Firebird SQL is 2,147,483,647.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Let us know how can we improve this article!
Feedback sent
We appreciate your effort and will try to fix the article
X