Unique  (cost=40718.88..42973.33 rows=8198 width=2601)
   ->  Sort  (cost=40718.88..40739.37 rows=8198 width=2601)
         Sort Key: orders.id, orders.customer_id, orders.created_at, orders.updated_at, orders.campaign_id, orders.sent_at, orders.return_at, orders.return_status, orders.return_description, orders.refund_at, orders.refund_amount_cents, orders.upload_id, orders.order_date, orders.tracking, orders.shipping_request_at, orders.total_cents, orders.grandtotal_cents, orders.state, orders.confirmation_letter_at, orders.temp_paid, orders.temp_refund, orders.payment_state, customers.created_at, customers.updated_at, customers.origin_id, customers.origin_type, customers.has_been_checked_for_duplicates, customers.customer_duplicates_count, customers.status, customers.description, customers.blacklist_reporter_id, customers.agent, customers.active_agent, customers.blacklisted_at, customers.deleted_at, customers.details, customers.identification_number, customers.current_balance_cents, customers.origin_customer_id, products.id, products.name, products.created_at, products.updated_at, products.price_cents, products.campaign_id, products.created_by, products.description, products.vat, products.purchase_price_cents, products.length, products.width, products.depth, products.weight, products.category_id, campaigns.id, campaigns.publication_name, campaigns.code, campaigns.start_at, campaigns.active_cc_operator, campaigns.created_at, campaigns.updated_at, campaigns.circulation, campaigns.concept, campaigns.cost_cents, campaigns.tr_sent, campaigns.bep, campaigns.gross_margin, campaigns.campaign_type, campaigns.campaign_customer_origin, campaigns.delivery_charge_cents, campaigns.active_operator, campaigns.business_unit_id, campaigns.parent_campaign_id, campaigns.tr_group, campaigns.publication_id, campaigns.type, campaigns.temp_catalog_id, campaigns.catalog_id, campaigns.payment_type, campaigns.forecast, gifts.id, gifts.campaign_id, gifts.product_id, gifts.quantity, gifts.created_at, gifts.updated_at, gifts_orders.id, gifts_orders.campaign_id, gifts_orders.product_id, gifts_orders.quantity, gifts_orders.created_at, gifts_orders.updated_at, products_gifts.id, products_gifts.name, products_gifts.created_at, products_gifts.updated_at, products_gifts.price_cents, products_gifts.campaign_id, products_gifts.created_by, products_gifts.description, products_gifts.vat, products_gifts.purchase_price_cents, products_gifts.length, products_gifts.width, products_gifts.depth, products_gifts.weight, products_gifts.category_id
         ->  Hash Join  (cost=3166.89..30966.97 rows=8198 width=2601)
               Hash Cond: (orders.id = line_items.order_id)
               ->  Hash Left Join  (cost=1840.85..28859.88 rows=139814 width=2601)
                     Hash Cond: (gifts_orders.product_id = products_gifts.id)
                     ->  Hash Left Join  (cost=1829.64..26926.23 rows=139814 width=2481)
                           Hash Cond: (orders.campaign_id = campaigns.id)
                           ->  Hash Left Join  (cost=1734.88..25023.49 rows=81967 width=2293)
                                 Hash Cond: (orders.campaign_id = campaigns_orders_join.id)
                                 ->  Hash Left Join  (cost=1640.11..23868.78 rows=48054 width=2261)
                                       Hash Cond: (line_items_orders_join.product_id = products.id)
                                       ->  Hash Left Join  (cost=1628.90..23196.83 rows=48054 width=2145)
                                             Hash Cond: (orders.id = line_items_orders_join.order_id)
                                             ->  Merge Join  (cost=0.68..19284.30 rows=23656 width=2141)
                                                   Merge Cond: (orders.customer_id = customers.id)
                                                   ->  Index Scan using index_orders_on_customer_id on orders  (cost=0.29..2400.46 rows=23656 width=220)
                                                   ->  Index Scan using customers_pkey on customers  (cost=0.29..16984.99 rows=96230 width=1921)
                                                         Filter: ((type)::text = 'VietnameseCustomer'::text)
                                             ->  Hash  (cost=1027.54..1027.54 rows=48054 width=8)
                                                   ->  Seq Scan on line_items line_items_orders_join  (cost=0.00..1027.54 rows=48054 width=8)
                                       ->  Hash  (cost=7.76..7.76 rows=276 width=120)
                                             ->  Seq Scan on products  (cost=0.00..7.76 rows=276 width=120)
                                 ->  Hash  (cost=78.39..78.39 rows=1310 width=36)
                                       ->  Hash Right Join  (cost=37.28..78.39 rows=1310 width=36)
                                             Hash Cond: (gifts_orders.campaign_id = campaigns_orders_join.id)
                                             ->  Seq Scan on gifts gifts_orders  (cost=0.00..23.10 rows=1310 width=32)
                                             ->  Hash  (cost=27.68..27.68 rows=768 width=4)
                                                   ->  Seq Scan on campaigns campaigns_orders_join  (cost=0.00..27.68 rows=768 width=4)
                           ->  Hash  (cost=78.39..78.39 rows=1310 width=188)
                                 ->  Hash Right Join  (cost=37.28..78.39 rows=1310 width=188)
                                       Hash Cond: (gifts.campaign_id = campaigns.id)
                                       ->  Seq Scan on gifts  (cost=0.00..23.10 rows=1310 width=32)
                                       ->  Hash  (cost=27.68..27.68 rows=768 width=156)
                                             ->  Seq Scan on campaigns  (cost=0.00..27.68 rows=768 width=156)
                     ->  Hash  (cost=7.76..7.76 rows=276 width=120)
                           ->  Seq Scan on products products_gifts  (cost=0.00..7.76 rows=276 width=120)
               ->  Hash  (cost=1308.69..1308.69 rows=1387 width=4)
                     ->  Hash Join  (cost=87.08..1308.69 rows=1387 width=4)
                           Hash Cond: (line_items.id = batch_line_items.line_item_id)
                           ->  Seq Scan on line_items  (cost=0.00..1027.54 rows=48054 width=8)
                           ->  Hash  (cost=69.74..69.74 rows=1387 width=4)
                                 ->  Index Scan using index_batch_line_items_on_document_id on batch_line_items  (cost=0.29..69.74 rows=1387 width=4)
                                       Index Cond: (document_id = 2439)