`gmail.thread_details`

pass

Detailed metadata and messages for one Gmail thread.

Requires `id` from `gmail.threads`. The default `format` is `full`,

id captured 2026-09-01 14:01:02Zmedian 7123 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	7111 ms	7123 ms	7136 ms	[2, 2]
list	2	7037 ms	7098 ms	7159 ms	[2, 2]
json-extract	2	7147 ms	7158 ms	7170 ms	[2, 2]
aggregate	2	7011 ms	7015 ms	7020 ms	[4, 4]
edge	2	7070 ms	7159 ms	7248 ms	[2, 2]

Latency per trial

minimalmedian 7123ms

scale: 0–7136 ms

listmedian 7098ms

scale: 0–7159 ms

json-extractmedian 7158ms

scale: 0–7170 ms

aggregatemedian 7015ms

scale: 0–7020 ms

edgemedian 7159ms

scale: 0–7248 ms

Probe variants — every command + output

minimal2 trials

min 7111ms · median 7123ms · max 7136ms · rows 2,2

smallest query

Command

SELECT id, snippet FROM gmail.thread_details WHERE id = '1a05d23da594d902' LIMIT 1

Trials + output

trial 1·7111ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7136ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 7037ms · median 7098ms · max 7159ms · rows 2,2

thread meta

Command

SELECT id, snippet, history_id, first_message_id FROM gmail.thread_details WHERE id = '1a05d23da594d902' LIMIT 1

Trials + output

trial 1·7037ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7159ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 7147ms · median 7158ms · max 7170ms · rows 2,2

typed JSON

Command

SELECT id, json_as_text(raw, 'id') AS raw_id, json_as_text(messages, '0') AS first_message FROM gmail.thread_details WHERE id = '1a05d23da594d902' LIMIT 1

Trials + output

trial 1·7170ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7147ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 7011ms · median 7015ms · max 7020ms · rows 4,4

single-id count

Command

SELECT COUNT(*) AS n FROM gmail.thread_details WHERE id = '1a05d23da594d902'

Trials + output

trial 1·7011ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

trial 2·7020ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

edge2 trials

min 7070ms · median 7159ms · max 7248ms · rows 2,2

edge: capped LIMIT

Command

SELECT id, snippet FROM gmail.thread_details WHERE id = '1a05d23da594d902' LIMIT 25

Trials + output

trial 1·7248ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7070ms·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	8	12	`"+------------------+---------+"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	7111ms	2	ok	+------------------+---------+
minimal	t2	7136ms	2	ok	+------------------+---------+
list	t1	7037ms	2	ok	+------------------+---------+------------+------------------+
list	t2	7159ms	2	ok	+------------------+---------+------------+------------------+
json-extract	t1	7170ms	2	ok	+------------------+------------------+---------------+
json-extract	t2	7147ms	2	ok	+------------------+------------------+---------------+
aggregate	t1	7011ms	4	ok	+---+
aggregate	t2	7020ms	4	ok	+---+
edge	t1	7248ms	2	ok	+------------------+---------+
edge	t2	7070ms	2	ok	+------------------+---------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires `id` from `gmail.threads`. The default `format` is `full`,

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T14:01:02Z

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

first_run_at: 2026-09-01T14:01:02Z

last_retried_at: 2026-09-01T14:01:02Z

retry_count: 1

View version history →