aurora_stat_reset_wal_cache - Amazon Aurora
SyntaxArgumentsReturn typeUsage notesExamples

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)