Monday, May 25, 2015

[PostgreSQL] List running queries

In psql, run this command
select * from pg_stat_activity where datname = YOUR_DB_NAME and state = 'active'
 You might also what to order the result by query_start or state_change

No comments:

[PostgreSQL] How to create read-only standby replica (follower)

This link  and this link explain it really well and concise