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
  • Regardless of the stability status the table is ready to be queried

Example

When running the command below:

SELECT * FROM oxla_internal.oxla_data_task_stability;

you will get the following output:

 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, 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