QUERY PLAN
Aggregate (cost=53.06..53.07 rows=1 width=8)
-> Sort (cost=53.00..53.01 rows=4 width=371)
Sort Key: (min(CASE WHEN (1 = r.verify_type) THEN CASE WHEN (rvr.status = 0) THEN 1 WHEN (rsvr.status = 0) THEN 2 ELSE 4 END ELSE CASE WHEN ((rvr.status = 0) AND (r.next_verify_user = 1001)) THEN 1 WHEN ((rsvr.status = 0) AND (r.next_stop_verify_user = 1001)) THEN 2 ELSE 4 END END)), r.created_at DESC
-> GroupAggregate (cost=52.76..52.96 rows=4 width=371)
Group Key: r.id
-> Merge Left Join (cost=52.76..52.83 rows=4 width=30)
Merge Cond: (r.id = rsvr.erp_sales_outbound_id)
-> Sort (cost=51.59..51.60 rows=4 width=26)
Sort Key: r.id
-> Hash Right Join (cost=40.67..51.55 rows=4 width=26)
Hash Cond: (epop.erp_sales_outbound_id = r.id)
-> Seq Scan on tbl_erp_sales_outbound_products epop (cost=0.00..9.25 rows=425 width=8)
-> Hash (cost=40.64..40.64 rows=2 width=26)
-> Hash Right Join (cost=30.20..40.64 rows=2 width=26)
Hash Cond: (rvr.erp_sales_outbound_id = r.id)
Filter: ((client.sales_rep = 1001) OR (r.created_by = 1001) OR (rvr.user_id = 1001) OR (r.created_by = ANY ('{1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1025,1026,1027,1028,1029,1030,5015,5016,5022,5023,5024,5025,5026,5027,5028,5029,5030,5031,5032,5033,5037,5043,5044,5045,5047,5048,5049,5050,5062,5063,5064,5065,5066,5069,5070,5071,5072,5073,5074,5075,5076,5078,5079,5080,5081,5082,5083,5085,5086,5087,5088,5089,5093,5094,5095,5096,5101,5102,5104,5105,5123,5124,5125,5126,5128,5135,5203,5208,5209,5229,5230,5247,5248,5249,5250,5252,5258,5259,5293,5294,5295,5296,5297,5298,5299,5300,5301,5302,5303,5304,5305,5309,5311,5329,5332,5333,5351,5356,5357,5358,5359,5360,5364,5388,5393,5404,5409,5411,5412,5413,5419,5420,5440,5445,5446,5448,5449,5461,5467,5476,5497,5499,5500}'::integer[])))
-> Seq Scan on tbl_erp_sales_outbound_verify_rels rvr (cost=0.00..8.39 rows=439 width=12)
-> Hash (cost=30.19..30.19 rows=1 width=30)
-> Nested Loop Left Join (cost=16.31..30.19 rows=1 width=30)
-> Nested Loop (cost=16.03..27.86 rows=1 width=30)
-> Hash Join (cost=15.89..27.64 rows=1 width=4)
Hash Cond: ("spentProduct".erp_inventory_product_id = tbl_erp_inventory_products.id)
-> Seq Scan on tbl_erp_sales_outbound_spent_products "spentProduct" (cost=0.00..10.34 rows=534 width=8)
-> Hash (cost=15.88..15.88 rows=1 width=4)
-> Seq Scan on tbl_erp_inventory_products (cost=0.00..15.88 rows=1 width=4)
Filter: (erp_purchase_inbound_id = 220)
-> Index Scan using tbl_erp_sales_outbounds_pkey on tbl_erp_sales_outbounds r (cost=0.14..0.22 rows=1 width=30)
Index Cond: (id = "spentProduct".erp_sales_outbound_id)
Filter: ((status <> 0) OR ((status = 0) AND (created_by = 1001)))
-> Index Scan using tbl_clients_pkey on tbl_clients client (cost=0.28..2.33 rows=1 width=8)
Index Cond: (id = r.client_id)
-> Sort (cost=1.17..1.19 rows=7 width=8)
Sort Key: rsvr.erp_sales_outbound_id
-> Seq Scan on tbl_erp_sales_outbound_stop_verify_rels rsvr (cost=0.00..1.07 rows=7 width=8)