Tideways Slow-SQL Command

The slow-sql command (alias slow-sqls) lets you inspect grouped slow SQL queries from the CLI. Slow SQL inspection is read-only.

It has two subcommands, list and show, which mirror tideways error.

List Slow SQL Groups

$ tideways slow-sql list acme/myproject42

Environment and service filters default to the selected project’s configured environment and all services. The default status is open and the default page is 1.

-e, --environment

(optional) Environment to list slow SQLs for. Defaults to the project’s configured environment.

-s, --service

(optional) Service to list slow SQLs for. Defaults to all services.

--status

(optional) Slow SQL status: open, resolved, ignored, or all. (default "open")

--transaction

(optional) Transaction ID to filter slow SQLs by.

--page

(optional) Result page (1 or greater). (default 1)

$ tideways slow-sql list acme/myproject42 --environment=production --service=web
$ tideways slow-sql list acme/myproject42 --transaction=123
$ tideways slow-sql list acme/myproject42 --status=resolved --page=2

Show a Slow SQL Group

$ tideways slow-sql show acme/myproject42 SLOW_SQL_ID

Shows aggregate slow SQL group data and the latest occurrence across all environments and services, including its query, stack trace, transaction, and context annotations. A compact histogram shows the occurrence distribution over the error-retention period included with the project’s license.

If project_name is omitted, the CLI uses the project configured for the current repository (see tideways init) or the global default project. Slow SQL IDs are opaque and may contain slashes.

Still need help? Email [email protected]