Log Architecture & Structural Overview

The Redis Slowlog & Execution Timer Parser is an essential telemetry stream within the Databases & Key-Value Stores ecosystem. Parse Redis slow command logs to audit blocking operations like KEYS, HGETALL, or SMEMBERS.

This schema defines a structure of 5 extracted attributes, including 3 numeric metrics and 2 string dimensions. In production observability architectures, these tokens provide high-cardinality indexing keys for telemetry pipelines before shipping to storage backends such as ClickHouse, Elasticsearch, Amazon S3, or Datadog.

Raw Telemetry Ingestion Profile

A typical raw event line for redis-slowlog averages 41 bytes across 5 tokens. Modern collectors such as Fluent Bit and Vector require zero-backtracking regular expressions to avoid CPU spikes during traffic surges.

Extracted Field Schema & Data Types

The transpiled Grok pattern extracts the following schema fields from each raw event line. Data collectors cast these values according to the typed mappings below.

Field Name	Inferred Type	Description & Collector Semantics
slowlog_id	integer	Sequential slowlog record identifier.
timestamp	integer	Unix epoch seconds timestamp.
duration_us	integer	Execution duration in microseconds.
command	string	Executed Redis command name.
argument	string	Primary command argument or key target.

Common Regex Traps & Production Edge Cases

Engineers frequently encounter ingestion failures or pipeline drops due to subtle variations in real-world event logs. Watch out for these verified pitfalls:

1Redis records slowlog durations in microseconds (us), not milliseconds.

2Commands without arguments (like FLUSHDB or PING) will omit the argument element.

Production Collector Setup & Configurations

Pre-configured parser definitions ready to be dropped into your infrastructure repository.

Fluent Bit (parsers.conf)

Format: regex

# ==============================================================================
# Fluent Bit Parser Configuration (parsers.conf)
# ==============================================================================
[PARSER]
    Name        logpipeline_parser
    Format      regex
    Regex       ^(?<slowlog_id>(?:[+-]?(?:[0-9]+)))\) (?<timestamp>(?:[+-]?(?:[0-9]+))) \((?<duration_us>(?:[+-]?(?:[0-9]+)))us\) \["(?<command>\b\w+\b)"(?:, "(?<argument>.*?)")?\]$
    Time_Key    timestamp
    Time_Format %Y-%m-%dT%H:%M:%S%z
    Types       slowlog_id:integer timestamp:integer duration_us:integer

# ==============================================================================
# Fluent Bit Pipeline Filter (fluent-bit.conf)
# ==============================================================================
[FILTER]
    Name         parser
    Match        *
    Key_Name     log
    Parser       logpipeline_parser
    Reserve_Data On

Vector.dev (Remap VRL)

parse_regex!

# ==============================================================================
# Vector.dev Remap Language (VRL) Transform
# Use inside a 'remap' transform in vector.yaml
# ==============================================================================
.parsed, err = parse_regex(.message, r'^(?<slowlog_id>(?:[+-]?(?:[0-9]+)))\) (?<timestamp>(?:[+-]?(?:[0-9]+))) \((?<duration_us>(?:[+-]?(?:[0-9]+)))us\) \["(?<command>\b\w+\b)"(?:, "(?<argument>.*?)")?\]$')

if err == null {
    . = merge(., .parsed)
    del(.parsed)

    # Type coercions
    .slowlog_id = to_int!(.slowlog_id)
    .timestamp = to_int!(.timestamp)
    .duration_us = to_int!(.duration_us)

} else {
    log("LogPipeline parsing warning: " + err, level: "warn")
}

# ==============================================================================
# vector.yaml Pipeline Component
# ==============================================================================
transforms:
  parse_logs:
    type: remap
    inputs: ["source_logs"]
    source: |
      .parsed, err = parse_regex(.message, r'^(?<slowlog_id>(?:[+-]?(?:[0-9]+)))\) (?<timestamp>(?:[+-]?(?:[0-9]+))) \((?<duration_us>(?:[+-]?(?:[0-9]+)))us\) \["(?<command>\b\w+\b)"(?:, "(?<argument>.*?)")?\]$')
      if err == null {
        . = merge(., .parsed)
        del(.parsed)
      }

Datadog Log Pipeline Grok Parser

match_rules

# ==============================================================================
# Datadog Log Processing Pipeline Grok Parser
# Navigate to: Logs -> Configuration -> Pipelines -> Add Processor -> Grok Parser
# ==============================================================================

# Match Rule:
rule %{INT:slowlog_id}\) %{INT:timestamp} \(%{INT:duration_us}us\) \["%{WORD:command}"(?:, "%{DATA:argument}")?\]

# Complete Datadog Pipeline Processor JSON:
{
  "type": "grok-parser",
  "name": "LogPipeline Grok Parser",
  "is_enabled": true,
  "source": "message",
  "samples": [],
  "grok": {
    "match_rules": "rule %{INT:slowlog_id}\\) %{INT:timestamp} \\(%{INT:duration_us}us\\) \\[\"%{WORD:command}\"(?:, \"%{DATA:argument}\")?\\]",
    "support_rules": ""
  }
}

# Target Fields Created:
# slowlog_id (integer), timestamp (integer), duration_us (integer), command (string), argument (string)

OpenTelemetry Collector (transform processor)

regex_parser

# ==============================================================================
# OpenTelemetry Collector Configuration (otel-collector-config.yaml)
# Option 1: Filelog Receiver with regex_parser Operator
# ==============================================================================
receivers:
  filelog:
    include: [ /var/log/**/*.log ]
    start_at: beginning
    operators:
      - type: regex_parser
        id: logpipeline_regex_parser
        regex: '^(?<slowlog_id>(?:[+-]?(?:[0-9]+)))\) (?<timestamp>(?:[+-]?(?:[0-9]+))) \((?<duration_us>(?:[+-]?(?:[0-9]+)))us\) \["(?<command>\b\w+\b)"(?:, "(?<argument>.*?)")?\]$'
        timestamp:
          parse_from: attributes.timestamp
          layout: '%Y-%m-%dT%H:%M:%S%z'

# ==============================================================================
# Option 2: Transform Processor (OTel Transformation Language - OTTL)
# ==============================================================================
processors:
  transform:
    error_mode: ignore
    log_statements:
      - context: log
        statements:
          - merge_maps(attributes, extract_patterns(body, "^(?<slowlog_id>(?:[+-]?(?:[0-9]+)))\\) (?<timestamp>(?:[+-]?(?:[0-9]+))) \\((?<duration_us>(?:[+-]?(?:[0-9]+)))us\\) \\[\"(?<command>\\b\\w+\\b)\"(?:, \"(?<argument>.*?)\")?\\]$"), "insert")

service:
  pipelines:
    logs:
      receivers: [filelog]
      processors: [transform]
      exporters: [otlp]

Logstash Filter Configuration

filter.grok

# ==============================================================================
# Logstash Pipeline Configuration (/etc/logstash/conf.d/logpipeline.conf)
# ==============================================================================
filter {
  grok {
    match => { "message" => "%{INT:slowlog_id:integer}\) %{INT:timestamp:integer} \(%{INT:duration_us:integer}us\) \[\"%{WORD:command}\"(?:, \"%{DATA:argument}\")?\]" }
    tag_on_failure => [ "_grokparsefailure" ]
  }

  date {
    match => [ "timestamp", "ISO8601", "dd/MMM/yyyy:HH:mm:ss Z" ]
    target => "@timestamp"
    remove_field => [ "timestamp" ]
  }
}