Actian Ingres 12.1 | A. Actian Monitor Metrics

Actian Monitor > A. Actian Monitor Metrics

Was this helpful?

Actian Monitor Metrics

Ingres Metrics

Vector Metrics

Communication and Server Metrics

Checkpoint and Recovery Metrics

Write, I/O and Cache Metrics

Network Metrics

Ingres Metrics

db_ingres_buffer_used

• Sample Rate: 1 min

• Description: memory used by kernel buffers.

• Type: Gauge

• Warm Threshold: —

• Crit Threshold: —

db_ingres_cache_fhdr_fix_calls

• Sample Rate: 5 mins

• Description: Number of times an FHDR page was fixed in the cache.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_fhdr_hits

• Sample Rate: 5 mins

• Description: Number of times the cache searched for an FHDR page and the page was found.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_free_pages

• Sample Rate: 5 mins

• Description: Current number of free pages in the single page cache.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_group_buffers

• Sample Rate: 5 mins

• Description: Number of individual groups in the cache.

• Data Type: long

• Units: {cacheBuffer)

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_fix_calls

• Sample Rate: 5 mins

• Description: Number of times a page was fixed in the cache.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_free_wait

• Sample Rate: 5 mins

• Description: Times buffer manager had to wait for a free page.

• Data Type: long

• Units: {cacheWait}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_gread_ios

• Sample Rate: 5 mins

• Description: Number of pages read into group buffers.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_gsync

• Sample Rate: 5 mins

• Description: Count of synchronous group writes.

• Data Type: long

• Units: {write}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_gwait

• Sample Rate: 5 mins

• Description: Times waiting for a free group buffer.

• Data Type: long

• Units: {cacheWait}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_ios

• Sample Rate: 5 mins

• Description: Total number of pages read or written by the cache.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_locks

• Sample Rate: 5 mins

• Description: Number of cache pages currently locked.

• Data Type: long

• Units: {lock}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_reads

• Sample Rate: 5 mins

• Description: Number of page reads requested from the cache.

• Data Type: long

• Units: {cachePage}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_cache_summary_writes

• Sample Rate: 5 mins

• Description: Number of pages written from the cache to disk.

• Data Type: long

• Units: {write}

• Attributes: cache_size

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_connections_active

• Sample Rate: 1 min

• Description: Number of currently active database connections.

• Data Type: long

• Units: connection

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_connections_idle

• Sample Rate: 1 min

• Description: Number of currently idle database connections.

• Data Type: long

• Units: connection

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_disk_reads

• Sample Rate: 5 mins

• Description: Number of physical disk reads.

• Data Type: long

• Units: read

• Attributes: —

• Type: Counter

• Warn Threshold: —

• Crit Threshold: —

db_ingres_disk_writes

• Sample Rate: 5 mins

• Description: Number of physical disk writes.

• Data Type: long

• Units: write

• Attributes: —

• Type: Counter

• Warn Threshold: —

• Crit Threshold: —

db_ingres_lock_waits

• Sample Rate: 1 min

• Description: Number of times transactions had to wait for a lock.

• Data Type: long

• Units: wait

• Attributes: —

• Type: Counter

• Warn Threshold: —

• Crit Threshold: —

db_ingres_query_runtime

• Sample Rate: 1 min

• Description: Average query execution time.

• Data Type: float

• Units: ms

• Attributes: query_type

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_temp_space_used

• Sample Rate: 5 mins

• Description: Amount of temporary disk space used.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_deadlock_search

• Sample Rate: 5 mins

• Description: Number of times a deadlock search was initiated.

• Data Type: long

• Units: {lockSearch}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_deadlocks

• Sample Rate: 5 mins

• Description: Number of times that deadlock existed.

• Data Type: long

• Units: {deadlock}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_disk_free_blocks

• Sample Rate: 1 hr

• Description: Free blocks on a device.

• Data Type: long

• Units: {block}

• Attributes: device_name, device_type

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_disk_total_blocks

• Sample Rate: 1 hr

• Description: Total blocks available on a device.

• Data Type: long

• Units: {block}

• Attributes: device_name, device_type

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_disk_used_blocks

• Sample Rate: 1 hr

• Description: Used blocks on a device.

• Data Type: long

• Units: {block}

• Attributes: device_name, device_type

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_disk_used_percent

• Sample Rate: 1 hr

• Description: Percentage of blocks used on a device.

• Data Type: double

• Units: %

• Attributes: device_name, device_type

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_error_type_count

• Sample Rate: 5 mins

• Description: Count of new instances of each tracked error code since last sampling.

• Data Type: long

• Units: {errorCode}

• Attributes: error_code

• Type: Counter

• Warn Threshold: —

• Crit Threshold: —

db_ingres_escalate

• Sample Rate: 5 mins

• Description: Number of partial releases allowing lock escalation.

• Data Type: long

• Units: {release}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_is_available

• Sample Rate: 2 mins

• Description: Indicates whether the Ingres database is available.

• Data Type: long

• Units: {boolean}

• Attributes: state

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_license_is_expired

• Sample Rate: 1 hr

• Description: Indicates whether the product license is expired.

• Data Type: long

• Units: {boolean}

• Attributes: product_name, product_version

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_license_time_remaining

• Sample Rate: 1 hr

• Description: Number of days remaining for each product license.

• Data Type: long

• Units: {day}

• Attributes: product_name, product_version

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_lkb_highwater

• Sample Rate: 5 mins

• Description: Maximum number of lock list blocks allocated.

• Data Type: long

• Units: {lockListBlock}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_lock_percent_waiting

• Sample Rate: 1 min

• Description: Percentage of sessions waiting on locks.

• Data Type: long

• Units: %

• Attributes: database

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingreslock_waits

• Sample rate: 5 mins

• Description: Number of lock requests that had to wait.

• Data Type: long

• Units:{lockWait}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_locks_in_use

• Sample Rate: 5 mins

• Description: Number of locks currently in use.

• Data Type: long

• Units: {lock}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_locks_per_txn

• Sample Rate: 5 mins

• Description: Maximum number of locks acquired per transaction.

• Data Type: long

• Units: {lock}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_lrq

• Sample Rate: 1 min

• Description: Runtime of long-running queries (≥ 30 seconds).

• Data Type: long

• Units: {second}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_lrq_count

• Sample Rate: 1 min

• Description: Number of long-running queries.

• Data Type: long

• Units: {query}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_lrq_blocked_count

• Sample Rate: 1 min

• Description: Number of blocked long-running queries.

• Data Type: long

• Units: {query}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_ram_free

• Sample Rate: 1 min

• Description: Amount of free RAM.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_ram_used

• Sample Rate: 1 min

• Description: Amount of used RAM.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_ram_total

• Sample Rate: 1 min

• Description: Total available RAM.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_ram_percent_used

• Sample Rate: 1 min

• Description: Percentage of RAM used.

• Data Type: double

• Units: %

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_swap_free

• Sample Rate: 1 min

• Description: Free swap space.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_swap_used

• Sample Rate: 1 min

• Description: Used swap space.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_swap_total

• Sample Rate: 1 min

• Description: Total swap space.

• Data Type: long

• Units: By

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_swap_percent_used

• Sample Rate: 1 min

• Description: Percentage of swap used.

• Data Type: double

• Units: %

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_system_threads

• Sample Rate: 2 mins

• Description: Total number of Ingres system sessions.

• Data Type: long

• Units: {thread}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_total_connections

• Sample Rate: 2 mins

• Description: Total active connections.

• Data Type: long

• Units: {connection}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

db_ingres_total_errors

• Sample Rate: 5 mins

• Description: Count of new error log entries.

• Data Type: long

• Units: {error}

• Attributes: —

• Type: Counter

• Warn Threshold: —

• Crit Threshold: —

db_ingres_user_sessions

• Sample Rate: 2 mins

• Description: Total number of Ingres user sessions.

• Data Type: long

• Units: {session}

• Attributes: —

• Type: Gauge

• Warn Threshold: —

• Crit Threshold: —

Last modified date: 01/29/2026