List query optimizer versions

Spanner provides a built-in SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS table to keep track of query optimizer versions. You can retrieve this data using SQL queries.

SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS table schema

Column name	Type	Description
VERSION	INT64	The optimizer version.
RELEASE_DATE	DATE	The release date of the optimizer version.
IS_DEFAULT	BOOL	Whether the version is the default version.

List all supported optimizer versions

SELECT * FROM SPANNER_SYS.SUPPORTED_OPTIMIZER_VERSIONS

An example result:

VERSION	RELEASE_DATE	IS_DEFAULT
1	2019-06-18	false
2	2020-03-01	false
3	2021-08-01	true

What's next

• To learn more about the query optimizer, see Query optimizer overview.
• To learn more about how the query optimizer has evolved, see Query optimizer versions.