PostgreSQL

When making a query with lots of columns, it can become so wide that it wraps, making the results incredibly difficult to read. To combat this, you …

Running queries View a list of queries running longer than 5 minutes: SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state FROM …

View a list of running queries: SELECT datname, pid, usename, client_addr, client_port, xact_start, backend_start, query_start, state, query FROM …

How to delete database from the inside, with only access to that database. The primary way this works is by using pg_dump’s ability to drop a …