Use the Session Detail page to inspect every SQL statement an AI agent executed, along with its execution metadata, in two views: a step-by-step reconstruction and a flat audit log.
Inspecting the page header
The header shows:
- Session ID — the session identifier, as a large monospace title.
- Started — the formatted timestamp of the first statement.
- Purpose — a tag showing the declared purpose, when one is available.
- Steps — a badge showing the total statement count.
Viewing the step-by-step reconstruction
Use the Reconstruction tab to step through the session chronologically. Each step is a single SQL statement with its full execution context, presented as an expandable accordion.
Collapsed step
Each collapsed step shows, at a glance:
- The step number, for example Step 1.
- A command tag for the SQL command type (
SELECT,INSERT,UPDATE,DELETE, and so on). - An error severity tag, shown only when the statement errored (red for
ERROR,FATAL, orPANIC). - The timestamp and duration, right-aligned — for example
14:30:45 · 45ms.
Expanded step
Selecting a step expands it to reveal the request panel, which is shown by default and contains:
- SQL statement — the statement, in a syntax-highlighted code block.
- SQLSTATE code — shown as a tag when it isn't
00000(success). - Properties — a grid of execution metadata:
| Property | Description |
|---|---|
| Database | Target database name |
| User | Postgres role used |
| PID | Backend process ID |
| PG Session ID | Postgres session identifier |
| Query ID | Internal query plan ID |
| Duration | Execution time in milliseconds |
| application_name | The full Airman tag, for example airman:billing/a1b2c3d4 |
Accordion mode
By default, you can expand multiple steps at once. When Accordion steps is enabled in settings, expanding a step automatically collapses the previously open one — useful for sessions with many steps where screen space is limited.
Viewing the flat audit log
The Audit Log tab presents the same session data as a flat table, optimized for scanning and filtering across all steps at once.
Audit log columns
| Column | Description |
|---|---|
| Time | Timestamp, monospace and right-aligned |
| SQL | Statement text, monospace, truncated with an ellipsis |
| Purpose | Declared purpose |
Searching the audit log
The toolbar's search field matches across the SQL text, purpose, and timestamps. Type a term to filter the table, and clear it to show all steps again.
Configuring page size
The table shows 10 rows per page by default, configurable to 10, 20, or 50.