system count
Loads the number of records stored until the time of the query by date.
Syntax
system count [from=yyyyMMdd] [to=yyyyMMdd] [diskonly=BOOL] [TABLE, ...]
Optional Parameter
from=yyyyMMdd
- Start date of the search period in the form of
yyyyMMdd
. The time period for the search includes the specified time point. to=yyyyMMdd
- End date of the search period in the form of
yyyyMMdd
. Unlike theto
option of the table command, the time period for the search includes the specified time point. diskonly=BOOL
- Option to load the number of records (default:
f
).t
: Loads the number of records written to the disk only.f
: Loads the number of records, including the number of records buffered in the memory.
TABLE, ...
- Tables in which to check the number of records, separated by a comma (
,
). If you do not specify a table name, the command checks the number of records in all tables for which the user is granted read permission.
Description
Output fields are as follows.
- _time: Partition date
- table: Table name
- count: Number of records in the table