How to improve performance under complex permission rules.

[ryicoh]

As the title says, I am facing a performance problem.

Even if query is simple like here, execution plan cost is too high(1886261.79..1886261.80)

query SimpleQuery {
  SubTask(limit: 10) {
    name
    body
    id
    SubTaskAssignees{
      User {
          name
        }
    }
    Task {
      name
      TaskAssignees{
        User {
          name
        }
        
      }
    }
  }
}

# HTTP Header: x-hasura-user-id=99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8, x-hasura-role=user
# Aggregate  (cost=1886261.79..1886261.80 rows=1 width=32)

Below repository includes simple code for reproducing the problem.

https://github.com/ryicoh/hasura-perf

I know the cause is many permission rules.
A execution plan cost without permission is lower(1089.21..1089.22).

Does anyone know a solution to the problem?

[0x777]

@ryicoh Thanks for sharing this. We are planning on some improvements to query generation when fetching relationships to remove permission rules when they are already enforced through the join condition. I'll try and reproduce your example and get back to you.

[ryicoh]

remove permission rules when they are already enforced through the join condition.

This is a good solution.
Alternatively, It might also be a good to configure Hasura Console to apply the rules to other tables. It is easier than generating query automatically.

e.g.

user: {"id": {"_eq": "x-hasura-user-id"}}
user->task: {"user": {"id": {"_eq": "x-hasura-user-id"}}}
↓
user: {"id": {"_eq": "x-hasura-user-id"}}
user->task: {"_has_permisson": "user"}

_has_permisson means that applying the permission rule of relationship table.

I'll try and reproduce your example and get back to you.

Thanks!
I'd like to give additional information, If you want.

[0x777]

@ryicoh Can you try your queries on this build: hasurabuild/graphql-engine:mono-pr-3362-8cd5313f9. This introduces the optimization that I was talking about earlier.

[ryicoh]

I tried the build hasurabuild/graphql-engine:mono-pr-3362-8cd5313f9 and compared it to hasura/graphql-engine:v2.0.10. cost
As it turns out, the execution cost has improved about 10%!

image	cost
hasura/graphql-engine:v2.0.10	1886261
hasurabuild/graphql-engine:mono-pr-3362-8cd5313f9	1718600

Below log is the execution plan and the query I used

• hasura/graphql-engine:v2.0.10

Aggregate  (cost=1886261.79..1886261.80 rows=1 width=32)
  ->  Limit  (cost=171606.34..1886261.66 rows=10 width=32)
        ->  Nested Loop Left Join  (cost=171606.34..74759112.82 rows=435 width=32)
              ->  Nested Loop Left Join  (cost=79848.90..34844607.11 rows=435 width=112)
                    ->  Seq Scan on "SubTask"  (cost=0.00..68844.40 rows=435 width=96)
                          Filter: ((alternatives: SubPlan 14 or hashed SubPlan 27) OR (alternatives: SubPlan 28 or hashed SubPlan 29))
                          SubPlan 14
                            ->  Index Scan using "Task_pkey" on "Task" "_0__be_0_Task"  (cost=0.15..95.47 rows=1 width=0)
                                  Index Cond: (id = "SubTask".task_id)
                                  Filter: ((alternatives: SubPlan 6 or hashed SubPlan 11) OR (alternatives: SubPlan 12 or hashed SubPlan 13))
                                  SubPlan 6
                                    ->  Index Scan using "Project_pkey" on "Project" "_1__be_1_Project"  (cost=0.15..64.10 rows=1 width=0)
                                          Index Cond: (id = "_0__be_0_Task".project_id)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 2 or hashed SubPlan 3)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 4 or hashed SubPlan 5)))
                                          SubPlan 2
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 3
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_1".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_1".organization_id)
                                          SubPlan 4
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 5
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 11
                                    ->  Seq Scan on "Project" "_1__be_1_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 7 or hashed SubPlan 8)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 9 or hashed SubPlan 10)))
                                          SubPlan 7
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project_1".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 8
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_3".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_3".organization_id)
                                          SubPlan 9
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 10
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 12
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                          Filter: ((task_id = "_0__be_0_Task".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 13
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 27
                            ->  Seq Scan on "Task" "_0__be_0_Task_1"  (cost=0.00..50651.25 rows=435 width=16)
                                  Filter: ((alternatives: SubPlan 19 or hashed SubPlan 24) OR (alternatives: SubPlan 25 or hashed SubPlan 26))
                                  SubPlan 19
                                    ->  Index Scan using "Project_pkey" on "Project" "_1__be_1_Project_2"  (cost=0.15..64.10 rows=1 width=0)
                                          Index Cond: (id = "_0__be_0_Task_1".project_id)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 15 or hashed SubPlan 16)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 17 or hashed SubPlan 18)))
                                          SubPlan 15
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_4"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project_2".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_4"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project_2".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 16
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_5".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_5"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_5"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_5".organization_id)
                                          SubPlan 17
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_4"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project_2".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 18
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_5"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 24
                                    ->  Seq Scan on "Project" "_1__be_1_Project_3"  (cost=0.00..32458.10 rows=6 width=16)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 20 or hashed SubPlan 21)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 22 or hashed SubPlan 23)))
                                          SubPlan 20
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_6"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project_3".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_6"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project_3".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 21
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_7".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_7"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_7"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_7".organization_id)
                                          SubPlan 22
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_6"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project_3".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 23
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_7"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 25
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee_2"  (cost=0.00..23.20 rows=1 width=0)
                                          Filter: ((task_id = "_0__be_0_Task_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 26
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee_3"  (cost=0.00..21.00 rows=4 width=16)
                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 28
                            ->  Seq Scan on "SubTaskAssignee" "_6__be_6_SubTaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                  Filter: ((sub_task_id = "SubTask".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                          SubPlan 29
                            ->  Seq Scan on "SubTaskAssignee" "_6__be_6_SubTaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                    ->  Nested Loop Left Join  (cost=79848.90..79944.26 rows=1 width=32)
                          ->  Index Scan using "Task_pkey" on "Task"  (cost=0.15..95.47 rows=1 width=48)
                                Index Cond: (id = "SubTask".task_id)
                                Filter: ((alternatives: SubPlan 35 or hashed SubPlan 40) OR (alternatives: SubPlan 41 or hashed SubPlan 42))
                                SubPlan 35
                                  ->  Index Scan using "Project_pkey" on "Project" "_8__be_0_Project"  (cost=0.15..64.10 rows=1 width=0)
                                        Index Cond: (id = "Task".project_id)
                                        Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 31 or hashed SubPlan 32)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 33 or hashed SubPlan 34)))
                                        SubPlan 31
                                          ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                      Index Cond: (id = "_8__be_0_Project".organization_id)
                                                ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                      Filter: ((organization_id = "_8__be_0_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                        SubPlan 32
                                          ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                      Group Key: "_10__be_2_OrganizationMember_1".organization_id
                                                      ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                            Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                      Index Cond: (id = "_10__be_2_OrganizationMember_1".organization_id)
                                        SubPlan 33
                                          ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                Filter: ((project_id = "_8__be_0_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                        SubPlan 34
                                          ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                SubPlan 40
                                  ->  Seq Scan on "Project" "_8__be_0_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                        Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 36 or hashed SubPlan 37)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 38 or hashed SubPlan 39)))
                                        SubPlan 36
                                          ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                      Index Cond: (id = "_8__be_0_Project_1".organization_id)
                                                ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                      Filter: ((organization_id = "_8__be_0_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                        SubPlan 37
                                          ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                      Group Key: "_10__be_2_OrganizationMember_3".organization_id
                                                      ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                            Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                      Index Cond: (id = "_10__be_2_OrganizationMember_3".organization_id)
                                        SubPlan 38
                                          ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                Filter: ((project_id = "_8__be_0_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                        SubPlan 39
                                          ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                SubPlan 41
                                  ->  Seq Scan on "TaskAssignee" "_12__be_4_TaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                        Filter: ((task_id = "Task".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                SubPlan 42
                                  ->  Seq Scan on "TaskAssignee" "_12__be_4_TaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          ->  Aggregate  (cost=79848.75..79848.76 rows=1 width=32)
                                ->  Nested Loop Left Join  (cost=0.15..79848.72 rows=2 width=32)
                                      ->  Seq Scan on "TaskAssignee"  (cost=0.00..79700.29 rows=2 width=16)
                                            Filter: (("Task".id = task_id) AND ((alternatives: SubPlan 49 or hashed SubPlan 54) OR (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)))
                                            SubPlan 49
                                              ->  Nested Loop  (cost=0.30..90.54 rows=1 width=0)
                                                    ->  Index Scan using "Task_pkey" on "Task" "_14__be_0_Task"  (cost=0.15..8.17 rows=1 width=16)
                                                          Index Cond: (id = "TaskAssignee".task_id)
                                                    ->  Index Scan using "Project_pkey" on "Project" "_15__be_1_Project"  (cost=0.15..64.10 rows=1 width=16)
                                                          Index Cond: (id = "_14__be_0_Task".project_id)
                                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 45 or hashed SubPlan 46)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 47 or hashed SubPlan 48)))
                                                          SubPlan 45
                                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                                        Index Cond: (id = "_15__be_1_Project".organization_id)
                                                                  ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                                        Filter: ((organization_id = "_15__be_1_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                          SubPlan 46
                                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                        Group Key: "_17__be_3_OrganizationMember_1".organization_id
                                                                        ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                                        Index Cond: (id = "_17__be_3_OrganizationMember_1".organization_id)
                                                          SubPlan 47
                                                            ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                                  Filter: ((project_id = "_15__be_1_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                          SubPlan 48
                                                            ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                            SubPlan 54
                                              ->  Nested Loop  (cost=0.00..32526.05 rows=6 width=16)
                                                    Join Filter: ("_14__be_0_Task_1".project_id = "_15__be_1_Project_1".id)
                                                    ->  Seq Scan on "Task" "_14__be_0_Task_1"  (cost=0.00..15.80 rows=580 width=32)
                                                    ->  Materialize  (cost=0.00..32458.13 rows=6 width=16)
                                                          ->  Seq Scan on "Project" "_15__be_1_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                                                Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 50 or hashed SubPlan 51)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 52 or hashed SubPlan 53)))
                                                                SubPlan 50
                                                                  ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                                              Index Cond: (id = "_15__be_1_Project_1".organization_id)
                                                                        ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                                              Filter: ((organization_id = "_15__be_1_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                                SubPlan 51
                                                                  ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                                        ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                              Group Key: "_17__be_3_OrganizationMember_3".organization_id
                                                                              ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                                                    Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                                              Index Cond: (id = "_17__be_3_OrganizationMember_3".organization_id)
                                                                SubPlan 52
                                                                  ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                                        Filter: ((project_id = "_15__be_1_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                                SubPlan 53
                                                                  ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                      ->  Index Scan using "User_pkey" on "User"  (cost=0.15..74.05 rows=1 width=48)
                                            Index Cond: (id = "TaskAssignee".user_id)
                                            Filter: ((id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid) OR (alternatives: SubPlan 55 or hashed SubPlan 56))
                                            SubPlan 43
                                              ->  Result  (cost=0.00..0.01 rows=1 width=32)
                                            SubPlan 55
                                              ->  Nested Loop Semi Join  (cost=22.19..65.87 rows=1 width=0)
                                                    Join Filter: ("_20__be_0_OrganizationMember".organization_id = "_22__be_2_OrganizationMember".organization_id)
                                                    ->  Seq Scan on "OrganizationMember" "_20__be_0_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                                          Filter: (user_id = "User".id)
                                                    ->  Materialize  (cost=22.19..43.38 rows=5 width=32)
                                                          ->  Hash Semi Join  (cost=22.19..43.35 rows=5 width=32)
                                                                Hash Cond: ("_21__be_1_Organization".id = "_22__be_2_OrganizationMember".organization_id)
                                                                ->  Seq Scan on "Organization" "_21__be_1_Organization"  (cost=0.00..18.80 rows=880 width=16)
                                                                ->  Hash  (cost=22.12..22.12 rows=5 width=16)
                                                                      ->  Seq Scan on "OrganizationMember" "_22__be_2_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                                                            Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                            SubPlan 56
                                              ->  Hash Semi Join  (cost=43.13..65.65 rows=24 width=16)
                                                    Hash Cond: ("_20__be_0_OrganizationMember_1".organization_id = "_22__be_2_OrganizationMember_1".organization_id)
                                                    ->  Seq Scan on "OrganizationMember" "_20__be_0_OrganizationMember_1"  (cost=0.00..19.70 rows=970 width=32)
                                                    ->  Hash  (cost=43.07..43.07 rows=5 width=32)
                                                          ->  Nested Loop  (cost=22.29..43.07 rows=5 width=32)
                                                                ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                      Group Key: "_22__be_2_OrganizationMember_1".organization_id
                                                                      ->  Seq Scan on "OrganizationMember" "_22__be_2_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                            Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                                ->  Index Only Scan using "Organization_pkey" on "Organization" "_21__be_1_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                                      Index Cond: (id = "_22__be_2_OrganizationMember_1".organization_id)
                                SubPlan 44
                                  ->  Result  (cost=0.00..0.01 rows=1 width=32)
                          SubPlan 30
                            ->  Result  (cost=0.00..0.01 rows=1 width=32)
              ->  Aggregate  (cost=91757.44..91757.45 rows=1 width=32)
                    ->  Nested Loop Left Join  (cost=0.15..91757.41 rows=2 width=32)
                          ->  Seq Scan on "SubTaskAssignee"  (cost=0.00..91608.98 rows=2 width=16)
                                Filter: (("SubTask".id = sub_task_id) AND ((alternatives: SubPlan 71 or hashed SubPlan 84) OR (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)))
                                SubPlan 71
                                  ->  Nested Loop  (cost=0.30..104.07 rows=1 width=0)
                                        ->  Index Scan using "SubTask_pkey" on "SubTask" "_31__be_0_SubTask"  (cost=0.15..8.17 rows=1 width=16)
                                              Index Cond: (id = "SubTaskAssignee".sub_task_id)
                                        ->  Index Scan using "Task_pkey" on "Task" "_32__be_1_Task"  (cost=0.15..95.47 rows=1 width=16)
                                              Index Cond: (id = "_31__be_0_SubTask".task_id)
                                              Filter: ((alternatives: SubPlan 63 or hashed SubPlan 68) OR (alternatives: SubPlan 69 or hashed SubPlan 70))
                                              SubPlan 63
                                                ->  Index Scan using "Project_pkey" on "Project" "_33__be_2_Project"  (cost=0.15..64.10 rows=1 width=0)
                                                      Index Cond: (id = "_32__be_1_Task".project_id)
                                                      Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 59 or hashed SubPlan 60)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 61 or hashed SubPlan 62)))
                                                      SubPlan 59
                                                        ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                                    Index Cond: (id = "_33__be_2_Project".organization_id)
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                                    Filter: ((organization_id = "_33__be_2_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 60
                                                        ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                              ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                    Group Key: "_35__be_4_OrganizationMember_1".organization_id
                                                                    ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                                    Index Cond: (id = "_35__be_4_OrganizationMember_1".organization_id)
                                                      SubPlan 61
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                              Filter: ((project_id = "_33__be_2_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 62
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                              SubPlan 68
                                                ->  Seq Scan on "Project" "_33__be_2_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                                      Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 64 or hashed SubPlan 65)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 66 or hashed SubPlan 67)))
                                                      SubPlan 64
                                                        ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                                    Index Cond: (id = "_33__be_2_Project_1".organization_id)
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                                    Filter: ((organization_id = "_33__be_2_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 65
                                                        ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                              ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                    Group Key: "_35__be_4_OrganizationMember_3".organization_id
                                                                    ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                                    Index Cond: (id = "_35__be_4_OrganizationMember_3".organization_id)
                                                      SubPlan 66
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                              Filter: ((project_id = "_33__be_2_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 67
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                              SubPlan 69
                                                ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                                      Filter: ((task_id = "_32__be_1_Task".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                              SubPlan 70
                                                ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                                      Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                SubPlan 84
                                  ->  Nested Loop  (cost=0.15..50705.41 rows=435 width=16)
                                        ->  Seq Scan on "SubTask" "_31__be_0_SubTask_1"  (cost=0.00..15.80 rows=580 width=32)
                                        ->  Index Scan using "Task_pkey" on "Task" "_32__be_1_Task_1"  (cost=0.15..87.55 rows=1 width=16)
                                              Index Cond: (id = "_31__be_0_SubTask_1".task_id)
                                              Filter: ((alternatives: SubPlan 76 or hashed SubPlan 81) OR (alternatives: SubPlan 82 or hashed SubPlan 83))
                                              SubPlan 76
                                                ->  Index Scan using "Project_pkey" on "Project" "_33__be_2_Project_2"  (cost=0.15..64.10 rows=1 width=0)
                                                      Index Cond: (id = "_32__be_1_Task_1".project_id)
                                                      Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 72 or hashed SubPlan 73)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 74 or hashed SubPlan 75)))
                                                      SubPlan 72
                                                        ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_4"  (cost=0.15..8.17 rows=1 width=16)
                                                                    Index Cond: (id = "_33__be_2_Project_2".organization_id)
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_4"  (cost=0.00..24.55 rows=1 width=16)
                                                                    Filter: ((organization_id = "_33__be_2_Project_2".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 73
                                                        ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                              ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                    Group Key: "_35__be_4_OrganizationMember_5".organization_id
                                                                    ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_5"  (cost=0.00..22.12 rows=5 width=16)
                                                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_5"  (cost=0.15..4.17 rows=1 width=16)
                                                                    Index Cond: (id = "_35__be_4_OrganizationMember_5".organization_id)
                                                      SubPlan 74
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_4"  (cost=0.00..23.20 rows=1 width=0)
                                                              Filter: ((project_id = "_33__be_2_Project_2".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 75
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_5"  (cost=0.00..21.00 rows=4 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                              SubPlan 81
                                                ->  Seq Scan on "Project" "_33__be_2_Project_3"  (cost=0.00..32458.10 rows=6 width=16)
                                                      Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 77 or hashed SubPlan 78)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 79 or hashed SubPlan 80)))
                                                      SubPlan 77
                                                        ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_6"  (cost=0.15..8.17 rows=1 width=16)
                                                                    Index Cond: (id = "_33__be_2_Project_3".organization_id)
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_6"  (cost=0.00..24.55 rows=1 width=16)
                                                                    Filter: ((organization_id = "_33__be_2_Project_3".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 78
                                                        ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                              ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                    Group Key: "_35__be_4_OrganizationMember_7".organization_id
                                                                    ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_7"  (cost=0.00..22.12 rows=5 width=16)
                                                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_7"  (cost=0.15..4.17 rows=1 width=16)
                                                                    Index Cond: (id = "_35__be_4_OrganizationMember_7".organization_id)
                                                      SubPlan 79
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_6"  (cost=0.00..23.20 rows=1 width=0)
                                                              Filter: ((project_id = "_33__be_2_Project_3".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                      SubPlan 80
                                                        ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_7"  (cost=0.00..21.00 rows=4 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                              SubPlan 82
                                                ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee_2"  (cost=0.00..23.20 rows=1 width=0)
                                                      Filter: ((task_id = "_32__be_1_Task_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                              SubPlan 83
                                                ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee_3"  (cost=0.00..21.00 rows=4 width=16)
                                                      Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          ->  Index Scan using "User_pkey" on "User" "User_1"  (cost=0.15..74.05 rows=1 width=48)
                                Index Cond: (id = "SubTaskAssignee".user_id)
                                Filter: ((id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid) OR (alternatives: SubPlan 85 or hashed SubPlan 86))
                                SubPlan 57
                                  ->  Result  (cost=0.00..0.01 rows=1 width=32)
                                SubPlan 85
                                  ->  Nested Loop Semi Join  (cost=22.19..65.87 rows=1 width=0)
                                        Join Filter: ("_39__be_0_OrganizationMember".organization_id = "_41__be_2_OrganizationMember".organization_id)
                                        ->  Seq Scan on "OrganizationMember" "_39__be_0_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                              Filter: (user_id = "User_1".id)
                                        ->  Materialize  (cost=22.19..43.38 rows=5 width=32)
                                              ->  Hash Semi Join  (cost=22.19..43.35 rows=5 width=32)
                                                    Hash Cond: ("_40__be_1_Organization".id = "_41__be_2_OrganizationMember".organization_id)
                                                    ->  Seq Scan on "Organization" "_40__be_1_Organization"  (cost=0.00..18.80 rows=880 width=16)
                                                    ->  Hash  (cost=22.12..22.12 rows=5 width=16)
                                                          ->  Seq Scan on "OrganizationMember" "_41__be_2_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                                                Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                SubPlan 86
                                  ->  Hash Semi Join  (cost=43.13..65.65 rows=24 width=16)
                                        Hash Cond: ("_39__be_0_OrganizationMember_1".organization_id = "_41__be_2_OrganizationMember_1".organization_id)
                                        ->  Seq Scan on "OrganizationMember" "_39__be_0_OrganizationMember_1"  (cost=0.00..19.70 rows=970 width=32)
                                        ->  Hash  (cost=43.07..43.07 rows=5 width=32)
                                              ->  Nested Loop  (cost=22.29..43.07 rows=5 width=32)
                                                    ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                          Group Key: "_41__be_2_OrganizationMember_1".organization_id
                                                          ->  Seq Scan on "OrganizationMember" "_41__be_2_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                    ->  Index Only Scan using "Organization_pkey" on "Organization" "_40__be_1_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                          Index Cond: (id = "_41__be_2_OrganizationMember_1".organization_id)
                    SubPlan 58
                      ->  Result  (cost=0.00..0.01 rows=1 width=32)
              SubPlan 1
                ->  Result  (cost=0.00..0.01 rows=1 width=32)
JIT:
  Functions: 827
  Options: Inlining true, Optimization true, Expressions true, Deforming true

• hasurabuild/graphql-engine:mono-pr-3362-8cd5313f9

Aggregate  (cost=1718600.42..1718600.43 rows=1 width=32)
  ->  Nested Loop Left Join  (cost=171606.34..1718600.27 rows=10 width=144)
        ->  Nested Loop Left Join  (cost=79848.90..801025.55 rows=10 width=112)
              ->  Limit  (cost=0.00..1582.63 rows=10 width=112)
                    ->  Seq Scan on "SubTask"  (cost=0.00..68844.40 rows=435 width=112)
                          Filter: ((alternatives: SubPlan 14 or hashed SubPlan 27) OR (alternatives: SubPlan 28 or hashed SubPlan 29))
                          SubPlan 14
                            ->  Index Scan using "Task_pkey" on "Task" "_0__be_0_Task"  (cost=0.15..95.47 rows=1 width=0)
                                  Index Cond: (id = "SubTask".task_id)
                                  Filter: ((alternatives: SubPlan 6 or hashed SubPlan 11) OR (alternatives: SubPlan 12 or hashed SubPlan 13))
                                  SubPlan 6
                                    ->  Index Scan using "Project_pkey" on "Project" "_1__be_1_Project"  (cost=0.15..64.10 rows=1 width=0)
                                          Index Cond: (id = "_0__be_0_Task".project_id)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 2 or hashed SubPlan 3)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 4 or hashed SubPlan 5)))
                                          SubPlan 2
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 3
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_1".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_1".organization_id)
                                          SubPlan 4
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 5
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 11
                                    ->  Seq Scan on "Project" "_1__be_1_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 7 or hashed SubPlan 8)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 9 or hashed SubPlan 10)))
                                          SubPlan 7
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project_1".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 8
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_3".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_3".organization_id)
                                          SubPlan 9
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 10
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 12
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                          Filter: ((task_id = "_0__be_0_Task".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 13
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 27
                            ->  Seq Scan on "Task" "_0__be_0_Task_1"  (cost=0.00..50651.25 rows=435 width=16)
                                  Filter: ((alternatives: SubPlan 19 or hashed SubPlan 24) OR (alternatives: SubPlan 25 or hashed SubPlan 26))
                                  SubPlan 19
                                    ->  Index Scan using "Project_pkey" on "Project" "_1__be_1_Project_2"  (cost=0.15..64.10 rows=1 width=0)
                                          Index Cond: (id = "_0__be_0_Task_1".project_id)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 15 or hashed SubPlan 16)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 17 or hashed SubPlan 18)))
                                          SubPlan 15
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_4"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project_2".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_4"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project_2".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 16
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_5".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_5"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_5"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_5".organization_id)
                                          SubPlan 17
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_4"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project_2".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 18
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_5"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 24
                                    ->  Seq Scan on "Project" "_1__be_1_Project_3"  (cost=0.00..32458.10 rows=6 width=16)
                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 20 or hashed SubPlan 21)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 22 or hashed SubPlan 23)))
                                          SubPlan 20
                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_6"  (cost=0.15..8.17 rows=1 width=16)
                                                        Index Cond: (id = "_1__be_1_Project_3".organization_id)
                                                  ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_6"  (cost=0.00..24.55 rows=1 width=16)
                                                        Filter: ((organization_id = "_1__be_1_Project_3".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 21
                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                        Group Key: "_3__be_3_OrganizationMember_7".organization_id
                                                        ->  Seq Scan on "OrganizationMember" "_3__be_3_OrganizationMember_7"  (cost=0.00..22.12 rows=5 width=16)
                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_2__be_2_Organization_7"  (cost=0.15..4.17 rows=1 width=16)
                                                        Index Cond: (id = "_3__be_3_OrganizationMember_7".organization_id)
                                          SubPlan 22
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_6"  (cost=0.00..23.20 rows=1 width=0)
                                                  Filter: ((project_id = "_1__be_1_Project_3".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                          SubPlan 23
                                            ->  Seq Scan on "ProjectMember" "_4__be_4_ProjectMember_7"  (cost=0.00..21.00 rows=4 width=16)
                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                  SubPlan 25
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee_2"  (cost=0.00..23.20 rows=1 width=0)
                                          Filter: ((task_id = "_0__be_0_Task_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 26
                                    ->  Seq Scan on "TaskAssignee" "_5__be_5_TaskAssignee_3"  (cost=0.00..21.00 rows=4 width=16)
                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 28
                            ->  Seq Scan on "SubTaskAssignee" "_6__be_6_SubTaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                  Filter: ((sub_task_id = "SubTask".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                          SubPlan 29
                            ->  Seq Scan on "SubTaskAssignee" "_6__be_6_SubTaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
              ->  Nested Loop Left Join  (cost=79848.90..79944.26 rows=1 width=32)
                    ->  Index Scan using "Task_pkey" on "Task"  (cost=0.15..95.47 rows=1 width=48)
                          Index Cond: (id = "SubTask".task_id)
                          Filter: ((alternatives: SubPlan 35 or hashed SubPlan 40) OR (alternatives: SubPlan 41 or hashed SubPlan 42))
                          SubPlan 35
                            ->  Index Scan using "Project_pkey" on "Project" "_8__be_0_Project"  (cost=0.15..64.10 rows=1 width=0)
                                  Index Cond: (id = "Task".project_id)
                                  Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 31 or hashed SubPlan 32)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 33 or hashed SubPlan 34)))
                                  SubPlan 31
                                    ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                          ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                Index Cond: (id = "_8__be_0_Project".organization_id)
                                          ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                Filter: ((organization_id = "_8__be_0_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 32
                                    ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                          ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                Group Key: "_10__be_2_OrganizationMember_1".organization_id
                                                ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                      Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                          ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                Index Cond: (id = "_10__be_2_OrganizationMember_1".organization_id)
                                  SubPlan 33
                                    ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                          Filter: ((project_id = "_8__be_0_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 34
                                    ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 40
                            ->  Seq Scan on "Project" "_8__be_0_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                  Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 36 or hashed SubPlan 37)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 38 or hashed SubPlan 39)))
                                  SubPlan 36
                                    ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                          ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                Index Cond: (id = "_8__be_0_Project_1".organization_id)
                                          ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                Filter: ((organization_id = "_8__be_0_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 37
                                    ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                          ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                Group Key: "_10__be_2_OrganizationMember_3".organization_id
                                                ->  Seq Scan on "OrganizationMember" "_10__be_2_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                      Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                          ->  Index Only Scan using "Organization_pkey" on "Organization" "_9__be_1_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                Index Cond: (id = "_10__be_2_OrganizationMember_3".organization_id)
                                  SubPlan 38
                                    ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                          Filter: ((project_id = "_8__be_0_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                  SubPlan 39
                                    ->  Seq Scan on "ProjectMember" "_11__be_3_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 41
                            ->  Seq Scan on "TaskAssignee" "_12__be_4_TaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                  Filter: ((task_id = "Task".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                          SubPlan 42
                            ->  Seq Scan on "TaskAssignee" "_12__be_4_TaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                    ->  Aggregate  (cost=79848.75..79848.76 rows=1 width=32)
                          ->  Nested Loop Left Join  (cost=0.15..79848.72 rows=2 width=32)
                                ->  Seq Scan on "TaskAssignee"  (cost=0.00..79700.29 rows=2 width=16)
                                      Filter: (("Task".id = task_id) AND ((alternatives: SubPlan 49 or hashed SubPlan 54) OR (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)))
                                      SubPlan 49
                                        ->  Nested Loop  (cost=0.30..90.54 rows=1 width=0)
                                              ->  Index Scan using "Task_pkey" on "Task" "_14__be_0_Task"  (cost=0.15..8.17 rows=1 width=16)
                                                    Index Cond: (id = "TaskAssignee".task_id)
                                              ->  Index Scan using "Project_pkey" on "Project" "_15__be_1_Project"  (cost=0.15..64.10 rows=1 width=16)
                                                    Index Cond: (id = "_14__be_0_Task".project_id)
                                                    Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 45 or hashed SubPlan 46)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 47 or hashed SubPlan 48)))
                                                    SubPlan 45
                                                      ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                            ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                                  Index Cond: (id = "_15__be_1_Project".organization_id)
                                                            ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                                  Filter: ((organization_id = "_15__be_1_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                    SubPlan 46
                                                      ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                            ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                  Group Key: "_17__be_3_OrganizationMember_1".organization_id
                                                                  ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                            ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                                  Index Cond: (id = "_17__be_3_OrganizationMember_1".organization_id)
                                                    SubPlan 47
                                                      ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                            Filter: ((project_id = "_15__be_1_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                    SubPlan 48
                                                      ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                            Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                      SubPlan 54
                                        ->  Nested Loop  (cost=0.00..32526.05 rows=6 width=16)
                                              Join Filter: ("_14__be_0_Task_1".project_id = "_15__be_1_Project_1".id)
                                              ->  Seq Scan on "Task" "_14__be_0_Task_1"  (cost=0.00..15.80 rows=580 width=32)
                                              ->  Materialize  (cost=0.00..32458.13 rows=6 width=16)
                                                    ->  Seq Scan on "Project" "_15__be_1_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                                          Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 50 or hashed SubPlan 51)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 52 or hashed SubPlan 53)))
                                                          SubPlan 50
                                                            ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                                        Index Cond: (id = "_15__be_1_Project_1".organization_id)
                                                                  ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                                        Filter: ((organization_id = "_15__be_1_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                          SubPlan 51
                                                            ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                                  ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                        Group Key: "_17__be_3_OrganizationMember_3".organization_id
                                                                        ->  Seq Scan on "OrganizationMember" "_17__be_3_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                                              Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                                  ->  Index Only Scan using "Organization_pkey" on "Organization" "_16__be_2_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                                        Index Cond: (id = "_17__be_3_OrganizationMember_3".organization_id)
                                                          SubPlan 52
                                                            ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                                  Filter: ((project_id = "_15__be_1_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                          SubPlan 53
                                                            ->  Seq Scan on "ProjectMember" "_18__be_4_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                                  Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                ->  Index Scan using "User_pkey" on "User"  (cost=0.15..74.05 rows=1 width=48)
                                      Index Cond: (id = "TaskAssignee".user_id)
                                      Filter: ((id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid) OR (alternatives: SubPlan 55 or hashed SubPlan 56))
                                      SubPlan 43
                                        ->  Result  (cost=0.00..0.01 rows=1 width=32)
                                      SubPlan 55
                                        ->  Nested Loop Semi Join  (cost=22.19..65.87 rows=1 width=0)
                                              Join Filter: ("_20__be_0_OrganizationMember".organization_id = "_22__be_2_OrganizationMember".organization_id)
                                              ->  Seq Scan on "OrganizationMember" "_20__be_0_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                                    Filter: (user_id = "User".id)
                                              ->  Materialize  (cost=22.19..43.38 rows=5 width=32)
                                                    ->  Hash Semi Join  (cost=22.19..43.35 rows=5 width=32)
                                                          Hash Cond: ("_21__be_1_Organization".id = "_22__be_2_OrganizationMember".organization_id)
                                                          ->  Seq Scan on "Organization" "_21__be_1_Organization"  (cost=0.00..18.80 rows=880 width=16)
                                                          ->  Hash  (cost=22.12..22.12 rows=5 width=16)
                                                                ->  Seq Scan on "OrganizationMember" "_22__be_2_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                                                      Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                      SubPlan 56
                                        ->  Hash Semi Join  (cost=43.13..65.65 rows=24 width=16)
                                              Hash Cond: ("_20__be_0_OrganizationMember_1".organization_id = "_22__be_2_OrganizationMember_1".organization_id)
                                              ->  Seq Scan on "OrganizationMember" "_20__be_0_OrganizationMember_1"  (cost=0.00..19.70 rows=970 width=32)
                                              ->  Hash  (cost=43.07..43.07 rows=5 width=32)
                                                    ->  Nested Loop  (cost=22.29..43.07 rows=5 width=32)
                                                          ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                                Group Key: "_22__be_2_OrganizationMember_1".organization_id
                                                                ->  Seq Scan on "OrganizationMember" "_22__be_2_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                      Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                          ->  Index Only Scan using "Organization_pkey" on "Organization" "_21__be_1_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                                Index Cond: (id = "_22__be_2_OrganizationMember_1".organization_id)
                          SubPlan 44
                            ->  Result  (cost=0.00..0.01 rows=1 width=32)
                    SubPlan 30
                      ->  Result  (cost=0.00..0.01 rows=1 width=32)
        ->  Aggregate  (cost=91757.44..91757.45 rows=1 width=32)
              ->  Nested Loop Left Join  (cost=0.15..91757.41 rows=2 width=32)
                    ->  Seq Scan on "SubTaskAssignee"  (cost=0.00..91608.98 rows=2 width=16)
                          Filter: (("SubTask".id = sub_task_id) AND ((alternatives: SubPlan 71 or hashed SubPlan 84) OR (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)))
                          SubPlan 71
                            ->  Nested Loop  (cost=0.30..104.07 rows=1 width=0)
                                  ->  Index Scan using "SubTask_pkey" on "SubTask" "_31__be_0_SubTask"  (cost=0.15..8.17 rows=1 width=16)
                                        Index Cond: (id = "SubTaskAssignee".sub_task_id)
                                  ->  Index Scan using "Task_pkey" on "Task" "_32__be_1_Task"  (cost=0.15..95.47 rows=1 width=16)
                                        Index Cond: (id = "_31__be_0_SubTask".task_id)
                                        Filter: ((alternatives: SubPlan 63 or hashed SubPlan 68) OR (alternatives: SubPlan 69 or hashed SubPlan 70))
                                        SubPlan 63
                                          ->  Index Scan using "Project_pkey" on "Project" "_33__be_2_Project"  (cost=0.15..64.10 rows=1 width=0)
                                                Index Cond: (id = "_32__be_1_Task".project_id)
                                                Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 59 or hashed SubPlan 60)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 61 or hashed SubPlan 62)))
                                                SubPlan 59
                                                  ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization"  (cost=0.15..8.17 rows=1 width=16)
                                                              Index Cond: (id = "_33__be_2_Project".organization_id)
                                                        ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember"  (cost=0.00..24.55 rows=1 width=16)
                                                              Filter: ((organization_id = "_33__be_2_Project".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 60
                                                  ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                        ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                              Group Key: "_35__be_4_OrganizationMember_1".organization_id
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                                    Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                              Index Cond: (id = "_35__be_4_OrganizationMember_1".organization_id)
                                                SubPlan 61
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember"  (cost=0.00..23.20 rows=1 width=0)
                                                        Filter: ((project_id = "_33__be_2_Project".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 62
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_1"  (cost=0.00..21.00 rows=4 width=16)
                                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                        SubPlan 68
                                          ->  Seq Scan on "Project" "_33__be_2_Project_1"  (cost=0.00..32458.10 rows=6 width=16)
                                                Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 64 or hashed SubPlan 65)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 66 or hashed SubPlan 67)))
                                                SubPlan 64
                                                  ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_2"  (cost=0.15..8.17 rows=1 width=16)
                                                              Index Cond: (id = "_33__be_2_Project_1".organization_id)
                                                        ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_2"  (cost=0.00..24.55 rows=1 width=16)
                                                              Filter: ((organization_id = "_33__be_2_Project_1".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 65
                                                  ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                        ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                              Group Key: "_35__be_4_OrganizationMember_3".organization_id
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_3"  (cost=0.00..22.12 rows=5 width=16)
                                                                    Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_3"  (cost=0.15..4.17 rows=1 width=16)
                                                              Index Cond: (id = "_35__be_4_OrganizationMember_3".organization_id)
                                                SubPlan 66
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_2"  (cost=0.00..23.20 rows=1 width=0)
                                                        Filter: ((project_id = "_33__be_2_Project_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 67
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_3"  (cost=0.00..21.00 rows=4 width=16)
                                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                        SubPlan 69
                                          ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee"  (cost=0.00..23.20 rows=1 width=0)
                                                Filter: ((task_id = "_32__be_1_Task".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                        SubPlan 70
                                          ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee_1"  (cost=0.00..21.00 rows=4 width=16)
                                                Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 84
                            ->  Nested Loop  (cost=0.15..50705.41 rows=435 width=16)
                                  ->  Seq Scan on "SubTask" "_31__be_0_SubTask_1"  (cost=0.00..15.80 rows=580 width=32)
                                  ->  Index Scan using "Task_pkey" on "Task" "_32__be_1_Task_1"  (cost=0.15..87.55 rows=1 width=16)
                                        Index Cond: (id = "_31__be_0_SubTask_1".task_id)
                                        Filter: ((alternatives: SubPlan 76 or hashed SubPlan 81) OR (alternatives: SubPlan 82 or hashed SubPlan 83))
                                        SubPlan 76
                                          ->  Index Scan using "Project_pkey" on "Project" "_33__be_2_Project_2"  (cost=0.15..64.10 rows=1 width=0)
                                                Index Cond: (id = "_32__be_1_Task_1".project_id)
                                                Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 72 or hashed SubPlan 73)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 74 or hashed SubPlan 75)))
                                                SubPlan 72
                                                  ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_4"  (cost=0.15..8.17 rows=1 width=16)
                                                              Index Cond: (id = "_33__be_2_Project_2".organization_id)
                                                        ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_4"  (cost=0.00..24.55 rows=1 width=16)
                                                              Filter: ((organization_id = "_33__be_2_Project_2".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 73
                                                  ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                        ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                              Group Key: "_35__be_4_OrganizationMember_5".organization_id
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_5"  (cost=0.00..22.12 rows=5 width=16)
                                                                    Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_5"  (cost=0.15..4.17 rows=1 width=16)
                                                              Index Cond: (id = "_35__be_4_OrganizationMember_5".organization_id)
                                                SubPlan 74
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_4"  (cost=0.00..23.20 rows=1 width=0)
                                                        Filter: ((project_id = "_33__be_2_Project_2".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 75
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_5"  (cost=0.00..21.00 rows=4 width=16)
                                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                        SubPlan 81
                                          ->  Seq Scan on "Project" "_33__be_2_Project_3"  (cost=0.00..32458.10 rows=6 width=16)
                                                Filter: ((visibility = 'Public'::text) OR ((visibility = 'OrganizationMemberOnly'::text) AND (alternatives: SubPlan 77 or hashed SubPlan 78)) OR ((visibility = 'ProjectMemberOnly'::text) AND (alternatives: SubPlan 79 or hashed SubPlan 80)))
                                                SubPlan 77
                                                  ->  Nested Loop Semi Join  (cost=0.15..32.73 rows=1 width=0)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_6"  (cost=0.15..8.17 rows=1 width=16)
                                                              Index Cond: (id = "_33__be_2_Project_3".organization_id)
                                                        ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_6"  (cost=0.00..24.55 rows=1 width=16)
                                                              Filter: ((organization_id = "_33__be_2_Project_3".organization_id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 78
                                                  ->  Nested Loop  (cost=22.29..43.07 rows=5 width=16)
                                                        ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                              Group Key: "_35__be_4_OrganizationMember_7".organization_id
                                                              ->  Seq Scan on "OrganizationMember" "_35__be_4_OrganizationMember_7"  (cost=0.00..22.12 rows=5 width=16)
                                                                    Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                                        ->  Index Only Scan using "Organization_pkey" on "Organization" "_34__be_3_Organization_7"  (cost=0.15..4.17 rows=1 width=16)
                                                              Index Cond: (id = "_35__be_4_OrganizationMember_7".organization_id)
                                                SubPlan 79
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_6"  (cost=0.00..23.20 rows=1 width=0)
                                                        Filter: ((project_id = "_33__be_2_Project_3".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                                SubPlan 80
                                                  ->  Seq Scan on "ProjectMember" "_36__be_5_ProjectMember_7"  (cost=0.00..21.00 rows=4 width=16)
                                                        Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                        SubPlan 82
                                          ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee_2"  (cost=0.00..23.20 rows=1 width=0)
                                                Filter: ((task_id = "_32__be_1_Task_1".id) AND (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid))
                                        SubPlan 83
                                          ->  Seq Scan on "TaskAssignee" "_37__be_6_TaskAssignee_3"  (cost=0.00..21.00 rows=4 width=16)
                                                Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                    ->  Index Scan using "User_pkey" on "User" "User_1"  (cost=0.15..74.05 rows=1 width=48)
                          Index Cond: (id = "SubTaskAssignee".user_id)
                          Filter: ((id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid) OR (alternatives: SubPlan 85 or hashed SubPlan 86))
                          SubPlan 57
                            ->  Result  (cost=0.00..0.01 rows=1 width=32)
                          SubPlan 85
                            ->  Nested Loop Semi Join  (cost=22.19..65.87 rows=1 width=0)
                                  Join Filter: ("_39__be_0_OrganizationMember".organization_id = "_41__be_2_OrganizationMember".organization_id)
                                  ->  Seq Scan on "OrganizationMember" "_39__be_0_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                        Filter: (user_id = "User_1".id)
                                  ->  Materialize  (cost=22.19..43.38 rows=5 width=32)
                                        ->  Hash Semi Join  (cost=22.19..43.35 rows=5 width=32)
                                              Hash Cond: ("_40__be_1_Organization".id = "_41__be_2_OrganizationMember".organization_id)
                                              ->  Seq Scan on "Organization" "_40__be_1_Organization"  (cost=0.00..18.80 rows=880 width=16)
                                              ->  Hash  (cost=22.12..22.12 rows=5 width=16)
                                                    ->  Seq Scan on "OrganizationMember" "_41__be_2_OrganizationMember"  (cost=0.00..22.12 rows=5 width=16)
                                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                          SubPlan 86
                            ->  Hash Semi Join  (cost=43.13..65.65 rows=24 width=16)
                                  Hash Cond: ("_39__be_0_OrganizationMember_1".organization_id = "_41__be_2_OrganizationMember_1".organization_id)
                                  ->  Seq Scan on "OrganizationMember" "_39__be_0_OrganizationMember_1"  (cost=0.00..19.70 rows=970 width=32)
                                  ->  Hash  (cost=43.07..43.07 rows=5 width=32)
                                        ->  Nested Loop  (cost=22.29..43.07 rows=5 width=32)
                                              ->  HashAggregate  (cost=22.14..22.19 rows=5 width=16)
                                                    Group Key: "_41__be_2_OrganizationMember_1".organization_id
                                                    ->  Seq Scan on "OrganizationMember" "_41__be_2_OrganizationMember_1"  (cost=0.00..22.12 rows=5 width=16)
                                                          Filter: (user_id = '99f530a2-cee9-44f8-b0f9-ecf44a2ff3e8'::uuid)
                                              ->  Index Only Scan using "Organization_pkey" on "Organization" "_40__be_1_Organization_1"  (cost=0.15..4.17 rows=1 width=16)
                                                    Index Cond: (id = "_41__be_2_OrganizationMember_1".organization_id)
              SubPlan 58
                ->  Result  (cost=0.00..0.01 rows=1 width=32)
  SubPlan 1
    ->  Result  (cost=0.00..0.01 rows=1 width=32)
JIT:
  Functions: 828
  Options: Inlining true, Optimization true, Expressions true, Deforming true

• query

query HeavyQuery {
  SubTask(limit: 10) {
    name
    body
    id
    SubTaskAssignees{
      User {
          name
        }
    }
    Task {
      name
      TaskAssignees{
        User {
          name
        }
        
      }
    }
  }
}