Thursday, July 31, 2025

How to check if a PostgreSQL streaming replicate server is up-to-date with the primary

›
On the primary, run SELECT pg_current_wal_lsn(); -- On the primary In my case, the result was pg_current_wal_lsn -------------------- ...

Basic postgres connect syntax

›
psql -h hostname -U username -d database Options: Option Description -h <host> Hostname or IP address of the PostgreSQL server -p...
Wednesday, July 30, 2025

How to find the columns in a specific postgres data dictionary table

›
For example, to check which columns belongs to the view "pg_stat_wal_receiver" SELECT column_name FROM information_schema.colu...
Monday, July 28, 2025

How to list the postgres processes running on your server and what their jobs are

›
A neet little trick I learned from the series " Mirage of memory, part 2: PSS " ps -fu postgres | grep $(pgrep -f postmaster) p...
1 comment:
Monday, July 14, 2025

How to find when a PostgreSQL table was last vacuumed

›
SELECT schemaname, relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze FROM pg_stat_user_tables WHERE relname = 'docu...
Friday, July 11, 2025

PostgreSQL: how to tail the alert log of the day with filtering for long-running statements

›
I have set the parameter log_min_duration_statement to 2 seconds and reloaded the config: postgres=# alter system set log_min_duration_sta...
Wednesday, July 9, 2025

How to list all subdirectories and exclude certain subdirectories in a tree-like fashion

›
In this example I want to see all subdirectories that starts with "dir", but also to exclude the directory "dirdat": cd...