Advertisement
Guest User

Untitled

a guest
Dec 8th, 2019
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.67 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement