Hmm, I was thinking of MySQL for some of those things, my Bad. MySQL seems to have a lot more metrics to choose from like Queries per minute(should be queries but is mislabeled questions) and slow queries per minute.
For Postgres specifically, I would watch commits per minute since auto commits are turned on in the default DB and inserts/updates should count as commits. So you can watch that to get a idea of the amount of DB writes there are for HQ and watch the disk metrics as well.
Your not seeing any metrics for that resource? Have you tried going to the metric data tab for postgres to see if the collection intervals are set and that it is collecting metrics for the DB? After that go back to the resources tab and select all metrics to add the commits per minute into the indicator chart.