The Psalmist asks god to stop him from doing evil, and begs him to let the righteous smite him. Death by cop? He says he doesn't care if his bones are scattered when he dies, because his eyes will be heavenward. And of course, he asks god to smite the wicked.
David is feeling neglected, but he's still crafty: he won't pray until god gets him out of whatever trouble he's in.
David is feeling persecuted and comforts himself by remembering the halcyon days of yore, when god actually spoke to him, and smote his enemies and so on.
Praise be to god for teaching us to fight in war! Christianity is a religion of peace, be damned. Anyway, the psalmist would like god's help in smiting a few enemies, just some volcanoes and lightening. Then he can sing to god to make everything hunky-dory.
God is slow to anger. Uh-huh. And he's nice to children and animals. Except Babylonian babies. He helps all that call out to him. This psalm is all propoganda.