Guides Meta Queries

📄️ Describe

Describing a Table

The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed,

Prepending a query with EXPLAIN ANALYZE both pretty-prints the query plan,

Goose provides a number of functions and PRAGMA options to retrieve information on the running Goose instance and its environment.

The SHOW TABLES command can be used to obtain a list of all tables within the selected schema.

The SUMMARIZE command can be used to easily compute a number of aggregates over a table or a query.