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(dot)klaver(at)aklaver(dot)com