`google_calendar.event_colors`

pass

Event color palette entries

Join this table to `google_calendar.events.color_id` to resolve event

no filters captured 2026-09-01 13:05:45Zmedian 6908 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	6903 ms	6908 ms	6913 ms	[2, 2]
list	2	6895 ms	6902 ms	6909 ms	[2, 2]
json-extract	2	6908 ms	6948 ms	6988 ms	[2, 2]
aggregate	2	6990 ms	7023 ms	7056 ms	[2, 2]
edge	2	6913 ms	6913 ms	6914 ms	[2, 2]

Latency per trial

minimalmedian 6908ms

scale: 0–6913 ms

listmedian 6902ms

scale: 0–6909 ms

json-extractmedian 6948ms

scale: 0–6988 ms

aggregatemedian 7023ms

scale: 0–7056 ms

edgemedian 6913ms

scale: 0–6914 ms

Probe variants — every command + output

minimal2 trials

min 6903ms · median 6908ms · max 6913ms · rows 2,2

smallest query

Command

SELECT id, background, foreground FROM google_calendar.event_colors LIMIT 1

Trials + output

trial 1·6913ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6903ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 6895ms · median 6902ms · max 6909ms · rows 2,2

all event colors

Command

SELECT id, background, foreground FROM google_calendar.event_colors ORDER BY id LIMIT 25

Trials + output

trial 1·6909ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6895ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 6908ms · median 6948ms · max 6988ms · rows 2,2

typed JSON alongside color

Command

SELECT id, background, json_as_text(raw, 'background') AS raw_bg FROM google_calendar.event_colors LIMIT 5

Trials + output

trial 1·6908ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6988ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 6990ms · median 7023ms · max 7056ms · rows 2,2

color totals

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT background) AS unique_bg FROM google_calendar.event_colors

Trials + output

trial 1·7056ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6990ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

edge2 trials

min 6913ms · median 6913ms · max 6914ms · rows 2,2

edge: larger limit

Command

SELECT id, background, foreground FROM google_calendar.event_colors LIMIT 200

Trials + output

trial 1·6913ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6914ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

20 rows stored · 40 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	+----+------------+------------+	—	—
0	17	+----+------------+------------+	—	—
1	18	+----+------------+------------+	—	—
2	19	+----+------------+------------+	—	—

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

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6913ms	2	ok	+----+------------+------------+
minimal	t2	6903ms	2	ok	+----+------------+------------+
list	t1	6909ms	2	ok	+----+------------+------------+
list	t2	6895ms	2	ok	+----+------------+------------+
json-extract	t1	6908ms	2	ok	+----+------------+---------+
json-extract	t2	6988ms	2	ok	+----+------------+---------+
aggregate	t1	7056ms	2	ok	+----+-----------+
aggregate	t2	6990ms	2	ok	+----+-----------+
edge	t1	6913ms	2	ok	+----+------------+------------+
edge	t2	6914ms	2	ok	+----+------------+------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Join this table to `google_calendar.events.color_id` to resolve event

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:05:45Z

JSON record: reports/google_calendar/tables/event_colors.json

first_run_at: 2026-09-01T13:05:45Z

last_retried_at: 2026-09-01T13:05:45Z

retry_count: 1

View version history →