{{tag>troubleshooting sentry postgres sql db}}

====== Sentry troubleshooting ======
===== Postgres DB getting too big =====
One option is to truncate the nodestore_node table. Enter the DB:

  psql -U postgres

Check the table size
  postgres=# SELECT oid::regclass, reltoastrelid::regclass, pg_relation_size(reltoastrelid) AS toast_size FROM pg_class WHERE relkind = 'r' AND reltoastrelid <> 0 ORDER BY 3 DESC;

Run truncate:

  postgres=# TRUNCATE nodestore_node ;
====== Tested on ======
  * sentry_version: 23.8.0 (docker)
  * PostgreSQL 14.5


====== See also ======
  * [[wiki:sentry_install|Sentry install]]
====== References ======