sow (instance statistics)

Clicking the sow link will list all available topics in the SOW for this AMPS instance. Selecting a single topic will list the following available statistics about the topic:

Element	Description	Type
`delete_count`	Number of deletes processed by the SOW.	cumulative
`deletes_per_sec`	Number of deletes per second processed by the SOW.	interval average
`device`	Device the topic is stored on, if applicable.	fixed
`historical_granularity`	The granularity at which the SOW maintains history for this topic (if set).	fixed
`historical_window`	The window for which the SOW maintains history for this topic (if set).	fixed
`insert_count`	Count of the number of new records inserted into this topic.	cumulative
`inserts_per_sec`	Rate of inserts into this topic.	interval average
`memory_bytes`	The number of bytes of memory used for this topic. This metric includes: messages stored in the topic metadata for the messages in the topic indices for the topic (both memo indices and hash indices) Notice that, particularly when the topic is heavily indexed, this can be larger than the message size. Indices are not persisted, so this can also be larger than the space used for persisting the topic data. See the section on Estimating AMPS Instance Memory Usage for details.	snapshot
`mmaps`	The number of memory maps used for this topic in the SOW.	snapshot
`message_type`	Message type for this topic.	fixed
`path`	File system location of the SOW topics file store.	fixed
`queries_per_sec`	Rate of queries for this SOW topic.	interval average
`query_count`	Number of queries processed for this topic.	cumulative
`record_size`	Record size for the topic in the SOW. For SOW files created with current versions of AMPS, this will always return the same value.	fixed
`resident_percent`	Percentage of the storage of this topic that is currently resident in memory. Messages that are not currently in memory will need to be retrieved from storage before they are delivered. When part of a topic is not resident, either the instance is under memory pressure or the messages (if any) in that part of the topic have not been recently updated or delivered.	snapshot
`slab_count`	The total number of slabs allocated for this SOW topic.	snapshot
`slab_size`	The slab size for this SOW topic.	fixed
`stored_bytes`	Number of bytes stored for this topic.	snapshot
`topic`	Name of this SOW topic.	fixed
`update_count`	Number of updates to existing records processed by this topic.	cumulative
`updates_per_sec`	Number of updates to existing records per second.	interval average
`valid_keys`	Number of distinct messages in the SOW - defined by the SOW topic key. For topics that maintain a history, this shows the total number of messages that the SOW maintains, which may be larger than the number of messages that would be returned by a query at the current time, or the number of messages that would be returned by a query at a historical point in time.	snapshot

Statistics Database Tables: ISOW_STATIC, ISOW_DYNAMIC

Admin Path: /amps/instance/sow/<identifier>/<metric>

Sample amps-sqlite3 query:

SELECT iso8601_local(timestamp), topic, deletes_per_sec, inserts_per_sec, updates_per_sec, valid_keys
 FROM ISOW
 GROUP BY topic
 ORDER BY topic, timestamp

This query shows the overall activity and number of records available for each SOW topic in the instance. Notice that the activity fields are averaged over the sample interval, while the number of valid keys is a snapshot at each sample.