`gmail.labels`

pass

Gmail labels visible in the mailbox.

Use this table to discover label IDs such as `INBOX`, `SENT`, custom

no filters captured 2026-09-01 13:37:24Zmedian 10121 ms

Verdict: TRUE

All variants returned rows on ≥2 of 3 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	10075 ms	10121 ms	10167 ms	[2, 2]
list	2	9995 ms	10009 ms	10023 ms	[2, 2]
filter-type	2	7075 ms	7108 ms	7141 ms	[2, 2]
group-by	2	7070 ms	7387 ms	7704 ms	[2, 2]
json-extract	2	6994 ms	7035 ms	7077 ms	[2, 2]
aggregate	2	6997 ms	7018 ms	7039 ms	[2, 2]
edge	2	6991 ms	6998 ms	7006 ms	[2, 2]

Latency per trial

minimalmedian 10121ms

scale: 0–10167 ms

listmedian 10009ms

scale: 0–10023 ms

filter-typemedian 7108ms

scale: 0–7141 ms

group-bymedian 7387ms

scale: 0–7704 ms

json-extractmedian 7035ms

scale: 0–7077 ms

aggregatemedian 7018ms

scale: 0–7039 ms

edgemedian 6998ms

scale: 0–7006 ms

Probe variants — every command + output

minimal2 trials

min 10075ms · median 10121ms · max 10167ms · rows 2,2

smallest query

Command

SELECT id, name, type FROM gmail.labels LIMIT 1

Trials + output

trial 1·10075ms·rows 2isError=false

First row (click to expand JSON)

{
  "+------+------+--------+": "+------+------+--------+"
}

columns (1)

+------+------+--------+

trial 2·10167ms·rows 2isError=false

First row (click to expand JSON)

{
  "+------+------+--------+": "+------+------+--------+"
}

columns (1)

+------+------+--------+

list2 trials

min 9995ms · median 10009ms · max 10023ms · rows 2,2

all labels

Command

SELECT id, name, type FROM gmail.labels ORDER BY id LIMIT 25

Trials + output

trial 1·10023ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------------+--------------------------+--------+": "+---------------------------+--------------------------+--------+"
}

columns (1)

+---------------------------+--------------------------+--------+

trial 2·9995ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------------+--------------------------+--------+": "+---------------------------+--------------------------+--------+"
}

columns (1)

+---------------------------+--------------------------+--------+

filter-type2 trials

min 7075ms · median 7108ms · max 7141ms · rows 2,2

system labels

Command

SELECT id, name FROM gmail.labels WHERE type = 'system' LIMIT 25

Trials + output

trial 1·7141ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+---------------------+": "+---------------------+---------------------+"
}

columns (1)

+---------------------+---------------------+

trial 2·7075ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------+---------------------+": "+---------------------+---------------------+"
}

columns (1)

+---------------------+---------------------+

group-by2 trials

min 7070ms · median 7387ms · max 7704ms · rows 2,2

labels by type

Command

SELECT type, COUNT(*) AS n FROM gmail.labels GROUP BY type ORDER BY n DESC

Trials + output

trial 1·7070ms·rows 2isError=false

First row (click to expand JSON)

{
  "+--------+----+": "+--------+----+"
}

columns (1)

+--------+----+

trial 2·7704ms·rows 2isError=false

First row (click to expand JSON)

{
  "+--------+----+": "+--------+----+"
}

columns (1)

+--------+----+

json-extract2 trials

min 6994ms · median 7035ms · max 7077ms · rows 2,2

typed JSON alongside row

Command

SELECT id, name, json_as_text(raw, 'id') AS raw_id FROM gmail.labels LIMIT 5

Trials + output

trial 1·7077ms·rows 2isError=false

First row (click to expand JSON)

{
  "+-----------+-----------+-----------+": "+-----------+-----------+-----------+"
}

columns (1)

+-----------+-----------+-----------+

trial 2·6994ms·rows 2isError=false

First row (click to expand JSON)

{
  "+-----------+-----------+-----------+": "+-----------+-----------+-----------+"
}

columns (1)

+-----------+-----------+-----------+

aggregate2 trials

min 6997ms · median 7018ms · max 7039ms · rows 2,2

label totals

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT type) AS types FROM gmail.labels

Trials + output

trial 1·7039ms·rows 2isError=false

First row (click to expand JSON)

{
  "+----+-------+": "+----+-------+"
}

columns (1)

+----+-------+

trial 2·6997ms·rows 2isError=false

First row (click to expand JSON)

{
  "+----+-------+": "+----+-------+"
}

columns (1)

+----+-------+

edge2 trials

min 6991ms · median 6998ms · max 7006ms · rows 2,2

edge: larger limit

Command

SELECT id, name, type FROM gmail.labels LIMIT 200

Trials + output

trial 1·6991ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------------+--------------------------+--------+": "+---------------------------+--------------------------+--------+"
}

columns (1)

+---------------------------+--------------------------+--------+

trial 2·7006ms·rows 2isError=false

First row (click to expand JSON)

{
  "+---------------------------+--------------------------+--------+": "+---------------------------+--------------------------+--------+"
}

columns (1)

+---------------------------+--------------------------+--------+

All returned rowsacross all non-errored trials · filterable · paginated

28 rows stored · 56 returned · page 1/2


-1	0	+------+------+--------+	—	—	—	—	—
0	1	+------+------+--------+	—	—	—	—	—
1	2	+------+------+--------+	—	—	—	—	—
2	3	+------+------+--------+	—	—	—	—	—
-1	4	—	+---------------------------+--------------------------+--------+	—	—	—	—
0	5	—	+---------------------------+--------------------------+--------+	—	—	—	—
1	6	—	+---------------------------+--------------------------+--------+	—	—	—	—
2	7	—	+---------------------------+--------------------------+--------+	—	—	—	—
-1	8	—	—	+---------------------+---------------------+	—	—	—
0	9	—	—	+---------------------+---------------------+	—	—	—
1	10	—	—	+---------------------+---------------------+	—	—	—
2	11	—	—	+---------------------+---------------------+	—	—	—
-1	12	—	—	—	+--------+----+	—	—
0	13	—	—	—	+--------+----+	—	—
1	14	—	—	—	+--------+----+	—	—
2	15	—	—	—	+--------+----+	—	—
-1	16	—	—	—	—	+-----------+-----------+-----------+	—
0	17	—	—	—	—	+-----------+-----------+-----------+	—
1	18	—	—	—	—	+-----------+-----------+-----------+	—
2	19	—	—	—	—	+-----------+-----------+-----------+	—
-1	20	—	—	—	—	—	+----+-------+
0	21	—	—	—	—	—	+----+-------+
1	22	—	—	—	—	—	+----+-------+
2	23	—	—	—	—	—	+----+-------+
-1	24	—	+---------------------------+--------------------------+--------+	—	—	—	—

Column profile

1 columns actually returned by coral. Catalog claims no required filters. Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	+------+------+--------+	string	4	24	`"+------+------+--------+"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	10075ms	2	ok	+------+------+--------+
minimal	t2	10167ms	2	ok	+------+------+--------+
list	t1	10023ms	2	ok	+---------------------------+--------------------------+--------+
list	t2	9995ms	2	ok	+---------------------------+--------------------------+--------+
filter-type	t1	7141ms	2	ok	+---------------------+---------------------+
filter-type	t2	7075ms	2	ok	+---------------------+---------------------+
group-by	t1	7070ms	2	ok	+--------+----+
group-by	t2	7704ms	2	ok	+--------+----+
json-extract	t1	7077ms	2	ok	+-----------+-----------+-----------+
json-extract	t2	6994ms	2	ok	+-----------+-----------+-----------+
aggregate	t1	7039ms	2	ok	+----+-------+
aggregate	t2	6997ms	2	ok	+----+-------+
edge	t1	6991ms	2	ok	+---------------------------+--------------------------+--------+
edge	t2	7006ms	2	ok	+---------------------------+--------------------------+--------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Use this table to discover label IDs such as `INBOX`, `SENT`, custom

Columns coral returned (1)

+------+------+--------+

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:37:24Z

JSON record: reports/gmail/tables/labels.json

first_run_at: 2026-09-01T13:37:24Z

last_retried_at: 2026-09-01T13:37:24Z

retry_count: 1

View version history →