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