[ADMIN] Sub SELECTS

[Waruna Geekiyanage]

I have a select query with 2 sub selects. When I run that query CPU usage goes to 98% for postgres. Does sub selects eat more resources and slower the queries? Is there any alternatives to sub selects?