On Tue, Jan 22, 2019 at 2:55 PM legrand legrand <legrand_legr...@hotmail.com> wrote:
> Hello, > could you check that statistics for fm_session are accurate ? > > Regards > PAscal > heroku pg:psql -c "SELECT schemaname, relname, last_analyze FROM pg_stat_all_tables WHERE relname LIKE 'fm_%'" schemaname | relname | last_analyze ------------+----------------+-------------- public | fm_account | public | fm_allocation | public | fm_approval | public | fm_capital | public | fm_grant | public | fm_market | public | fm_marketplace | public | fm_order | public | fm_person | public | fm_session | public | fm_trader | I suspect you'd say "not accurate"? :-o After ANALYZE, the performance is much better <https://explain.depesz.com/s/p9KX>. Thank you so much!
