Example Queries

See below for a selection of example queries across different entity types.

Note: using the msgpaths syntax requires log files to have been ingested by a corresponding action. You can find ingestion actions for common log formats in the Action Hub (e.g. ROS, PX4 etc.). If you’re using a custom log file format, get in touch and we can help you with ingestion.

Datasets

Find the 5 most recently created datasets

* SORT BY created DESC LIMIT 5

Find datasets from May 2024 collected on vehicle sn_1234

created >= "2024-05-01" AND
created < "2024-05-31" AND
metadata.vehicle_id = "sn_1234"

Find datasets containing a large ROS bag (>20GB) and a video with a filename like takeoff.mp4

(files[0].size > 2000000000 AND files[0].path CONTAINS ".bag") AND
files[1].path CONTAINS "takeoff.mp4"

Find datasets tagged with Night where any file had a topic named cpuload with average load >80%

topics[0].msgpaths[cpuload.load].mean > 0.8 AND
tags CONTAINS "Night"

Files

Find the 10 largest files I have stored in Roboto

* SORT BY size DESC LIMIT 10

Find .ulg files which belong to a dataset tagged with Rainy

dataset.tags CONTAINS "Rainy" AND
path CONTAINS ".ulg"

Find .ulg files where the mean CPU load was low and the max altitude is high

topics[0].msgpaths[vehicle_air_data.baro_alt_meter].max > 1000 AND
topics[1].msgpaths[cpuload.load].mean < 0.4

Topics

Find vehicle angular velocity topics from between 11AM and 12PM PDT on April 28, 2024

name = "vehicle_angular_velocity" AND
created >= "2024-04-28T11:00-07:00" AND
created < "2024-04-28T12:00-07:00"

Find noisy topics (10k+ messages) in small files (<10MB)

file.size < 10000000 AND
message_count > 10000

Find battery status topics where the battery was both connected and disconnected

msgpaths[battery_status.connected].false_count > 0 AND
msgpaths[battery_status.connected].true_count > 0

Find camera topics recorded on software version 3.14

dataset.metadata.softwareVersion = "3.14" AND
name CONTAINS "camera"

Message Paths

Find message paths with data type uint8[] created after September 25, 2024

data_type = "uint8[]" AND created > "2024-09-25"

Find message paths from topics called /camera/front/image in files tagged with crash

topic.name = "/camera/front/image" AND file.tags CONTAINS "crash"

Events

Find events with the word spike that started after September 09, 2024 4:38 PM PDT

name CONTAINS "spike" AND start_time > "2024-09-09T16:38:26.941-07:00"

Find events called Lane Change with a tag London

name = "Lane Change" AND tags CONTAINS "London"