Me(CO) $460.60 - VP:15 PFR:11 AF:1.7 W:67|100 STL:50|0 3B:9|0 CB:50| Hands:27
P6(BB) $327.76 - VP:67 PFR:33 AF:2.5 W:0| STL:|0 3B:25|0 CB:67|100 Hands:9


Pre Flop: Me(CO) with [Qc,Qs]
P8(UTG) folds, P9(MP) folds, P1(LP) folds, Me(CO) raises 12, P3(BTN) folds, P5(SB) folds, P6(BB) calls 8


Flop: (4c,6d,Qh) (2 players)
P6(BB) checks, Me(LP) checks


Turn: 9s (2 players)
P6(BB) bets 13, Me(LP) raises 45, P6(BB) calls 32


River: Ad (2 players)
P6(BB) bets 38, Me(LP) raises 230, P6(BB) folds


Final:
Returns 192 to Me(CO)
Me(CO) wins 188

Was my river raise too big? In the moment my first instinct was to make it around 150, but my next thought was if he would call 150 he would most likely call for more. He'd probably wouldn't fold a set, but it seemed fairly unlikely he had one given his small river bet.

Should I have made it around 100 or even less for a higher chance to get looked up by what was most likely AQ?

You block AQ with your QQQ.
When he donks river A, id be happy doing 230 too tbh. He has many hands in his range that would call a size like this often.