Statistical databases list

Database name Number of backends XACT commit XACT rollback Blocks read Blocks hit Tuple returned Tuple fetched Tuple inserted Tuple updated Tuple deleted
benchs 0 6916 3 1131 449420 2511148 103903 0 0 0
logs 0 0 0 0 0 0 0 0 0 0
middleoffice 0 5370 0 566 571266 3518929 78305 0 0 0
moduleo 0 5625 2 601 359492 2029040 82462 8 3 0
pagila 1 14602 69 5492 794342 5950252 205613 0 410 400
postgres 0 8662 0 1475 649495 2727876 237432 0 0 0
template0 0 0 0 0 0 0 0 0 0 0
template1 0 23772 0 453 169592 955380 39487 0 0 0
tests 0 6777 5 23585 4544856 2482416 98546 4100035 3 0

SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit, tup_returned, tup_fetched, tup_inserted, tup_updated, tup_deleted FROM pg_stat_database ORDER BY datname