Nested Loop Left dd.id_databox_data dd.recipient_id dd.sender_id lp.business_name fa.repayment_identification act.perform_time dd.subject communication_act.subject d.unique_name s.name s.long_name lld.legal_template lld.issue_date act.perform_time dd.id_recipient_document_ident dd.id_sender_document_ident dci1.ref_number dci2.ref_number Nested Loop Outer Left dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name fa.repayment_identification lp.business_name dci1.ref_number Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name fa.repayment_identification lp.business_name Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name pr.id_source fa.repayment_identification (flight.id_portfolio = p.id_portfolio) Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name pr.id_source fa.repayment_identification flight.id_portfolio Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name pr.id_source fa.repayment_identification fa.id_flight Nested Loop Outer Left dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name r.id_accountability pr.id_source ((dd.recipient_id)::text = (party.data_box_id)::text) Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name r.id_accountability pr.id_source Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time s.name s.long_name r.id_responsible r.id_accountability Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time party_act.id_related_responsibility s.name s.long_name Nested Loop Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject act.perform_time act.id_solver party_act.id_related_responsibility Hash Join Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name lld.legal_template lld.issue_date communication_act.subject communication_act.id_act act.perform_time act.id_act act.id_solver (ld.id_letter_data = communication_act.id_letter_data) Hash Join Outer Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident d.unique_name fld.id_letter_data ld.id_letter_data lld.legal_template lld.issue_date lld.id_letter_data (dda.id_databox_data = dd.id_databox_data) Hash Join Outer Inner dda.id_databox_data d.unique_name fld.id_letter_data ld.id_letter_data lld.legal_template lld.issue_date lld.id_letter_data (da.id_databox_attachment = dda.id_databox_attachment) Hash Join Outer Inner da.id_databox_attachment d.unique_name fld.id_letter_data ld.id_letter_data lld.legal_template lld.issue_date lld.id_letter_data (lld.id_legal_instrument = li.id_legal_instrument) Hash Join Outer Inner da.id_databox_attachment d.unique_name fld.id_letter_data ld.id_letter_data lld.legal_template lld.issue_date lld.id_letter_data lld.id_legal_instrument (ld.id_letter_data = fld.id_letter_data) Seq Scan Outer letter_data public ld ld.id_letter_data Hash Inner da.id_databox_attachment d.unique_name fld.id_letter_data lld.legal_template lld.issue_date lld.id_letter_data lld.id_legal_instrument Hash Join Outer Inner da.id_databox_attachment d.unique_name fld.id_letter_data lld.legal_template lld.issue_date lld.id_letter_data lld.id_legal_instrument (lld.id_letter_data = fld.id_letter_data) Seq Scan Outer legal_letter_data public lld lld.legal_template lld.issue_date lld.id_letter_data lld.id_legal_instrument Hash Inner da.id_databox_attachment d.unique_name fld.id_letter_data Hash Join Outer Inner da.id_databox_attachment d.unique_name fld.id_letter_data (fld.id_document = d.id_document) Seq Scan Outer external_file_letter_data public fld fld.id_document fld.id_letter_data Hash Inner da.id_databox_attachment da.id_document d.unique_name d.id_document Hash Join Outer Inner da.id_databox_attachment da.id_document d.unique_name d.id_document (da.id_document = d.id_document) Seq Scan Outer databox_attachment public da da.id_databox_attachment da.id_document Hash Inner d.unique_name d.id_document Seq Scan Outer document public d d.unique_name d.id_document Hash Inner li.id_legal_instrument Seq Scan Outer legal_instrument public li li.id_legal_instrument Hash Inner dda.id_databox_data dda.id_databox_attachment Seq Scan Outer databox_data_attachments public dda dda.id_databox_data dda.id_databox_attachment Hash Inner dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident Seq Scan Outer databox_data public dd dd.id_databox_data dd.recipient_id dd.sender_id dd.subject dd.id_recipient_document_ident dd.id_sender_document_ident Hash Inner communication_act.subject communication_act.id_act communication_act.id_letter_data act.perform_time act.id_act act.id_solver Nested Loop Outer Inner communication_act.subject communication_act.id_act communication_act.id_letter_data act.perform_time act.id_act act.id_solver Bitmap Heap Scan Outer act public act act.id_act act.perform_time act.id_solved_task act.id_solver (act.id_solver = 41) (act.perform_time > ((now())::date - 1)) Bitmap Index Scan Outer idx_act_id_solver (act.id_solver = 41) Index Scan Inner NoMovement communication_act_pkey communication_act public communication_act communication_act.id_act communication_act.channel communication_act.direction communication_act.is_rpc communication_act.id_used_contact_entry communication_act.id_letter_data communication_act.id_returned_mail_notification communication_act.subject communication_act.id_erased_act (communication_act.id_act = act.id_act) Index Scan Inner NoMovement party_act_pkey party_act public party_act party_act.id_act party_act.id_party party_act.id_related_responsibility (party_act.id_act = communication_act.id_act) Seq Scan Inner solver public s s.id_solver s.name s.long_name (s.id_solver = 41) Index Scan Inner NoMovement responsibility_pkey responsibility public r r.id_responsibility r.id_accountability r.id_responsible (r.id_responsibility = party_act.id_related_responsibility) Index Scan Inner NoMovement party_pkey party public pr pr.id_party pr.id_mailing_address pr.id_residential_address pr.id_source pr.external_id pr.id_jurisdiction_country pr.data_box_id (pr.id_party = r.id_responsible) Nested Loop Inner Inner party.data_box_id Seq Scan Outer authority public authority authority.id_party authority.id_bank_account authority.name Index Scan Inner NoMovement party_pkey party public party party.id_party party.id_mailing_address party.id_residential_address party.id_source party.external_id party.id_jurisdiction_country party.data_box_id (party.id_party = authority.id_party) Index Scan Inner NoMovement financial_accountability_pkey financial_accountability public fa fa.id_accountability fa.id_current_promise fa.repayment_identification fa.id_repayment_account fa.exists_unknown_manual_suit fa.id_flight fa.id_installment_agreement fa.is_written_off (fa.id_accountability = r.id_accountability) Index Scan Inner NoMovement flight_pkey flight public flight flight.id_flight flight.purchase_date flight.project_code flight.id_portfolio flight.id_attorney (flight.id_flight = fa.id_flight) Seq Scan Inner portfolio public p p.id_portfolio p.code p.name Index Scan Inner NoMovement legal_person_pkey legal_person public lp lp.id_party lp.business_name lp.registration_number (lp.id_party = pr.id_source) Index Scan Inner NoMovement databox_document_ident_pkey databox_document_ident public dci1 dci1.id_databox_document_ident dci1.ident dci1.ref_number (dd.id_recipient_document_ident = dci1.id_databox_document_ident) Index Scan Inner NoMovement databox_document_ident_pkey databox_document_ident public dci2 dci2.id_databox_document_ident dci2.ident dci2.ref_number (dd.id_recipient_document_ident = dci2.id_databox_document_ident)