`gmail.drafts`

pass

Gmail draft references.

This table lists draft IDs and their message IDs. For Gmail search

no filters captured 2026-09-01 13:33:19Zmedian 10659 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	10046 ms	10659 ms	11272 ms	[2, 2]
list	2	10024 ms	10047 ms	10071 ms	[2, 2]
filter-thread	2	10210 ms	10217 ms	10224 ms	[1, 1]
json-extract	2	10032 ms	10068 ms	10104 ms	[2, 2]
aggregate	2	10017 ms	10096 ms	10176 ms	[4, 4]
edge	2	10087 ms	10106 ms	10126 ms	[2, 2]

Latency per trial

minimalmedian 10659ms

scale: 0–11272 ms

listmedian 10047ms

scale: 0–10071 ms

filter-threadmedian 10217ms

scale: 0–10224 ms

json-extractmedian 10068ms

scale: 0–10104 ms

aggregatemedian 10096ms

scale: 0–10176 ms

edgemedian 10106ms

scale: 0–10126 ms

Probe variants — every command + output

minimal2 trials

min 10046ms · median 10659ms · max 11272ms · rows 2,2

smallest query

Command

SELECT id, message_id, thread_id FROM gmail.drafts LIMIT 1

Trials + output

trial 1·10046ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·11272ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 10024ms · median 10047ms · max 10071ms · rows 2,2

all drafts (paginated)

Command

SELECT id, message_id, thread_id FROM gmail.drafts ORDER BY id LIMIT 25

Trials + output

trial 1·10024ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·10071ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

filter-thread2 trials

min 10210ms · median 10217ms · max 10224ms · rows 1,1

drafts in one thread

Command

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

Trials + output

trial 1·10210ms·rows 1isError=false

First row (click to expand JSON)

{
  "++": "++"
}

columns (1)

trial 2·10224ms·rows 1isError=false

First row (click to expand JSON)

{
  "++": "++"
}

columns (1)

json-extract2 trials

min 10032ms · median 10068ms · max 10104ms · rows 2,2

typed JSON alongside row

Command

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

Trials + output

trial 1·10104ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·10032ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 10017ms · median 10096ms · max 10176ms · rows 4,4

draft count

Command

SELECT COUNT(*) AS n FROM gmail.drafts

Trials + output

trial 1·10176ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+----+

trial 2·10017ms·rows 4isError=false

First row (click to expand JSON)

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

columns (1)

+----+

edge2 trials

min 10087ms · median 10106ms · max 10126ms · rows 2,2

edge: larger limit

Command

SELECT id, message_id FROM gmail.drafts LIMIT 200

Trials + output

trial 1·10126ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·10087ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

24 rows stored · 52 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	10046ms	2	ok	+---------------------+------------------+------------------+
minimal	t2	11272ms	2	ok	+---------------------+------------------+------------------+
list	t1	10024ms	2	ok	+-----------------------+------------------+------------------+
list	t2	10071ms	2	ok	+-----------------------+------------------+------------------+
filter-thread	t1	10210ms	1	ok	++
filter-thread	t2	10224ms	1	ok	++
json-extract	t1	10104ms	2	ok	+-----------------------+------------------+-----------------------+
json-extract	t2	10032ms	2	ok	+-----------------------+------------------+-----------------------+
aggregate	t1	10176ms	4	ok	+----+
aggregate	t2	10017ms	4	ok	+----+
edge	t1	10126ms	2	ok	+------------------------+------------------+
edge	t2	10087ms	2	ok	+------------------------+------------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

This table lists draft IDs and their message IDs. For Gmail search

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:33:19Z

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

first_run_at: 2026-09-01T13:33:19Z

last_retried_at: 2026-09-01T13:33:19Z

retry_count: 1

View version history →