Log Encyclopedia

Kubernetes Ingress Nginx

Ingress-Nginx controller log with request identifiers and upstream timings.

Category: Kubernetes

Regex Pattern

^(?<remote_addr>\S+) - (?<remote_user>\S+) \[(?<time_local>[^\]]+)\] "(?<request>[^"]+)" (?<status>\d+) (?<body_bytes_sent>\d+) "(?<http_referer>[^"]*)" "(?<http_user_agent>[^"]*)" (?<request_length>\d+) (?<request_time>\S+) (?<proxy_upstream_name>\S+) (?<upstream_addr>\S+) (?<upstream_response_time>\S+) (?<upstream_status>\d+)

DuckDB Schema

remote_addr VARCHAR, remote_user VARCHAR, time_local VARCHAR, request VARCHAR, status INTEGER, body_bytes_sent INTEGER, http_referer VARCHAR, http_user_agent VARCHAR, request_length INTEGER, request_time DOUBLE, proxy_upstream_name VARCHAR, upstream_addr VARCHAR, upstream_response_time DOUBLE, upstream_status INTEGER

Ready to analyze?

Click below to open the local DuckDB tool preloaded for Kubernetes Ingress Nginx.

Analyze Now (Local & Private)Prefilled SQL: SELECT * FROM log_table WHERE status IN ('429', '503', 'upstream_timeout') LIMIT 200;