aurora_stat_optimized_reads_cache - Amazon Aurora
SyntaxArgumentsReturn typeUsage notesExamples
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

aurora_stat_optimized_reads_cache

This function shows tiered cache stats.

Syntax

aurora_stat_optimized_reads_cache()

Arguments

None

Return type

SETOF record with the following columns:

  • total_size – Total optimized reads cache size.

  • used_size – Used page size in optimized reads cache.

Usage notes

This function is available in the following Aurora PostgreSQL versions:

  • 15.4 and higher 15 versions

  • 14.9 and higher 14 versions

Examples

The following example shows the output on a r6gd.8xlarge instance :

=> select pg_size_pretty(total_size) as total_size, pg_size_pretty(used_size) 
                as used_size from aurora_stat_optimized_reads_cache();    
total_size | used_size
-----------+-----------
1054 GB    | 975 GB