a guest Dec 8th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  Seq Scan ON objects  (cost=15.54..21914.54 rows=750000 width=24) (actual TIME=9.987..142.383 rows=4492 loops=1)
  2.    Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2))
  3.    Rows Removed BY Filter: 995508
  4.    SubPlan 1
  5.      ->  ProjectSet  (cost=0.00..5.27 rows=1000 width=4) (actual TIME=0.736..0.770 rows=96 loops=1)
  6.            ->  Result  (cost=0.00..0.01 rows=1 width=0) (actual TIME=0.001..0.001 rows=1 loops=1)
  7.    SubPlan 2
  8.      ->  ProjectSet  (cost=0.00..5.27 rows=1000 width=4) (actual TIME=8.125..8.391 rows=4492 loops=1)
  9.            ->  Result  (cost=0.00..0.01 rows=1 width=0) (actual TIME=0.001..0.001 rows=1 loops=1)
  10.  Planning TIME: 0.219 ms
  11.  Execution TIME: 142.682 ms
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand