kuda.ai

Thoughts on programming and music theory.

dark mode

Limit Postgres Usage

Created on June 23, 2026

postgres

alter role analyst set statement_timeout = '60s';
alter role analyst set idle_in_transaction_timeout = '5min';
alter role analyst set work_mem = 128MB';

Then you can verify with:

select rolname, rolconfig from pg_roles
where rolname in ('analyst');