Time Series Databases for Metrics

TDengine is a distributed time-series database designed for the high-speed ingestion, compression, and retrieval of timestamped metrics and sensor data. It functions as a SQL-compatible analytics engine, allowing users to perform complex operations on massive volumes of time-ordered information using standard relational syntax. The platform is built to serve as a backend foundation for industrial IoT environments, managing real-time data streams and device metadata through a cluster-based architecture. The system distinguishes itself through a distributed sharding architecture that uses consistent hashing to ensure horizontal scalability and high-throughput ingestion. It employs a log-structured write path to minimize disk seek latency and utilizes super-table virtualization to provide a unified logical view across multiple physical tables. To maintain performance and cost-efficiency, the database features automated multi-tiered lifecycle management, which migrates data between high-performance memory and low-cost storage based on age and access frequency. Beyond its core storage capabilities, the platform provides robust tools for edge-to-cloud synchronization, ensuring consistent data states across geographically distributed infrastructure. It includes built-in support for real-time stream processing, allowing for the analysis of live data without requiring external message queues. The system also incorporates comprehensive security frameworks, including user access control, audit logging, and encrypted transport protocols to protect sensitive operational data. Developers can interact with the database through native client libraries that support connection pooling and query parameter binding. The system is documented with comprehensive error code diagnostics and provides command-line utilities for cluster administration, health monitoring, and configuration management.

InfluxDB is a high-performance time-series database designed for collecting, storing, and querying time-stamped metrics and event data. It functions as a columnar time-series store and a real-time analytics engine, providing a network-accessible interface for retrieving and analyzing temporal records. The system utilizes a specialized columnar storage format to support high ingestion rates and efficient data retrieval. It incorporates a programmable runtime for executing custom plugins and triggers, including integration for processing and transforming incoming data streams. The platform covers wide-ranging capabilities for telemetry ingestion, operational metrics tracking, and real-time system monitoring. It supports temporal data analytics and uses standard SQL query languages to derive insights from continuous streams of event data.

TimescaleDB is an open-source PostgreSQL extension that adds native time-series capabilities to the database. At its core, it transforms standard PostgreSQL tables into hypertables—automatically partitioned by time intervals—so data is stored in fixed-size chunks without manual sharding. The extension includes a library of over 200 built-in SQL functions purpose-built for time-series workloads, such as time bucketing, gap filling, percentile estimation, and time-weighted averages. What distinguishes TimescaleDB from generic PostgreSQL is its set of integrated time-series features that work through ordinary SQL. Continuous aggregate materialized views incrementally refresh precomputed summaries as new data arrives, keeping dashboards fast without full rescans. A multi-tier storage architecture automatically moves older, less frequently accessed data from SSD to low-cost object storage while keeping it fully queryable through the same SQL interface. Columnar compression reduces storage footprint, and a background job scheduler handles compaction, retention, and tiering policies without blocking write or read traffic. Beyond core time-series storage and analytics, TimescaleDB supports mixed workloads. It offers multi-modal search that combines BM25 full-text ranking, vector embedding similarity, and relational filters in a single SQL query against time-series data. The extension also provides read replica scaling to offload queries, connection pooling for high concurrency, and chunk-level query skipping that eliminates irrelevant data partitions during scans. The entire feature set is accessed as a PostgreSQL extension, meaning all standard PostgreSQL tooling, drivers, and ecosystem compatibility remain intact.

Apache IoTDB is a time-series database designed for the Internet of Things, purpose-built to ingest high-volume data from millions of low-power devices and store timestamp-value pairs with configurable data types and encoding schemes. It organizes time series data and device metadata in a tree-like hierarchy, enabling efficient management of complex industrial sensor networks. The database supports rich querying capabilities, including time-aligned data retrieval across multiple devices, time-based aggregation like downsampling, and frequency-domain signal analysis. It provides high-throughput read and write operations while compressing stored data with high-ratio algorithms to reduce hardware storage costs. Data can be imported from and exported to external files for backup or transfer. IoTDB integrates with big data ecosystems such as Hadoop, Spark, Flink, and Grafana for processing, analysis, and visualization. It offers flexible deployment options across edge and cloud environments with one-click setup and data synchronization between nodes.

QuestDB is a high-performance, distributed time-series database designed for the ingestion, storage, and analysis of massive datasets. It functions as a real-time analytics platform that utilizes a columnar storage engine to optimize disk input and output, enabling efficient analytical scans and complex windowing operations on streaming data. The platform distinguishes itself through specialized capabilities for handling asynchronous time-series streams, including advanced join algorithms that align disparate data sets based on precise timestamp lookups. It supports high-volume ingestion through non-blocking data structures, allowing for simultaneous data entry and analytical querying without performance degradation. By decoupling compute from storage, the system enables independent scaling and utilizes shared object storage to maintain a consistent source of truth across distributed replicas. The system provides a comprehensive suite of tools for data lifecycle management, including automated partitioning, tiered storage, and incremental materialized views that update as new information arrives. It supports standard SQL for data exploration and offers granular security controls, including role-based access and encrypted communication, to ensure data governance. The platform is built to operate across diverse environments, ranging from on-premises setups to cloud-native deployments.

InfluxDB is a specialized time series database platform engineered for the high-speed ingestion, compression, and retrieval of timestamped data at scale. It functions as a distributed metrics platform, providing the infrastructure necessary to organize and analyze massive volumes of time-stamped information to identify trends, patterns, and anomalies within complex data streams. The platform distinguishes itself through a functional dataflow engine that utilizes a specialized programming language for complex analytical transformations and automated tasks. This architecture is supported by a plugin-driven ingestion system that decouples data collection from core storage, alongside a distributed consensus protocol that ensures high availability and metadata consistency across clustered environments. To maintain performance as data grows, the system employs shard-based partitioning, columnar compression, and log-structured merge-tree storage to optimize write throughput and analytical query execution. Beyond core storage, the platform provides a comprehensive suite of tools for infrastructure monitoring, automated alerting, and data visualization. Users can manage the entire data lifecycle through a centralized control plane that handles cluster provisioning, security, and retention policies. The ecosystem includes integrated agent management for telemetry collection, allowing for consistent configuration and health monitoring across distributed computing environments. Deployment options are flexible, ranging from single-node instances for development to fully-managed cloud, serverless, and enterprise-grade clustered services.

Prometheus is a comprehensive monitoring and alerting platform designed to track infrastructure health and application performance. It functions as a time series database that ingests, indexes, and queries high-frequency numerical data points. By utilizing a pull-based model, the system periodically collects multi-dimensional metrics from monitored targets, storing them in an optimized block storage format that supports high-throughput ingestion and efficient historical analysis. The platform distinguishes itself through a specialized query engine that enables real-time analysis of performance data using a dedicated functional language. It maintains operational visibility in dynamic environments by integrating with infrastructure APIs for service discovery, allowing it to adapt automatically to changing topologies. To support diverse architectures, it includes mechanisms for buffering metrics from short-lived batch jobs and streaming data to external long-term storage systems via standardized protocols. Beyond core data collection, the system provides integrated alerting capabilities that continuously evaluate logical expressions against incoming data streams. It manages the full lifecycle of incident notifications by applying grouping, inhibition, and silence rules to reduce operational noise. The ecosystem also supports broad observability through service availability probing, legacy metric translation, and the instrumentation of application-level performance data. The software is available as pre-compiled binaries or container images, and it can be managed through standard infrastructure automation tools.

VictoriaMetrics is a high-performance, scalable time series database and observability platform designed for long-term storage and analysis of metric, log, and trace data. It functions as a unified backend for monitoring ecosystems, offering full compatibility with industry-standard protocols and query languages. The system is built to handle massive data volumes through a distributed architecture that supports horizontal scaling and efficient data lifecycle management. The platform distinguishes itself through a storage engine that utilizes consistent hashing for data sharding and log-structured merge trees to optimize write throughput and disk space. It provides robust multi-tenant isolation, allowing organizations to segment data and alerting configurations by account or project while maintaining secure, partitioned access. By offloading long-term data to object storage while retaining local caching, it balances cost-effective persistence with high-performance query execution. The system covers the entire observability lifecycle, including automated metric scraping, log aggregation, and distributed tracing. It features a sophisticated alerting and recording engine that supports dynamic rule evaluation and high-availability execution. Additionally, the project includes a Kubernetes operator that automates the deployment, configuration, and lifecycle management of monitoring components, ensuring consistent observability across containerized environments. VictoriaMetrics is distributed as a set of container-native services and can be managed via declarative resource definitions within Kubernetes clusters.

GreptimeDB is a distributed, open-source time-series database built for unified observability. It stores and queries metrics, logs, and traces together in a single columnar engine, supporting both SQL and PromQL for analysis. The database is designed as a Kubernetes-native operator with a decoupled compute and storage architecture, enabling horizontal scaling and multi-region deployment. What distinguishes GreptimeDB is its role as a multi-protocol ingestion gateway, accepting data through OpenTelemetry, Prometheus Remote Write, InfluxDB, Loki, Elasticsearch, Kafka, and MQTT protocols without requiring a predefined schema. It provides a unified observability data model that processes all three signal types as timestamped wide events, allowing JOIN queries across signals. The system includes a continuous aggregation pipeline with an optional Flownode component for streaming and materialized view computations, plus configurable log pipeline processing that parses and transforms raw log lines during ingestion. The database offers a broad capability surface including automatic schema inference, columnar storage with LSMT, distributed query execution with pushdown, and support for inverted, fulltext, and skipping indexes. It provides multiple query APIs (MySQL, PostgreSQL, HTTP, gRPC, Elasticsearch, Jaeger), BI tool connectivity, and integration with AI assistants through the Model Context Protocol. Deployment options range from standalone binaries to distributed clusters on Kubernetes, with metadata stored in etcd, MySQL, or PostgreSQL.

OpenObserve is a unified observability data platform designed to ingest, store, and analyze logs, metrics, and traces. It functions as a cloud-native monitoring tool that centralizes telemetry from diverse sources, including standard collectors and cloud service providers, into a single, scalable system. By utilizing a columnar storage engine backed by object storage, the platform enables efficient long-term data retention and high-performance analytical querying. The platform distinguishes itself through deep integration with artificial intelligence, allowing users to query data using natural language, generate dashboards via prompts, and automate incident analysis. It provides specialized monitoring for language model pipelines, including token usage cost analysis and performance tracking for AI agents. Furthermore, the system enforces strict multi-tenant resource isolation and zero-trust access, ensuring that organizational data remains secure and independent within shared infrastructure. Beyond its core storage and AI capabilities, the platform includes a comprehensive suite of tools for incident management, infrastructure monitoring, and data pipeline orchestration. It supports real-time stream processing, schema-agnostic indexing, and automated data enrichment, allowing for flexible telemetry management without rigid pre-defined structures. The system also provides advanced diagnostic features such as production error deobfuscation, service dependency mapping, and user journey analysis to accelerate root cause investigation. The software is designed for flexible deployment, running as a stateless, containerized service that supports high availability and horizontal scaling. It is distributed as a single binary or container image, with configuration managed through infrastructure-as-code templates.

Apache Druid is a real-time OLAP database and distributed analytics engine. It functions as a columnar time-series database designed for high-performance analytical queries and the real-time ingestion of streaming and batch datasets. The system provides a framework for high-concurrency analytics, allowing multiple simultaneous users to execute SQL and native queries across large-scale data. It supports mixed data ingestion, combining real-time streaming and batch loading into a single system for unified analysis. The platform includes capabilities for distributed cluster management, enabling the monitoring of data sources and system services through a centralized console.

RisingWave is a cloud-native streaming database and real-time analytics engine that uses standard SQL to process continuous data streams. It functions as a streaming data lakehouse, combining the capabilities of a streaming SQL database with a platform that integrates streaming ingestion with open table formats. The system is distinguished by its use of the PostgreSQL wire protocol, allowing it to integrate with existing SQL tools and drivers. It employs a decoupled compute and storage architecture, persisting streaming state and materialized views in cloud object storage to enable independent scaling and rapid recovery. The platform covers a broad range of real-time data operations, including change data capture, streaming ETL pipelines, and the maintenance of incremental materialized views. It supports complex stream processing such as windowed aggregations, event-time tracking with watermarks, and the continuous export of processed data to downstream sinks. The project can be deployed via Kubernetes and Helm, Docker Compose, or as a managed instance.

ClickHouse is a high-performance, columnar analytical database designed for real-time query execution and large-scale data aggregation. It functions as a distributed data warehouse capable of processing petabytes of information, while also providing an embedded engine that integrates directly into applications for native query capabilities without external dependencies. The system is built to handle high-throughput ingestion and complex analytical workloads, delivering millisecond-level latency for interactive dashboards and operational monitoring. The platform distinguishes itself through advanced storage and execution techniques, including vectorized query processing and a merge tree storage engine that maintains performance during massive insertions. It features adaptive subcolumn mapping for semi-structured data and supports native vector search for machine learning and generative AI applications. To facilitate efficient data movement, the engine utilizes zero-copy shared memory buffers, minimizing overhead when interacting with external analytical tools or processing diverse file formats like Parquet, JSON, and Arrow. Beyond its core storage and processing capabilities, the project provides a comprehensive suite of tools for observability, security, and data integration. It includes built-in support for natural language querying, automated workflow orchestration for AI agents, and extensive diagnostic features for query plan inspection. The platform also offers robust cloud infrastructure management, including support for private networking, compliant deployment strategies, and integrated billing consolidation.

Cockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures. The system distinguishes itself through a layered architecture that separates the relational SQL abstraction from a distributed key-value store. It achieves global consistency without requiring perfectly synchronized hardware clocks by employing a hybrid logical clock synchronization mechanism. To support high-concurrency environments, it utilizes multi-version concurrency control and lock-free transaction execution, which allow for consistent snapshots and efficient conflict resolution. Furthermore, the engine is built for compatibility, implementing the standard wire protocol to support existing relational database drivers and tools. Beyond its core transactional capabilities, the platform includes comprehensive tooling for cluster orchestration, security, and performance diagnostics. It supports a variety of deployment models, ranging from self-hosted on-premises configurations to fully managed cloud services. The system provides a command-line interface for session management and query execution, ensuring that administrators can monitor cluster health and manage workloads through standard relational interfaces.

Vitess is a distributed MySQL orchestrator and clustering system designed for horizontal database scaling. It functions as sharding middleware that distributes data and load across multiple MySQL instances to handle growth beyond the capacity of a single machine. The system provides a proxy layer that abstracts data distribution, allowing applications to query a cluster as a single logical database without knowing the physical location of the data. This is achieved through a routing mechanism that intercepts queries and directs them to the appropriate shards based on keyspace mappings. The platform manages large-scale data distribution through the ability to split or merge database shards. It coordinates these resharding processes and atomic cutovers to rebalance load across the cluster with minimal downtime.

OceanBase is a distributed SQL database designed for high availability and strong consistency across multiple nodes and regions. It functions as a hybrid transactional and analytical processing engine, allowing real-time analytics and transactions to execute on a single data copy. The system also serves as a vector database engine for indexing and querying vector data to power semantic search and recommendation systems. The platform features native compatibility layers for MySQL and Oracle, enabling the migration of legacy workloads without rewriting SQL code. It utilizes a Paxos-based distributed store for synchronous replication and implements a multi-tenant architecture that isolates CPU, memory, and I/O resources for different tenants within a single cluster. The system covers a broad range of capabilities, including horizontal storage scaling, distributed transaction management, and hybrid row-columnar storage. It provides tools for cluster orchestration, automated load balancing via log-stream migration, and disaster resilience through multi-zone replication and automated failover. Deployment and management are supported through a Kubernetes operator and a web monitoring dashboard.

SigNoz is a full-stack observability platform designed to collect, store, and visualize metrics, logs, and distributed traces in a unified environment. It leverages OpenTelemetry-based data collection to ingest telemetry from diverse sources using vendor-neutral protocols, ensuring interoperability across complex microservices architectures. The platform utilizes a high-performance columnar storage engine to enable rapid aggregation and filtering, providing a centralized backend for monitoring application health and performance. What distinguishes the platform is its focus on automated instrumentation and semantic correlation. It allows users to capture telemetry data across various programming languages and frameworks without manual code changes, often requiring only simple environment variable updates. Once ingested, the system automatically links logs, metrics, and traces through shared identifiers, enabling seamless navigation between different telemetry types during root cause analysis. The frontend further supports this by using virtualized rendering to efficiently display complex distributed traces containing millions of spans. The platform provides a comprehensive suite of tools for infrastructure monitoring, application performance tracking, and log management. Users can define complex alert conditions and manage monitoring configurations as version-controlled resources, ensuring consistency across deployment environments. Additionally, the system includes specialized support for monitoring large language model applications and provides visual query pipelines that translate user-defined filters into optimized database queries for real-time dashboard generation. The entire observability stack can be deployed using container orchestration tools, with built-in utilities for verifying service status and managing data retention.

Graphite-web is a time-series monitoring platform that stores numeric metric data in fixed-size Whisper database files, ingests metrics over a plaintext TCP protocol, and renders on-demand graphs from stored data. It provides a tag-based metric query engine for flexible data organization and retrieval, and includes a custom dashboard builder that assembles multiple time-series graphs into a single web view for consolidated monitoring. The platform distinguishes itself through its URL-driven metric retrieval system, which allows fetching rendered graph images or raw data by constructing HTTP requests with target, time range, and format parameters. It also features a function pipeline that applies mathematical transformations such as averaging, summing, or rate calculation to time-series data before rendering, and supports composite dashboard assembly that combines independent graphs into a single monitoring page. Graphite-web handles the full lifecycle of time-series data, from ingestion and storage through organization, retrieval, and visualization. Its documentation covers installation, configuration, and usage of the URL-based query API, the plaintext ingestion protocol, and the dashboard assembly interface.