`gmail.history`

pass

Gmail mailbox history records after a starting history ID.

Requires `start_history_id`. For the first sync, read it from

start_history_id captured 2026-09-01 14:03:24Zmedian 7155 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	6986 ms	7155 ms	7325 ms	[2, 2]
list	2	7032 ms	7034 ms	7037 ms	[2, 2]
json-extract	2	6999 ms	7012 ms	7026 ms	[2, 2]
aggregate	2	6986 ms	6989 ms	6993 ms	[4, 4]
edge	2	6993 ms	6995 ms	6998 ms	[2, 2]

Latency per trial

minimalmedian 7155ms

scale: 0–7325 ms

listmedian 7034ms

scale: 0–7037 ms

json-extractmedian 7012ms

scale: 0–7026 ms

aggregatemedian 6989ms

scale: 0–6993 ms

edgemedian 6995ms

scale: 0–6998 ms

Probe variants — every command + output

minimal2 trials

min 6986ms · median 7155ms · max 7325ms · rows 2,2

smallest query

Command

SELECT id, start_history_id FROM gmail.history WHERE start_history_id = '16541140' LIMIT 1

Trials + output

trial 1·6986ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7325ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 7032ms · median 7034ms · max 7037ms · rows 2,2

history records

Command

SELECT id, start_history_id FROM gmail.history WHERE start_history_id = '16541140' LIMIT 25

Trials + output

trial 1·7037ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7032ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 6999ms · median 7012ms · max 7026ms · rows 2,2

typed JSON on messages_added

Command

SELECT id, start_history_id, json_as_text(messages_added, '0') AS first_added FROM gmail.history WHERE start_history_id = '16541140' LIMIT 5

Trials + output

trial 1·7026ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6999ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 6986ms · median 6989ms · max 6993ms · rows 4,4

history count

Command

SELECT COUNT(*) AS n FROM gmail.history WHERE start_history_id = '16541140'

Trials + output

trial 1·6993ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+----+

trial 2·6986ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+----+

edge2 trials

min 6993ms · median 6995ms · max 6998ms · rows 2,2

edge: capped LIMIT

Command

SELECT id, start_history_id FROM gmail.history WHERE start_history_id = '16541140' LIMIT 200

Trials + output

trial 1·6998ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6993ms·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)": "start_history_id". Click a column to drill in.

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

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6986ms	2	ok	+----------+------------------+
minimal	t2	7325ms	2	ok	+----------+------------------+
list	t1	7037ms	2	ok	+----------+------------------+
list	t2	7032ms	2	ok	+----------+------------------+
json-extract	t1	7026ms	2	ok	+----------+------------------+-------------+
json-extract	t2	6999ms	2	ok	+----------+------------------+-------------+
aggregate	t1	6993ms	4	ok	+----+
aggregate	t2	6986ms	4	ok	+----+
edge	t1	6998ms	2	ok	+----------+------------------+
edge	t2	6993ms	2	ok	+----------+------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Requires `start_history_id`. For the first sync, read it from

Columns coral returned (1)

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

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

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

first_run_at: 2026-09-01T14:03:24Z

last_retried_at: 2026-09-01T14:03:24Z

retry_count: 1

View version history →