Limit  (cost=299806.35..299806.60 rows=100 width=11) (actual time=1448.470..1448.478 rows=100 loops=1)
  ->  Sort  (cost=299806.35..299829.68 rows=9331 width=11) (actual time=1448.469..1448.472 rows=100 loops=1)
        Sort Key: subq.price, subq.is_instock, subq.product_id
        Sort Method: top-N heapsort  Memory: 33kB
        ->  Subquery Scan on subq  (cost=2.69..299449.73 rows=9331 width=11) (actual time=0.044..1439.162 rows=51147 loops=1)
              Filter: (subq.rn = 1)
              Rows Removed by Filter: 1814999
              ->  WindowAgg  (cost=2.69..276122.89 rows=1866147 width=19) (actual time=0.043..1373.931 rows=1866146 loops=1)
                    ->  Merge Append  (cost=2.69..238799.95 rows=1866147 width=11) (actual time=0.027..667.424 rows=1866146 loops=1)
                          Sort Key: products_displayproductaccess.product_id, products_displayproductaccess.price, products_displayproductaccess.is_instock
                          ->  Sort  (cost=2.26..2.26 rows=1 width=11) (actual time=0.009..0.010 rows=0 loops=1)
                                Sort Key: products_displayproductaccess.product_id, products_displayproductaccess.price, products_displayproductaccess.is_instock
                                Sort Method: quicksort  Memory: 25kB
                                ->  Index Only Scan using pmtest on products_displayproductaccess  (cost=0.12..2.25 rows=1 width=11) (actual time=0.008..0.008 rows=0 loops=1)
                                      Index Cond: (location_intspace = 755)
                                      Filter: (location_id = ANY ('{55,60,61,62,64,65,68,69,72,78,79,81,84,85,89,92,97,99,101,102,113,120,121,130,149,187,210,234,597,599,601,602,603,605,606,607,608,610,611,613,632,633,634,635,636,637,865,870,900,910,950,951,952,953,954,955,999,1045,1046,1521,1522,1525,1526,1531,1532}'::integer[]))
                                      Heap Fetches: 0
                          ->  Index Only Scan using testidx2 on products_displayproductaccess_755_755  (cost=0.43..220136.21 rows=1866146 width=11) (actual time=0.017..586.877 rows=1866146 loops=1)
                                Index Cond: (location_intspace = 755)
                                Filter: (location_id = ANY ('{55,60,61,62,64,65,68,69,72,78,79,81,84,85,89,92,97,99,101,102,113,120,121,130,149,187,210,234,597,599,601,602,603,605,606,607,608,610,611,613,632,633,634,635,636,637,865,870,900,910,950,951,952,953,954,955,999,1045,1046,1521,1522,1525,1526,1531,1532}'::integer[]))
                                Heap Fetches: 1759553
Planning Time: 14.128 ms
Execution Time: 1448.518 ms