9.6.3 Information Reset

This section describes how to reset information.

Information added by Fujitsu Enterprise Postgres

You can reset information added by Fujitsu Enterprise Postgres by using the pg_stat_reset_shared function in the same way as for information common to PostgreSQL.

Configure the following parameters in the pg_stat_reset_shared function:

Function	Type of return value	Description
pg_stat_reset_shared(text)	void	Reset some cluster-wide statistics counters to zero, depending on the argument (requires superuser privileges). Calling pg_stat_reset_shared('lwlock') will zero all counters shown in pgx_stat_lwlock. Similarly, in the following cases, all values of the pertinent statistics counter are reset: If pg_stat_reset_shared('latch') is called: All values displayed in pgx_stat_latch If pg_stat_reset_shared('walwriter') is called: All values displayed in pgx_stat_walwriter If pg_stat_reset_shared('sql') is called: All values displayed in pgx_stat_sql If pg_stat_reset_shared('gmc') is called: All values except size column in pgx_stat_gmc

Function

Type of return value

Description

pg_stat_reset_shared(text)

void

Reset some cluster-wide statistics counters to zero, depending on the argument (requires superuser privileges).

Calling pg_stat_reset_shared('lwlock') will zero all counters shown in pgx_stat_lwlock.

Similarly, in the following cases, all values of the pertinent statistics counter are reset:

If pg_stat_reset_shared('latch') is called:
All values displayed in pgx_stat_latch
If pg_stat_reset_shared('walwriter') is called:
All values displayed in pgx_stat_walwriter
If pg_stat_reset_shared('sql') is called:
All values displayed in pgx_stat_sql
If pg_stat_reset_shared('gmc') is called:
All values except size column in pgx_stat_gmc

See

Refer to "Statistics Functions" in "Monitoring Database Activity" under "Server Administration" in the PostgreSQL Documentation for information on other parameters of the pg_stat_reset_shared function.