Learn how to import JFR data into DuckDB, to easily query and analyze your profiling data in this weeks blog post.

Mostly Nerdless

A new tool enables importing JDK Flight Recorder (JFR) profiling files into DuckDB databases for SQL-based analysis. The post covers the data modeling decisions: how JFR events map to tables, how structs are either inlined (numeric-only or single-property) or given separate tables with _id references, and how stack traces are handled with capped depth arrays. The tool supports all built-in JFR views reimplemented as SQL views, caches the database file, and ships as a self-contained JAR with embedded DuckDB. Alternatives like jfr-analytics (Apache Calcite), InfluxDB/Grafana exporters, and a Rust-based DuckDB JFR extension are discussed and compared. The tool is available on GitHub and via jbang.

Making JFR Quack: Importing JFR files into DuckDB - Mostly nerdless