1.1.1

Syntax
sqlf stats ([<instanceId>][:<typeId>][.<statId>])* [-details]
[-nofilter|-persec|-persample] [-prunezeros]
[-starttime=<time>] [-endtime=<time>] -archive=<statFile>
Description
To enable statistics generation with archiving, you configure the following properties when you start the SQLFire
server:
•
statistic-sampling-enabled=true
•
statistic-archive-file=<stats-archive-file-name>
To include timing statistics you set enable-time-statistics=true along with the above properties.
See Configuration Properties on page 319.
By default sqlf stats prints all statistics. You can use one or more statistics specification arguments to print
individual resources or a specific statistic. The format of a statistics specification is: an optional combine operator,
an optional instanceId, an optional typeId, and an optional statId.
The combine operator can be a plus (+) to combine all matches in the same file or a double plus (++) to combine
all matches across all files.
instanceId must be the name or id of a resource.
typeId is a colon (:) followed by the name of a resource type.
statId is a period (.) followed by the name of a statistic.
A typeId or instanceId with no statId prints out all the matching resources and all their statistics. A typeId or
instanceId with a statId prints out just the named statistic on the matching resources.
A statId with no typeId or instanceId matches all statistics with that name.
The table shows options for sqlf stats.
DescriptionOption
Prints static descriptions.-details
In conjunction with -archive, prints statistics as raw, unfiltered,
values.
-nofilter
In conjunction with -archive, prints statistics as the rate of change,
per second, of the raw values.
-persec
In conjunction with -archive, prints statistics as the rate of change,
per sample, of the raw values.
-persample
In conjunction with -archive, suppresses printing those statistics that
have all zero values.
-prunezeros
In conjunction with -archive, ignores those statistics samples that
were taken before the specified time. The time argument format must
-starttime=<time>
match the string yyyy/MM/dd HH:mm:ss.SSS z where z is the time
zone.
In conjunction with -archive, ignores statistics samples that were
taken after the specified time. The time argument format must match
the string yyyy/MM/dd HH:mm:ss.SSS z where z is the time zone.
-endtime=<time>
Specifies the archive file to use.-archive
405
sqlf Launcher Commands