Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Nested Loop (cost=238142.52..2142564914.18 rows=37173362684 width=40)
- -> Bitmap Heap Scan on v2_test_pressure b (cost=238142.10..801536.31 rows=10285617 width=24)
- Recheck Cond: ("EquipmentId" = 3405345)
- -> Bitmap Index Scan on v2_test_pressure_eq_timestamp (cost=0.00..235570.70 rows=10285617 width=0)
- Index Cond: ("EquipmentId" = 3405345)"
- -> Index Only Scan using v2_test_prs_eq_timestamp_validuntil on v2_test_prs a (cost=0.42..172.09 rows=3614 width=24)
- Index Cond: (("EquipmentId" = 3405345) AND ("Timestamp" <= b."Timestamp") AND ("ValidUntil" > b."Timestamp"))
Advertisement
Add Comment
Please, Sign In to add comment
