Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "Hash Join (cost=1319.03..13150.08 rows=5727 width=8) (actual time=50.395..80.506 rows=10175 loops=1)"
- " Hash Cond: (ship.id = ship_control.ship_id)"
- " -> Bitmap Heap Scan on ship (cost=576.35..12180.18 rows=19422 width=4) (actual time=9.005..19.482 rows=10175 loops=1)"
- " Recheck Cond: ((player_id = get_player_id("session_user"())) AND (NOT destroyed))"
- " -> Bitmap Index Scan on ship_player_id_idx (cost=0.00..571.50 rows=19422 width=0) (actual time=8.719..8.719 rows=39385 loops=1)"
- " Index Cond: (player_id = get_player_id("session_user"()))"
- " -> Hash (cost=473.97..473.97 rows=21497 width=8) (actual time=41.347..41.347 rows=21497 loops=1)"
- " Buckets: 4096 Batches: 1 Memory Usage: 581kB"
- " -> Seq Scan on ship_control (cost=0.00..473.97 rows=21497 width=8) (actual time=0.006..21.599 rows=21497 loops=1)"
- "Total runtime: 85.376 ms"
Add Comment
Please, Sign In to add comment