explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PYVT

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 8,237.343 ↑ 1.0 1 1

Limit (cost=836.18..853.76 rows=1 width=423) (actual time=8,237.343..8,237.343 rows=1 loops=1)

2. 0.003 8,237.342 ↑ 1.0 1 1

Nested Loop Left Join (cost=836.18..853.76 rows=1 width=423) (actual time=8,237.342..8,237.342 rows=1 loops=1)

  • Join Filter: (directory."accountLockingPolicyId" = "directory->accountLockingPolicy".id)
  • Rows Removed by Join Filter: 16
3. 0.011 8,237.333 ↑ 1.0 1 1

Nested Loop (cost=836.18..852.02 rows=1 width=295) (actual time=8,237.333..8,237.333 rows=1 loops=1)

  • Join Filter: (directory.id = account."directoryId")
  • Rows Removed by Join Filter: 5
4. 0.016 0.042 ↓ 6.0 6 1

Hash Right Join (cost=2.74..6.08 rows=1 width=48) (actual time=0.037..0.042 rows=6 loops=1)

  • Hash Cond: ("directory->provider"."directoryId" = directory.id)
  • Filter: ("directory->provider".id IS NULL)
  • Rows Removed by Filter: 26
5. 0.007 0.007 ↑ 1.0 26 1

Seq Scan on "directoryProviders" "directory->provider" (cost=0.00..3.26 rows=26 width=32) (actual time=0.004..0.007 rows=26 loops=1)

6. 0.006 0.019 ↑ 1.0 33 1

Hash (cost=2.33..2.33 rows=33 width=32) (actual time=0.019..0.019 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
7. 0.013 0.013 ↑ 1.0 33 1

Seq Scan on directories directory (cost=0.00..2.33 rows=33 width=32) (actual time=0.007..0.013 rows=33 loops=1)

8. 32.627 8,237.280 ↑ 11.0 1 6

Bitmap Heap Scan on accounts account (cost=833.44..845.80 rows=11 width=247) (actual time=1,372.879..1,372.880 rows=1 loops=6)

  • Recheck Cond: (((email)::text = 'ochedru@dhatim.com'::text) OR ((username)::text = 'ochedru@dhatim.com'::text))
  • Filter: ((("tenantId" = 'e158cdc0-3cc1-447f-a204-6cbc6ef9f801'::uuid) OR ("tenantId" IS NULL)) AND ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3) OR (hashed SubPlan 4) OR (hashed SubPlan 5) OR (hashed SubPlan 6)))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=24
9. 0.000 0.060 ↓ 0.0 0 6

BitmapOr (cost=3.13..3.13 rows=11 width=0) (actual time=0.010..0.010 rows=0 loops=6)

10. 0.036 0.036 ↑ 1.5 4 6

Bitmap Index Scan on accounts_email_directory_id (cost=0.00..1.56 rows=6 width=0) (actual time=0.006..0.006 rows=4 loops=6)

  • Index Cond: ((email)::text = 'ochedru@dhatim.com'::text)
11. 0.024 0.024 ↑ 1.5 4 6

Bitmap Index Scan on accounts_username_directory_id (cost=0.00..1.56 rows=6 width=0) (actual time=0.004..0.004 rows=4 loops=6)

  • Index Cond: ((username)::text = 'ochedru@dhatim.com'::text)
12.          

SubPlan (for Bitmap Heap Scan)

13. 84.446 3,456.564 ↓ 54,197.0 54,197 1

Nested Loop (cost=1.40..36.05 rows=1 width=16) (actual time=590.404..3,456.564 rows=54,197 loops=1)

  • Join Filter: ("a->a->a->a->a"."directoryId" = "a->a->a->a->a->d".id)
  • Rows Removed by Join Filter: 1517516
14. 0.027 0.027 ↓ 29.0 29 1

Seq Scan on directories "a->a->a->a->a->d" (cost=0.00..2.41 rows=1 width=16) (actual time=0.002..0.027 rows=29 loops=1)

  • Filter: ((status)::text = 'ENABLED'::text)
  • Rows Removed by Filter: 4
15. 1,100.231 3,372.091 ↓ 3,871.2 54,197 29

Nested Loop (cost=1.40..33.46 rows=14 width=32) (actual time=0.027..116.279 rows=54,197 loops=29)

16. 190.008 700.147 ↓ 3,871.2 54,197 29

Nested Loop (cost=1.11..28.76 rows=14 width=16) (actual time=0.025..24.143 rows=54,197 loops=29)

17. 0.000 49.735 ↓ 1,134.0 1,134 29

Nested Loop (cost=0.70..6.47 rows=1 width=16) (actual time=0.023..1.715 rows=1,134 loops=29)

  • Join Filter: (a."accountStoreId" = "a->a".id)
18. 8.700 19.256 ↓ 1,134.0 1,134 29

Nested Loop (cost=0.56..6.10 rows=1 width=48) (actual time=0.022..0.664 rows=1,134 loops=29)

19. 0.087 0.696 ↓ 20.0 20 29

Nested Loop (cost=0.28..3.59 rows=1 width=16) (actual time=0.008..0.024 rows=20 loops=29)

20. 0.116 0.116 ↑ 1.0 1 29

Seq Scan on applications application (cost=0.00..1.09 rows=1 width=16) (actual time=0.002..0.004 rows=1 loops=29)

  • Filter: (id = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid)
  • Rows Removed by Filter: 6
21. 0.493 0.493 ↓ 20.0 20 29

Index Scan using account_store_mappings_type_application_id on "accountStoreMappings" a (cost=0.28..2.49 rows=1 width=32) (actual time=0.006..0.017 rows=20 loops=29)

  • Index Cond: (("accountStoreType" = 'directory'::"enum_accountStoreMappings_accountStoreType") AND ("applicationId" = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid))
22. 9.860 9.860 ↓ 57.0 57 580

Index Scan using groups_directory_id_status on groups "a->a->a" (cost=0.28..2.50 rows=1 width=32) (actual time=0.001..0.017 rows=57 loops=580)

  • Index Cond: (("directoryId" = a."accountStoreId") AND ((status)::text = 'ENABLED'::text))
23. 32.886 32.886 ↑ 1.0 1 32,886

Index Scan using directories_pkey on directories "a->a" (cost=0.14..0.35 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=32,886)

  • Index Cond: (id = "a->a->a"."directoryId")
  • Filter: ((status)::text = 'ENABLED'::text)
24. 460.404 460.404 ↓ 1.9 48 32,886

Index Scan using group_memberships_group_id on "groupMemberships" "a->a->a->a" (cost=0.41..22.04 rows=25 width=32) (actual time=0.002..0.014 rows=48 loops=32,886)

  • Index Cond: ("groupId" = "a->a->a".id)
25. 1,571.713 1,571.713 ↑ 1.0 1 1,571,713

Index Scan using accounts_pkey on accounts "a->a->a->a->a" (cost=0.29..0.34 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,571,713)

  • Index Cond: (id = "a->a->a->a"."accountId")
26. 2.918 11.151 ↓ 31.5 39,799 1

Nested Loop (cost=0.56..511.08 rows=1,262 width=16) (actual time=0.036..11.151 rows=39,799 loops=1)

27. 0.040 0.137 ↓ 16.0 16 1

Nested Loop (cost=0.28..6.02 rows=1 width=32) (actual time=0.028..0.137 rows=16 loops=1)

  • Join Filter: (a_1."accountStoreId" = "a->a_1".id)
  • Rows Removed by Join Filter: 388
28. 0.004 0.037 ↓ 20.0 20 1

Nested Loop (cost=0.28..3.59 rows=1 width=16) (actual time=0.018..0.037 rows=20 loops=1)

29. 0.008 0.008 ↑ 1.0 1 1

Seq Scan on applications application_1 (cost=0.00..1.09 rows=1 width=16) (actual time=0.006..0.008 rows=1 loops=1)

  • Filter: (id = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid)
  • Rows Removed by Filter: 6
30. 0.025 0.025 ↓ 20.0 20 1

Index Scan using account_store_mappings_type_application_id on "accountStoreMappings" a_1 (cost=0.28..2.49 rows=1 width=32) (actual time=0.011..0.025 rows=20 loops=1)

  • Index Cond: (("accountStoreType" = 'directory'::"enum_accountStoreMappings_accountStoreType") AND ("applicationId" = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid))
31. 0.060 0.060 ↓ 20.0 20 20

Seq Scan on directories "a->a_1" (cost=0.00..2.41 rows=1 width=16) (actual time=0.001..0.003 rows=20 loops=20)

  • Filter: ((status)::text = 'ENABLED'::text)
  • Rows Removed by Filter: 3
32. 8.096 8.096 ↑ 1.1 2,487 16

Index Scan using accounts_directory_id on accounts "a->a->a_1" (cost=0.29..477.29 rows=2,777 width=32) (actual time=0.002..0.506 rows=2,487 loops=16)

  • Index Cond: ("directoryId" = a_1."accountStoreId")
33. 0.024 0.088 ↓ 0.0 0 1

Nested Loop (cost=1.26..35.92 rows=1 width=16) (actual time=0.088..0.088 rows=0 loops=1)

  • Join Filter: ("a->a->a->a_1"."directoryId" = "a->a->a->a->d".id)
34. 0.006 0.006 ↓ 29.0 29 1

Seq Scan on directories "a->a->a->a->d" (cost=0.00..2.41 rows=1 width=16) (actual time=0.003..0.006 rows=29 loops=1)

  • Filter: ((status)::text = 'ENABLED'::text)
  • Rows Removed by Filter: 4
35. 0.000 0.058 ↓ 0.0 0 29

Nested Loop (cost=1.26..33.33 rows=14 width=32) (actual time=0.002..0.002 rows=0 loops=29)

36. 0.000 0.058 ↓ 0.0 0 29

Nested Loop (cost=0.97..28.64 rows=14 width=16) (actual time=0.002..0.002 rows=0 loops=29)

  • Join Filter: (a_2."accountStoreId" = "a->a->a_2"."groupId")
37. 0.000 0.058 ↓ 0.0 0 29

Nested Loop (cost=0.56..6.28 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=29)

38. 0.000 0.058 ↓ 0.0 0 29

Nested Loop (cost=0.28..3.59 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=29)

39. 0.029 0.029 ↑ 1.0 1 29

Seq Scan on applications application_2 (cost=0.00..1.09 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=29)

  • Filter: (id = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid)
  • Rows Removed by Filter: 6
40. 0.029 0.029 ↓ 0.0 0 29

Index Scan using account_store_mappings_type_application_id on "accountStoreMappings" a_2 (cost=0.28..2.49 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=29)

  • Index Cond: (("accountStoreType" = 'group'::"enum_accountStoreMappings_accountStoreType") AND ("applicationId" = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid))
41. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_pkey on groups "a->a_2" (cost=0.28..2.50 rows=1 width=16) (never executed)

  • Index Cond: (id = a_2."accountStoreId")
  • Filter: ((status)::text = 'ENABLED'::text)
42. 0.000 0.000 ↓ 0.0 0

Index Scan using group_memberships_group_id on "groupMemberships" "a->a->a_2" (cost=0.41..22.04 rows=25 width=32) (never executed)

  • Index Cond: ("groupId" = "a->a_2".id)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_pkey on accounts "a->a->a->a_1" (cost=0.29..0.34 rows=1 width=32) (never executed)

  • Index Cond: (id = "a->a->a_2"."accountId")
44. 0.018 10.523 ↓ 0.0 0 1

Nested Loop (cost=1.96..39.94 rows=1 width=16) (actual time=10.523..10.523 rows=0 loops=1)

  • Join Filter: ("a->a->a->a->a->a->a"."directoryId" = "a->a->a->a->a->a->a->d".id)
45. 0.007 0.007 ↓ 29.0 29 1

Seq Scan on directories "a->a->a->a->a->a->a->d" (cost=0.00..2.41 rows=1 width=16) (actual time=0.003..0.007 rows=29 loops=1)

  • Filter: ((status)::text = 'ENABLED'::text)
  • Rows Removed by Filter: 4
46. 0.000 10.498 ↓ 0.0 0 29

Nested Loop (cost=1.96..37.35 rows=14 width=32) (actual time=0.362..0.362 rows=0 loops=29)

47. 0.000 10.498 ↓ 0.0 0 29

Nested Loop (cost=1.67..32.65 rows=14 width=16) (actual time=0.362..0.362 rows=0 loops=29)

48. 0.000 10.498 ↓ 0.0 0 29

Nested Loop (cost=1.25..10.36 rows=1 width=16) (actual time=0.362..0.362 rows=0 loops=29)

  • Join Filter: ("a->a->a_3"."accountStoreId" = "a->a->a->a_2".id)
49. 0.000 10.498 ↓ 0.0 0 29

Nested Loop (cost=1.11..9.99 rows=1 width=48) (actual time=0.362..0.362 rows=0 loops=29)

50. 0.000 10.498 ↓ 0.0 0 29

Nested Loop (cost=0.83..7.81 rows=1 width=16) (actual time=0.362..0.362 rows=0 loops=29)

  • Join Filter: (a_3."accountStoreId" = "a->a_3".id)
51. 0.000 10.498 ↓ 0.0 0 29

Nested Loop (cost=0.56..6.29 rows=1 width=48) (actual time=0.362..0.362 rows=0 loops=29)

52. 0.812 2.320 ↓ 357.0 357 29

Nested Loop (cost=0.28..3.59 rows=1 width=16) (actual time=0.005..0.080 rows=357 loops=29)

53. 0.029 0.029 ↑ 1.0 1 29

Seq Scan on applications application_3 (cost=0.00..1.09 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=29)

  • Filter: (id = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid)
  • Rows Removed by Filter: 6
54. 1.479 1.479 ↓ 357.0 357 29

Index Scan using account_store_mappings_type_application_id on "accountStoreMappings" a_3 (cost=0.28..2.49 rows=1 width=32) (actual time=0.004..0.051 rows=357 loops=29)

  • Index Cond: (("accountStoreType" = 'organization'::"enum_accountStoreMappings_accountStoreType") AND ("applicationId" = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid))
55. 10.353 10.353 ↓ 0.0 0 10,353

Index Only Scan using organization_account_store_mappings_account_store_type_account_ on "organizationAccountStoreMappings" "a->a->a_3" (cost=0.28..2.69 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=10,353)

  • Index Cond: (("accountStoreType" = 'directory'::"enum_organizationAccountStoreMappings_accountStoreType") AND ("organizationId" = a_3."accountStoreId"))
  • Heap Fetches: 0
56. 0.000 0.000 ↓ 0.0 0

Index Scan using organizations_pkey on organizations "a->a_3" (cost=0.28..1.51 rows=1 width=16) (never executed)

  • Index Cond: (id = "a->a->a_3"."organizationId")
  • Filter: ((status)::text = 'ENABLED'::text)
57. 0.000 0.000 ↓ 0.0 0

Index Scan using groups_directory_id_status on groups "a->a->a->a->a_1" (cost=0.28..2.17 rows=1 width=32) (never executed)

  • Index Cond: (("directoryId" = "a->a->a_3"."accountStoreId") AND ((status)::text = 'ENABLED'::text))
58. 0.000 0.000 ↓ 0.0 0

Index Scan using directories_pkey on directories "a->a->a->a_2" (cost=0.14..0.35 rows=1 width=16) (never executed)

  • Index Cond: (id = "a->a->a->a->a_1"."directoryId")
  • Filter: ((status)::text = 'ENABLED'::text)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using group_memberships_group_id on "groupMemberships" "a->a->a->a->a->a" (cost=0.41..22.04 rows=25 width=32) (never executed)

  • Index Cond: ("groupId" = "a->a->a->a->a_1".id)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_pkey on accounts "a->a->a->a->a->a->a" (cost=0.29..0.34 rows=1 width=32) (never executed)

  • Index Cond: (id = "a->a->a->a->a->a"."accountId")
61. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=1.12..161.29 rows=1,262 width=16) (actual time=0.032..0.032 rows=0 loops=1)

62. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=0.83..9.51 rows=1 width=32) (actual time=0.032..0.032 rows=0 loops=1)

63. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=0.83..8.41 rows=1 width=48) (actual time=0.032..0.032 rows=0 loops=1)

  • Join Filter: ("a->a_4".id = a_4."accountStoreId")
64. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=0.56..6.84 rows=1 width=64) (actual time=0.032..0.032 rows=0 loops=1)

65. 0.000 0.032 ↓ 0.0 0 1

Nested Loop (cost=0.28..4.92 rows=1 width=48) (actual time=0.032..0.032 rows=0 loops=1)

66. 0.006 0.006 ↓ 29.0 29 1

Seq Scan on directories "a->a->a->a_3" (cost=0.00..2.41 rows=1 width=16) (actual time=0.002..0.006 rows=29 loops=1)

  • Filter: ((status)::text = 'ENABLED'::text)
  • Rows Removed by Filter: 4
67. 0.029 0.029 ↓ 0.0 0 29

Index Only Scan using organization_account_store_mappings_account_store_type_account_ on "organizationAccountStoreMappings" "a->a->a_4" (cost=0.28..2.50 rows=1 width=32) (actual time=0.001..0.001 rows=0 loops=29)

  • Index Cond: (("accountStoreType" = 'directory'::"enum_organizationAccountStoreMappings_accountStoreType") AND ("accountStoreId" = "a->a->a->a_3".id))
  • Heap Fetches: 0
68. 0.000 0.000 ↓ 0.0 0

Index Scan using organizations_pkey on organizations "a->a_4" (cost=0.28..1.51 rows=1 width=16) (never executed)

  • Index Cond: (id = "a->a->a_4"."organizationId")
  • Filter: ((status)::text = 'ENABLED'::text)
69. 0.000 0.000 ↓ 0.0 0

Index Only Scan using account_store_mappings_account_store_id_account_store_type_appl on "accountStoreMappings" a_4 (cost=0.28..1.56 rows=1 width=32) (never executed)

  • Index Cond: (("accountStoreId" = "a->a->a_4"."organizationId") AND ("accountStoreType" = 'organization'::"enum_accountStoreMappings_accountStoreType") AND ("applicationId" = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid))
  • Heap Fetches: 0
70. 0.000 0.000 ↓ 0.0 0

Seq Scan on applications application_4 (cost=0.00..1.09 rows=1 width=16) (never executed)

  • Filter: (id = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid)
71. 0.000 0.000 ↓ 0.0 0

Index Scan using accounts_directory_id on accounts "a->a->a->a->a_2" (cost=0.29..124.01 rows=2,777 width=32) (never executed)

  • Index Cond: ("directoryId" = "a->a->a_4"."accountStoreId")
72. 87.971 4,726.235 ↓ 54,156.0 54,156 1

Nested Loop (cost=1.82..39.72 rows=1 width=16) (actual time=832.564..4,726.235 rows=54,156 loops=1)

  • Join Filter: ("a->a->a->a->a->a_1"."directoryId" = "a->a->a->a->a->a->d".id)
  • Rows Removed by Join Filter: 1516368
73. 0.033 0.033 ↓ 29.0 29 1

Seq Scan on directories "a->a->a->a->a->a->d" (cost=0.00..2.41 rows=1 width=16) (actual time=0.002..0.033 rows=29 loops=1)

  • Filter: ((status)::text = 'ENABLED'::text)
  • Rows Removed by Filter: 4
74. 1,425.872 4,638.231 ↓ 3,868.3 54,156 29

Nested Loop (cost=1.82..37.13 rows=14 width=32) (actual time=0.082..159.939 rows=54,156 loops=29)

75. 237.713 1,641.835 ↓ 3,868.3 54,156 29

Nested Loop (cost=1.53..32.44 rows=14 width=16) (actual time=0.080..56.615 rows=54,156 loops=29)

  • Join Filter: ("a->a->a_5"."accountStoreId" = "a->a->a->a->a_3"."groupId")
76. 3.277 932.582 ↓ 1,084.0 1,084 29

Nested Loop (cost=1.11..10.08 rows=1 width=32) (actual time=0.078..32.158 rows=1,084 loops=29)

77. 19.546 865.215 ↓ 1,105.0 1,105 29

Nested Loop (cost=0.83..7.81 rows=1 width=16) (actual time=0.075..29.835 rows=1,105 loops=29)

  • Join Filter: (a_5."accountStoreId" = "a->a_5".id)
78. 1.247 813.624 ↓ 1,105.0 1,105 29

Nested Loop (cost=0.56..6.29 rows=1 width=48) (actual time=0.073..28.056 rows=1,105 loops=29)

79. 1.305 4.843 ↓ 357.0 357 29

Nested Loop (cost=0.28..3.59 rows=1 width=16) (actual time=0.011..0.167 rows=357 loops=29)

80. 0.116 0.116 ↑ 1.0 1 29

Seq Scan on applications application_5 (cost=0.00..1.09 rows=1 width=16) (actual time=0.001..0.004 rows=1 loops=29)

  • Filter: (id = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid)
  • Rows Removed by Filter: 6
81. 3.422 3.422 ↓ 357.0 357 29

Index Scan using account_store_mappings_type_application_id on "accountStoreMappings" a_5 (cost=0.28..2.49 rows=1 width=32) (actual time=0.009..0.118 rows=357 loops=29)

  • Index Cond: (("accountStoreType" = 'organization'::"enum_accountStoreMappings_accountStoreType") AND ("applicationId" = '8b96be0c-d3c3-4149-a5a5-556a388a0780'::uuid))
82. 807.534 807.534 ↓ 3.0 3 10,353

Index Only Scan using organization_account_store_mappings_account_store_type_account_ on "organizationAccountStoreMappings" "a->a->a_5" (cost=0.28..2.69 rows=1 width=32) (actual time=0.022..0.078 rows=3 loops=10,353)

  • Index Cond: (("accountStoreType" = 'group'::"enum_organizationAccountStoreMappings_accountStoreType") AND ("organizationId" = a_5."accountStoreId"))
  • Heap Fetches: 32045
83. 32.045 32.045 ↑ 1.0 1 32,045

Index Scan using organizations_pkey on organizations "a->a_5" (cost=0.28..1.51 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=32,045)

  • Index Cond: (id = "a->a->a_5"."organizationId")
  • Filter: ((status)::text = 'ENABLED'::text)
84. 64.090 64.090 ↑ 1.0 1 32,045

Index Scan using groups_pkey on groups "a->a->a->a_4" (cost=0.28..2.12 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=32,045)

  • Index Cond: (id = "a->a->a_5"."accountStoreId")
  • Filter: ((status)::text = 'ENABLED'::text)
85. 471.540 471.540 ↓ 2.0 50 31,436

Index Scan using group_memberships_group_id on "groupMemberships" "a->a->a->a->a_3" (cost=0.41..22.04 rows=25 width=32) (actual time=0.002..0.015 rows=50 loops=31,436)

  • Index Cond: ("groupId" = "a->a->a->a_4".id)
86. 1,570.524 1,570.524 ↑ 1.0 1 1,570,524

Index Scan using accounts_pkey on accounts "a->a->a->a->a->a_1" (cost=0.29..0.34 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1,570,524)

  • Index Cond: (id = "a->a->a->a->a_3"."accountId")
87. 0.006 0.006 ↑ 1.9 17 1

Seq Scan on "accountLockingPolicies" "directory->accountLockingPolicy" (cost=0.00..1.33 rows=33 width=144) (actual time=0.005..0.006 rows=17 loops=1)

Planning time : 31.701 ms
Execution time : 8,237.590 ms