| Database Name | Blocks read | Blocks hit | Cache hit ratio % |
| benchs | 1131 | 449420 | 99.7487526412046 |
| logs | 0 | 0 | 0 |
| middleoffice | 566 | 571266 | 99.9008451768261 |
| moduleo | 601 | 359492 | 99.8328214299599 |
| pagila | 5492 | 794342 | 99.3132333543793 |
| postgres | 1475 | 649495 | 99.7732617889276 |
| template0 | 0 | 0 | 0 |
| template1 | 453 | 169592 | 99.7330134198981 |
| tests | 23585 | 4544856 | 99.4837189571412 |
SELECT datname, blks_read, blks_hit, blks_hit::float/(blks_read+blks_hit+1)*100 as cachehitratio FROM pg_stat_database ORDER BY datname, cachehitratio