title: How to determine number of write transactions per second in Postgres
body: <p>Is there a way to measure how many <strong>write</strong> transactions are happening per second in Postgres? As I understand <code>pg_stat_database.xact_commit</code> will show <strong>total</strong> number of transactions committed, but I want to exclude readonly queries and only see the number of commits that actually modified data.</p>