Back to feed
GCP·Spannerfeature·
AI Insights

Spanner provides JSON string versions of the following statistics columns for PostgreSQL-dialect databases:

Spanner provides JSON string versions of the following statistics columns for PostgreSQL-dialect databases:

• TOTAL_LATENCY_DISTRIBUTION_JSON_STRING in Transaction statistics • OPERATIONS_BY_TABLE_JSON_STRING in Transaction statistics • LATENCY_DISTRIBUTION_JSON_STRING in Query statistics • SAMPLE_LOCK_REQUESTS_JSON_STRING in Lock statistics

You can use these columns to retrieve statistics in JSON format from the SPANNER_SYS tables.

Read original announcement

More from Spanner

Spanner offers conversational analytics, which lets users query their operational data using natural language.Mar 30, 2026You can create BigQuery non-incremental materialized views over Spanner data to improve query performance by periodically caching results.Mar 30, 2026You can use Cloud resource connections with EXPORT DATA statements to reverse ETL (extract, transform, load) BigQuery data to Spanner.Mar 30, 2026The Spark Spanner connector supports writing a Spark Dataframe to a Spanner table using the Spark data source API.Mar 25, 2026