Guest User

Untitled

a guest
Jul 18th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. "Hash Join (cost=1319.03..13150.08 rows=5727 width=8) (actual time=50.395..80.506 rows=10175 loops=1)"
  2. " Hash Cond: (ship.id = ship_control.ship_id)"
  3. " -> Bitmap Heap Scan on ship (cost=576.35..12180.18 rows=19422 width=4) (actual time=9.005..19.482 rows=10175 loops=1)"
  4. " Recheck Cond: ((player_id = get_player_id("session_user"())) AND (NOT destroyed))"
  5. " -> 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)"
  6. " Index Cond: (player_id = get_player_id("session_user"()))"
  7. " -> Hash (cost=473.97..473.97 rows=21497 width=8) (actual time=41.347..41.347 rows=21497 loops=1)"
  8. " Buckets: 4096 Batches: 1 Memory Usage: 581kB"
  9. " -> Seq Scan on ship_control (cost=0.00..473.97 rows=21497 width=8) (actual time=0.006..21.599 rows=21497 loops=1)"
  10. "Total runtime: 85.376 ms"
Add Comment
Please, Sign In to add comment