database size

[rosano]

Is it normal for the database to be half a gigabyte?

I have deleted all my executions several times but it doesn't seem to change anything. Also just set export DB_SQLITE_VACUUM_ON_STARTUP=true in /app/data/env.sh, but after restarting it seems to take the same amount of space. When I run SELECT pg_size_pretty(pg_database_size('XXXXX')) it says

pg_size_pretty 
----------------
 594 MB
(1 row)

Is there some data stuck in there that I can see and remove somehow?

[BrutalBirdie]

That DB_SQLITE_VACUUM_ON_STARTUP does nothing, is absolutly corret and is no error.
Because, the Cloudron package does not use SQLITE.
It uses postgresql.

[joseph]

@rosano you should investigate which table is taking so much space . (you can get table size queries from chatgpt)

[rosano]

@joseph it's the execution_data table but I'm not sure how to figure out where the bloat is. the LLM queries are giving me mostly table size but nothing more detailed.

[rosano]

Deleting all executions still didn't move the database down from 500mb, but after running VACUUM FULL execution_data it's now 13mb. I''ll take it.