explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O42t : Holds List - Nulls First

Settings
# exclusive inclusive rows x rows loops node
1. 1.375 68,661.270 ↓ 74.8 374 1

Sort (cost=18,597,752.36..18,597,752.37 rows=5 width=1,767) (actual time=68,661.245..68,661.270 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, (CASE WHEN (h.cancel_time IS NOT NULL) THEN 6 WHEN (h.frozen AND (h.capture_time IS NULL)) THEN 7 WHEN ((h.current_shelf_lib IS NOT NULL) AND (h.current_shelf_lib <> h.pickup_lib)) THEN 8 WHEN (h.fulfillment_time IS NOT NULL) THEN 9 WHEN (h.current_copy IS NULL) THEN 1 WHEN (h.capture_time IS NULL) THEN 2 WHEN (cp.status = 6) THEN 3 WHEN (date_part('epoch'::text, (COALESCE(NULLIF(btrim(hold_wait_time.value, '"'::text), ''::text), '0 seconds'::text))::interval) = 0::double precision) THEN 4 WHEN ((h.shelf_time + (COALESCE(NULLIF(btrim(hold_wait_time.value, '"'::text), ''::text), '0 seconds'::text))::interval) > now()) THEN 5 ELSE 4 END), (((h.shelf_expire_time < now()) OR (h.cancel_time IS NOT NULL) OR ((h.current_shelf_lib IS NOT NULL) AND (h.current_shelf_lib <> h.pickup_lib)))), ((h.usr <> h.requestor)), cc.id, cc.label, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, (CASE WHEN (u.alias IS NOT NULL) THEN u.alias ELSE u.first_given_name END), (CASE WHEN (u.alias IS NOT NULL) THEN u.alias ELSE regexp_replace(array_to_string(ARRAY[COALESCE(u.family_name, ''::text), COALESCE(u.suffix, ''::text), ', '::text, COALESCE(u.prefix, ''::text), COALESCE(u.first_given_name, ''::text), COALESCE(u.second_given_name, ''::text)], ' '::text), 's+,'::text, ','::text) END), (regexp_replace(array_to_string(ARRAY[COALESCE(u.family_name, ''::text), COALESCE(u.suffix, ''::text), ', '::text, COALESCE(u.prefix, ''::text), COALESCE(u.first_given_name, ''::text), COALESCE(u.second_given_name, ''::text)], ' '::text), 's+,'::text, ','::text)), uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.status, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, siss.label, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, p.id, p.record, p.label, p.label_sortkey, p.deleted, acnp.label, acns.label, (btrim(((((acnp.label || ' '::text) || cn.label) || ' '::text) || acns.label))), r.bib_record, (first(display_entry.value)), (first(display_entry_1.value)), acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, (COALESCE((acplo."position")::bigint, acpl_ordered.fallback_position)), (row_number() OVER (?)), (date_part('epoch'::text, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)), (date_part('epoch'::text, (COALESCE(NULLIF(btrim(min_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)), (COALESCE((count(*)), 0::bigint)), (COALESCE((count(DISTINCT m.hold)), 0::bigint)), (COALESCE((sum(date_part('epoch'::text, COALESCE(cm.avg_wait_time, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)))), 0::double precision)), (count(*)), (max(hold_notification.notify_time))
  • Sort Key: h.shelf_expire_time
  • Sort Method: quicksort Memory: 778kB
  • Buffers: shared hit=1495154 dirtied=12
2.          

CTE t_field

3. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on config.display_field_map (cost=0.00..1.32 rows=1 width=4) (actual time=0.003..0.008 rows=1 loops=1)

  • Output: display_field_map.field
  • Filter: (display_field_map.name = 'title'::text)
  • Rows Removed by Filter: 25
  • Buffers: shared hit=1
4.          

CTE a_field

5. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on config.display_field_map display_field_map_1 (cost=0.00..1.32 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=1)

  • Output: display_field_map_1.field
  • Filter: (display_field_map_1.name = 'author'::text)
  • Rows Removed by Filter: 25
  • Buffers: shared hit=1
6. 6.400 68,659.895 ↓ 74.8 374 1

WindowAgg (cost=18,597,749.05..18,597,749.65 rows=5 width=1,767) (actual time=68,653.539..68,659.895 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, CASE WHEN (h.cancel_time IS NOT NULL) THEN 6 WHEN (h.frozen AND (h.capture_time IS NULL)) THEN 7 WHEN ((h.current_shelf_lib IS NOT NULL) AND (h.current_shelf_lib <> h.pickup_lib)) THEN 8 WHEN (h.fulfillment_time IS NOT NULL) THEN 9 WHEN (h.current_copy IS NULL) THEN 1 WHEN (h.capture_time IS NULL) THEN 2 WHEN (cp.status = 6) THEN 3 WHEN (date_part('epoch'::text, (COALESCE(NULLIF(btrim(hold_wait_time.value, '"'::text), ''::text), '0 seconds'::text))::interval) = 0::double precision) THEN 4 WHEN ((h.shelf_time + (COALESCE(NULLIF(btrim(hold_wait_time.value, '"'::text), ''::text), '0 seconds'::text))::interval) > now()) THEN 5 ELSE 4 END, ((h.shelf_expire_time < now()) OR (h.cancel_time IS NOT NULL) OR ((h.current_shelf_lib IS NOT NULL) AND (h.current_shelf_lib <> h.pickup_lib))), (h.usr <> h.requestor), cc.id, cc.label, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, CASE WHEN (u.alias IS NOT NULL) THEN u.alias ELSE u.first_given_name END, CASE WHEN (u.alias IS NOT NULL) THEN u.alias ELSE regexp_replace(array_to_string(ARRAY[COALESCE(u.family_name, ''::text), COALESCE(u.suffix, ''::text), ', '::text, COALESCE(u.prefix, ''::text), COALESCE(u.first_given_name, ''::text), COALESCE(u.second_given_name, ''::text)], ' '::text), 's+,'::text, ','::text) END, regexp_replace(array_to_string(ARRAY[COALESCE(u.family_name, ''::text), COALESCE(u.suffix, ''::text), ', '::text, COALESCE(u.prefix, ''::text), COALESCE(u.first_given_name, ''::text), COALESCE(u.second_given_name, ''::text)], ' '::text), 's+,'::text, ','::text), uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.status, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, siss.label, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, p.id, p.record, p.label, p.label_sortkey, p.deleted, acnp.label, acns.label, btrim(((((acnp.label || ' '::text) || cn.label) || ' '::text) || acns.label)), r.bib_record, (first(display_entry.value)), (first(display_entry_1.value)), acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, COALESCE((acplo."position")::bigint, acpl_ordered.fallback_position), row_number() OVER (?), date_part('epoch'::text, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval), date_part('epoch'::text, (COALESCE(NULLIF(btrim(min_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval), COALESCE((count(*)), 0::bigint), COALESCE((count(DISTINCT m.hold)), 0::bigint), COALESCE((sum(date_part('epoch'::text, COALESCE(cm.avg_wait_time, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)))), 0::double precision), (count(*)), (max(hold_notification.notify_time))
  • Buffers: shared hit=1495154 dirtied=12
7. 5.160 68,653.495 ↓ 74.8 374 1

Sort (cost=18,597,749.05..18,597,749.06 rows=5 width=1,767) (actual time=68,653.416..68,653.495 rows=374 loops=1)

  • Output: h.request_time, h.cut_in_line, r.bib_record, h.id, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, cp.status, hold_wait_time.value, cc.id, cc.label, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, siss.label, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, p.id, p.record, p.label, p.label_sortkey, p.deleted, acnp.label, acns.label, (first(display_entry.value)), (first(display_entry_1.value)), acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, acplo."position", acpl_ordered.fallback_position, default_estimated_wait_interval.value, min_estimated_wait_interval.value, (count(*)), (count(DISTINCT m.hold)), (sum(date_part('epoch'::text, COALESCE(cm.avg_wait_time, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)))), (count(*)), (max(hold_notification.notify_time))
  • Sort Key: r.bib_record, h.cut_in_line, h.request_time
  • Sort Method: quicksort Memory: 774kB
  • Buffers: shared hit=1495154 dirtied=12
8. 2.867 68,648.335 ↓ 74.8 374 1

Nested Loop (cost=43.42..18,597,748.99 rows=5 width=1,767) (actual time=145.331..68,648.335 rows=374 loops=1)

  • Output: h.request_time, h.cut_in_line, r.bib_record, h.id, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, cp.status, hold_wait_time.value, cc.id, cc.label, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, siss.label, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, p.id, p.record, p.label, p.label_sortkey, p.deleted, acnp.label, acns.label, (first(display_entry.value)), (first(display_entry_1.value)), acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, acplo."position", acpl_ordered.fallback_position, default_estimated_wait_interval.value, min_estimated_wait_interval.value, (count(*)), (count(DISTINCT m.hold)), (sum(date_part('epoch'::text, COALESCE(cm.avg_wait_time, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)))), (count(*)), (max(hold_notification.notify_time))
  • Buffers: shared hit=1495154 dirtied=12
9. 2.795 68,610.686 ↓ 74.8 374 1

Nested Loop Left Join (cost=24.69..18,597,655.17 rows=5 width=1,743) (actual time=145.241..68,610.686 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), (count(*)), (max(hold_notification.notify_time)), (first(display_entry.value)), (first(display_entry_1.value)), default_estimated_wait_interval.value, min_estimated_wait_interval.value, hold_wait_time.value
  • Buffers: shared hit=1485572 dirtied=10
10. 2.236 68,580.963 ↓ 74.8 374 1

Nested Loop Left Join (cost=24.44..18,597,654.82 rows=5 width=1,711) (actual time=145.138..68,580.963 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), (count(*)), (max(hold_notification.notify_time)), (first(display_entry.value)), (first(display_entry_1.value)), default_estimated_wait_interval.value, min_estimated_wait_interval.value
  • Buffers: shared hit=1482206 dirtied=10
11. 2.650 68,551.051 ↓ 74.8 374 1

Nested Loop Left Join (cost=24.19..18,597,654.47 rows=5 width=1,679) (actual time=145.019..68,551.051 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), (count(*)), (max(hold_notification.notify_time)), (first(display_entry.value)), (first(display_entry_1.value)), default_estimated_wait_interval.value
  • Buffers: shared hit=1478840 dirtied=10
12. 2.622 68,496.041 ↓ 74.8 374 1

Nested Loop Left Join (cost=23.94..18,597,654.12 rows=5 width=1,647) (actual time=144.786..68,496.041 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), (count(*)), (max(hold_notification.notify_time)), (first(display_entry.value)), (first(display_entry_1.value))
  • Buffers: shared hit=1475474 dirtied=10
13. 2.712 68,485.939 ↓ 74.8 374 1

Nested Loop Left Join (cost=19.77..18,597,633.12 rows=5 width=1,619) (actual time=144.714..68,485.939 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), (count(*)), (max(hold_notification.notify_time)), (first(display_entry.value))
  • Buffers: shared hit=1473695 dirtied=10
14. 2.503 68,465.275 ↓ 74.8 374 1

Nested Loop Left Join (cost=15.60..18,597,612.12 rows=5 width=1,591) (actual time=144.561..68,465.275 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*)), (count(*)), (max(hold_notification.notify_time))
  • Buffers: shared hit=1471911 dirtied=10
15. 2.605 68,456.414 ↓ 74.8 374 1

Nested Loop Left Join (cost=13.15..18,597,599.74 rows=5 width=1,575) (actual time=144.537..68,456.414 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time, (count(*))
  • Buffers: shared hit=1470442 dirtied=10
16. 3.765 68,447.825 ↓ 74.8 374 1

Nested Loop Left Join (cost=12.11..18,597,594.39 rows=5 width=1,567) (actual time=144.512..68,447.825 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label, hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time
  • Buffers: shared hit=1470068 dirtied=10
17. 1.816 68,427.604 ↓ 74.8 374 1

Nested Loop Left Join (cost=9.66..18,597,582.00 rows=5 width=1,506) (actual time=144.459..68,427.604 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label, acns.label
  • Join Filter: (cn.suffix = acns.id)
  • Rows Removed by Join Filter: 374
  • Buffers: shared hit=1468679 dirtied=10
18. 5.772 68,425.414 ↓ 74.8 374 1

Nested Loop Left Join (cost=9.66..18,597,580.82 rows=5 width=1,499) (actual time=144.446..68,425.414 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey, acnp.label
  • Join Filter: (cn.prefix = acnp.id)
  • Rows Removed by Join Filter: 26928
  • Buffers: shared hit=1468678 dirtied=10
19. 51,709.243 68,417.398 ↓ 74.8 374 1

Nested Loop Left Join (cost=9.66..18,597,573.44 rows=5 width=1,490) (actual time=144.426..68,417.398 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position, cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey
  • Join Filter: ((cn.id = cp.call_number) OR ((h.hold_type = 'V'::text) AND (cn.id = h.target)))
  • Rows Removed by Join Filter: 251201588
  • Buffers: shared hit=1468677 dirtied=10
20. 6.318 2,829.763 ↓ 74.8 374 1

Nested Loop Left Join (cost=9.66..18,512,146.57 rows=5 width=1,407) (actual time=10.798..2,829.763 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position", acpl_ordered.fallback_position
  • Join Filter: (acpl_ordered.id = cp.location)
  • Rows Removed by Join Filter: 36278
  • Buffers: shared hit=1458749 dirtied=10
21. 2.795 2,820.827 ↓ 74.8 374 1

Nested Loop Left Join (cost=3.44..18,512,129.82 rows=5 width=1,399) (actual time=10.672..2,820.827 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field, acplo."position
  • Join Filter: ((cp.location = acplo.location) AND (cp.circ_lib = acplo.org))
  • Rows Removed by Join Filter: 3740
  • Buffers: shared hit=1458747 dirtied=10
22. 1.596 2,817.284 ↓ 74.8 374 1

Nested Loop (cost=3.44..18,512,127.82 rows=5 width=1,395) (actual time=10.658..2,817.284 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url, a_field.field
  • Buffers: shared hit=1458746 dirtied=10
23. 6.814 2,814.940 ↓ 74.8 374 1

Nested Loop Left Join (cost=3.44..18,512,127.71 rows=5 width=1,391) (actual time=10.648..2,814.940 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available, acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url
  • Join Filter: (cp.location = acpl.id)
  • Rows Removed by Join Filter: 36278
  • Buffers: shared hit=1458745 dirtied=10
24. 1.402 2,805.134 ↓ 74.8 374 1

Nested Loop (cost=3.44..18,512,117.13 rows=5 width=1,338) (actual time=10.639..2,805.134 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost, cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available
  • Buffers: shared hit=1458743 dirtied=10
25. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on config.copy_status cs (cost=0.00..1.26 rows=1 width=20) (actual time=0.007..0.011 rows=1 loops=1)

  • Output: cs.id, cs.name, cs.holdable, cs.opac_visible, cs.copy_active, cs.restrict_copy_delete, cs.is_available
  • Filter: (cs.id = 8)
  • Rows Removed by Filter: 20
  • Buffers: shared hit=1
26. 1.347 2,803.721 ↓ 74.8 374 1

Nested Loop Left Join (cost=3.44..18,512,115.82 rows=5 width=1,318) (actual time=10.625..2,803.721 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, siss.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost
  • Join Filter: ((h.hold_type = 'I'::text) AND (siss.id = h.target))
  • Buffers: shared hit=1458742 dirtied=10
27. 579.394 2,802.374 ↓ 74.8 374 1

Nested Loop Left Join (cost=3.44..18,512,059.82 rows=5 width=1,286) (actual time=10.619..2,802.374 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, p.id, p.record, p.label, p.label_sortkey, p.deleted, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost
  • Join Filter: ((h.hold_type = 'P'::text) AND (p.id = h.target))
  • Rows Removed by Join Filter: 5632814
  • Buffers: shared hit=1458742 dirtied=10
28. 2.270 1,824.670 ↓ 74.8 374 1

Nested Loop Left Join (cost=3.44..18,510,352.72 rows=5 width=1,229) (actual time=3.872..1,824.670 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cc.id, cc.label, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost
  • Join Filter: (h.cancel_cause = cc.id)
  • Rows Removed by Join Filter: 2611
  • Buffers: shared hit=1458541 dirtied=10
29. 12.206 1,821.652 ↓ 74.8 374 1

Nested Loop (cost=3.44..18,510,351.11 rows=5 width=1,208) (actual time=3.862..1,821.652 rows=374 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field, cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost
  • Buffers: shared hit=1458540 dirtied=10
30. 27.331 1,557.161 ↓ 1.1 22,935 1

Nested Loop (cost=2.41..102,716.88 rows=20,452 width=1,003) (actual time=0.092..1,557.161 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar, t_field.field
  • Buffers: shared hit=1290310 dirtied=4
31. 32.321 1,529.830 ↓ 1.1 22,935 1

Nested Loop (cost=2.41..102,307.83 rows=20,452 width=999) (actual time=0.084..1,529.830 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active, pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar
  • Buffers: shared hit=1290309 dirtied=4
32. 25.191 1,474.574 ↓ 1.1 22,935 1

Nested Loop (cost=2.27..98,828.07 rows=20,452 width=904) (actual time=0.080..1,474.574 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, r.bib_record, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active
  • Buffers: shared hit=1244439 dirtied=4
33. 15.094 1,334.708 ↓ 1.1 22,935 1

Nested Loop (cost=1.84..81,083.25 rows=20,452 width=896) (actual time=0.069..1,334.708 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ruc.id, ruc.barcode, ruc.usr, ruc.active
  • Buffers: shared hit=1152570 dirtied=4
34. 28.870 1,273.744 ↓ 1.1 22,935 1

Nested Loop (cost=1.55..74,167.31 rows=20,729 width=873) (actual time=0.065..1,273.744 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active, ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time
  • Buffers: shared hit=1083744 dirtied=4
35. 13.777 1,199.004 ↓ 1.1 22,935 1

Nested Loop (cost=1.14..58,752.99 rows=20,729 width=578) (actual time=0.058..1,199.004 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, uc.id, uc.barcode, uc.usr, uc.active
  • Buffers: shared hit=991960 dirtied=4
36. 31.217 1,093.487 ↓ 1.1 22,935 1

Nested Loop (cost=0.84..51,743.64 rows=21,009 width=555) (actual time=0.049..1,093.487 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, u.id, u.card, u.profile, u.usrname, u.email, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time
  • Buffers: shared hit=923050 dirtied=4
37. 970.530 970.530 ↓ 1.1 22,935 1

Index Scan using hold_request_target_idx on action.hold_request h (cost=0.42..36,121.11 rows=21,009 width=260) (actual time=0.036..970.530 rows=22,935 loops=1)

  • Output: h.id, h.request_time, h.capture_time, h.fulfillment_time, h.checkin_time, h.return_time, h.prev_check_time, h.expire_time, h.cancel_time, h.cancel_cause, h.cancel_note, h.target, h.current_copy, h.fulfillment_staff, h.fulfillment_lib, h.request_lib, h.requestor, h.usr, h.selection_ou, h.selection_depth, h.pickup_lib, h.hold_type, h.holdable_formats, h.phone_notify, h.email_notify, h.sms_notify, h.sms_carrier, h.frozen, h.thaw_date, h.shelf_time, h.cut_in_line, h.mint_condition, h.shelf_expire_time, h.current_shelf_lib, h.behind_desk, h.acq_request
  • Filter: ((h.capture_time IS NOT NULL) AND (h.fulfillment_time IS NULL) AND (h.current_shelf_lib = 102))
  • Rows Removed by Filter: 833634
  • Buffers: shared hit=831243 dirtied=4
38. 91.740 91.740 ↑ 1.0 1 22,935

Index Scan using usr_pkey on actor.usr u (cost=0.42..0.73 rows=1 width=295) (actual time=0.004..0.004 rows=1 loops=22,935)

  • Output: u.id, u.card, u.profile, u.usrname, u.email, u.passwd, u.standing, u.ident_type, u.ident_value, u.ident_type2, u.ident_value2, u.net_access_level, u.photo_url, u.prefix, u.first_given_name, u.second_given_name, u.family_name, u.suffix, u.alias, u.day_phone, u.evening_phone, u.other_phone, u.mailing_address, u.billing_address, u.home_ou, u.dob, u.active, u.master_account, u.super_user, u.barred, u.deleted, u.juvenile, u.usrgroup, u.claims_returned_count, u.credit_forward_balance, u.last_xact_id, u.alert_message, u.create_date, u.expire_date, u.claims_never_checked_out_count, u.last_update_time, u.pref_prefix, u.pref_first_given_name, u.pref_second_given_name, u.pref_family_name, u.pref_suffix, u.name_keywords, u.name_kw_tsvector, u.guardian
  • Index Cond: (u.id = h.usr)
  • Buffers: shared hit=91807
39. 91.740 91.740 ↑ 1.0 1 22,935

Index Scan using card_pkey on actor.card uc (cost=0.29..0.32 rows=1 width=23) (actual time=0.003..0.004 rows=1 loops=22,935)

  • Output: uc.id, uc.usr, uc.barcode, uc.active
  • Index Cond: (uc.id = u.card)
  • Buffers: shared hit=68910
40. 45.870 45.870 ↑ 1.0 1 22,935

Index Scan using usr_pkey on actor.usr ru (cost=0.42..0.73 rows=1 width=295) (actual time=0.002..0.002 rows=1 loops=22,935)

  • Output: ru.id, ru.card, ru.profile, ru.usrname, ru.email, ru.passwd, ru.standing, ru.ident_type, ru.ident_value, ru.ident_type2, ru.ident_value2, ru.net_access_level, ru.photo_url, ru.prefix, ru.first_given_name, ru.second_given_name, ru.family_name, ru.suffix, ru.alias, ru.day_phone, ru.evening_phone, ru.other_phone, ru.mailing_address, ru.billing_address, ru.home_ou, ru.dob, ru.active, ru.master_account, ru.super_user, ru.barred, ru.deleted, ru.juvenile, ru.usrgroup, ru.claims_returned_count, ru.credit_forward_balance, ru.last_xact_id, ru.alert_message, ru.create_date, ru.expire_date, ru.claims_never_checked_out_count, ru.last_update_time, ru.pref_prefix, ru.pref_first_given_name, ru.pref_second_given_name, ru.pref_family_name, ru.pref_suffix, ru.name_keywords, ru.name_kw_tsvector, ru.guardian
  • Index Cond: (ru.id = h.requestor)
  • Buffers: shared hit=91784
41. 45.870 45.870 ↑ 1.0 1 22,935

Index Scan using card_pkey on actor.card ruc (cost=0.29..0.32 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=22,935)

  • Output: ruc.id, ruc.usr, ruc.barcode, ruc.active
  • Index Cond: (ruc.id = ru.card)
  • Buffers: shared hit=68826
42. 114.675 114.675 ↑ 1.0 1 22,935

Index Scan using reporter_hold_request_record_pkey_idx on reporter.hold_request_record r (cost=0.42..0.86 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=22,935)

  • Output: r.id, r.target, r.hold_type, r.bib_record
  • Index Cond: (r.id = h.id)
  • Buffers: shared hit=91869
43. 22.935 22.935 ↑ 1.0 1 22,935

Index Scan using org_unit_pkey on actor.org_unit pl (cost=0.14..0.16 rows=1 width=95) (actual time=0.001..0.001 rows=1 loops=22,935)

  • Output: pl.id, pl.parent_ou, pl.ou_type, pl.ill_address, pl.holds_address, pl.mailing_address, pl.billing_address, pl.shortname, pl.name, pl.email, pl.phone, pl.opac_visible, pl.fiscal_calendar
  • Index Cond: (pl.id = h.pickup_lib)
  • Buffers: shared hit=45870
44. 0.000 0.000 ↑ 1.0 1 22,935

CTE Scan on t_field (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=22,935)

  • Output: t_field.field
  • Buffers: shared hit=1
45. 68.805 252.285 ↓ 0.0 0 22,935

Append (cost=1.03..900.02 rows=2 width=287) (actual time=0.011..0.011 rows=0 loops=22,935)

  • Buffers: shared hit=168230 dirtied=6
46. 50.055 183.480 ↓ 0.0 0 22,935

Bitmap Heap Scan on asset.copy cp (cost=1.03..12.99 rows=1 width=205) (actual time=0.008..0.008 rows=0 loops=22,935)

  • Output: cp.status, cp.id, cp.circ_lib, cp.creator, cp.call_number, cp.editor, cp.create_date, cp.edit_date, cp.copy_number, cp.location, cp.loan_duration, cp.fine_level, cp.age_protect, cp.circulate, cp.deposit, cp.ref, cp.holdable, cp.deposit_amount, cp.price, cp.barcode, cp.circ_modifier, cp.circ_as_type, cp.dummy_title, cp.dummy_author, cp.alert_message, cp.opac_visible, cp.deleted, cp.floating, cp.dummy_isbn, cp.status_changed_time, cp.active_date, cp.mint_condition, cp.cost
  • Recheck Cond: ((h.current_copy = cp.id) OR (cp.id = h.target))
  • Filter: ((NOT cp.deleted) AND (cp.status = 8) AND ((h.current_copy = cp.id) OR ((h.hold_type = ANY ('{C,F,R}'::text[])) AND (cp.id = h.target))) AND ((h.capture_time IS NULL) OR (h.id = (SubPlan 3))))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=22935
  • Buffers: shared hit=168230 dirtied=6
47. 22.935 114.675 ↓ 0.0 0 22,935

BitmapOr (cost=1.03..1.03 rows=2 width=0) (actual time=0.005..0.005 rows=0 loops=22,935)

  • Buffers: shared hit=137700
48. 68.805 68.805 ↑ 1.0 1 22,935

Bitmap Index Scan on copy_pkey (cost=0.00..0.51 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=22,935)

  • Index Cond: (h.current_copy = cp.id)
  • Buffers: shared hit=68888
49. 22.935 22.935 ↓ 0.0 0 22,935

Bitmap Index Scan on copy_pkey (cost=0.00..0.51 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=22,935)

  • Index Cond: (cp.id = h.target)
  • Buffers: shared hit=68812
50.          

SubPlan (for Bitmap Heap Scan)

51. 1.875 18.750 ↑ 1.0 1 625

Limit (cost=5.46..5.46 rows=1 width=12) (actual time=0.030..0.030 rows=1 loops=625)

  • Output: recheck.id, recheck.capture_time
  • Buffers: shared hit=7595 dirtied=1
52. 6.875 16.875 ↑ 4.0 1 625

Sort (cost=5.46..5.47 rows=4 width=12) (actual time=0.027..0.027 rows=1 loops=625)

  • Output: recheck.id, recheck.capture_time
  • Sort Key: recheck.capture_time
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7595 dirtied=1
53. 10.000 10.000 ↓ 2.2 9 625

Index Scan using hold_request_current_copy_idx on action.hold_request recheck (cost=0.42..5.44 rows=4 width=12) (actual time=0.008..0.016 rows=9 loops=625)

  • Output: recheck.id, recheck.capture_time
  • Index Cond: (recheck.current_copy = cp.id)
  • Buffers: shared hit=7595 dirtied=1
54. 0.000 0.000 ↓ 0.0 0 22,935

Seq Scan on serial.unit cp_1 (cost=0.00..887.03 rows=1 width=369) (actual time=0.000..0.000 rows=0 loops=22,935)

  • Output: cp_1.status, cp_1.id, cp_1.circ_lib, cp_1.creator, cp_1.call_number, cp_1.editor, cp_1.create_date, cp_1.edit_date, cp_1.copy_number, cp_1.location, cp_1.loan_duration, cp_1.fine_level, cp_1.age_protect, cp_1.circulate, cp_1.deposit, cp_1.ref, cp_1.holdable, cp_1.deposit_amount, cp_1.price, cp_1.barcode, cp_1.circ_modifier, cp_1.circ_as_type, cp_1.dummy_title, cp_1.dummy_author, cp_1.alert_message, cp_1.opac_visible, cp_1.deleted, cp_1.floating, cp_1.dummy_isbn, cp_1.status_changed_time, cp_1.active_date, cp_1.mint_condition, cp_1.cost
  • Filter: ((NOT cp_1.deleted) AND (cp_1.status = 8) AND ((h.current_copy = cp_1.id) OR ((h.hold_type = ANY ('{C,F,R}'::text[])) AND (cp_1.id = h.target))) AND ((h.capture_time IS NULL) OR (h.id = (SubPlan 3))))
55.          

SubPlan (for Seq Scan)

56. 1.875 18.750 ↑ 1.0 1 625

Limit (cost=5.46..5.46 rows=1 width=12) (actual time=0.030..0.030 rows=1 loops=625)

  • Output: recheck.id, recheck.capture_time
  • Buffers: shared hit=7595 dirtied=1
57. 6.875 16.875 ↑ 4.0 1 625

Sort (cost=5.46..5.47 rows=4 width=12) (actual time=0.027..0.027 rows=1 loops=625)

  • Output: recheck.id, recheck.capture_time
  • Sort Key: recheck.capture_time
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=7595 dirtied=1
58. 10.000 10.000 ↓ 2.2 9 625

Index Scan using hold_request_current_copy_idx on action.hold_request recheck (cost=0.42..5.44 rows=4 width=12) (actual time=0.008..0.016 rows=9 loops=625)

  • Output: recheck.id, recheck.capture_time
  • Index Cond: (recheck.current_copy = cp_1.id)
  • Buffers: shared hit=7595 dirtied=1
59. 0.746 0.748 ↑ 1.0 7 374

Materialize (cost=0.00..1.10 rows=7 width=21) (actual time=0.001..0.002 rows=7 loops=374)

  • Output: cc.id, cc.label
  • Buffers: shared hit=1
60. 0.002 0.002 ↑ 1.0 7 1

Seq Scan on action.hold_request_cancel_cause cc (cost=0.00..1.07 rows=7 width=21) (actual time=0.001..0.002 rows=7 loops=1)

  • Output: cc.id, cc.label
  • Buffers: shared hit=1
61. 396.480 398.310 ↑ 1.0 15,061 374

Materialize (cost=0.00..426.92 rows=15,061 width=57) (actual time=0.000..1.065 rows=15,061 loops=374)

  • Output: p.id, p.record, p.label, p.label_sortkey, p.deleted
  • Buffers: shared hit=201
62. 1.830 1.830 ↑ 1.0 15,061 1

Seq Scan on biblio.monograph_part p (cost=0.00..351.61 rows=15,061 width=57) (actual time=0.003..1.830 rows=15,061 loops=1)

  • Output: p.id, p.record, p.label, p.label_sortkey, p.deleted
  • Buffers: shared hit=201
63. 0.000 0.000 ↓ 0.0 0 374

Materialize (cost=0.00..16.90 rows=460 width=36) (actual time=0.000..0.000 rows=0 loops=374)

  • Output: siss.label, siss.id
64. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on serial.issuance siss (cost=0.00..14.60 rows=460 width=36) (actual time=0.000..0.000 rows=0 loops=1)

  • Output: siss.label, siss.id
65. 2.978 2.992 ↑ 1.0 98 374

Materialize (cost=0.00..3.47 rows=98 width=53) (actual time=0.000..0.008 rows=98 loops=374)

  • Output: acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url
  • Buffers: shared hit=2
66. 0.014 0.014 ↑ 1.0 98 1

Seq Scan on asset.copy_location acpl (cost=0.00..2.98 rows=98 width=53) (actual time=0.002..0.014 rows=98 loops=1)

  • Output: acpl.id, acpl.name, acpl.owning_lib, acpl.holdable, acpl.hold_verify, acpl.opac_visible, acpl.circulate, acpl.label_prefix, acpl.label_suffix, acpl.checkin_alert, acpl.deleted, acpl.url
  • Buffers: shared hit=2
67. 0.748 0.748 ↑ 1.0 1 374

CTE Scan on a_field (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=374)

  • Output: a_field.field
  • Buffers: shared hit=1
68. 0.746 0.748 ↑ 1.0 10 374

Materialize (cost=0.00..1.15 rows=10 width=12) (actual time=0.001..0.002 rows=10 loops=374)

  • Output: acplo."position", acplo.location, acplo.org
  • Buffers: shared hit=1
69. 0.002 0.002 ↑ 1.0 10 1

Seq Scan on asset.copy_location_order acplo (cost=0.00..1.10 rows=10 width=12) (actual time=0.001..0.002 rows=10 loops=1)

  • Output: acplo."position", acplo.location, acplo.org
  • Buffers: shared hit=1
70. 2.429 2.618 ↑ 1.0 98 374

Materialize (cost=6.22..9.65 rows=98 width=12) (actual time=0.001..0.007 rows=98 loops=374)

  • Output: acpl_ordered.fallback_position, acpl_ordered.id
  • Buffers: shared hit=2
71. 0.020 0.189 ↑ 1.0 98 1

Subquery Scan on acpl_ordered (cost=6.22..9.16 rows=98 width=12) (actual time=0.087..0.189 rows=98 loops=1)

  • Output: acpl_ordered.fallback_position, acpl_ordered.id
  • Buffers: shared hit=2
72. 0.075 0.169 ↑ 1.0 98 1

WindowAgg (cost=6.22..8.18 rows=98 width=53) (actual time=0.087..0.169 rows=98 loops=1)

  • Output: copy_location.id, copy_location.name, copy_location.owning_lib, copy_location.holdable, copy_location.hold_verify, copy_location.opac_visible, copy_location.circulate, copy_location.label_prefix, copy_location.label_suffix, copy_location.checkin_alert, copy_location.deleted, copy_location.url, (row_number() OVER (?) + 1000000)
  • Buffers: shared hit=2
73. 0.068 0.094 ↑ 1.0 98 1

Sort (cost=6.22..6.47 rows=98 width=53) (actual time=0.080..0.094 rows=98 loops=1)

  • Output: copy_location.name, copy_location.id, copy_location.owning_lib, copy_location.holdable, copy_location.hold_verify, copy_location.opac_visible, copy_location.circulate, copy_location.label_prefix, copy_location.label_suffix, copy_location.checkin_alert, copy_location.deleted, copy_location.url
  • Sort Key: copy_location.name
  • Sort Method: quicksort Memory: 32kB
  • Buffers: shared hit=2
74. 0.026 0.026 ↑ 1.0 98 1

Seq Scan on asset.copy_location (cost=0.00..2.98 rows=98 width=53) (actual time=0.003..0.026 rows=98 loops=1)

  • Output: copy_location.name, copy_location.id, copy_location.owning_lib, copy_location.holdable, copy_location.hold_verify, copy_location.opac_visible, copy_location.circulate, copy_location.label_prefix, copy_location.label_suffix, copy_location.checkin_alert, copy_location.deleted, copy_location.url
  • Buffers: shared hit=2
75. 13,786.877 13,878.392 ↓ 1.0 671,663 374

Materialize (cost=0.00..19,994.52 rows=671,101 width=83) (actual time=0.000..37.108 rows=671,663 loops=374)

  • Output: cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey
  • Buffers: shared hit=9928
76. 91.515 91.515 ↓ 1.0 671,663 1

Seq Scan on asset.call_number cn (cost=0.00..16,639.01 rows=671,101 width=83) (actual time=0.003..91.515 rows=671,663 loops=1)

  • Output: cn.id, cn.creator, cn.create_date, cn.editor, cn.edit_date, cn.record, cn.owning_lib, cn.label, cn.deleted, cn.prefix, cn.suffix, cn.label_class, cn.label_sortkey
  • Buffers: shared hit=9928
77. 2.225 2.244 ↑ 1.0 73 374

Materialize (cost=0.00..2.09 rows=73 width=13) (actual time=0.001..0.006 rows=73 loops=374)

  • Output: acnp.label, acnp.id
  • Buffers: shared hit=1
78. 0.019 0.019 ↑ 1.0 73 1

Seq Scan on asset.call_number_prefix acnp (cost=0.00..1.73 rows=73 width=13) (actual time=0.005..0.019 rows=73 loops=1)

  • Output: acnp.label, acnp.id
  • Buffers: shared hit=1
79. 0.370 0.374 ↑ 1.0 2 374

Materialize (cost=0.00..1.03 rows=2 width=11) (actual time=0.000..0.001 rows=2 loops=374)

  • Output: acns.label, acns.id
  • Buffers: shared hit=1
80. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on asset.call_number_suffix acns (cost=0.00..1.02 rows=2 width=11) (actual time=0.002..0.004 rows=2 loops=1)

  • Output: acns.label, acns.id
  • Buffers: shared hit=1
81. 1.870 16.456 ↑ 1.0 1 374

Limit (cost=2.45..2.46 rows=1 width=61) (actual time=0.044..0.044 rows=1 loops=374)

  • Output: hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time
  • Buffers: shared hit=1389
82. 6.358 14.586 ↑ 1.0 1 374

Sort (cost=2.45..2.46 rows=1 width=61) (actual time=0.039..0.039 rows=1 loops=374)

  • Output: hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time
  • Sort Key: hold_transit_copy.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1389
83. 8.228 8.228 ↑ 1.0 1 374

Index Scan using hold_transit_copy_hold_idx on action.hold_transit_copy (cost=0.42..2.44 rows=1 width=61) (actual time=0.022..0.022 rows=1 loops=374)

  • Output: hold_transit_copy.id, hold_transit_copy.source_send_time, hold_transit_copy.dest_recv_time, hold_transit_copy.target_copy, hold_transit_copy.source, hold_transit_copy.dest, hold_transit_copy.prev_hop, hold_transit_copy.copy_status, hold_transit_copy.persistant_transfer, hold_transit_copy.prev_dest, hold_transit_copy.hold, hold_transit_copy.cancel_time
  • Index Cond: (h.id = hold_transit_copy.hold)
  • Buffers: shared hit=1389
84. 3.366 5.984 ↑ 1.0 1 374

Aggregate (cost=1.04..1.05 rows=1 width=0) (actual time=0.016..0.016 rows=1 loops=374)

  • Output: count(*)
  • Buffers: shared hit=374
85. 2.618 2.618 ↓ 0.0 0 374

Seq Scan on action.hold_request_note (cost=0.00..1.04 rows=1 width=0) (actual time=0.007..0.007 rows=0 loops=374)

  • Output: hold_request_note.id, hold_request_note.hold, hold_request_note.title, hold_request_note.body, hold_request_note.slip, hold_request_note.pub, hold_request_note.staff
  • Filter: ((hold_request_note.pub OR hold_request_note.staff) AND (h.id = hold_request_note.hold))
  • Rows Removed by Filter: 3
  • Buffers: shared hit=374
86. 1.870 6.358 ↑ 1.0 1 374

Aggregate (cost=2.45..2.46 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=374)

  • Output: count(*), max(hold_notification.notify_time)
  • Buffers: shared hit=1469
87. 4.488 4.488 ↑ 1.0 1 374

Index Scan using ahn_hold_idx on action.hold_notification (cost=0.42..2.44 rows=1 width=8) (actual time=0.011..0.012 rows=1 loops=374)

  • Output: hold_notification.id, hold_notification.hold, hold_notification.notify_staff, hold_notification.notify_time, hold_notification.method, hold_notification.note
  • Index Cond: (h.id = hold_notification.hold)
  • Buffers: shared hit=1469
88. 8.602 17.952 ↑ 1.0 1 374

Aggregate (cost=4.17..4.18 rows=1 width=33) (actual time=0.048..0.048 rows=1 loops=374)

  • Output: first(display_entry.value)
  • Buffers: shared hit=1784
89. 9.350 9.350 ↑ 1.0 1 374

Index Scan using metabib_display_entry_source_idx on metabib.display_entry (cost=0.43..3.92 rows=1 width=33) (actual time=0.022..0.025 rows=1 loops=374)

  • Output: display_entry.id, display_entry.source, display_entry.field, display_entry.value
  • Index Cond: (display_entry.source = r.bib_record)
  • Filter: (display_entry.field = t_field.field)
  • Rows Removed by Filter: 29
  • Buffers: shared hit=1784
90. 2.992 7.480 ↑ 1.0 1 374

Aggregate (cost=4.17..4.18 rows=1 width=33) (actual time=0.020..0.020 rows=1 loops=374)

  • Output: first(display_entry_1.value)
  • Buffers: shared hit=1779
91. 4.488 4.488 ↑ 1.0 1 374

Index Scan using metabib_display_entry_source_idx on metabib.display_entry display_entry_1 (cost=0.43..3.92 rows=1 width=33) (actual time=0.011..0.012 rows=1 loops=374)

  • Output: display_entry_1.id, display_entry_1.source, display_entry_1.field, display_entry_1.value
  • Index Cond: (display_entry_1.source = r.bib_record)
  • Filter: (display_entry_1.field = a_field.field)
  • Rows Removed by Filter: 30
  • Buffers: shared hit=1779
92. 52.360 52.360 ↓ 0.0 0 374

Function Scan on actor.org_unit_ancestor_setting default_estimated_wait_interval (cost=0.25..0.26 rows=1 width=32) (actual time=0.140..0.140 rows=0 loops=374)

  • Output: default_estimated_wait_interval.id, default_estimated_wait_interval.org_unit, default_estimated_wait_interval.name, default_estimated_wait_interval.value
  • Function Call: actor.org_unit_ancestor_setting('circ.holds.default_estimated_wait_interval'::text, u.home_ou)
  • Buffers: shared hit=3366
93. 27.676 27.676 ↓ 0.0 0 374

Function Scan on actor.org_unit_ancestor_setting min_estimated_wait_interval (cost=0.25..0.26 rows=1 width=32) (actual time=0.074..0.074 rows=0 loops=374)

  • Output: min_estimated_wait_interval.id, min_estimated_wait_interval.org_unit, min_estimated_wait_interval.name, min_estimated_wait_interval.value
  • Function Call: actor.org_unit_ancestor_setting('circ.holds.min_estimated_wait_interval'::text, u.home_ou)
  • Buffers: shared hit=3366
94. 26.928 26.928 ↑ 1.0 1 374

Function Scan on actor.org_unit_ancestor_setting hold_wait_time (cost=0.25..0.26 rows=1 width=32) (actual time=0.072..0.072 rows=1 loops=374)

  • Output: hold_wait_time.id, hold_wait_time.org_unit, hold_wait_time.name, hold_wait_time.value
  • Function Call: actor.org_unit_ancestor_setting('circ.hold_shelf_status_delay'::text, h.pickup_lib)
  • Buffers: shared hit=3366
95. 10.846 34.782 ↑ 1.0 1 374

Aggregate (cost=18.74..18.75 rows=1 width=20) (actual time=0.093..0.093 rows=1 loops=374)

  • Output: count(*), count(DISTINCT m.hold), sum(date_part('epoch'::text, COALESCE(cm.avg_wait_time, (COALESCE(NULLIF(btrim(default_estimated_wait_interval.value, '"'::text), ''::text), '0 seconds'::text))::interval)))
  • Buffers: shared hit=9582 dirtied=2
96. 2.399 23.936 ↑ 1.3 3 374

Nested Loop Left Join (cost=0.97..18.66 rows=4 width=20) (actual time=0.038..0.064 rows=3 loops=374)

  • Output: m.hold, cm.avg_wait_time
  • Buffers: shared hit=9582 dirtied=2
97. 1.514 17.952 ↑ 1.3 3 374

Nested Loop (cost=0.84..18.00 rows=4 width=9) (actual time=0.028..0.048 rows=3 loops=374)

  • Output: m.hold, cp_2.circ_modifier
  • Buffers: shared hit=7192 dirtied=2
98. 4.488 4.488 ↑ 1.3 3 374

Index Only Scan using copy_once_per_hold on action.hold_copy_map m (cost=0.41..2.49 rows=4 width=12) (actual time=0.011..0.012 rows=3 loops=374)

  • Output: m.hold, m.target_copy
  • Index Cond: (m.hold = h.id)
  • Heap Fetches: 147
  • Buffers: shared hit=1211 dirtied=1
99. 2.390 11.950 ↑ 2.0 1 1,195

Append (cost=0.42..3.86 rows=2 width=26) (actual time=0.007..0.010 rows=1 loops=1,195)

  • Buffers: shared hit=5981 dirtied=1
100. 8.365 8.365 ↑ 1.0 1 1,195

Index Scan using copy_pkey on asset.copy cp_2 (cost=0.42..2.45 rows=1 width=13) (actual time=0.007..0.007 rows=1 loops=1,195)

  • Output: cp_2.id, cp_2.circ_modifier
  • Index Cond: (cp_2.id = m.target_copy)
  • Buffers: shared hit=4786 dirtied=1
101. 1.195 1.195 ↓ 0.0 0 1,195

Index Scan using unit_pkey on serial.unit cp_3 (cost=0.14..1.42 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1,195)

  • Output: cp_3.id, cp_3.circ_modifier
  • Index Cond: (cp_3.id = m.target_copy)
  • Buffers: shared hit=1195
102. 3.585 3.585 ↑ 1.0 1 1,195

Index Scan using circ_modifier_pkey on config.circ_modifier cm (cost=0.14..0.15 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=1,195)

  • Output: cm.code, cm.name, cm.description, cm.sip2_media_type, cm.magnetic_media, cm.avg_wait_time
  • Index Cond: (cp_2.circ_modifier = cm.code)
  • Buffers: shared hit=2390
Planning time : 16.112 ms
Execution time : 68,678.310 ms