> For the complete documentation index, see [llms.txt](https://goldenore.gitbook.io/goldenore-cdc/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://goldenore.gitbook.io/goldenore-cdc/moduly-goldenore-cdc/cdc-backend/dashboard/metryki/konektory-zrodlowe/debezium-snapshot.md).

# Debezium snapshot

Wszystkie metryki są takie same dla obsługiwanych baz (postgres, oracle, sqlserver)

Label: 

```
context="streaming"
```

## Podstawowe metryki

<table data-full-width="true"><thead><tr><th width="251.33333333333337">Nazwa</th><th width="136">Typ</th><th width="483">Opis</th><th data-type="checkbox">Używane</th><th data-type="checkbox">Dashboard</th></tr></thead><tbody><tr><td><code>LastEvent</code></td><td><code>string</code></td><td>The last snapshot event that the connector has read.</td><td>true</td><td>false</td></tr><tr><td><code>MilliSecondsSinceLastEvent</code></td><td><code>long</code></td><td>The number of milliseconds since the connector has read and processed the most recent event.</td><td>true</td><td>false</td></tr><tr><td><code>TotalNumberOfEventsSeen</code></td><td><code>long</code></td><td>The total number of events that this connector has seen since last started or reset.</td><td>true</td><td>false</td></tr><tr><td><code>NumberOfEventsFiltered</code></td><td><code>long</code></td><td>The number of events that have been filtered by include/exclude list filtering rules configured on the connector.</td><td>true</td><td>false</td></tr><tr><td><code>CapturedTables</code></td><td><code>string[]</code></td><td>The list of tables that are captured by the connector.</td><td>true</td><td>false</td></tr><tr><td><code>QueueTotalCapacity</code></td><td><code>int</code></td><td>The length the queue used to pass events between the snapshotter and the main Kafka Connect loop.</td><td>false</td><td>false</td></tr><tr><td><code>QueueRemainingCapacity</code></td><td><code>int</code></td><td>The free capacity of the queue used to pass events between the snapshotter and the main Kafka Connect loop.</td><td>false</td><td>false</td></tr><tr><td><code>TotalTableCount</code></td><td><code>int</code></td><td>The total number of tables that are being included in the snapshot.</td><td>true</td><td>true</td></tr><tr><td><code>RemainingTableCount</code></td><td><code>int</code></td><td>The number of tables that the snapshot has yet to copy.</td><td>false</td><td>false</td></tr><tr><td><code>SnapshotRunning</code></td><td><code>boolean</code></td><td>Whether the snapshot was started.</td><td>true</td><td>true</td></tr><tr><td><code>SnapshotPaused</code></td><td><code>boolean</code></td><td>Whether the snapshot was paused.</td><td>true</td><td>false</td></tr><tr><td><code>SnapshotAborted</code></td><td><code>boolean</code></td><td>Whether the snapshot was aborted.</td><td>true</td><td>false</td></tr><tr><td><code>SnapshotCompleted</code></td><td><code>boolean</code></td><td>Whether the snapshot completed.</td><td>true</td><td>false</td></tr><tr><td><code>SnapshotDurationInSeconds</code></td><td><code>long</code></td><td>The total number of seconds that the snapshot has taken so far, even if not complete. Includes also time when snapshot was paused.</td><td>true</td><td>false</td></tr><tr><td><code>SnapshotPausedDurationInSeconds</code></td><td><code>long</code></td><td>The total number of seconds that the snapshot was paused. If the snapshot was paused several times, the paused time adds up.</td><td>true</td><td>false</td></tr><tr><td><code>RowsScanned</code></td><td><code>Map&#x3C;String, Long></code></td><td>Map containing the number of rows scanned for each table in the snapshot. Tables are incrementally added to the Map during processing. Updates every 10,000 rows scanned and upon completing a table.</td><td>false</td><td>false</td></tr><tr><td><code>MaxQueueSizeInBytes</code></td><td><code>long</code></td><td>The maximum buffer of the queue in bytes. This metric is available if <a href="https://debezium.io/documentation/reference/stable/connectors/postgresql.html#postgresql-property-max-queue-size-in-bytes"><code>max.queue.size.in.bytes</code></a> is set to a positive long value.</td><td>false</td><td>false</td></tr><tr><td><code>CurrentQueueSizeInBytes</code></td><td><code>long</code></td><td>The current volume, in bytes, of records in the queue.</td><td>false</td><td>false</td></tr></tbody></table>

## Incremental snapshot

Przy incremental snapshot dodatkowo są dostępne:

<table data-full-width="true"><thead><tr><th width="254.5">Nazwa</th><th width="136">Typ</th><th width="509">Opis</th><th data-type="checkbox">Używane</th></tr></thead><tbody><tr><td><code>ChunkId</code></td><td><code>string</code></td><td>The identifier of the current snapshot chunk.</td><td>true</td></tr><tr><td><code>ChunkFrom</code></td><td><code>string</code></td><td>The lower bound of the primary key set defining the current chunk.</td><td>true</td></tr><tr><td><code>ChunkTo</code></td><td><code>string</code></td><td>The upper bound of the primary key set defining the current chunk.</td><td>true</td></tr><tr><td><code>TableFrom</code></td><td><code>string</code></td><td>The lower bound of the primary key set of the currently snapshotted table.</td><td>true</td></tr><tr><td><code>TableTo</code></td><td><code>string</code></td><td>The upper bound of the primary key set of the currently snapshotted table.</td><td>true</td></tr></tbody></table>