Watch for database changes on #PostgreSQL
If you are trying to debug multi-threaded environments or a really fast job queue you might need to "watch" a table for changes.
psql use the
\watch command like so:
\watch 1 "select * from job_queue";
This will run the query every 1 second (you can change the second argument if you need it slower) and display the result as well as past results.Tweet