API tools faq
paste
Advertisement
Guest User

Flesh Hold Alt route to ausp explain analyze

a guest
Jun 6th, 2018
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.92 KB | None | 0 0
raw download clone embed print report
  1. Hash Left Join (cost=971.05..1347.18 rows=1 width=349) (actual time=0.174..0.174 rows=0 loops=1)
  2. Hash Cond: (ahr.target = siss.id)
  3. Join Filter: (ahr.hold_type = 'I'::text)
  4. -> Nested Loop Left Join (cost=969.87..1345.96 rows=1 width=339) (actual time=0.174..0.174 rows=0 loops=1)
  5. -> Nested Loop Anti Join (cost=969.73..1345.78 rows=1 width=343) (actual time=0.173..0.173 rows=0 loops=1)
  6. Join Filter: (((csp.org_depth IS NULL) AND (ahr.pickup_lib = ausp.org_unit)) OR ((csp.org_depth IS NOT NULL) AND (SubPlan 1)))
  7. -> Nested Loop (cost=969.59..1343.15 rows=1 width=351) (actual time=0.173..0.173 rows=0 loops=1)
  8. -> Nested Loop (cost=969.45..1342.99 rows=1 width=348) (actual time=0.173..0.173 rows=0 loops=1)
  9. -> Nested Loop Left Join (cost=969.33..1342.83 rows=1 width=351) (actual time=0.173..0.173 rows=0 loops=1)
  10. -> Nested Loop (cost=968.91..1342.34 rows=1 width=347) (actual time=0.172..0.172 rows=0 loops=1)
  11. -> Nested Loop (cost=968.47..1341.72 rows=1 width=337) (actual time=0.172..0.172 rows=0 loops=1)
  12. -> Hash Join (cost=968.04..1333.26 rows=1 width=276) (actual time=0.171..0.171 rows=0 loops=1)
  13. Hash Cond: (copy_location.id = acp.location)
  14. -> WindowAgg (cost=934.30..1150.72 rows=10821 width=37) (never executed)
  15. -> Sort (cost=934.30..961.35 rows=10821 width=37) (never executed)
  16. Sort Key: copy_location.name
  17. -> Seq Scan on copy_location (cost=0.00..209.21 rows=10821 width=37) (never executed)
  18. -> Hash (cost=33.73..33.73 rows=1 width=268) (actual time=0.150..0.150 rows=0 loops=1)
  19. Buckets: 1024 Batches: 1 Memory Usage: 0kB
  20. -> Nested Loop (cost=1.29..33.73 rows=1 width=268) (actual time=0.150..0.150 rows=0 loops=1)
  21. -> Nested Loop (cost=0.85..17.08 rows=1 width=252) (actual time=0.150..0.150 rows=0 loops=1)
  22. -> Index Scan using hold_request_pkey on hold_request ahr (cost=0.43..8.45 rows=1 width=244) (actual time=0.149..0.149 rows=0 loops=1)
  23. Index Cond: (id = 4489817)
  24. Filter: ((capture_time IS NULL) AND (cancel_time IS NULL) AND ((expire_time IS NULL) OR (expire_time > now())))
  25. Rows Removed by Filter: 1
  26. -> GroupAggregate (cost=0.42..8.61 rows=1 width=12) (never executed)
  27. Group Key: hold_copy_map.hold
  28. -> Index Only Scan using copy_once_per_hold on hold_copy_map (cost=0.42..8.56 rows=8 width=12) (never executed)
  29. Index Cond: (hold = 4489817)
  30. Heap Fetches: 0
  31. -> Append (cost=0.43..16.62 rows=2 width=24) (never executed)
  32. -> Index Scan using copy_pkey on copy acp (cost=0.43..8.46 rows=1 width=24) (never executed)
  33. Index Cond: (id = ahr.current_copy)
  34. Filter: (status = ANY ('{0,7}'::integer[]))
  35. -> Index Scan using unit_pkey on unit acp_1 (cost=0.14..8.17 rows=1 width=24) (never executed)
  36. Index Cond: (id = ahr.current_copy)
  37. Filter: (status = ANY ('{0,7}'::integer[]))
  38. -> Index Scan using usr_pkey on usr au (cost=0.43..8.45 rows=1 width=61) (never executed)
  39. Index Cond: (id = ahr.usr)
  40. -> Index Scan using call_number_pkey on call_number acn (cost=0.44..0.61 rows=1 width=26) (never executed)
  41. Index Cond: (id = acp.call_number)
  42. -> Index Scan using actor_usr_standing_penalty_usr_idx on usr_standing_penalty ausp (cost=0.42..0.47 rows=2 width=12) (never executed)
  43. Index Cond: (au.id = usr)
  44. Filter: ((stop_date IS NULL) OR (stop_date > now()))
  45. -> Index Scan using call_number_suffix_pkey on call_number_suffix acns (cost=0.12..0.15 rows=1 width=5) (never executed)
  46. Index Cond: (id = acn.suffix)
  47. -> Index Scan using call_number_prefix_pkey on call_number_prefix acnp (cost=0.14..0.16 rows=1 width=11) (never executed)
  48. Index Cond: (id = acn.prefix)
  49. -> Index Scan using standing_penalty_pkey on standing_penalty csp (cost=0.14..0.16 rows=1 width=8) (never executed)
  50. Index Cond: (id = ausp.standing_penalty)
  51. Filter: (((org_depth IS NULL) OR (org_depth IS NOT NULL)) AND (block_list ~~ '%CAPTURE%'::text))
  52. SubPlan 1
  53. -> Function Scan on org_unit_descendants (cost=0.25..3.75 rows=350 width=4) (never executed)
  54. -> Index Scan using acplo_once_per_org on copy_location_order acplo (cost=0.14..0.17 rows=1 width=12) (never executed)
  55. Index Cond: ((acp.location = location) AND (acp.circ_lib = org))
  56. -> Hash (cost=1.08..1.08 rows=8 width=14) (never executed)
  57. -> Seq Scan on issuance siss (cost=0.00..1.08 rows=8 width=14) (never executed)
  58. Planning time: 192.897 ms
  59. Execution time: 1.148 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!