`google_calendar.calendar_colors`

pass

Calendar color palette entries

Join this table to `google_calendar.calendars.color_id` to resolve

no filters captured 2026-09-01 13:03:26Zmedian 6961 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	6948 ms	6961 ms	6974 ms	[2, 2]
list	2	6897 ms	6920 ms	6943 ms	[2, 2]
json-extract	2	6894 ms	6909 ms	6924 ms	[2, 2]
aggregate	2	6870 ms	6881 ms	6893 ms	[2, 2]
edge	2	6915 ms	6974 ms	7034 ms	[2, 2]

Latency per trial

minimalmedian 6961ms

scale: 0–6974 ms

listmedian 6920ms

scale: 0–6943 ms

json-extractmedian 6909ms

scale: 0–6924 ms

aggregatemedian 6881ms

scale: 0–6893 ms

edgemedian 6974ms

scale: 0–7034 ms

Probe variants — every command + output

minimal2 trials

min 6948ms · median 6961ms · max 6974ms · rows 2,2

smallest query

Command

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

Trials + output

trial 1·6948ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6974ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 6897ms · median 6920ms · max 6943ms · rows 2,2

all calendar colors

Command

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

Trials + output

trial 1·6897ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6943ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 6894ms · median 6909ms · max 6924ms · rows 2,2

typed JSON alongside color

Command

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

Trials + output

trial 1·6924ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6894ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

aggregate2 trials

min 6870ms · median 6881ms · max 6893ms · rows 2,2

color totals

Command

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

Trials + output

trial 1·6870ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6893ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

edge2 trials

min 6915ms · median 6974ms · max 7034ms · rows 2,2

edge: larger limit

Command

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

Trials + output

trial 1·7034ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·6915ms·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	6948ms	2	ok	+----+------------+------------+
minimal	t2	6974ms	2	ok	+----+------------+------------+
list	t1	6897ms	2	ok	+----+------------+------------+
list	t2	6943ms	2	ok	+----+------------+------------+
json-extract	t1	6924ms	2	ok	+----+------------+---------+---------+
json-extract	t2	6894ms	2	ok	+----+------------+---------+---------+
aggregate	t1	6870ms	2	ok	+----+-----------+
aggregate	t2	6893ms	2	ok	+----+-----------+
edge	t1	7034ms	2	ok	+----+------------+------------+
edge	t2	6915ms	2	ok	+----+------------+------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Join this table to `google_calendar.calendars.color_id` to resolve

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T13:03:26Z

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

first_run_at: 2026-09-01T13:03:26Z

last_retried_at: 2026-09-01T13:03:26Z

retry_count: 1

View version history →