QUERY PLAN
Sort (cost=46.95..46.98 rows=12 width=251)
Sort Key: a.user_id
-> Hash Join (cost=5.79..46.74 rows=12 width=251)
Hash Cond: ((a.item_name)::text = (b.name)::text)
-> Seq Scan on tbl_auth_assignments a (cost=0.00..40.59 rows=133 width=15)
Filter: (user_id = ANY ('{5258,5049,1000,5083,5301,1017,1018,5022,1028,5209,5030,5026,5293,5250,5298,5309,5016,1010,5356,5329,5074,1002,5065,5086,5080,1011,1019,5050,5299,5125,5101,5303,5302,5085,5332,5047,5419,1016,1026,5259,5028,1012,5249,5096,5070,5102,5063,5095,5420,5445,5082,5073,1029,1027,5446,1001,5037,5087,1008,5123,5048,5043,5094,5045,5230,5031,5088,5208,5305,5078,1003,5294,5357,5044,5024,5351,1030,5076,5135,5300,1007,5027,5089,5311,5029,5411,1021,1020,5066,5069,5079,5252,5364,5071,1009,5295,5248,1013,1015,5128,5404,5203,1025,5413,5023,5124,1022,5126,5032,5075,5388,5064,1004,5025,5105,5072,5081,5033,5062,5440,5359,5104,5360,5247,5393,5412,5409,5015,5229,1005,5304,5296,5358,1023,1006,5333,5297,1014,5093}'::integer[]))
-> Hash (cost=5.56..5.56 rows=18 width=247)
-> Seq Scan on tbl_auth_items b (cost=0.00..5.56 rows=18 width=247)
Filter: (type = 1)