|
60151
|
2026-04-17T14:23:24.147061+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30441892
|
click
|
926
|
458
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60189
|
2026-04-17T14:25:14.858104+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30552599
|
click
|
840
|
738
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60193
|
2026-04-17T14:25:18.219830+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30555961
|
click
|
794
|
598
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60198
|
2026-04-17T14:26:31.483372+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30629222
|
click
|
854
|
548
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60200
|
2026-04-17T14:26:34.681038+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30632420
|
click
|
7
|
700
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60216
|
2026-04-17T14:27:43.774844+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30701512
|
click
|
869
|
640
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60238
|
2026-04-17T14:32:03.161642+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30960865
|
click
|
1084
|
439
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60240
|
2026-04-17T14:32:10.642722+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30968345
|
click
|
653
|
579
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60243
|
2026-04-17T14:32:17.018276+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30974721
|
click
|
465
|
358
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60247
|
2026-04-17T14:32:25.784345+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
30983487
|
click
|
694
|
747
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60259
|
2026-04-17T14:33:53.109637+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31070809
|
click
|
721
|
705
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60271
|
2026-04-17T14:34:36.235678+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31113934
|
click
|
855
|
760
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
CREATE INDEX IF NOT EXISTS nas.idx_frames_timesta
CREATE INDEX IF NOT EXISTS nas.idx_frames_timestamp ON frames(timestamp);
CREATE INDEX IF NOT EXISTS nas.idx_frames_app_name ON frames(app_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_window_name ON frames(window_name);
CREATE INDEX IF NOT EXISTS nas.idx_frames_video_chunk_id ON frames(video_chunk_id);
INSERT OR IGNORE INTO nas.frames
SELECT * FROM main.frames WHERE date(timestamp) = '$DATE';
DETACH nas;
EOF
sqlite3 "$DB_SRC" <<<"" 0.44s user 1.41s system 0% cpu 3:28.33 total
lukas@......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60280
|
2026-04-17T14:34:44.115020+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31121813
|
click
|
537
|
519
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60291
|
2026-04-17T14:35:34.856491+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31172553
|
click
|
646
|
366
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60296
|
2026-04-17T14:35:43.608780+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31181305
|
click
|
4
|
84
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60316
|
2026-04-17T14:37:46.184515+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31303877
|
click
|
734
|
616
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60322
|
2026-04-17T14:38:05.089310+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31322781
|
click
|
777
|
580
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60352
|
2026-04-17T14:40:21.083269+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31458771
|
click
|
551
|
449
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60441
|
2026-04-17T14:45:10.530549+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31748190
|
click
|
983
|
649
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60455
|
2026-04-17T14:45:22.025410+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31759684
|
click
|
993
|
717
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60463
|
2026-04-17T14:45:29.427171+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31767085
|
click
|
959
|
651
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60486
|
2026-04-17T14:47:36.943534+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31894597
|
click
|
1119
|
858
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60508
|
2026-04-17T14:49:11.457935+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
31989109
|
click
|
945
|
483
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60571
|
2026-04-17T14:54:10.635436+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32288277
|
click
|
1004
|
415
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60591
|
2026-04-17T14:56:23.240864+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32420879
|
click
|
955
|
815
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60631
|
2026-04-17T14:58:47.940392+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32565574
|
click
|
1013
|
717
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60663
|
2026-04-17T14:59:48.183871+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32625802
|
click
|
861
|
752
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60672
|
2026-04-17T15:03:49.541304+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32867149
|
click
|
980
|
777
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60678
|
2026-04-17T15:05:18.193567+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32955798
|
click
|
1277
|
647
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60691
|
2026-04-17T15:05:58.541988+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32996146
|
click
|
849
|
764
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60696
|
2026-04-17T15:06:02.351586+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
32999955
|
click
|
104
|
864
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60723
|
2026-04-17T15:08:14.267789+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
33131867
|
click
|
636
|
532
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60737
|
2026-04-17T15:09:13.610315+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
33191208
|
click
|
1176
|
455
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60756
|
2026-04-17T15:09:40.540016+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
33218137
|
click
|
973
|
492
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60779
|
2026-04-17T15:17:51.683159+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
33709271
|
click
|
1152
|
633
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60797
|
2026-04-17T15:18:23.337476+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
33740924
|
click
|
1370
|
640
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60884
|
2026-04-17T15:26:18.642568+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
34216216
|
click
|
4
|
350
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60886
|
2026-04-17T15:26:20.835135+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
34218409
|
click
|
8
|
352
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60925
|
2026-04-17T15:32:26.631945+00:00
|
a6aa001c-600c-47ef-97db-b500eecbecbe
|
34584260
|
click
|
642
|
592
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
System Settings
|
NULL
|
Screen & System Audio Recording
|
NULL
|
AXTextArea
|
shell
|
2026-04-17T09:12:29.961434Z INFO screenpipe_engin 2026-04-17T09:12:29.961434Z INFO screenpipe_engine::snapshot_compaction: snapshot compaction: 99 frames, 18.1MB → 8.8MB (2.0x), 99 JPEGs deleted
2026-04-17T09:12:30.602191Z INFO screenpipe_engine::snapshot_compaction: snapshot compaction: 3 frames, 0.7MB → 0.6MB (1.2x), 3 JPEGs deleted
2026-04-17T09:17:30.753532Z INFO screenpipe_engine::snapshot_compaction: snapshot compaction: found 133 eligible frames
2026-04-17T09:17:33.779666Z INFO screenpipe_engine::snapshot_compaction: snapshot ......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60929
|
2026-04-17T15:33:13.214593+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
86
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
6
|
iTerm2
|
3199
|
NULL
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '2026-04-15'))
FROM dbstat d, elements e
WHERE d.name = 'elements'
UNION ALL
SELECT 'ui_events',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM ui_events WHERE date(timestamp) = '2026-04-15')
FROM dbstat d, ui_events e
WHERE d.name = 'ui_events';"
^CError: stepping, interrupted (9)
Program interrupted.
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60969
|
2026-04-17T15:33:45.214811+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
32086
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
6
|
iTerm2
|
3199
|
NULL
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '2026-04-15'))
FROM dbstat d, elements e
WHERE d.name = 'elements'
UNION ALL
SELECT 'ui_events',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM ui_events WHERE date(timestamp) = '2026-04-15')
FROM dbstat d, ui_events e
WHERE d.name = 'ui_events';"
^CError: stepping, interrupted (9)
Program interrupted.
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
60982
|
2026-04-17T15:33:57.817176+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
44688
|
click
|
822
|
501
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Finder
|
NULL
|
screenpipe
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61002
|
2026-04-17T15:36:18.398592+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
185269
|
click
|
757
|
589
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Claude
|
NULL
|
Claude
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61016
|
2026-04-17T15:36:38.094704+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
204965
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
6
|
iTerm2
|
3199
|
NULL
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM elements WHERE frame_id IN (SELECT id FROM frames WHERE date(timestamp) = '2026-04-15'))
FROM dbstat d, elements e
WHERE d.name = 'elements'
UNION ALL
SELECT 'ui_events',
COUNT(*),
SUM(payload),
SUM(payload)/COUNT(*),
(SELECT COUNT(*) FROM ui_events WHERE date(timestamp) = '2026-04-15')
FROM dbstat d, ui_events e
WHERE d.name = 'ui_events';"
^CError: stepping, interrupted (9)
Program interrupted.
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61018
|
2026-04-17T15:36:38.726312+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
205597
|
click
|
879
|
609
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
iTerm2
|
NULL
|
-zsh
|
NULL
|
AXTextArea
|
shell
|
elements|465966705
ui_events|9804622
ocr_text|1443 elements|465966705
ui_events|9804622
ocr_text|1443084543
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
'frames' as tbl,
COUNT(*) as total_rows,
SUM(payload) as total_bytes,
SUM(payload)/COUNT(*) as bytes_per_row,
-- estimate yesterday's rows
(SELECT COUNT(*) FROM frames WHERE date(timestamp) = '2026-04-15') as day_rows
FROM dbstat d, frames f
WHERE d.name = 'frames'
UNION ALL
SELECT 'elements',
COUNT(*),
SUM(payload),
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61022
|
2026-04-17T15:36:40.263037+00:00
|
c00555c6-4e2d-463e-ab89-442aa6ad161b
|
207134
|
click
|
908
|
436
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
iTerm2
|
NULL
|
-zsh
|
NULL
|
AXTextArea
|
shell
|
2026-04-17T10:33:21.740808Z INFO screenpipe_engin 2026-04-17T10:33:21.740808Z INFO screenpipe_engine::event_driven_capture: content dedup: skipping capture for monitor 1 (hash=4808873546457089246, trigger=visual_change)
2026-04-17T10:33:24.077293Z INFO screenpipe_engine::event_driven_capture: content dedup: skipping capture for monitor 2 (hash=4808873546457089246, trigger=click)
2026-04-17T10:33:32.696490Z INFO screenpipe_engine::event_driven_capture: content dedup: skipping capture for monitor 1 (hash=5806715368348452318, trigger=click)
......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61025
|
2026-04-17T18:04:31.727025+00:00
|
13156b68-4e30-4eee-8f49-e1d631b92a35
|
90
|
app_switch
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
iTerm2
|
6
|
iTerm2
|
3199
|
NULL
|
NULL
|
AXTextArea
|
shell
|
2026-04-17T11:30:59.028334Z INFO screenpipe_engin 2026-04-17T11:30:59.028334Z INFO screenpipe_engine::event_driven_capture: content dedup: skipping capture for monitor 1 (hash=7979294446021828187, trigger=visual_change)
2026-04-17T11:31:03.942253Z INFO screenpipe_engine::event_driven_capture: content dedup: skipping capture for monitor 2 (hash=7979294446021828187, trigger=click)
2026-04-17T11:33:59.842094Z WARN sqlx::query: summary="SELECT id, snapshot_path, device_name, …" db.statement="\n\nSELECT\n id,\n snapshot_path,\n device_name,\n timestamp\nFROM\n frames\nWHERE\n snapshot_path IS NOT NULL\n AND timestamp < ?1\nORDER BY\n device_name,\n timestamp ASC\nLIMIT\n 5000\n" rows_affected=0 rows_returned=193 elapsed=5.192745333s
2026-04-17T11:33:59.842255Z INFO screenpipe_engine::snapshot_compaction: snapshot compaction: found 193 eligible frames
2026-04-17T11:34:18.778071Z INFO screenpipe_engine::snapshot_compaction: snapshot compaction: 99 frames, 19.3MB → 8.7MB (2.2x), 99 JPEGs deleted
2026-04-17T11:34:21.25062......
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61044
|
2026-04-17T18:05:40.455102+00:00
|
13156b68-4e30-4eee-8f49-e1d631b92a35
|
68818
|
click
|
966
|
698
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Claude
|
NULL
|
Claude
|
NULL
|
AXTextArea
|
shell
|
alias cnt="docker exec -ti \$(docker ps | grep alias cnt="docker exec -ti \$(docker ps | grep worker | awk '{print \$1}') /bin/bash -c \"cd /home/jiminny && bash\""
alias prodes="ssh ubuntu@jiminny-prod-ecs1 -L 7970:vpc-activities7-3o2zlrelmga5qicf2yxxwtx6bi.us-east-2.es.amazonaws.com:80"
alias stges="ssh ubuntu@jiminny-stage-ecs1 -L 7980:vpc-activities7-tgeodjeaugnaiigqgdcjjkrrj4.us-east-2.es.amazonaws.com:80"
alias qaes="ssh ubuntu@jiminny-qa-ecs1 -L 7950:vpc-activities7-s5zchrs4xqcnav3rjzmxgxvfvq.us-east-2.es.amazonaws.com:80"
alias e......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61052
|
2026-04-17T18:05:52.687563+00:00
|
13156b68-4e30-4eee-8f49-e1d631b92a35
|
81050
|
click
|
984
|
447
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
Claude
|
NULL
|
Claude
|
NULL
|
AXTextArea
|
shell
|
alias cnt="docker exec -ti \$(docker ps | grep alias cnt="docker exec -ti \$(docker ps | grep worker | awk '{print \$1}') /bin/bash -c \"cd /home/jiminny && bash\""
alias prodes="ssh ubuntu@jiminny-prod-ecs1 -L 7970:vpc-activities7-3o2zlrelmga5qicf2yxxwtx6bi.us-east-2.es.amazonaws.com:80"
alias stges="ssh ubuntu@jiminny-stage-ecs1 -L 7980:vpc-activities7-tgeodjeaugnaiigqgdcjjkrrj4.us-east-2.es.amazonaws.com:80"
alias qaes="ssh ubuntu@jiminny-qa-ecs1 -L 7950:vpc-activities7-s5zchrs4xqcnav3rjzmxgxvfvq.us-east-2.es.amazonaws.com:80"
alias e......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
|
61054
|
2026-04-17T18:06:08.297674+00:00
|
13156b68-4e30-4eee-8f49-e1d631b92a35
|
96660
|
click
|
148
|
874
|
NULL
|
NULL
|
0
|
0
|
NULL
|
0
|
NULL
|
NULL
|
iTerm2
|
NULL
|
-zsh
|
NULL
|
AXTextArea
|
shell
|
alias cnt="docker exec -ti \$(docker ps | grep alias cnt="docker exec -ti \$(docker ps | grep worker | awk '{print \$1}') /bin/bash -c \"cd /home/jiminny && bash\""
alias prodes="ssh ubuntu@jiminny-prod-ecs1 -L 7970:vpc-activities7-3o2zlrelmga5qicf2yxxwtx6bi.us-east-2.es.amazonaws.com:80"
alias stges="ssh ubuntu@jiminny-stage-ecs1 -L 7980:vpc-activities7-tgeodjeaugnaiigqgdcjjkrrj4.us-east-2.es.amazonaws.com:80"
alias qaes="ssh ubuntu@jiminny-qa-ecs1 -L 7950:vpc-activities7-s5zchrs4xqcnav3rjzmxgxvfvq.us-east-2.es.amazonaws.com:80"
alias e......
|
shell
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|
NULL
|