`twilio.messages`

pass

SMS and MMS messages sent and received through Twilio. Includes body, sender, recipient, delivery status, price, and timestamps.

No required filters. Start with:

no filters captured 2026-09-02 04:23:05Zmedian 11633 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	10696 ms	11633 ms	12570 ms	[2, 2]
list	2	11744 ms	12180 ms	12617 ms	[2, 2]
filter-direction	2	11424 ms	11874 ms	12324 ms	[2, 2]
filter-status	2	12851 ms	12981 ms	13111 ms	[2, 2]
group-by	2	14558 ms	15508 ms	16459 ms	[2, 2]
json-extract	2	10231 ms	10811 ms	11391 ms	[1, 1]
aggregate	2	9975 ms	10368 ms	10761 ms	[2, 2]
edge	2	9690 ms	11231 ms	12772 ms	[2, 2]

Latency per trial

minimalmedian 11633ms

scale: 0–12570 ms

listmedian 12180ms

scale: 0–12617 ms

filter-directionmedian 11874ms

scale: 0–12324 ms

filter-statusmedian 12981ms

scale: 0–13111 ms

group-bymedian 15508ms

scale: 0–16459 ms

json-extractmedian 10811ms

scale: 0–11391 ms

aggregatemedian 10368ms

scale: 0–10761 ms

edgemedian 11231ms

scale: 0–12772 ms

Probe variants — every command + output

minimal2 trials

min 10696ms · median 11633ms · max 12570ms · rows 2,2

smallest query

Command

SELECT sid, direction, "from", "to", body, status FROM twilio.messages LIMIT 1

Trials + output

trial 1·12570ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·10696ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

list2 trials

min 11744ms · median 12180ms · max 12617ms · rows 2,2

all messages

Command

SELECT sid, direction, "from", "to", body, status, price, num_segments, date_sent FROM twilio.messages LIMIT 25

Trials + output

trial 1·11744ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·12617ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

filter-direction2 trials

min 11424ms · median 11874ms · max 12324ms · rows 2,2

outbound messages

Command

SELECT sid, "from", "to", body, status FROM twilio.messages WHERE direction = 'outbound-api' LIMIT 25

Trials + output

trial 1·12324ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·11424ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

filter-status2 trials

min 12851ms · median 12981ms · max 13111ms · rows 2,2

delivered messages

Command

SELECT sid, "from", "to", body FROM twilio.messages WHERE status = 'delivered' LIMIT 25

Trials + output

trial 1·13111ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·12851ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

group-by2 trials

min 14558ms · median 15508ms · max 16459ms · rows 2,2

messages by direction + status

Command

SELECT direction, status, COUNT(*) AS n FROM twilio.messages GROUP BY direction, status ORDER BY n DESC

Trials + output

trial 1·14558ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·16459ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

json-extract2 trials

min 10231ms · median 10811ms · max 11391ms · rows 1,1

typed JSON on error_message

Command

SELECT sid, direction, body, json_as_text(error_message, 'message') AS err_message FROM twilio.messages WHERE error_message != '' LIMIT 5

Trials + output

trial 1·10231ms·rows 1isError=false

First row (click to expand JSON)

{
  "++": "++"
}

columns (1)

trial 2·11391ms·rows 1isError=false

First row (click to expand JSON)

{
  "++": "++"
}

columns (1)

aggregate2 trials

min 9975ms · median 10368ms · max 10761ms · rows 2,2

messages by direction + status

Command

SELECT direction, status, COUNT(*) AS n FROM twilio.messages GROUP BY direction, status ORDER BY n DESC

Trials + output

trial 1·10761ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·9975ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

edge2 trials

min 9690ms · median 11231ms · max 12772ms · rows 2,2

edge: capped LIMIT

Command

SELECT sid, direction, "from", "to" FROM twilio.messages LIMIT 200

Trials + output

trial 1·9690ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

trial 2·12772ms·rows 2isError=false

First row (click to expand JSON)

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

columns (1)

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

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

32 rows stored · 60 returned · page 1/2


-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	—	—	—	—	+--------------+-----------+----+	—	—
-1	20	—	—	—	—	—	++	—
0	21	—	—	—	—	—	++	—
1	22	—	—	—	—	—	++	—
2	23	—	—	—	—	—	++	—
-1	24	—	—	—	—	+--------------+-----------+----+	—	—

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	28	`"+------------------------------------+--------------+-------"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	12570ms	2	ok	+------------------------------------+--------------+--------------+---------------+-----------------------------------------------------------+-----------+
minimal	t2	10696ms	2	ok	+------------------------------------+--------------+--------------+---------------+-----------------------------------------------------------+-----------+
list	t1	11744ms	2	ok	+------------------------------------+--------------+---------------+---------------+--------------------------------------------------------------------------------------------------------------------------------+-----------+----------+--------------+---------------------------------+
list	t2	12617ms	2	ok	+------------------------------------+--------------+---------------+---------------+--------------------------------------------------------------------------------------------------------------------------------+-----------+----------+--------------+---------------------------------+
filter-direction	t1	12324ms	2	ok	+------------------------------------+---------------+---------------+--------------------------------------------------------------------------------------------------------------------------------+-----------+
filter-direction	t2	11424ms	2	ok	+------------------------------------+---------------+---------------+--------------------------------------------------------------------------------------------------------------------------------+-----------+
filter-status	t1	13111ms	2	ok	+------------------------------------+--------------+---------------+--------------------------------------------------------------------------------------------------------------------------------+
filter-status	t2	12851ms	2	ok	+------------------------------------+--------------+---------------+--------------------------------------------------------------------------------------------------------------------------------+
group-by	t1	14558ms	2	ok	+--------------+-----------+----+
group-by	t2	16459ms	2	ok	+--------------+-----------+----+
json-extract	t1	10231ms	1	ok	++
json-extract	t2	11391ms	1	ok	++
aggregate	t1	10761ms	2	ok	+--------------+-----------+----+
aggregate	t2	9975ms	2	ok	+--------------+-----------+----+
edge	t1	9690ms	2	ok	+------------------------------------+--------------+---------------+---------------+
edge	t2	12772ms	2	ok	+------------------------------------+--------------+---------------+---------------+

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

No required filters. Start with:

Columns coral returned (1)

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

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-02T04:23:05Z

JSON record: reports/twilio/tables/messages.json

first_run_at: 2026-09-02T04:23:05Z

last_retried_at: 2026-09-02T04:23:05Z

retry_count: 1

View version history →