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 the to 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