`gmail.message_details`

pass

Detailed metadata and payload for one Gmail message.

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

id captured 2026-09-01 13:58:38Zmedian 7633 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	7383 ms	7633 ms	7883 ms	[2, 2]
list	2	7075 ms	7203 ms	7332 ms	[2, 2]
json-extract	2	7036 ms	7045 ms	7055 ms	[2, 2]
aggregate	2	7263 ms	7357 ms	7451 ms	[4, 4]
edge	2	7053 ms	7058 ms	7064 ms	[2, 2]

Latency per trial

minimalmedian 7633ms

scale: 0–7883 ms

listmedian 7203ms

scale: 0–7332 ms

json-extractmedian 7045ms

scale: 0–7055 ms

aggregatemedian 7357ms

scale: 0–7451 ms

edgemedian 7058ms

scale: 0–7064 ms

Probe variants — every command + output

minimal2 trials

min 7383ms · median 7633ms · max 7883ms · rows 2,2

smallest query

Command

SELECT id, subject, internal_date FROM gmail.message_details WHERE id = '1a05d23da594d902' LIMIT 1

Trials + output

trial 1·7883ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7383ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 7075ms · median 7203ms · max 7332ms · rows 2,2

full message metadata

Command

SELECT id, subject, "from", "to", date, size_estimate FROM gmail.message_details WHERE id = '1a05d23da594d902' LIMIT 1

Trials + output

trial 1·7075ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7332ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 7036ms · median 7045ms · max 7055ms · rows 2,2

typed JSON on payload + raw

Command

SELECT id, subject, json_as_text(payload, 'mimeType') AS payload_mime, json_as_text(raw, 'id') AS raw_id FROM gmail.message_details WHERE id = '1a05d23da594d902' LIMIT 1

Trials + output

trial 1·7055ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7036ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 7263ms · median 7357ms · max 7451ms · rows 4,4

single-id count

Command

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

Trials + output

trial 1·7263ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

trial 2·7451ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+---+

edge2 trials

min 7053ms · median 7058ms · max 7064ms · rows 2,2

edge: capped LIMIT

Command

SELECT id, subject FROM gmail.message_details WHERE id = '1a05d23da594d902' LIMIT 25

Trials + output

trial 1·7053ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7064ms·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	7883ms	2	ok	+------------------+-------------------------------------------------------+----------------------+
minimal	t2	7383ms	2	ok	+------------------+-------------------------------------------------------+----------------------+
list	t1	7075ms	2	ok	+------------------+-------------------------------------------------------+--------------------------------------------------+----------------------+--------------------------------+---------------+
list	t2	7332ms	2	ok	+------------------+-------------------------------------------------------+--------------------------------------------------+----------------------+--------------------------------+---------------+
json-extract	t1	7055ms	2	ok	+------------------+-------------------------------------------------------+-----------------------+------------------+
json-extract	t2	7036ms	2	ok	+------------------+-------------------------------------------------------+-----------------------+------------------+
aggregate	t1	7263ms	4	ok	+---+
aggregate	t2	7451ms	4	ok	+---+
edge	t1	7053ms	2	ok	+------------------+-------------------------------------------------------+
edge	t2	7064ms	2	ok	+------------------+-------------------------------------------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

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

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:58:38Z

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

first_run_at: 2026-09-01T13:58:38Z

last_retried_at: 2026-09-01T13:58:38Z

retry_count: 1

View version history →