Aurora Postgres resource metrics by database

Which database in Aurora Postgres is doing the most work (physical reads, ins, upds, dels, activity etc) Useful when you want to know since startup time, which database is doing the most work.

The below query is sorted by blks_read (physical reads), you can sort it by any column depending where your bottle neck is.

select datname, xact_commit as commits, xact_rollback as rollbacks, blks_read, blks_hit, tup_inserted as ins, tup_updated as upds, tup_deleted as dels, blk_read_time as blk_r_time, blk_write_time as blk_w_time, active_time, storage_blks_read, local_blks_read, storage_blk_read_time from aurora_stat_database() order by blks_read desc;

****************************************** 

keywords: aurora postgres 

****************************************** 

rdbms version: Aurora Postgres 15.5 

******************************************