Обсуждение: 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