On Mon, 2020-08-17 at 03:25 -0500, Sujith Kumar.S wrote: > After the postgresql server restart, the details on the pg_stat_all_tables are showing as zero. That would indicate that you didn't shut down PostgreSQL cleanly. https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-STATS-SETUP > When recovery is performed at server start (e.g. after immediate shutdown, server crash, > and point-in-time recovery), all statistics counters are reset. Consult the PostgreSQL log file for confirmation. Yours, Laurenz Albe
