|
.
|
NULL
|
NULL
|
NULL
|
|
I want to
|
NULL
|
NULL
|
NULL
|
|
know the size
|
NULL
|
NULL
|
NULL
|
|
, and
|
NULL
|
NULL
|
NULL
|
|
count
|
NULL
|
NULL
|
NULL
|
|
,
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
Als
|
NULL
|
NULL
|
NULL
|
|
.
|
NULL
|
NULL
|
NULL
|
|
Also
|
NULL
|
NULL
|
NULL
|
|
what is
|
NULL
|
NULL
|
NULL
|
|
stored in data
|
NULL
|
NULL
|
NULL
|
|
/data
|
NULL
|
NULL
|
NULL
|
|
/
|
NULL
|
NULL
|
NULL
|
|
{date
|
NULL
|
NULL
|
NULL
|
|
}
|
NULL
|
NULL
|
NULL
|
|
.
|
NULL
|
NULL
|
NULL
|
|
It seesm that
|
NULL
|
NULL
|
NULL
|
|
n
|
NULL
|
NULL
|
NULL
|
|
Seems there is
|
NULL
|
NULL
|
NULL
|
|
j
|
NULL
|
NULL
|
NULL
|
|
pg
|
NULL
|
NULL
|
NULL
|
|
but
|
NULL
|
NULL
|
NULL
|
|
also
|
NULL
|
NULL
|
NULL
|
|
mp
|
NULL
|
NULL
|
NULL
|
|
4
|
NULL
|
NULL
|
NULL
|
|
.
|
NULL
|
NULL
|
NULL
|
|
Exaplin the process
|
NULL
|
NULL
|
NULL
|
|
.
|
NULL
|
NULL
|
NULL
|
|
Wha
|
NULL
|
NULL
|
NULL
|
|
t
|
NULL
|
NULL
|
NULL
|
|
is each
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
K
|
NULL
|
NULL
|
NULL
|
|
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks','audio_transcriptions',
'memories','meetings','tags','pipe_executions'
)
GROUP BY d.name......
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
SELECT sql FROM sqlite_master
WHERE type='tab SELECT sql FROM sqlite_master
WHERE type='table'
AND name NOT LIKE '%_fts%'
AND name NOT LIKE 'sqlite_%'
AND name NOT LIKE '_sqlx%'
ORDER BY name;...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
SELECT frame_id, app_name, window_name, browser_ur SELECT frame_id, app_name, window_name, browser_url, focused,
substr(text, 1, 100) as text_preview
FROM ocr_text
ORDER BY frame_id DESC
LIMIT 5;...
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks',......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks',......
|
NULL
|
NULL
|
NULL
|
|
lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screen lukas@Lukas-Kovaliks-MacBook-Pro-Jiminny ~/.screenpipe $ sqlite3 ~/.screenpipe/db.sqlite "
SELECT
d.name,
SUM(d.pgsize) / 1024 / 1024 as size_mb,
(SELECT COUNT(*) FROM frames WHERE d.name = 'frames') +
(SELECT COUNT(*) FROM ocr_text WHERE d.name = 'ocr_text') +
(SELECT COUNT(*) FROM elements WHERE d.name = 'elements') +
(SELECT COUNT(*) FROM ui_events WHERE d.name = 'ui_events') +
(SELECT COUNT(*) FROM video_chunks WHERE d.name = 'video_chunks') +
(SELECT COUNT(*) FROM audio_chunks WHERE d.name = 'audio_chunks') +
(SELECT COUNT(*) FROM audio_transcriptions WHERE d.name = 'audio_transcriptions') +
(SELECT COUNT(*) FROM memories WHERE d.name = 'memories') +
(SELECT COUNT(*) FROM meetings WHERE d.name = 'meetings') +
(SELECT COUNT(*) FROM tags WHERE d.name = 'tags') +
(SELECT COUNT(*) FROM pipe_executions WHERE d.name = 'pipe_executions') as row_count
FROM dbstat d
WHERE d.name IN (
'frames','ocr_text','elements','ui_events',
'video_chunks','audio_chunks',......
|
NULL
|
NULL
|
NULL
|
|
clear
|
NULL
|
NULL
|
NULL
|
|
|
NULL
|
NULL
|
NULL
|
|
ls ~/.screenpipe/data/ | head -20
|
NULL
|
NULL
|
NULL
|