Re: PostgreSQL statistics

2023-11-17 Thread Adrian Klaver
On 11/17/23 02:25, Paulo Silva wrote: Hi, I have a table in a PostgreSQL 11 server that isn't being used a lot. If I run a manual ANALYSE on it the last_analyse statistic isn't being update (I've waited enough time for it to be updated): # SELECT * FROM pg_catalog.pg_stat_user_tables WHERE s

PostgreSQL statistics

2023-11-17 Thread Paulo Silva
Hi, I have a table in a PostgreSQL 11 server that isn't being used a lot. If I run a manual ANALYSE on it the last_analyse statistic isn't being update (I've waited enough time for it to be updated): # SELECT * FROM pg_catalog.pg_stat_user_tables WHERE schemaname='s1' and relname='t1'; relid