Useful postgres commands

postgres

Example of getting size of fields:

SELECT id, length(raw), length(cooked) FROM posts ORDER BY length(cooked) DESC limit 100;


Truncate table:

truncate table <table>;


Show size of tables:

\dt+


Terminate all connections to a DB:

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB';