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 |
Using 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.
Reading the 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. The table shows 10 rows per page by default; use the page-size picker to switch to 20 or 50.