Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Seq Scan ON objects (cost=15.54..21914.54 rows=750000 width=24) (actual TIME=9.987..142.383 rows=4492 loops=1)
- Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2))
- Rows Removed BY Filter: 995508
- SubPlan 1
- -> ProjectSet (cost=0.00..5.27 rows=1000 width=4) (actual TIME=0.736..0.770 rows=96 loops=1)
- -> Result (cost=0.00..0.01 rows=1 width=0) (actual TIME=0.001..0.001 rows=1 loops=1)
- SubPlan 2
- -> ProjectSet (cost=0.00..5.27 rows=1000 width=4) (actual TIME=8.125..8.391 rows=4492 loops=1)
- -> Result (cost=0.00..0.01 rows=1 width=0) (actual TIME=0.001..0.001 rows=1 loops=1)
- Planning TIME: 0.219 ms
- Execution TIME: 142.682 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement