The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-analyze.html Description:
In the ANALYZE docs it states, - "ANALYZE collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog" - "ANALYZE requires only a read lock on the target table". When trying to determien if this command could be run with `default_transaction_read_only` set to `on,` I was left stumped on whether this is a read only or read-write operation. It is unclear to me, what "stores" in the context of the "pg_statistic system catalog" means, and whether that requires a write operation. I'm potentially missing understanding on the workings of the `pg_statistic` system catalog, but figured this could be a small improvement made to clarify the docs about this operation.
