Monitor statement progress
SQL statements like CREATE MATERIALIZED VIEW, CREATE INDEX, or CREATE SINK might take a while to complete, because they may consume a lot of data. In RisingWave, you can view the progress of such a statement, and abort it if necessary.
To view the progress of a running CREATE MATERIALIZED VIEW, CREATE INDEX, or CREATE SINK statement, run the following command:
SELECT * FROM rw_catalog.rw_ddl_progress;
ddl_id | ddl_statement | progress
--------+-------------------------------+----------
1026 | CREATE INDEX idx ON sbtest1(c) | 69.02%
(1 row)
Note that the progress given here is just an estimate.
To abort a running CREATE MATERIALIZED VIEW, CREATE INDEX, or CREATE SINK statement, press CTRL+C (or Control+C).
For example:
CREATE MATERIALIZED VIEW mv2 AS SELECT * FROM mv1;
------------------------
^CCancel request sent
ERROR: QueryError: Scheduler error: Cancelled: create
Alternatively, you can use the SHOW JOBS command to get all streaming jobs (that is, the creation of a materialized view, an index, a table, a source, or a sink) that are in progress. The IDs, specific statements, and their progresses will be returned in the result. You can then cancel specific jobs by their IDs using the CANCEL JOBS command. The CANCEL JOBS command will return IDs of the jobs that are canceled successfully.
SHOW JOBS;
------RESULT
Id | Statement | Progress
------+---------------------------------------------------+----------
1010 | CREATE MATERIALIZED VIEW mv3 AS SELECT *FROM mv1 | 2.21%
1012 | CREATE MATERIALIZED VIEW mv2 AS SELECT* FROM mv1 | 0.86%
CANCEL JOBS 1010, 1012;
------RESULT
Id
------
1012
1010