Re: PostgreSQL Database Upgrade

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