Re: Query slow for new participants

Hello All, Thank you very much for your help. You have really helped me out! The query is now as fast as the others. The indexes ix_companyarticledb_article and ix_companyarticledb_company are removed. The parameter for default_statistics_target was set to 1000 ANALYZE was performed on the

Re: What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum

On Wed, Feb 27, 2019 at 09:47:13AM -0500, Fd Habash wrote: > I have been able to locate four google search results with the same inquiry. > What’ve been able to understand is … > > 1. If auto-vaccum is working as expected, stats collector does not nullify > these values as part of a startup sequ

What is pg_stat_user_tables Showing NULL for last_autoanalyze & last_autovacuum

I have been able to locate four google search results with the same inquiry. What’ve been able to understand is … 1. If auto-vaccum is working as expected, stats collector does not nullify these values as part of a startup sequence or regular Maitenance. If a relation gets auto[vacuumed|analyze