1.1.1

APP.FLIGHTS.DESTINDEX (Index Entry Size, Value Size, Row Count)
|dyozie-e4310(6880)<v0>:3439/59731
|4888,3784,87
[...]
Understanding Table and Index Values
Querying the SYS.MEMORYANALYTICS table provides run-time information about the tables and indexes
available in SQLFire.
Table Values
Each table has a single row in SYS.MEMORYANALYTICS identitfied with the SQLENTITY format:
schema_name.table_name (Entry Size, Value Size, Row Count). The ID column value displays the values
separated by commas.
DescriptionTable Value
The per-entry overhead, in bytes. (This excludes the Value Size
below.)
Entry Size
The total size of a table row, in bytes. (This includes the Entry Size
overhead.)
Value Size
The total number of rows stored on the local SQLFire member. For
a partitioned table, this includes all buckets for the table, as well as
primary and secondary replicas.
Row Count
For example, the following row from SYS.MEMORYANALYTICS shows that the APP.FLIGHTS table has
30352 bytes of overhead per row, with 542 total rows:
SQLENTITY
|ID
|MEMORY
----------------------------------------------------------------
APP.FLIGHTS (Entry Size, Value Size, Row Count)
|dyozie-e4310(6880)<v0>:3439/59731
|30352,31436,542
Index Values
Each index has two rows in SYS.MEMORYANALYTICS. The first row uses the SQLENTITY format:
schema_name.table_name.index_name (Index Entry Overhead, SkipList Size, Max Level). This row provides
details about concurrent skip lists for the index. The ID column value displays these values separated by commas:
DescriptionIndex Value
The number of linked list objects that the index uses for storing the
entry.
Index Entry Overhead
The number of linked list objects that the index uses for skipping
values to expedite searches.
SkipList Size
The total number of skip lists that are currently available for lookups.Max Level
75
Estimating Memory Requirements