explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DdqV

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,130.550 ↑ 1.0 1 1

Unique (cost=7,540.63..7,540.64 rows=1 width=17) (actual time=1,130.549..1,130.550 rows=1 loops=1)

2. 0.042 1,130.548 ↑ 1.0 1 1

Sort (cost=7,540.63..7,540.64 rows=1 width=17) (actual time=1,130.548..1,130.548 rows=1 loops=1)

  • Sort Key: ccc_.alias_value
  • Sort Method: quicksort Memory: 25kB
3. 0.004 1,130.506 ↑ 1.0 1 1

Nested Loop Semi Join (cost=6,147.54..7,540.62 rows=1 width=17) (actual time=85.034..1,130.506 rows=1 loops=1)

4. 0.073 1,130.102 ↓ 8.0 8 1

Nested Loop Semi Join (cost=6,145.00..7,406.20 rows=1 width=71) (actual time=79.743..1,130.102 rows=8 loops=1)

5. 0.288 1,114.789 ↓ 381.0 381 1

Nested Loop (cost=6,142.46..7,271.78 rows=1 width=44) (actual time=71.029..1,114.789 rows=381 loops=1)

6. 1.047 1,109.929 ↓ 381.0 381 1

Hash Join (cost=6,142.03..7,246.23 rows=1 width=68) (actual time=70.949..1,109.929 rows=381 loops=1)

  • Hash Cond: (xb_.r_object_id = acc_.r_object_id)
7. 1.241 1,108.670 ↑ 2.1 7,630 1

Merge Join (cost=5,973.15..6,877.44 rows=15,834 width=78) (actual time=51.437..1,108.670 rows=7,630 loops=1)

  • Merge Cond: (wb__1.r_object_id = lyb_.r_object_id)
8. 6.818 1,107.057 ↑ 2.1 7,630 1

Nested Loop (cost=5,622.96..209,704.25 rows=15,834 width=112) (actual time=51.037..1,107.057 rows=7,630 loops=1)

  • Join Filter: (dm_repeating1_1.i_position = xb_.i_position)
  • Rows Removed by Join Filter: 102,603
9. 0.008 0.547 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.14..1,804.03 rows=1 width=63) (actual time=0.395..0.547 rows=1 loops=1)

  • Filter: (((wb__1.owner_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])) OR (SubPlan 2))
10. 0.004 0.484 ↑ 1.0 1 1

Nested Loop (cost=0.71..1,783.51 rows=1 width=100) (actual time=0.333..0.484 rows=1 loops=1)

  • Join Filter: (wb__1.r_object_id = dm_repeating1_1.r_object_id)
  • Rows Removed by Join Filter: 14
11. 0.420 0.420 ↑ 1.0 15 1

Index Scan using d_1f01e24080000539 on d2_dictionary_r dm_repeating1_1 (cost=0.28..1,770.93 rows=15 width=19) (actual time=0.056..0.420 rows=15 loops=1)

  • Filter: ((alias_name)::text = 'Subgroup'::text)
  • Rows Removed by Filter: 1,673
12. 0.011 0.060 ↑ 2.0 1 15

Materialize (cost=0.43..12.13 rows=2 width=81) (actual time=0.004..0.004 rows=1 loops=15)

13. 0.049 0.049 ↑ 2.0 1 1

Index Scan using d_1f01e2408000000f on dm_sysobject_s wb__1 (cost=0.43..12.12 rows=2 width=81) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: ((object_name)::text = 'Regulatory-Admin Artifact'::text)
  • Filter: ((i_has_folder = 1) AND (i_is_deleted = 0))
14. 0.016 0.016 ↑ 1.0 1 1

Index Scan using d_1f01e24080000990 on dm_acl_s acl_s1 (cost=0.43..8.45 rows=1 width=48) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: ((wb__1.acl_name)::text = (object_name)::text)
  • Filter: ((wb__1.acl_domain)::text = (owner_name)::text)
15.          

SubPlan (for Nested Loop Left Join)

16. 0.004 0.039 ↑ 1.0 1 1

Result (cost=0.43..12.05 rows=1 width=0) (actual time=0.039..0.039 rows=1 loops=1)

  • One-Time Filter: (((wb__1.acl_domain)::text = (acl_s1.owner_name)::text) AND ((wb__1.acl_name)::text = (acl_s1.object_name)::text))
17. 0.035 0.035 ↑ 1.0 1 1

Index Scan using d_1f01e24080000991 on dm_acl_r acl_r_1 (cost=0.43..12.05 rows=1 width=0) (actual time=0.035..0.035 rows=1 loops=1)

  • Index Cond: (acl_s1.r_object_id = r_object_id)
  • Filter: (((r_permit_type = 0) OR (r_permit_type IS NULL)) AND (r_accessor_permit >= 2) AND (((r_accessor_name)::text = ANY ('{reguser358,dm_world}'::text[])) OR ((r_is_group = 1) AND ((r_accessor_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])))))
  • Rows Removed by Filter: 4
18. 30.836 1,099.692 ↓ 1.3 110,233 1

Gather (cost=5,621.82..206,841.50 rows=84,698 width=55) (actual time=50.539..1,099.692 rows=110,233 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
19. 629.320 1,068.856 ↓ 1.0 36,744 3 / 3

Hash Join (cost=4,621.82..197,371.70 rows=35,291 width=55) (actual time=46.826..1,068.856 rows=36,744 loops=3)

  • Hash Cond: ((xb_.r_object_id = ccc_.r_object_id) AND (xb_.i_position = ccc_.i_position))
20. 395.478 395.478 ↑ 1.3 2,558,505 3 / 3

Parallel Seq Scan on dm_sysobject_r xb_ (cost=0.00..105,630.71 rows=3,198,371 width=19) (actual time=0.018..395.478 rows=2,558,505 loops=3)

21. 26.787 44.058 ↑ 1.0 110,233 3 / 3

Hash (cost=2,106.33..2,106.33 rows=110,233 width=36) (actual time=44.058..44.058 rows=110,233 loops=3)

  • Buckets: 131,072 Batches: 2 Memory Usage: 4,701kB
22. 17.271 17.271 ↑ 1.0 110,233 3 / 3

Seq Scan on d2_dictionary_value_r ccc_ (cost=0.00..2,106.33 rows=110,233 width=36) (actual time=0.024..17.271 rows=110,233 loops=3)

23. 0.278 0.372 ↑ 1.4 260 1

Sort (cost=27.90..28.85 rows=377 width=17) (actual time=0.361..0.372 rows=260 loops=1)

  • Sort Key: lyb_.r_object_id
  • Sort Method: quicksort Memory: 54kB
24. 0.094 0.094 ↑ 1.0 377 1

Seq Scan on d2_dictionary_s lyb_ (cost=0.00..11.77 rows=377 width=17) (actual time=0.008..0.094 rows=377 loops=1)

25. 0.080 0.212 ↑ 1.0 381 1

Hash (cost=164.13..164.13 rows=381 width=50) (actual time=0.212..0.212 rows=381 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 36kB
26. 0.076 0.132 ↑ 1.0 381 1

Bitmap Heap Scan on d2_dictionary_value_s acc_ (cost=19.36..164.13 rows=381 width=50) (actual time=0.067..0.132 rows=381 loops=1)

  • Recheck Cond: ((dictionary_name)::text = 'Regulatory-Admin Artifact'::text)
  • Heap Blocks: exact=5
27. 0.056 0.056 ↑ 1.0 381 1

Bitmap Index Scan on d_1f01e2408000099c (cost=0.00..19.27 rows=381 width=0) (actual time=0.056..0.056 rows=381 loops=1)

  • Index Cond: ((dictionary_name)::text = 'Regulatory-Admin Artifact'::text)
28. 1.905 4.572 ↑ 1.0 1 381

Index Scan using d_1f01e2408000010b on dm_sysobject_s wb_ (cost=0.43..25.55 rows=1 width=72) (actual time=0.012..0.012 rows=1 loops=381)

  • Index Cond: (r_object_id = xb_.r_object_id)
  • Filter: ((i_has_folder = 1) AND (i_is_deleted = 0) AND (((owner_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])) OR (SubPlan 1)))
29.          

SubPlan (for Index Scan)

30. 0.381 2.667 ↑ 1.0 1 381

Nested Loop (cost=0.86..20.51 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=381)

31. 0.762 0.762 ↑ 1.0 1 381

Index Scan using d_1f01e24080000990 on dm_acl_s acl_s0 (cost=0.43..8.45 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=381)

  • Index Cond: ((wb_.acl_name)::text = (object_name)::text)
  • Filter: ((wb_.acl_domain)::text = (owner_name)::text)
32. 1.524 1.524 ↑ 1.0 1 381

Index Scan using d_1f01e24080000991 on dm_acl_r acl_r (cost=0.43..12.05 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=381)

  • Index Cond: (r_object_id = acl_s0.r_object_id)
  • Filter: (((r_permit_type = 0) OR (r_permit_type IS NULL)) AND (r_accessor_permit >= 2) AND (((r_accessor_name)::text = ANY ('{reguser358,dm_world}'::text[])) OR ((r_is_group = 1) AND ((r_accessor_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])))))
  • Rows Removed by Filter: 4
33. 0.099 15.240 ↓ 0.0 0 381

Nested Loop (cost=2.54..134.41 rows=1 width=27) (actual time=0.040..0.040 rows=0 loops=381)

  • Join Filter: ((wb__3.r_object_id = dm_repeating2_1.r_object_id) AND (dm_repeating2_0.i_position = dm_repeating2_1.i_position))
  • Rows Removed by Join Filter: 0
34. 0.485 14.859 ↓ 0.0 0 381

Nested Loop Left Join (cost=2.26..129.72 rows=1 width=63) (actual time=0.038..0.039 rows=0 loops=381)

  • Filter: (((wb__3.owner_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])) OR (SubPlan 4))
35. 0.193 13.716 ↓ 0.0 0 381

Nested Loop (cost=1.83..109.20 rows=1 width=100) (actual time=0.036..0.036 rows=0 loops=381)

36. 0.005 13.335 ↓ 0.0 0 381

Nested Loop (cost=1.56..100.86 rows=1 width=83) (actual time=0.035..0.035 rows=0 loops=381)

37. 0.381 12.954 ↓ 0.0 0 381

Nested Loop (cost=1.13..88.73 rows=1 width=62) (actual time=0.034..0.034 rows=0 loops=381)

38. 0.780 10.287 ↑ 1.0 1 381

Nested Loop (cost=0.72..75.67 rows=1 width=94) (actual time=0.027..0.027 rows=1 loops=381)

39. 2.730 8.001 ↓ 2.0 2 381

Index Scan using d_1f01e2408000000f on dm_sysobject_s wb__2 (cost=0.43..70.86 rows=1 width=72) (actual time=0.013..0.021 rows=2 loops=381)

  • Index Cond: ((object_name)::text = (wb_.object_name)::text)
  • Filter: ((i_has_folder = 1) AND (i_is_deleted = 0) AND (((owner_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])) OR (SubPlan 3)))
40.          

SubPlan (for Index Scan)

41. 0.753 5.271 ↑ 1.0 1 753

Nested Loop (cost=0.86..20.51 rows=1 width=0) (actual time=0.007..0.007 rows=1 loops=753)

42. 1.506 1.506 ↑ 1.0 1 753

Index Scan using d_1f01e24080000990 on dm_acl_s acl_s0_1 (cost=0.43..8.45 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=753)

  • Index Cond: ((wb__2.acl_name)::text = (object_name)::text)
  • Filter: ((wb__2.acl_domain)::text = (owner_name)::text)
43. 3.012 3.012 ↑ 1.0 1 753

Index Scan using d_1f01e24080000991 on dm_acl_r acl_r_2 (cost=0.43..12.05 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=753)

  • Index Cond: (r_object_id = acl_s0_1.r_object_id)
  • Filter: (((r_permit_type = 0) OR (r_permit_type IS NULL)) AND (r_accessor_permit >= 2) AND (((r_accessor_name)::text = ANY ('{reguser358,dm_world}'::text[])) OR ((r_is_group = 1) AND ((r_accessor_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])))))
  • Rows Removed by Filter: 3
44. 1.506 1.506 ↑ 1.0 1 753

Index Scan using d_1f01e2408000053b on d2_dictionary_value_s acc__1 (cost=0.29..4.79 rows=1 width=50) (actual time=0.002..0.002 rows=1 loops=753)

  • Index Cond: (r_object_id = wb__2.r_object_id)
  • Filter: ((dictionary_name)::text = 'Regulatory-Admin Artifact'::text)
  • Rows Removed by Filter: 0
45. 2.286 2.286 ↓ 0.0 0 381

Index Scan using d_1f01e2408000053c on d2_dictionary_value_r dm_repeating2_0 (cost=0.42..13.04 rows=1 width=19) (actual time=0.006..0.006 rows=0 loops=381)

  • Index Cond: (r_object_id = wb__2.r_object_id)
  • Filter: ((alias_value)::text = 'Application Form'::text)
  • Rows Removed by Filter: 15
46. 0.376 0.376 ↑ 2.0 1 94

Index Scan using d_1f01e2408000000f on dm_sysobject_s wb__3 (cost=0.43..12.12 rows=2 width=81) (actual time=0.004..0.004 rows=1 loops=94)

  • Index Cond: ((object_name)::text = 'Regulatory-Admin Artifact'::text)
  • Filter: ((i_has_folder = 1) AND (i_is_deleted = 0))
47. 0.188 0.188 ↑ 1.0 1 94

Index Only Scan using d_1f01e24080000538 on d2_dictionary_s lyb__1 (cost=0.27..8.29 rows=1 width=17) (actual time=0.002..0.002 rows=1 loops=94)

  • Index Cond: (r_object_id = wb__3.r_object_id)
  • Heap Fetches: 94
48. 0.188 0.188 ↑ 1.0 1 94

Index Scan using d_1f01e24080000990 on dm_acl_s acl_s1_1 (cost=0.43..8.45 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=94)

  • Index Cond: ((wb__3.acl_name)::text = (object_name)::text)
  • Filter: ((wb__3.acl_domain)::text = (owner_name)::text)
49.          

SubPlan (for Nested Loop Left Join)

50. 0.094 0.470 ↑ 1.0 1 94

Result (cost=0.43..12.05 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=94)

  • One-Time Filter: (((wb__3.acl_domain)::text = (acl_s1_1.owner_name)::text) AND ((wb__3.acl_name)::text = (acl_s1_1.object_name)::text))
51. 0.376 0.376 ↑ 1.0 1 94

Index Scan using d_1f01e24080000991 on dm_acl_r acl_r_3 (cost=0.43..12.05 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=94)

  • Index Cond: (acl_s1_1.r_object_id = r_object_id)
  • Filter: (((r_permit_type = 0) OR (r_permit_type IS NULL)) AND (r_accessor_permit >= 2) AND (((r_accessor_name)::text = ANY ('{reguser358,dm_world}'::text[])) OR ((r_is_group = 1) AND ((r_accessor_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])))))
  • Rows Removed by Filter: 4
52. 0.282 0.282 ↑ 1.0 1 94

Index Scan using d_1f01e2408000099b on d2_dictionary_r dm_repeating2_1 (cost=0.28..4.68 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=94)

  • Index Cond: ((r_object_id = lyb__1.r_object_id) AND ((alias_name)::text = 'Artifact'::text))
53. 0.009 0.400 ↓ 0.0 0 8

Nested Loop (cost=2.54..134.41 rows=1 width=27) (actual time=0.050..0.050 rows=0 loops=8)

  • Join Filter: ((wb__5.r_object_id = dm_repeating2_1_1.r_object_id) AND (dm_repeating2_0_1.i_position = dm_repeating2_1_1.i_position))
54. 0.013 0.384 ↓ 0.0 0 8

Nested Loop Left Join (cost=2.26..129.72 rows=1 width=63) (actual time=0.048..0.048 rows=0 loops=8)

  • Filter: (((wb__5.owner_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])) OR (SubPlan 6))
55. 0.005 0.344 ↓ 0.0 0 8

Nested Loop (cost=1.83..109.20 rows=1 width=100) (actual time=0.043..0.043 rows=0 loops=8)

56. 0.005 0.328 ↓ 0.0 0 8

Nested Loop (cost=1.56..100.86 rows=1 width=83) (actual time=0.041..0.041 rows=0 loops=8)

57. 0.008 0.312 ↓ 0.0 0 8

Nested Loop (cost=1.13..88.73 rows=1 width=62) (actual time=0.039..0.039 rows=0 loops=8)

58. 0.024 0.256 ↑ 1.0 1 8

Nested Loop (cost=0.72..75.67 rows=1 width=94) (actual time=0.030..0.032 rows=1 loops=8)

59. 0.072 0.200 ↓ 2.0 2 8

Index Scan using d_1f01e2408000000f on dm_sysobject_s wb__4 (cost=0.43..70.86 rows=1 width=72) (actual time=0.015..0.025 rows=2 loops=8)

  • Index Cond: ((object_name)::text = (wb_.object_name)::text)
  • Filter: ((i_has_folder = 1) AND (i_is_deleted = 0) AND (((owner_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])) OR (SubPlan 5)))
60.          

SubPlan (for Index Scan)

61. 0.016 0.128 ↑ 1.0 1 16

Nested Loop (cost=0.86..20.51 rows=1 width=0) (actual time=0.008..0.008 rows=1 loops=16)

62. 0.048 0.048 ↑ 1.0 1 16

Index Scan using d_1f01e24080000990 on dm_acl_s acl_s0_2 (cost=0.43..8.45 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=16)

  • Index Cond: ((wb__4.acl_name)::text = (object_name)::text)
  • Filter: ((wb__4.acl_domain)::text = (owner_name)::text)
63. 0.064 0.064 ↑ 1.0 1 16

Index Scan using d_1f01e24080000991 on dm_acl_r acl_r_4 (cost=0.43..12.05 rows=1 width=17) (actual time=0.004..0.004 rows=1 loops=16)

  • Index Cond: (r_object_id = acl_s0_2.r_object_id)
  • Filter: (((r_permit_type = 0) OR (r_permit_type IS NULL)) AND (r_accessor_permit >= 2) AND (((r_accessor_name)::text = ANY ('{reguser358,dm_world}'::text[])) OR ((r_is_group = 1) AND ((r_accessor_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])))))
  • Rows Removed by Filter: 3
64. 0.032 0.032 ↓ 0.0 0 16

Index Scan using d_1f01e2408000053b on d2_dictionary_value_s acc__2 (cost=0.29..4.79 rows=1 width=50) (actual time=0.002..0.002 rows=0 loops=16)

  • Index Cond: (r_object_id = wb__4.r_object_id)
  • Filter: ((dictionary_name)::text = 'Regulatory-Admin Artifact'::text)
  • Rows Removed by Filter: 0
65. 0.048 0.048 ↓ 0.0 0 8

Index Scan using d_1f01e2408000053c on d2_dictionary_value_r dm_repeating2_0_1 (cost=0.42..13.04 rows=1 width=19) (actual time=0.006..0.006 rows=0 loops=8)

  • Index Cond: (r_object_id = wb__4.r_object_id)
  • Filter: ((alias_value)::text = 'CA'::text)
  • Rows Removed by Filter: 14
66. 0.011 0.011 ↑ 2.0 1 1

Index Scan using d_1f01e2408000000f on dm_sysobject_s wb__5 (cost=0.43..12.12 rows=2 width=81) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: ((object_name)::text = 'Regulatory-Admin Artifact'::text)
  • Filter: ((i_has_folder = 1) AND (i_is_deleted = 0))
67. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using d_1f01e24080000538 on d2_dictionary_s lyb__2 (cost=0.27..8.29 rows=1 width=17) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (r_object_id = wb__5.r_object_id)
  • Heap Fetches: 1
68. 0.013 0.013 ↑ 1.0 1 1

Index Scan using d_1f01e24080000990 on dm_acl_s acl_s1_2 (cost=0.43..8.45 rows=1 width=48) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: ((wb__5.acl_name)::text = (object_name)::text)
  • Filter: ((wb__5.acl_domain)::text = (owner_name)::text)
69.          

SubPlan (for Nested Loop Left Join)

70. 0.004 0.014 ↑ 1.0 1 1

Result (cost=0.43..12.05 rows=1 width=0) (actual time=0.014..0.014 rows=1 loops=1)

  • One-Time Filter: (((wb__5.acl_domain)::text = (acl_s1_2.owner_name)::text) AND ((wb__5.acl_name)::text = (acl_s1_2.object_name)::text))
71. 0.010 0.010 ↑ 1.0 1 1

Index Scan using d_1f01e24080000991 on dm_acl_r acl_r_5 (cost=0.43..12.05 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (acl_s1_2.r_object_id = r_object_id)
  • Filter: (((r_permit_type = 0) OR (r_permit_type IS NULL)) AND (r_accessor_permit >= 2) AND (((r_accessor_name)::text = ANY ('{reguser358,dm_world}'::text[])) OR ((r_is_group = 1) AND ((r_accessor_name)::text = ANY ('{reguser358,cd_regulatory,cd_regulatory_doc_authors,dm_world,cd_regulatory_users,ws_lsrd_managers,cd_general,cd_submission_users,cd_general_doc_authors}'::text[])))))
  • Rows Removed by Filter: 4
72. 0.007 0.007 ↑ 1.0 1 1

Index Scan using d_1f01e2408000099b on d2_dictionary_r dm_repeating2_1_1 (cost=0.28..4.68 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((r_object_id = lyb__2.r_object_id) AND ((alias_name)::text = 'Region'::text))
Planning time : 50.760 ms
Execution time : 1,131.339 ms