SpacetimeDB
SpacetimeDB copied to clipboard
Slow query log
I'd like each database to have a slow query log in the form of a system table. We should log ad hoc queries submitted via the cli as well as subscription and subscription update queries. Each entry should include:
- The sql text
- The sender identity
- The time it was executed
- Metrics such as rows scanned, bytes scanned, index seeks, etc.
- The physical plan that was executed (requires that we have some textual plan representation)
- The energy cost of the plan
Constraints/Requirements:
- The logging level should be configurable
- It should be possible to truncate the log
- The log does not have to be consistent - writes to the log can be delayed/batched together