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

System Tables

System Tables are logical tables to describe the databases configuration, settings, and metrics. All tables except fb_views are logical, in-memory, and dynamically created upon database creation.

Table of contents

fb_views

The fb_views table is a system table which provides a catalog of all previously created views.

fb_database_info

The fb_database_info table provides a single row which describes the version and state of the database.

fb_database_nodes

The fb_database_nodes table provides a listing of all the cluster nodes or workers in the database, including their connectivity and state.

fb_exec_requests

The fb_exec_requests table provides a query log of requests executed (and executing) by node.

  • 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

fb_table_ddl

The fb_table_ddl table provides the corresponding Data Definition Language (DDL) to create the existing database’s tables.

fb_performance_counters

The fb_performance_counters table provides metrics about the nodes/workers within the database.