aurora_stat_reset_wal_cache - Amazon Aurora
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_reset_wal_cache

Resets the counter for logical wal cache.

Syntax

To reset a specific slot

SELECT * FROM aurora_stat_reset_wal_cache('slot_name')

To reset all slots

SELECT * FROM aurora_stat_reset_wal_cache(NULL)

Arguments

NULL or slot_name

Return type

Status message, text string

  • Reset the logical wal cache counter – Success message. This text is returned when the function succeeds.

  • Replication slot not found. Please try again. – Failure message. This text is returned when the function doesn't succeed.

Usage notes

This function is available for the following versions.

  • Aurora PostgreSQL 14.5 and higher

  • Aurora PostgreSQL version 13.8 and higher

  • Aurora PostgreSQL version 12.12 and higher

  • Aurora PostgreSQLversion 11.17 and higher

Examples

The following example uses the aurora_stat_reset_wal_cache function to reset a slot named test_results, and then tries to reset a slot that doesn't exist.

=> SELECT * FROM aurora_stat_reset_wal_cache('test_slot'); aurora_stat_reset_wal_cache -------------------------------------- Reset the logical wal cache counter. (1 row) => SELECT * FROM aurora_stat_reset_wal_cache('slot-not-exist'); aurora_stat_reset_wal_cache ----------------------------------------------- Replication slot not found. Please try again. (1 row)