Every dashboard number on this site ties back to a row in this table.
Sync_runs is the audit trail your CTO will ask about and your finance team will reference at close.
It records each connector run (ezyVet, Instinct, Cornerstone, AVImark), the hospital it targeted,
the row count it ingested, the duration, the status, and any error. Press "trigger sync →" below
to replay a 12-second simulated ingest end-to-end across all four PMSes — exactly the cadence a
production sync hits in our connector library. The Akron 2026-03-15 row is the integration moment
for the acquired site: an 8-minute full-historical AVImark backfill, no errors, all rows landed.
Live sync demo
12-second simulated cross-PMS pull · normalize · upsert
idle. press "trigger sync →" to start.
Per-connector reliability and latency
SRE-shape table: P50/P95 latency, success rate, total rows ingested across the most recent 50 runs.
| Connector | Runs | Success rate | Failures | P50 duration | P95 duration | Rows ingested |
|---|---|---|---|---|---|---|
avimark | 1 | 100.00% | 0 | 8m 0s | 8m 0s | 1,136 |
cornerstone | 1 | 100.00% | 0 | 12.0s | 12.0s | 23 |
ezyvet | 1 | 100.00% | 0 | 12.0s | 12.0s | 23 |
instinct | 1 | 100.00% | 0 | 12.0s | 12.0s | 23 |
Recent sync_runs (reverse chronological)
| Started | Connector | Hospital | Status | Rows ingested | Duration | Error |
|---|---|---|---|---|---|---|
| 2026-05-19 06:39 | cornerstone | Riverbend Urgent Care Columbus | success | 23 | 12.0s | — |
| 2026-05-19 06:39 | instinct | Riverbend Emergency Cleveland | success | 23 | 12.0s | — |
| 2026-05-19 06:39 | ezyvet | Riverbend Specialty Pittsburgh | success | 23 | 12.0s | — |
| 2026-03-15 09:00 | avimark | Riverbend Specialty Akron integration moment | success | 1,136 | 8m 0s | — |
What this looks like in your stack today.
A production audit-log surface for PMS ingestion is rare in this industry. BluWave and Reflexion run their
own scheduled jobs and don't expose them to the customer. Vetspire emits some job-status events but
doesn't surface a per-run row count. The data engineer who built your in-house Looker pipeline almost
certainly has a Datadog or Cloudwatch dashboard for this — but it's not on a URL your COO can hit.
The drawer in the lower-right has the exact query. The live-sync demo above streams the same shape of
events a production run does.
Architecture pointer. Connector source lives in src/connectors/;
every connector writes a sync_runs row on completion via
src/connectors/index.ts:runAllConnectors. The SSE stream above is served
from /api/sync/live. Press Q for the audit query.