`gmail.threads`

pass

Gmail thread references, optionally filtered by label.

This table uses Gmail's list endpoint. Use `label_id` and

no filters captured 2026-09-01 13:50:00Zmedian 7001 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	7000 ms	7001 ms	7002 ms	[2, 2]
order-id	2	11782 ms	12122 ms	12462 ms	[2, 2]
filter-id	2	11940 ms	12265 ms	12590 ms	[2, 2]
json-extract	2	7071 ms	7210 ms	7350 ms	[2, 2]
aggregate	2	11966 ms	12014 ms	12063 ms	[4, 4]
edge	2	7426 ms	7570 ms	7715 ms	[2, 2]

Latency per trial

minimalmedian 7001ms

scale: 0–7002 ms

order-idmedian 12122ms

scale: 0–12462 ms

filter-idmedian 12265ms

scale: 0–12590 ms

json-extractmedian 7210ms

scale: 0–7350 ms

aggregatemedian 12014ms

scale: 0–12063 ms

edgemedian 7570ms

scale: 0–7715 ms

Probe variants — every command + output

minimal2 trials

min 7000ms · median 7001ms · max 7002ms · rows 2,2

smallest query

Command

SELECT id, snippet FROM gmail.threads LIMIT 1

Trials + output

trial 1·7002ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7000ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

order-id2 trials

min 11782ms · median 12122ms · max 12462ms · rows 2,2

most recent thread IDs

Command

SELECT id, snippet, history_id FROM gmail.threads ORDER BY id DESC LIMIT 25

Trials + output

trial 1·11782ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·12462ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

filter-id2 trials

min 11940ms · median 12265ms · max 12590ms · rows 2,2

one thread by ID

Command

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

Trials + output

trial 1·12590ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

trial 2·11940ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

json-extract2 trials

min 7071ms · median 7210ms · max 7350ms · rows 2,2

typed JSON

Command

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

Trials + output

trial 1·7350ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·7071ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 11966ms · median 12014ms · max 12063ms · rows 4,4

thread count

Command

SELECT COUNT(*) AS n FROM gmail.threads

Trials + output

trial 1·11966ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+------+

trial 2·12063ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+------+

edge2 trials

min 7426ms · median 7570ms · max 7715ms · rows 2,2

edge: larger limit

Command

SELECT id, snippet FROM gmail.threads LIMIT 200

Trials + output

trial 1·7426ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

trial 2·7715ms·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	4	20	`"+------------------+----------------------------------------"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	7002ms	2	ok	+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------+
minimal	t2	7000ms	2	ok	+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------+
order-id	t1	11782ms	2	ok	+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+
order-id	t2	12462ms	2	ok	+------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+
filter-id	t1	12590ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
filter-id	t2	11940ms	2	ok	+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
json-extract	t1	7350ms	2	ok	+------------------+------------------+
json-extract	t2	7071ms	2	ok	+------------------+------------------+
aggregate	t1	11966ms	4	ok	+------+
aggregate	t2	12063ms	4	ok	+------+
edge	t1	7426ms	2	ok	+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
edge	t2	7715ms	2	ok	+------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

This table uses Gmail's list endpoint. Use `label_id` and

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:50:00Z

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

first_run_at: 2026-09-01T13:50:00Z

last_retried_at: 2026-09-01T13:50:00Z

retry_count: 1

View version history →