FirebirdSQL logo

-⁠FE[TCH_PASSWORD]

This switch causes the password to be read from a file as opposed to being specified on the command line.

Syntax
-FE[TCH_PASSWORD] { password_filename | stdin | /dev/tty }

The filename supplied must be readable by the user running gstat.If the filename is specified as stdin, then the user will be prompted for a password.On POSIX systems, the filename /dev/tty will also result in a prompt for the password.

Note
Introduced in Firebird 2.5.

-⁠Z

This is a modifier switch.Using -⁠z displays the version number of the gstat utility and of the Firebird installation.If you don’t supply a valid database name and possibly another switch, gstat will print out the gstat version and an error.If a valid database is provided, gstat will also print out version information about the database engine, and — if applicable — client library and protocol versions.

The shortest output would be from a -⁠t non_existent_tablename if all you need is the version details, as follows:

tux> gstat -t non_existing_tablename -z employee
gstat version LI-V2.1.3.18185 Firebird 2.1

Database "/opt/firebird/examples/empbuild/employee.fdb"
Database header page information:
...

Database file sequence:
File /opt/firebird/examples/empbuild/employee.fdb is the only file
        Firebird/linux Intel (access method), version
"LI-V2.1.3.18185 Firebird 2.1"
        Firebird/linux Intel (remote server), version
"LI-V2.1.3.18185 Firebird 2.1/tcp (greenbird)/P11"
        Firebird/linux Intel (remote interface), version
"LI-V2.1.3.18185 Firebird 2.1/tcp (greenbird)/P11"
        on disk structure version 11.1

Analyzing database pages ...
Note
The output above has been slightly changed to allow it to fit the page width for a pdf.

The output starts by displaying the gstat version, followed by the details of the database header.The database file and Firebird details are displayed next and finally, the details for the supplied table name, which of course is not found.

-⁠?

This switch displays the usage information of gstat.

Note
Introduced in Firebird 2.5.

-⁠D[ATA]

Specifying this switch causes gstat to analyse all user tables of the specified database.Indices are not analysed unless [gstat-cmdline-index] is also specified.

When combined with [gstat-cmdline-system], the system tables are analysed in addition to the user tables.

If [gstat-cmdline-table] is also specified, analysis is restricted to the specified tables.

This switch is implied by [gstat-cmdline-all].