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. |
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 |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2026-06-09 UTC.