FirebirdSQL logo

-⁠N[OCREATION]

This switch excludes the “Creation date” entry from the database header output.

Warning

Formally, this is an unsupported switch which could be removed or changed at any time.It exists to stabilize output for tests in the testsuite of Firebird.

In other words, use at your own risk.

-⁠S[YSTEM]

This switch is a modifier and alters the output from the [gstat-cmdline-data] or [gstat-cmdline-index] switches by including the system tables (or indices of system tables) in addition to the user-defined tables (or indices).Using this switch on its own is equivalent to calling gstat with -⁠a[ll] -⁠s[ystem] specified.

When run, this switch lists statistics for the various RDB$ tables and indices.

Note

In Firebird 2.1 only, this will also list information for the various monitoring tables (prefix MON$).However, as these are virtual tables, all statistics are 0, so this was removed from the output in Firebird 2.5.

-⁠R[ECORD]

The -⁠r[ecord] switch is a modifier for the [gstat-cmdline-data] switche.It adds data about the average record and version lengths for any data tables (user and/or system) analysed.This switch has no effect on the [gstat-cmdline-index] switch.

-⁠RO[LE]

Specifies the role for privileges — for example RDB$ADMIN, or another role providing the system privilege USE_GSTAT_UTILITY (and IGNORE_DB_TRIGGERS).

Syntax
-RO[LE] role_name
Note
Introduced in Firebird 3.0.