Escape hatch

SQL console

For questions the rest of the console can't answer. Reads are safe — Postgres itself refuses to write unless you explicitly ask it to.

Start from

SELECT relname AS table, n_live_tup AS rows,
       pg_size_pretty(pg_total_relation_size(relid)) AS size
  FROM pg_stat_user_tables
 ORDER BY pg_total_relation_size(relid) DESC
 LIMIT 25

Read-only. Switch to Editing on at the top right to run a write.

“Run it” opens a read-only transaction, so a statement that tries to write is refused by Postgres itself rather than by a check on this page. Every statement, reads included, is recorded in the change history.