Settings
Database Statistics
Total Rows
9443
Rows / Day (avg)
674.4
Date Span (days)
14.00
DB File Size
500.0 KB
Last 24h
700
Last 7d
4732
Last 30d
9443
Distinct Sensors
6
Distinct Plants
2
Rows w/ Plant ID
2698
Rows w/o Plant ID
6745
Oldest: 2026-09-16 03:02:00 | Newest: 2026-09-30 03:05:50
Per-Sensor Aggregates
| Sensor | Count | Min | Max | Avg | First | Last |
|---|---|---|---|---|---|---|
| bh1750_lux | 1349 | 0.00 | 19970.50 | 12120.78 | 2026-09-16 03:02:00 | 2026-09-30 03:05:50 |
| bme280_altitude_m | 1349 | 61.70 | 90.70 | 75.66 | 2026-09-16 03:02:00 | 2026-09-30 03:05:50 |
| bme280_humidity_pct | 1349 | 48.22 | 67.15 | 58.02 | 2026-09-16 03:02:00 | 2026-09-30 03:05:50 |
| bme280_pressure_hpa | 1349 | 1002.40 | 1005.86 | 1004.20 | 2026-09-16 03:02:00 | 2026-09-30 03:05:50 |
| bme280_temp_f | 1349 | 72.12 | 81.25 | 75.87 | 2026-09-16 03:02:00 | 2026-09-30 03:05:50 |
| moisture | 2698 | 32.20 | 69.90 | 47.78 | 2026-09-16 03:02:00 | 2026-09-30 03:05:50 |
Timestamps are UTC. Stats computed live.
Outlier Inspector
Shows single-point anomalies per sensor using robust MAD-based scoring with Z-score fallback. Adjust sensitivity and window, then delete selected rows.
No outliers found with current settings.
Tip: Start with a high MAD threshold (6–7). Lower only if needed. This tool looks at single points, not trends.
System
Database Management
Latest 5 Readings
| Timestamp (UTC) | Sensor | Plant ID | Reading |
|---|---|---|---|
| 2026-09-30 03:05:50 | bme280_temp_f | N/A | 75.46 |
| 2026-09-30 03:05:50 | bme280_humidity_pct | N/A | 59.87 |
| 2026-09-30 03:05:50 | bme280_pressure_hpa | N/A | 1002.4 |
| 2026-09-30 03:05:50 | bme280_altitude_m | N/A | 90.7 |
| 2026-09-30 03:05:50 | bh1750_lux | N/A | 16191.7 |
Manual Timelapse Build
Existing Timelapses
| Filename | Size | Modified (UTC) | Actions |
|---|---|---|---|
| No timelapses yet. | |||
MP4 + WebM pairs are shown; deleting one removes both formats.
Prune Old Captures
Deletes entire dated folders older than threshold.