Readyset Command Reference

Create a new cache entry for a specific SELECT Statement or QueryID

Command : CREATE CACHE FROM [select_statement | QueryID]

Drop a cache entry based on a CacheID from SHOW CACHES.

Command : DROP CACHE {CacheID}

Drop all cache entries.

Command : DROP ALL CACHES

Clear the list of proxied queries show at SHOW PROXIED QUERIES.

Command : DROP ALL PROXIED QUERIES

List all CREATE CACHE statements that have been executed, for the purpose of exporting them.

Command : EXPLAIN CACHES

Display information about how Readyset will interpret a specific query. Including if the query is supported or not.

Command : EXPLAIN CREATE CACHE FROM select_statement

List domain shard replicas and what worker they're running on.

Command : EXPLAIN DOMAINS

Print a graphviz representation of the current query graph to stdout.

Command : EXPLAIN [SIMPLIFIED] GRAPHVIZ [FOR CACHE CacheID]

List and give information about all materializations in the graph.

Command : EXPLAIN MATERIALIZATIONS

Provides metadata about the last statement that was executed.

Command : EXPLAIN LAST STATEMENT

Display a list of proxied queries to upstream. Optionally, users can filter only SUPPORTED queries.

Command : SHOW PROXIED [SUPPORTED] QUERIES

Display a list of cached queries.

Command : SHOW CACHES

Display current Readyset server status

Command : SHOW READYSET STATUS

Display current Readyset adapter status.

Command : SHOW READYSET STATUS ADAPTER

Display the migration status for a specific ID.

Command : SHOW MIGRATION STATUS {ID}

Display information about the current Readyset version.

Command : SHOW READYSET VERSION

Display the list of replicated tables and their statuses. Optionally, users can include the ALL keyword to include the non-replicated tables from the upstream.

Command : SHOW READYSET [ALL] TABLES

Display a list of client connections.

Command : SHOW CONNECTIONS