Help Center/ Data Warehouse Service/ Developer Guide/ Developer Guide (9.1.1.x)/ DWS System Catalogs and Views/ System Views/ GS_NODE_STAT_RESET_TIME
Updated on 2026-09-23 GMT+08:00
View PDF
Share

GS_NODE_STAT_RESET_TIME

GS_NODE_STAT_RESET_TIME displays the time when the statistics of the current node are reset.

Table 1 GS_NODE_STAT_RESET_TIME columns

Name

Type

Description

get_node_stat_reset_time

timestamp with time zone

Time when statistics on the current node are reset
When an instance is running, its statistics keep rising. In the following cases, the statistical values in the memory will be reset to 0:
  • The instance is restarted or a cluster switchover occurs.
  • The database is dropped.
  • A reset operation is performed. For example, the statistics counter in the database is reset using the pgstat_recv_resetcounter function or the Unique SQL statements are cleared using the reset_instr_unique_sql function.

If any of the preceding events occurs, DWS will record the time when the statistics are reset. You can query the time using the get_node_stat_reset_time function.

Parent Topic: System Views