Usually, most pressure comes onto a player when he is in a huge game or when he has had issues off the field.
In the Super Bowl, this is when players take advantage of the big stage and play their guts out. Take, for example, Drew Brees from last year's Super Bowl. He had a fantastic game.
Here is a list of the top 10 performances in the Super Bowl in the last 10 years.