—
—
Page of 1
Sensor trends
SQL console
Recent queries
Schema
Health & tools
Data health
Gaps in the last 24 hours
Pauses of more than 2 minutes between saved readings, longest first.
Back up
Download a complete copy of the database as a .db file. Safe to run while data is coming in.
Delete old data
Remove rows older than a number of days. Preview first to see how many rows it affects.
older than
days
Remove impossible readings
Readings outside realistic ranges, usually from a loose sensor wire.
Optimize
Shrinks the file after deleting rows (VACUUM). Takes a moment on a big database.