QUERY PLAN
Aggregate (cost=1336.77..1336.78 rows=1 width=8)
-> GroupAggregate (cost=861.27..1336.38 rows=31 width=373)
Group Key: r.id
-> Nested Loop Left Join (cost=861.27..1335.99 rows=31 width=4)
Join Filter: (rvr.erp_purchase_order_id = r.id)
-> Merge Left Join (cost=861.27..862.82 rows=31 width=8)
Merge Cond: (r.id = epop.erp_purchase_order_id)
-> Sort (cost=837.67..837.74 rows=31 width=8)
Sort Key: r.id
-> Hash Right Join (cost=204.71..836.90 rows=31 width=8)
Hash Cond: (cs.object_id = c.id)
-> Seq Scan on tbl_attachement_relationships cs (cost=0.00..624.51 rows=2027 width=4)
Filter: (object_type = 108)
-> Hash (cost=204.33..204.33 rows=31 width=12)
-> Hash Right Join (cost=136.34..204.33 rows=31 width=12)
Hash Cond: (c.id = r.purchase_contract_id)
-> Seq Scan on tbl_purchase_contracts c (cost=0.00..60.13 rows=2013 width=4)
-> Hash (cost=135.95..135.95 rows=31 width=12)
-> Hash Right Join (cost=113.71..135.95 rows=31 width=12)
Hash Cond: (rvr.erp_purchase_order_id = r.id)
Filter: ((r.created_by = 5250) OR (rvr.user_id = 5250) 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}'::integer[])))
-> Seq Scan on tbl_erp_purchase_order_verify_rels rvr (cost=0.00..19.70 rows=970 width=8)
-> Hash (cost=113.18..113.18 rows=42 width=12)
-> Seq Scan on tbl_erp_purchase_orders r (cost=0.00..113.18 rows=42 width=12)
Filter: ((NOT inventory_status) AND (NOT is_done) AND (status = 2) AND ((status <> 0) OR ((status = 0) AND (created_by = 5250))))
-> Sort (cost=23.60..24.28 rows=270 width=8)
Sort Key: epop.erp_purchase_order_id
-> Seq Scan on tbl_erp_purchase_order_products epop (cost=0.00..12.70 rows=270 width=8)
-> Materialize (cost=0.00..24.55 rows=970 width=0)
-> Seq Scan on tbl_erp_purchase_order_stop_verify_rels rsvr (cost=0.00..19.70 rows=970 width=0)