fbstat1
Analyze firebird database
Usage
fbstat [command]
[option ...]
[server:]
database
fbstat -h
server:db
fbstat -all
server:db
fbstat -data
server:db
Overview
(Note: Due to file-level conflict, the Debian package has changed the name of gstat to fbstat.)
fbstat Analyzes Firebird databases and produces different kinds of reports. These are useful when analyzing where all this huge disk space has gone or when estimating evaluating index efficiency.
Options
-
-all -
Analyze data and index pages.
-
-data -
Analyze data pages.
-
-system -
Analyze system tables.
-
-header -
Display information from the database header, skip analyzing any tables.
-
-index -
Analyze leaf index pages.
-
-record -
Analyze average record and version length.
-
-table table -
Analyze data pages used by the given table.
-
-nocreation -
Suppress creation date.
-
-user name
-
-password secret
-
-fetch_password file -
Authentication parameters.
-
-z
-
-? -
Displays version number.
Author & copyright
Copyright (C) 2010, Damyan Ivanov.
This manpage was written by Damyan Ivanov for the Debian project but may be used by others. Permission is granted to use this document, with or without modifications, provided that this notice is retained. If we meet some day, and you think this stuff is worth it, you can buy me a beer in return.
Releases
10 releases since Debian 3.1 (Sarge); the text changed 9 times.
-? since Debian 9 (Stretch);
-all since Debian 9 (Stretch);
-data since Debian 9 (Stretch);
-fetch_password since Debian 9 (Stretch);
-header since Debian 9 (Stretch);
-index since Debian 9 (Stretch);
-nocreation since Debian 9 (Stretch);
-password since Debian 9 (Stretch);
-record since Debian 9 (Stretch);
-system since Debian 9 (Stretch);
-table since Debian 9 (Stretch);
-user since Debian 9 (Stretch);
-z since Debian 9 (Stretch).