On Wed, Jan 23, 2019 at 12:37 PM legrand legrand <
legrand_legr...@hotmail.com> wrote:
> Hi,
> is there an index on
> fm_order(session_id,type)?
>
There isn't at the moment:
table_name | index_name | column_name
On Wed, Jan 23, 2019 at 6:51 AM Jim Finnerty wrote:
> One thing that isn't helping is that you have a redundant predicate. The
> selectivity of this predicate is also estimated too low, so removing the
> redundant predicate might improve the estimate and change the plan:
>
> (
On Tue, Jan 22, 2019 at 2:55 PM legrand legrand
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 |