Once you have inspected active database connections, you can dig deeper and inspect database-level statistics. pg_stat_database will return one line per database inside your PostgreSQL instance.
This is what you can find there:
test=# \d pg_stat_database View "pg_catalog.pg_stat_database"Column | Type | Collation | Nullable | Default ----------------+--------------------------+-----------+----------+--------- datid | oid | | datname | name | | numbackends | integer | | xact_commit | bigint | | xact_rollback | bigint | | blks_read | bigint | | blks_hit | bigint | | tup_returned | bigint | | tup_fetched | bigint | | tup_inserted | bigint | | tup_updated | bigint | | tup_deleted | bigint | | conflicts | bigint ...
