IN GERMANY, are those guns in the holsters of their police officers just for show?

http://barenakedislam.com/2018/08/20/in-germany-are-those-guns-in-the-holsters-of-their-police-officers-just-for-show/