Skip to main content Link Menu Expand (external link) Document Search Copy Copied

Reference: FeatureBase system tables

At a high-level, FeatureBase system tables:

  • describe database configuration, settings and metrics
  • are logical and in-memory tables, dynamically created on database creation

The only exception is fb_views which is automatically created when a user runs the CREATE VIEW statement

Table of contents

System Database tables

System table Description Additional information
fb_views Contains a catalog of existing views in the database Created when one or more views are created
fb_database_info Contains properties and state of each database in the system One database per row
fb_database_nodes Lists database nodes  
fb_performance_counters Contains metrics on database nodes and database workers  

System DDL tables

System table Description Additional information
fb_table_ddl Contains DDL (Data Definition Language) to recreate user tables in the existing database INSERT statements are not included

Query tables

System table Description Additional information
fb_exec_requests Contains a log of SQL queries executed (and executing) by database node fb_exec_requests additional

Additional information

fb_exec_requests additional

  • fb_exec_requests keeps only the latest 2000 records (queries)
  • fb_exec_requests.sql and fb_exec_requexts.plan are limited to 4000 characters.

Query status

The status column represents the execution status of the query, possible values are:

Status Description
running Query execution is in progress
complete Query execution completed
cancelled Query cancelled by user
error Query execution stopped after error
timedout Query execution stopped after exceeding execution time limit