Explore

Pre-canned queries against the live database. The SQL is shown alongside the result. All queries hit the public API at api.quantumlane.io.

SELECT received_at::date AS day,
       'ttc.vehicle_positions' AS feed_key,
       COUNT(*) AS record_count
FROM realtime.vehicle_positions
WHERE received_at >= NOW() - INTERVAL '14 days'
GROUP BY received_at::date
ORDER BY day DESC;

SELECT DISTINCT ON (vehicle_id)
    vehicle_id, route_id, ST_X(location::geometry) AS lon, ST_Y(location::geometry) AS lat
FROM realtime.vehicle_positions
WHERE received_at > NOW() - INTERVAL '5 minutes'
ORDER BY vehicle_id, received_at DESC
LIMIT 20;

SELECT run_id, asset_key, started_at, status, records_written
FROM ops.ingestion_runs
ORDER BY started_at DESC
LIMIT 20;