An agony aunt is an advice columnist on a magazine. They answer readers' queries on personal problems, in particular giving advice about sexual problems. The image presented was originally of an older women providing comforting advice and maternal wisdom, hence the name "aunt".

Examples:

Author Terry Pratchett uses the term in quite another sense. It involves more of the word "agony".