On Tue, Jan 22, 2019 at 2:55 PM legrand legrand <legrand_legrand@xxxxxxxxxxx> 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. Thank you so much!
