Recent Posts

PSQL: Truncate All Rows

less than 1 minute read

Given a postgres database, if you want to delete all rows in a table, you can use the DELETE query without any conditions.

PSQL: Turn Timing On

less than 1 minute read

When digging around your database and running queries, it is helpful to have an eye on the speed of those queries. This can give insight into where there are...

PSQL: Limit Execution Time Of Statements

less than 1 minute read

You can limit the amount of time that postgres will execute a statement by setting a hard timeout. By default the timeout is 0 (see show statement_timeout;) ...