Skip to main content

system_history.log_history

Introduced or updated: v1.2.764
ENTERPRISE EDITION FEATURE
LOG HISTORY is an Enterprise Edition feature. Contact Databend Support for a license.

System operations audit trail - Raw log repository from all Databend nodes and components. Foundation for operational intelligence:

  • System Monitoring: Track system health, performance, and resource usage
  • Troubleshooting: Debug issues with detailed error logs and system events
  • Operational Analytics: Analyze system behavior patterns and trends
  • Root Cause Analysis: Investigate system failures and performance bottlenecks

Note: This table contains raw log data that feeds into other specialized history tables. Other tables provide structured, query-specific views of this data.

Fields

FieldTypeDescription
timestampTIMESTAMPThe timestamp when the log entry was recorded
pathVARCHARSource file path and line number of the log
targetVARCHARTarget module or component of the log
log_levelVARCHARLog level (e.g., INFO, ERROR)
cluster_idVARCHARIdentifier of the cluster
node_idVARCHARIdentifier of the node
warehouse_idVARCHARIdentifier of the warehouse
query_idVARCHARQuery ID associated with the log
messageVARCHARLog message content
fieldsVARIANTAdditional fields (as a JSON object)
batch_numberBIGINTInternal use, no special meaning

Note: The message field stores plain text logs, while the fields field stores logs in JSON format.

For example, the fields field of a log entry might look like:

fields: {"node_id":"8R5ZMF8q0HHE6x9H7U1gr4","query_id":"72d2319a-b6d6-4b1d-8694-670137a40d87","session_id":"189fd3e2-e6ac-48c3-97ef-73094c141312","sql":"select * from system_history.log_history"}

the message field of another log entry might appear as follows:

message: [HTTP-QUERY] Preparing to plan SQL query

Examples

SELECT * FROM system_history.log_history LIMIT 1;

*************************** 1. row ***************************
timestamp: 2025-06-03 01:29:49.335455
path: databend_common_meta_client::channel_manager: channel_manager.rs:86
target: databend_common_meta_client::channel_manager
log_level: INFO
cluster_id: test_cluster
node_id: CkdmtwYXLRMhJIvVzl6i11
warehouse_id: NULL
query_id: NULL
message: MetaChannelManager done building RealClient to 127.0.0.1:9191, start handshake
fields: {}
batch_number: 41
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today