Log Encyclopedia

GCP HTTP Load Balancer Log

Structured text export for Google Cloud HTTP(S) Load Balancers (classic logging).

Category: Cloud Networking

Regex Pattern

^(?<timestamp>\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}\.\d+Z)\s+(?<elb>\S+)\s+(?<client_ip>\S+):(?<client_port>\d+)\s+(?<backend_ip>\S+):(?<backend_port>\d+)\s+(?<request_processing_time>\S+)\s+(?<backend_processing_time>\S+)\s+(?<response_processing_time>\S+)\s+(?<elb_status_code>\d{3})\s+(?<backend_status_code>\d{3})\s+(?<received_bytes>\d+)\s+(?<sent_bytes>\d+)\s+"(?<request>[^"]+)"\s+(?<user_agent>\S+)\s+(?<ssl_cipher>\S+)\s+(?<ssl_protocol>\S+)\s+(?<target_group_arn>\S+)\s+(?<trace_id>\S+)

DuckDB Schema

timestamp TIMESTAMP, elb VARCHAR, client_ip VARCHAR, client_port INTEGER, backend_ip VARCHAR, backend_port INTEGER, request_processing_time DOUBLE, backend_processing_time DOUBLE, response_processing_time DOUBLE, elb_status_code INTEGER, backend_status_code INTEGER, received_bytes BIGINT, sent_bytes BIGINT, request VARCHAR, user_agent VARCHAR, ssl_cipher VARCHAR, ssl_protocol VARCHAR, target_group_arn VARCHAR, trace_id VARCHAR

Ready to analyze?

Click below to open the local DuckDB tool preloaded for GCP HTTP Load Balancer Log.

Analyze Now (Local & Private)Prefilled SQL: SELECT * FROM log_table LIMIT 200;