Inspect a statement
Open any Postgres, MySQL, SQL Server or Oracle call on the Traffic page to see what you would otherwise have to reconstruct from logs and code: the exact SQL with its values, how it ended, who ran it, and what else that connection was doing. Everything comes from the recorded traffic, so you can inspect a production call without access to the production database.
The SQL with its values
The Request tab shows the statement. A prepared statement arrives with placeholders and its values separately, so the panel shows both:
- SQL is the statement as the app sent it, with
$1,?,@p1or:1placeholders. - With values fills the bound values in as literals, so you can copy the statement and run it. SQL Server values are written as T-SQL, such as
N'text'for a string and0x0A1Bfor binary. - Parameters lists each placeholder with its type and value.

SQL Server calls
A SQL Server call is one SQL batch, one RPC or one transaction request:
- A batch shows its full T-SQL text, which can hold several statements and return several result sets.
- An
sp_executesqlorsp_prepexeccall shows the SQL it carries with its typed parameters. Ansp_executecall shows the SQL its handle was prepared with. - A stored procedure called by name shows the procedure and its parameters, and its response shows the rows, the return value and the return status.
- Informational messages, such as
PRINToutput andRAISERRORat severity 10 or below, appear with the response. BEGIN,COMMITandROLLBACK, whether sent as T-SQL or as the driver's transaction requests, mark the transaction on the Connection tab.
Oracle calls
An Oracle call is one round trip from the driver and the server's whole reply to it:
- An execute shows its full SQL text, or a PL/SQL block, with its bind values. A re-execute that names only a cursor shows the SQL the cursor was opened with.
- A fetch shows the rows it returned, with every column decoded to its type, such as
NUMBER,DATE,TIMESTAMP, a LOB,JSONorVECTOR. - A commit or rollback, whether sent as SQL or as the driver's own call, marks the transaction on the Connection tab.
- A cancel shows the break the driver sent and the reset that answered it.
How it ended
The top of the Response tab says how the call ended:
- A successful call shows what it did: the command tag, such as
UPDATE 1, and the rows it returned. Writes return no rows, so this is where anUPDATEorDELETEsays how many rows it changed. - A failed call shows an error card with the message, the SQLSTATE, the MySQL or SQL Server error number or the Oracle
ORA-code, and its name, and the line of SQL the server pointed at with a caret under the position. - A call that was cancelled, timed out, deadlocked, waited too long for a lock or was terminated shows why. For a deadlock, a lock timeout, a timeout or a cancel, the card also lists the statements that were running at the same time on other connections, which is usually where the cause is.
- A chip says when the statement ran inside a transaction, or inside one that had already failed.

Below the card, each database fact of the call (event, operation, table, statement shape, error, user, session and so on) has a filter and an exclude button that add it to the Traffic filters. See Find statements with filters.
Who connected
A login call shows a login card: the user, the database, the client application, the authentication method, the session id, the server version and the client address. A refused login shows why it was refused. For a SQL Server connection recorded without TLS interception whose driver encrypted the login packet, the user and application are not known, and the database comes from the server's reply; see Record SQL Server.

Everything that connection did
The Connection tab lists the calls on the same database connection around the selected one, in order, from the login to the logout when they are in range. Calls inside a transaction are marked with a colored bar and a number, and a chip above the list says how each transaction ended (committed, rolled back, failed, ended or still open), how long it took and how long the client held it open without running anything.
Use it to see what led up to a failed or slow statement, whether a transaction held its locks while the app did something else, and in what order a request's statements really ran. Export as .sql downloads the connection's statements as a runnable script; see Export a SQL script.

The request that ran it
When the app writes the request's trace id into its SQL comments, the drawer of a database call names the inbound request that ran it, marked linked by trace ID, and otherwise the request that was running when it ran, marked by timing. See Link queries to the request that ran them.