PostgreSQL: pg_stat_reset() is not resetting all statistics counters.

Dmitry Romanoff - Nov 12 '23 - - Dev Community

The pg_stat_reset only resets the stats for the current database, not the whole cluster.

To reset the statistics connect to the concrete database, then reset the statistics:

select pg_stat_reset();

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Terabox Video Player