running_status
Short Description
running_status reports the status of SCHEMA CHANGE, BACKUP, RESTORE, IMPORT and CREATE STATS commands.
Detailed Description​
the running_status field in the output of the SHOW JOBS command can show the current activity and the status of completed jobs.
- draining names
- The names in use by this descriptor
- waiting for GC TTL
- waiting for the Garbage Collector Time To Live to expire
- rocksDB compaction
- compaction of data files is running
- NULL
- the status of the running job cannot be determined currently
How to reduce this wait​
Follow SQL performance best practices to reduce the executing time for top statements.
Additional Links​
- cockroachDB docs - Jobs running_status
- https://deepkb.com/CO_000018/en/kb/IMPORT-13b2c56d-3eba-3111-9092-4b21c80ceb99/performance-tuning
- https://deepkb.com/CO_000018/en/kb/IMPORT-7f1d824e-62ce-3665-bed0-85f69d5dacfe/performance-best-practices-overview
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.