Extract Database Statistics by Table

Name Value

Documentation

Retrieve an existing Extract Database Statistics by Table

Process Type(s)

Extract

Endpoint

/services/v2/mpoints/{item}/statisticsTableExtract

JSON Schema

mpoints:statisticsTableExtract

Base Name

statistics-table-extract

Internal Name

MPL_TABLE_COUNTS_EX

Tag Description

deploymentName

The name of the OGG Microservices deployment

deploymentId

The unique identity of the OGG Microservices deployment

processType

The type of process

processName

The name of the process

table-name

The name of the table

Metric Data Type Description

mapped-total-inserts

integer

Number of INSERT operations performed

mapped-total-updates

integer

Number of UPDATE operations performed

mapped-total-deletes

integer

Number of DELETE operations performed

mapped-total-truncates

integer

Number of TRUNCATE operations performed

total-ignores

integer

Number of errors ignored

total-discards

integer

Number of operations discarded

total-row-fetch-attempts

integer

Number of attempts to fetch from DBMS

total-row-fetch-failures

integer

Number of failed fetch attempts