Guest User

Untitled

a guest
Feb 28th, 2020
198
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Limit  (cost=299806.35..299806.60 rows=100 width=11) (actual time=1448.470..1448.478 rows=100 loops=1)
  2.   ->  Sort  (cost=299806.35..299829.68 rows=9331 width=11) (actual time=1448.469..1448.472 rows=100 loops=1)
  3.         Sort Key: subq.price, subq.is_instock, subq.product_id
  4.         Sort Method: top-N heapsort  Memory: 33kB
  5.         ->  Subquery Scan on subq  (cost=2.69..299449.73 rows=9331 width=11) (actual time=0.044..1439.162 rows=51147 loops=1)
  6.               Filter: (subq.rn = 1)
  7.               Rows Removed by Filter: 1814999
  8.               ->  WindowAgg  (cost=2.69..276122.89 rows=1866147 width=19) (actual time=0.043..1373.931 rows=1866146 loops=1)
  9.                     ->  Merge Append  (cost=2.69..238799.95 rows=1866147 width=11) (actual time=0.027..667.424 rows=1866146 loops=1)
  10.                           Sort Key: products_displayproductaccess.product_id, products_displayproductaccess.price, products_displayproductaccess.is_instock
  11.                           ->  Sort  (cost=2.26..2.26 rows=1 width=11) (actual time=0.009..0.010 rows=0 loops=1)
  12.                                 Sort Key: products_displayproductaccess.product_id, products_displayproductaccess.price, products_displayproductaccess.is_instock
  13.                                 Sort Method: quicksort  Memory: 25kB
  14.                                 ->  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)
  15.                                       Index Cond: (location_intspace = 755)
  16.                                       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[]))
  17.                                       Heap Fetches: 0
  18.                           ->  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)
  19.                                 Index Cond: (location_intspace = 755)
  20.                                 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[]))
  21.                                 Heap Fetches: 1759553
  22. Planning Time: 14.128 ms
  23. Execution Time: 1448.518 ms
RAW Paste Data