Is your feature request related to a problem? Please describe.
Currently we are getting number of types from elasticsearch, but due to the changes of how we store the index (we use service as index instead of type as index), there is no simple approach to calculate/aggregate number of types of assets. Since we have a postgres as our main storage, we can leave elasticsearch purely for discovery and count the type from postgres as a source of truth.

Describe the solution you'd like
Fetching count of types from assets in postgres