aurora_stat_bgwriter
aurora_stat_bgwriter
is a statistics view showing information about Optimized Reads cache writes.
Syntax
aurora_stat_bgwriter()
Arguments
None
Return type
SETOF record with all pg_stat_bgwriter
columns and the following additional columns. For more information on pg_stat_bgwriter
columns,
see pg_stat_bgwriter
You can reset stats for this function using pg_stat_reset_shared("bgwriter")
.
orcache_blks_written
– Total number of optimized reads cache data blocks written.orcache_blk_write_time
– Iftrack_io_timing
is enabled, it tracks the total time spent writing optimized reads cache data file blocks, in milliseconds. For more information, see track_io_timing.
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
=>
select * from aurora_stat_bgwriter();
-[ RECORD 1 ]-----------------+----------- orcache_blks_written | 246522 orcache_blk_write_time | 339276.404