Thoughts...
So, look at the attitude of the psalmist, David. He is secure in having God rule over him. Though David was a king, he was not frustrated by God's sovereign rule...(though I don't know if David was a king when he wrote this psalm). The oversight of God seems to be a comfort and a joy to David. That attitude is reminiscent of a child, in the care of a loving parent; a child as we are called to be.
He has no worry about the future...He is confident that God will keep him from destruction.
He has the assurance of God's constant presence, as he notes that God is at his right hand, and God counsels him in the nighttime.
If as he states, God is his refuge, then God is a surrounding, safe, presence and David is aware of this presence in all situations.
To be aware of God in all things means viewing life, in each situation, with the knowledge that He is there with us, is present in us, using us for His purposes. This is a challenge for each of us. The prayer would seem to be to ask God to keep us sensitve to Him, with ears to hear Him when He speaks.