PostgreSQL Database Upgrade
Hello PostgreSQL Team,
We have recently upgraded the postgreSQL version from V9 to V10.
- Is the below command right to update the database statistics after the
database upgrade ?.
- How do I verify in PG_STATS if the Analyze ran successfully? Does it
show any time when the last Analyze successfully completed.?
Command used:
*ANALYZE VERBOSE;*
Appreciate your help, thank you !!
On 12/7/20 8:35 AM, github kran wrote:
Hello PostgreSQL Team,
We have recently upgraded the postgreSQL version from V9 to V10.
* Is the below command right to update the database statistics after
the database upgrade ?.
* How do I verify in PG_STATS if the Analyze ran successfully? Does it
show any time when the last Analyze successfully completed.?
See:
https://www.postgresql.org/docs/10/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW
last_analyze timestamp with time zone Last time at which this table
was manually analyzed
Command used:
*ANALYZE VERBOSE;*
*
*
*
*
Appreciate your help, thank you !!*
*
--
Adrian Klaver
adrian.klaver@aklaver.com