Real-Time Postgres Protocol Proxying with Lnav

The query hits like a gunshot on the wire. Your Postgres queries are moving, but you can’t see them. Lnav now changes that. With full Postgres binary protocol proxying, you can watch, parse, and understand live database traffic without grinding your production system to dust.

Lnav has long been a favorite for log file navigation. Now it steps deeper—into the raw binary flow between clients and the Postgres server. It’s not just reading text logs. It’s sitting in the middle, speaking the Postgres protocol, proxying requests, and capturing every detail. This gives you query-level visibility in real time.

When Lnav acts as a Postgres binary protocol proxy, it intercepts packets before they hit the database. You can inspect query parameters, response times, and transaction boundaries. The tool translates the binary data into human-readable format without losing fidelity. This means you spend less time recreating issues and more time fixing them.

Protocol proxying also enables advanced filtering. Want to capture only INSERT statements from a specific user? Lnav can match patterns at the binary protocol layer, before SQL parsing, for precise control. This makes debugging and performance tuning faster.

For distributed systems, this approach strips away guesswork. Instead of correlating logs across multiple components and time zones, you watch the direct client–server conversation. If latency spikes, you see it in the handshake. If the database returns errors, you read them at the protocol level, not after some middleware has reformatted them.

Security gets a boost too. With Postgres binary protocol proxying, Lnav can detect suspicious queries before they execute. It’s a small but vital guardrail in complex environments where multiple services hit the same database.

The implementation is lean. No bulky agents. No invasive instrumentation. Lnav binds to the port you choose, receives inbound connections, and proxies them to your Postgres instance. Binary traffic is decoded inline, stored, and indexed for navigation. This keeps overhead low and analysis high.

Lnav’s Postgres binary protocol proxying turns opaque traffic into actionable insight. You get the truth from the wire, fast.

See it live in minutes at hoop.dev and start capturing real Postgres protocol data without touching your database code.