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