| Sort (cost=11.10..11.12 rows=5 width=24) |
| Sort Key: g.sort |
| -> Group (cost=11.01..11.05 rows=5 width=24) |
| Group Key: g.id |
| -> Sort (cost=11.01..11.03 rows=7 width=20) |
| Sort Key: g.id |
| -> Hash Join (cost=9.24..10.91 rows=7 width=20) |
| Hash Cond: (sgr.group_id = g.id) |
| -> Hash Join (cost=8.10..9.74 rows=8 width=4) |
| Hash Cond: (sgr.sales_id = tbl_users.id) |
| -> Seq Scan on tbl_sales_group_relationships sgr (cost=0.00..1.51 rows=51 width=8) |
| -> Hash (cost=7.80..7.80 rows=24 width=4) |
| -> Seq Scan on tbl_users (cost=0.00..7.80 rows=24 width=4) |
| Filter: (user_status = '1'::type_global_user_status) |
| -> Hash (cost=1.07..1.07 rows=5 width=20) |
| -> Seq Scan on tbl_groups g (cost=0.00..1.07 rows=5 width=20) |
| Filter: (id <> 999999) |