`gmail.label_details`

pass

Detailed Gmail label metadata for one label.

Requires `id` from `gmail.labels`. This returns counters and color

id captured 2026-09-01 13:56:17Zmedian 6997 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	6988 ms	6997 ms	7007 ms	[2, 2]
list	2	6996 ms	7029 ms	7062 ms	[2, 2]
json-extract	2	7073 ms	7126 ms	7179 ms	[2, 2]
aggregate	2	7015 ms	7031 ms	7048 ms	[4, 4]
edge	2	7012 ms	7210 ms	7408 ms	[2, 2]

Latency per trial

minimalmedian 6997ms

scale: 0–7007 ms

listmedian 7029ms

scale: 0–7062 ms

json-extractmedian 7126ms

scale: 0–7179 ms

aggregatemedian 7031ms

scale: 0–7048 ms

edgemedian 7210ms

scale: 0–7408 ms

Probe variants — every command + output

minimal2 trials

min 6988ms · median 6997ms · max 7007ms · rows 2,2

smallest query

Command

SELECT id, name, messages_total, threads_total FROM gmail.label_details WHERE id = 'INBOX' LIMIT 1

Trials + output

trial 1·6988ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7007ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 6996ms · median 7029ms · max 7062ms · rows 2,2

label counters

Command

SELECT id, name, messages_total, messages_unread, threads_total, threads_unread FROM gmail.label_details WHERE id = 'INBOX' LIMIT 1

Trials + output

trial 1·7062ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6996ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 7073ms · median 7126ms · max 7179ms · rows 2,2

typed JSON on raw + color

Command

SELECT id, name, json_as_text(raw, 'id') AS raw_id, json_as_text(color, 'backgroundColor') AS bg FROM gmail.label_details WHERE id = 'INBOX' LIMIT 1

Trials + output

trial 1·7073ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7179ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 7015ms · median 7031ms · max 7048ms · rows 4,4

single-id count

Command

SELECT COUNT(*) AS n FROM gmail.label_details WHERE id = 'INBOX'

Trials + output

trial 1·7015ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

trial 2·7048ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

edge2 trials

min 7012ms · median 7210ms · max 7408ms · rows 2,2

edge: capped LIMIT

Command

SELECT id, name, messages_total FROM gmail.label_details WHERE id = 'INBOX' LIMIT 25

Trials + output

trial 1·7408ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7012ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

20 rows stored · 48 returned · page 1/1


-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	—	—	—	n	—
0	13	—	—	—	n	—
1	14	—	—	—	n	—
2	15	—	—	—	n	—
-1	16	—	—	—	—	+-------+-------+----------------+
0	17	—	—	—	—	+-------+-------+----------------+
1	18	—	—	—	—	+-------+-------+----------------+
2	19	—	—	—	—	+-------+-------+----------------+

Column profile

1 columns actually returned by coral. Catalog claims "1 required filter(s)": "id". Click a column to drill in.

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

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6988ms	2	ok	+-------+-------+----------------+---------------+
minimal	t2	7007ms	2	ok	+-------+-------+----------------+---------------+
list	t1	7062ms	2	ok	+-------+-------+----------------+-----------------+---------------+----------------+
list	t2	6996ms	2	ok	+-------+-------+----------------+-----------------+---------------+----------------+
json-extract	t1	7073ms	2	ok	+-------+-------+--------+----+
json-extract	t2	7179ms	2	ok	+-------+-------+--------+----+
aggregate	t1	7015ms	4	ok	+---+
aggregate	t2	7048ms	4	ok	+---+
edge	t1	7408ms	2	ok	+-------+-------+----------------+
edge	t2	7012ms	2	ok	+-------+-------+----------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires `id` from `gmail.labels`. This returns counters and color

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:56:17Z

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

first_run_at: 2026-09-01T13:56:17Z

last_retried_at: 2026-09-01T13:56:17Z

retry_count: 1

View version history →