Re: SELECT performance drop

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



With Pascal's suggestion, I added a new index:

    CREATE INDEX fm_order_sid_type_idx ON fm_order (session_id, type);

which improved the query to 2mS!

  https://explain.depesz.com/s/oxvs

Thank you, Pascal!

On Thu, Jan 24, 2019 at 9:52 AM Jan Nielsen <jan.sture.nielsen@xxxxxxxxx> wrote:


On Wed, Jan 23, 2019 at 12:37 PM legrand legrand <legrand_legrand@xxxxxxxxxxx> wrote:
Hi,
is there an index on
 fm_order(session_id,type)?

There isn't at the moment:

   table_name   |          index_name          | column_name  
----------------+------------------------------+-------------
fm_account     | fm_account_pkey              | id
fm_account     | uk_5p6qalvucbxmw9u64wf0aif9d | name
fm_allocation  | fm_allocation_pkey           | id
fm_approval    | fm_approval_pkey             | id
fm_capital     | fm_capital_pkey              | id
fm_grant       | fm_grant_pkey                | id
fm_market      | fm_market_pkey               | id
fm_marketplace | fm_marketplace_pkey          | id
fm_order       | fm_order_pkey                | id
fm_person      | fm_person_pkey               | id
fm_session     | fm_session_pkey              | id
fm_trader      | fm_trader_pkey               | id


 

regar
ds
PAscal

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux