op: schema

11 events · 30.36 ms wall · 24.02 ms DB (79%) · 6.34 ms non-DB (21%)
DB 24.02 msnon-DB 6.34 ms

Transactions

Autocommit mode — every statement was its own transaction. Group related writes in one explicit transaction (and reads outside it) to cut round-trips.

#durationreadswritesmax idleoutcomelongest template
14.91 ms01—autocommitCREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(?), email VARCHAR(?), phone VARCHAR(?), address_line VARCHAR(?), city VARCHAR(?), …
27.25 ms01—autocommitCREATE TABLE orders (id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, amount DECIMAL(?,?), status VARCHAR(?), shipped_at TIMESTAMP, refu…
3601.70 us01—autocommitCREATE TABLE sessions (id INT PRIMARY KEY, last_seen TIMESTAMP)
45.90 ms01—autocommitCREATE TABLE settings (k VARCHAR(?) PRIMARY KEY, v VARCHAR(?))
51.99 ms01—autocommitINSERT INTO settings (k, v) VALUES (?, ?), (?, ?)
6670.20 us01—autocommitCREATE TABLE audit (id INT AUTO_INCREMENT PRIMARY KEY, kind VARCHAR(?), payload VARCHAR(?), ts TIMESTAMP)
7665.90 us01—autocommitCREATE TABLE outbox_events (id INT AUTO_INCREMENT PRIMARY KEY, kind VARCHAR(?), payload VARCHAR(?), status VARCHAR(?) DEFAULT ?, attempts I…
8560.10 us01—autocommitCREATE TABLE customer_balances (customer_id INT PRIMARY KEY, orders_count INT, lifetime_spend DECIMAL(?,?), last_order_at TIMESTAMP, update…
9772.50 us01—autocommitCREATE TABLE reconciliation_exceptions (id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, expected DECIMAL(?,?), actual DECIMAL(?,?), rea…
10688.50 us01—autocommitCREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, sku VARCHAR(?), name VARCHAR(?), category VARCHAR(?), price DECIMAL(?,?), stock_q…

Timeline

gap is idle time since the previous event on the same thread — highlighted rows had noticeably more app/non-DB time before them than the rest. Follow those to find where the op lost its wall-clock time outside the database.

+offsetgapeventdurationtemplateparamscall-site
0 ns—EXECUTE_UPDATE4.91 msCREATE TABLE customers (id INT PRIMARY KEY, name VARCHAR(?), email VARCHAR(?), phone VARCHAR(?), address_line VARCHAR(?), city VARCHAR(?), …—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
9.52 ms4.61 msEXECUTE_UPDATE7.25 msCREATE TABLE orders (id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, amount DECIMAL(?,?), status VARCHAR(?), shipped_at TIMESTAMP, refu…—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
16.99 ms216.70 usEXECUTE_UPDATE601.70 usCREATE TABLE sessions (id INT PRIMARY KEY, last_seen TIMESTAMP)—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
17.76 ms171.30 usEXECUTE_UPDATE5.90 msCREATE TABLE settings (k VARCHAR(?) PRIMARY KEY, v VARCHAR(?))—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
23.94 ms277.80 usEXECUTE_UPDATE1.99 msINSERT INTO settings (k, v) VALUES (?, ?), (?, ?)—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
26.12 ms179.40 usEXECUTE_UPDATE670.20 usCREATE TABLE audit (id INT AUTO_INCREMENT PRIMARY KEY, kind VARCHAR(?), payload VARCHAR(?), ts TIMESTAMP)—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
26.96 ms177.60 usEXECUTE_UPDATE665.90 usCREATE TABLE outbox_events (id INT AUTO_INCREMENT PRIMARY KEY, kind VARCHAR(?), payload VARCHAR(?), status VARCHAR(?) DEFAULT ?, attempts I…—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
27.77 ms143.30 usEXECUTE_UPDATE560.10 usCREATE TABLE customer_balances (customer_id INT PRIMARY KEY, orders_count INT, lifetime_spend DECIMAL(?,?), last_order_at TIMESTAMP, update…—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
28.49 ms161.10 usEXECUTE_UPDATE772.50 usCREATE TABLE reconciliation_exceptions (id INT AUTO_INCREMENT PRIMARY KEY, customer_id INT, expected DECIMAL(?,?), actual DECIMAL(?,?), rea…—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
29.49 ms219.30 usEXECUTE_UPDATE688.50 usCREATE TABLE products (id INT AUTO_INCREMENT PRIMARY KEY, sku VARCHAR(?), name VARCHAR(?), category VARCHAR(?), price DECIMAL(?,?), stock_q…—fi.vesas.jdbclens.capture.CapturingStatement.emitExecuteUnknown:203
30.36 ms181.80 usCLOSE8.00 us——stack[-1]