`gmail.messages`

pass

Gmail message references, optionally filtered by label.

This table uses Gmail's list endpoint, so rows contain message IDs and

no filters captured 2026-09-01 13:41:06Zmedian 7020 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	6987 ms	7020 ms	7053 ms	[2, 2]
order-id	2	11317 ms	11406 ms	11495 ms	[2, 2]
filter-thread	2	11430 ms	11646 ms	11862 ms	[2, 2]
json-extract	2	6977 ms	7084 ms	7192 ms	[2, 2]
aggregate	2	11362 ms	11574 ms	11786 ms	[4, 4]
edge	2	7035 ms	7053 ms	7071 ms	[2, 2]

Latency per trial

minimalmedian 7020ms

scale: 0–7053 ms

order-idmedian 11406ms

scale: 0–11495 ms

filter-threadmedian 11646ms

scale: 0–11862 ms

json-extractmedian 7084ms

scale: 0–7192 ms

aggregatemedian 11574ms

scale: 0–11786 ms

edgemedian 7053ms

scale: 0–7071 ms

Probe variants — every command + output

minimal2 trials

min 6987ms · median 7020ms · max 7053ms · rows 2,2

smallest query

Command

SELECT id, thread_id FROM gmail.messages LIMIT 1

Trials + output

trial 1·7053ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6987ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

order-id2 trials

min 11317ms · median 11406ms · max 11495ms · rows 2,2

most recent message IDs

Command

SELECT id, thread_id FROM gmail.messages ORDER BY id DESC LIMIT 25

Trials + output

trial 1·11495ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·11317ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

filter-thread2 trials

min 11430ms · median 11646ms · max 11862ms · rows 2,2

messages in one thread

Command

SELECT id, thread_id FROM gmail.messages WHERE thread_id = '1a05d23da594d902' LIMIT 25

Trials + output

trial 1·11862ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·11430ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 6977ms · median 7084ms · max 7192ms · rows 2,2

typed JSON alongside row

Command

SELECT id, thread_id, json_as_text(raw, 'id') AS raw_id FROM gmail.messages LIMIT 5

Trials + output

trial 1·7192ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6977ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 11362ms · median 11574ms · max 11786ms · rows 4,4

message count

Command

SELECT COUNT(*) AS n FROM gmail.messages

Trials + output

trial 1·11362ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+------+

trial 2·11786ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+------+

edge2 trials

min 7035ms · median 7053ms · max 7071ms · rows 2,2

edge: larger limit

Command

SELECT id, thread_id FROM gmail.messages LIMIT 200

Trials + output

trial 1·7071ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7035ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

24 rows stored · 56 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	—	+------------------+------------------+------------------+	—
0	13	—	+------------------+------------------+------------------+	—
1	14	—	+------------------+------------------+------------------+	—
2	15	—	+------------------+------------------+------------------+	—
-1	16	—	—	n
0	17	—	—	n
1	18	—	—	n
2	19	—	—	n
-1	20	+------------------+------------------+	—	—
0	21	+------------------+------------------+	—	—
1	22	+------------------+------------------+	—	—
2	23	+------------------+------------------+	—	—

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	16	8	`"+------------------+------------------+"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	7053ms	2	ok	+------------------+------------------+
minimal	t2	6987ms	2	ok	+------------------+------------------+
order-id	t1	11495ms	2	ok	+------------------+------------------+
order-id	t2	11317ms	2	ok	+------------------+------------------+
filter-thread	t1	11862ms	2	ok	+------------------+------------------+
filter-thread	t2	11430ms	2	ok	+------------------+------------------+
json-extract	t1	7192ms	2	ok	+------------------+------------------+------------------+
json-extract	t2	6977ms	2	ok	+------------------+------------------+------------------+
aggregate	t1	11362ms	4	ok	+------+
aggregate	t2	11786ms	4	ok	+------+
edge	t1	7071ms	2	ok	+------------------+------------------+
edge	t2	7035ms	2	ok	+------------------+------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

This table uses Gmail's list endpoint, so rows contain message IDs and

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:41:06Z

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

first_run_at: 2026-09-01T13:41:06Z

last_retried_at: 2026-09-01T13:41:06Z

retry_count: 1

View version history →