Column Statistics

Get instant statistical insights on any column in your query results without writing aggregate queries.

It’s the quickest way to profile data before you trust it: how many nulls are really in that column, how skewed the distribution is, whether a “unique” field actually is. Instead of writing four COUNT(DISTINCT ...) / MIN / MAX queries by hand, you click a column and read it off.

Opening the Stats Panel

Click on any column header in the results table and select Column Statistics from the context menu, or click the chart icon on a column header.

Available Statistics

General

• Row count — total rows in the result
• Distinct count — number of unique values
• Null count — number of NULL values
• Null percentage — proportion of NULLs

Numeric Columns

For numeric columns, additional stats are computed:

• Min and Max values
• Mean (average)
• Median (50th percentile)
• Standard deviation

Distribution

A histogram shows the distribution of values across the column, giving you a visual sense of data shape.

Most Common Values

A frequency chart displays the most common values with relative proportion bars, helping you spot dominant patterns at a glance.

Example: profiling a column before a migration

About to add NOT NULL to users.phone? Run SELECT phone FROM users, open Column Statistics on the column, and read the Null percentage. If it’s above 0%, the constraint will fail — now you know to backfill first. The Most Common Values chart also exposes junk defaults (a suspicious spike of '' or 'N/A') that a plain null check would miss.

Related

• Results Viewer — the grid these stats are computed from
• Smart Filters — filter to the rows a stat surfaced
• Data Masking — hide sensitive column values for demos and screenshots