API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 6th, 2018
117
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.42 KB | None | 0 0
raw download clone embed print report
  1. QUERY PLAN
  2. -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3. Nested Loop Left Join (cost=160.19..260.71 rows=2 width=328) (actual time=0.015..0.015 rows=0 loops=1)
  4. -> Nested Loop Left Join (cost=159.91..260.04 rows=2 width=332) (actual time=0.014..0.014 rows=0 loops=1)
  5. Join Filter: (ahr.hold_type = 'I'::text)
  6. -> Nested Loop (cost=159.62..251.41 rows=2 width=317) (actual time=0.014..0.014 rows=0 loops=1)
  7. -> GroupAggregate (cost=0.55..17.12 rows=1 width=12) (actual time=0.014..0.014 rows=0 loops=1)
  8. Group Key: hold_copy_map.hold
  9. -> Index Only Scan using copy_once_per_hold on hold_copy_map (cost=0.55..16.95 rows=32 width=12) (actual time=0.013..0.013 rows=0 loops=1)
  10. Index Cond: (hold = 1535337)
  11. Heap Fetches: 0
  12. -> Nested Loop Anti Join (cost=159.08..234.26 rows=2 width=309) (never executed)
  13. Join Filter: (((csp.org_depth IS NULL) AND (ahr.pickup_lib = ausp.org_unit)) OR ((csp.org_depth IS NOT NULL) AND (SubPlan 1)))
  14. -> Nested Loop Left Join (cost=158.94..233.38 rows=2 width=317) (never executed)
  15. -> Nested Loop (cost=158.52..228.08 rows=1 width=309) (never executed)
  16. -> Nested Loop (cost=158.09..223.62 rows=1 width=285) (never executed)
  17. -> Nested Loop (cost=157.94..223.44 rows=1 width=279) (never executed)
  18. -> Nested Loop (cost=157.80..223.27 rows=1 width=278) (never executed)
  19. -> Hash Join (cost=157.37..222.76 rows=1 width=268) (never executed)
  20. Hash Cond: (copy_location.id = acp.location)
  21. -> WindowAgg (cost=144.13..182.87 rows=1937 width=34) (never executed)
  22. -> Sort (cost=144.13..148.97 rows=1937 width=34) (never executed)
  23. Sort Key: copy_location.name
  24. -> Seq Scan on copy_location (cost=0.00..38.37 rows=1937 width=34) (never executed)
  25. -> Hash (cost=13.23..13.23 rows=1 width=260) (never executed)
  26. -> Nested Loop (cost=0.86..13.23 rows=1 width=260) (never executed)
  27. -> Index Scan using hold_request_pkey on hold_request ahr (cost=0.43..4.45 rows=1 width=244) (never executed)
  28. Index Cond: (id = 1535337)
  29. Filter: ((capture_time IS NULL) AND (cancel_time IS NULL) AND ((expire_time IS NULL) OR (expire_time > now())))
  30. -> Append (cost=0.43..8.76 rows=2 width=24) (never executed)
  31. -> Index Scan using copy_pkey on copy acp (cost=0.43..4.46 rows=1 width=24) (never executed)
  32. Index Cond: (id = ahr.current_copy)
  33. Filter: (status = ANY ('{0,7}'::integer[]))
  34. -> Index Scan using unit_pkey on unit acp_1 (cost=0.29..4.31 rows=1 width=24) (never executed)
  35. Index Cond: (id = ahr.current_copy)
  36. Filter: (status = ANY ('{0,7}'::integer[]))
  37. -> Index Scan using call_number_pkey on call_number acn (cost=0.43..0.51 rows=1 width=26) (never executed)
  38. Index Cond: (id = acp.call_number)
  39. -> Index Scan using call_number_prefix_pkey on call_number_prefix acnp (cost=0.14..0.16 rows=1 width=9) (never executed)
  40. Index Cond: (id = acn.prefix)
  41. -> Index Scan using call_number_suffix_pkey on call_number_suffix acns (cost=0.14..0.17 rows=1 width=14) (never executed)
  42. Index Cond: (id = acn.suffix)
  43. -> Index Scan using usr_pkey on usr au (cost=0.43..4.45 rows=1 width=28) (never executed)
  44. Index Cond: (id = ahr.usr)
  45. -> Index Scan using actor_usr_standing_penalty_usr_idx on usr_standing_penalty ausp (cost=0.42..5.28 rows=2 width=12) (never executed)
  46. Index Cond: (ahr.usr = usr)
  47. Filter: ((stop_date IS NULL) OR (stop_date > now()))
  48. -> Index Scan using standing_penalty_pkey on standing_penalty csp (cost=0.14..0.16 rows=1 width=8) (never executed)
  49. Index Cond: (id = ausp.standing_penalty)
  50. Filter: (((org_depth IS NULL) OR (org_depth IS NOT NULL)) AND (block_list ~~ '%CAPTURE%'::text))
  51. SubPlan 1
  52. -> Function Scan on org_unit_descendants (cost=0.25..0.26 rows=1 width=4) (never executed)
  53. -> Index Scan using issuance_pkey on issuance siss (cost=0.29..4.30 rows=1 width=19) (never executed)
  54. Index Cond: (id = ahr.target)
  55. -> Index Scan using acplo_once_per_org on copy_location_order acplo (cost=0.28..0.30 rows=1 width=12) (never executed)
  56. Index Cond: ((acp.location = location) AND (acp.circ_lib = org))
  57. Planning time: 27.338 ms
  58. Execution time: 7.207 ms
  59. (56 rows)
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!