postgresql_cheat_sheet.md

See current version

SELECT version();

Check if DB recovery is paused

SELECT pg_is_xlog_replay_paused();

Check delay of DB recovery since last (possibly slow) transaction

SELECT NOW() - pg_last_xact_replay_timestamp();

Copy CSV contents to table (assuming CSV rows are w/o header and follows table columns serially)

COPY [table_name] FROM '[file_path]' DELIMITER ',' CSV;