>Is it normal that to show this view it takes 5 seconds.
It could well be normal even if fully optimized or partial with no deleted() tag (often no deleted tag is faster, and why Cetin recommended it). But SQL with that many tables and joins can be slow no matter what.
The solution for this is to break up the SQL into 2 or 3 parts. Usually, with a little testing of different SQL split-ups, you can improve performance, sometimes very impressively.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.