Resources
Data Task Stability
Overview
The oxla_data_task_stability
table provides information about the stability of data tasks for tables within Oxla.
- Data tasks are background processes responsible for normalizing and maintaining data layouts.
- The stability status indicates whether the table’s files have been processed and are up-to-date.
Example
- Run the following command:
SELECT * FROM oxla_internal.oxla_data_task_stability;
- Here’s an example of the output you might see:
table_id | namespace_id | database_id | is_stable
----------+--------------+-------------+-----------
16384 | 0 | 0 | t
(1 row)
Table schema
Column Name | Data Type | Constraints | Description |
---|---|---|---|
table_id | BIGINT | NOT NULL | Unique identifier for the table |
namespace_id | BIGINT | NOT NULL | Identifier for the namespace that the table belongs to |
database_id | BIGINT | NOT NULL | Identifier for the database where the table is located |
is_stable | BOOL | NOT NULL | Indicates the state of the data task. false means the files are either being processed or queued for processing. true means the files have been processed and are stable, and this state persists until the user updates the data in the table |
You can join the
table_id
, namespace_id
, and database_id
columns with other virtual tables to obtain human-readable names for the table, namespace, and database.