Retro Eye care Haitian Deep Dark Default

SHOW STREAMING LIST

Description

The SHOW STREAMING LIST syntax is used to query the CDC streaming job list.

Syntax

ShowStreamingList ::=
  'SHOW' 'STREAMING' 'LIST'

Return Value Description

Column Description
id CDC streaming job id
database database name
tables CDC streaming tables
job_item_count CDC streaming job item count
active whether the job is active
create_time job create time
stop_time job stop time

Example

  • Query CDC streaming job list
SHOW STREAMING LIST;

sharding_db=> SHOW STREAMING LIST;
                     id                     |  database   | tables  | job_item_count | active |     create_time     | stop_time
--------------------------------------------+-------------+---------+----------------+--------+---------------------+-----------
 j0302p0000702a83116fcee83f70419ca5e2993791 | sharding_db | t_order | 1              | true   | 2023-10-27 22:01:27 |
(1 row)

Reserved word

SHOW, STREAMING, LIST