# aurora\$1stat\$1reset\$1wal\$1cache
<a name="aurora_stat_reset_wal_cache"></a>

Resets the counter for logical wal cache. 

## Syntax
<a name="aurora_stat_reset_wal_cache-syntax"></a>

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
<a name="aurora_stat_reset_wal_cache-arguments"></a>

`NULL` or `slot_name`

## Return type
<a name="aurora_stat_reset_wal_cache-return-type"></a>

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
<a name="aurora_stat_reset_wal_cache-usage-notes"></a>

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
<a name="aurora_stat_reset_wal_cache-examples"></a>

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)
```