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

  1. Run the following command:
SELECT * FROM oxla_internal.oxla_data_task_stability;
  1. 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 NameData TypeConstraintsDescription
table_idBIGINTNOT NULLUnique identifier for the table
namespace_idBIGINTNOT NULLIdentifier for the namespace that the table belongs to
database_idBIGINTNOT NULLIdentifier for the database where the table is located
is_stableBOOLNOT NULLIndicates 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.