Retro Eye care Haitian Deep Dark Default

SHOW STREAMING STATUS

Description

The SHOW STREAMING STATUS syntax is used to query the status of a specified CDC streaming job.

Syntax

ShowStreamingStatus ::=
  'SHOW' 'STREAMING' 'STATUS' jobId

jobId ::=
  integer | identifier | string

Supplement

Return Value Description

Column Description
item CDC streaming job item
data_source data source
status CDC streaming job status
active whether the job item is active
processed_records_count number of processed records
inventory_finished_percentage inventory finished percentage
incremental_idle_seconds incremental idle time in seconds
confirmed_position confirmed incremental position
current_position current incremental position
error_message error message

Example

  • Query CDC streaming job status
SHOW STREAMING STATUS j0302p0000702a83116fcee83f70419ca5e2993791;

sharding_db=> SHOW STREAMING STATUS j0302p0000702a83116fcee83f70419ca5e2993791;
 item | data_source |          status          | active | processed_records_count | inventory_finished_percentage | incremental_idle_seconds | confirmed_position | current_position | error_message
------+-------------+--------------------------+--------+-------------------------+-------------------------------+--------------------------+--------------------+------------------+---------------
 0    | ds_0        | EXECUTE_INCREMENTAL_TASK | false  | 2                       | 100                           | 115                      | 5/597E43D0         | 5/597E4810       |
 1    | ds_1        | EXECUTE_INCREMENTAL_TASK | false  | 3                       | 100                           | 115                      | 5/597E4450         | 5/597E4810       |
(2 rows)

Reserved word

SHOW, STREAMING, STATUS