Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT performance drop - Mailing list pgsql-performance

From Jan Nielsen
Subject Re: SELECT performance drop
Date
Msg-id CANxH4hFR6+wjcWTjf_+MtW5iGkNq7yxLXKyyyeUtoiRZ+BuOFA@mail.gmail.com
Whole thread Raw
In response to Re: SELECT performance drop  (legrand legrand <legrand_legrand@hotmail.com>)
Responses RE:SELECT performance drop  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-performance
Tree view
On Tue, Jan 22, 2019 at 2:55 PM legrand legrand <legrand_legrand@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. Thank you so much!

pgsql-performance by date:

Previous
From: legrand legrand
Date:
Subject: Re: SELECT performance drop
Next
From: Jim Finnerty
Date:
Subject: Re: SELECT performance drop