explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kOMzn : Optimization for: Optimization for: Optimization for: Optimization for: plan #DCuI; plan #l38n; plan #NEe1; plan #d7Ee

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.008 1,031.871 ↓ 3.3 50 1

Limit (cost=40,392.98..59,081.39 rows=15 width=2,082) (actual time=1,016.292..1,031.871 rows=50 loops=1)

2. 0.425 1,031.863 ↓ 3.3 50 1

Nested Loop Semi Join (cost=40,392.98..59,081.39 rows=15 width=2,082) (actual time=1,016.291..1,031.863 rows=50 loops=1)

3. 0.726 1,027.338 ↓ 1.6 50 1

Nested Loop (cost=40,392.56..56,442.59 rows=31 width=907) (actual time=1,016.061..1,027.338 rows=50 loops=1)

4. 0.476 1,021.988 ↓ 1.7 1,156 1

Unique (cost=40,392.13..51,034.02 rows=698 width=549) (actual time=1,015.788..1,021.988 rows=1,156 loops=1)

5. 0.527 1,021.512 ↓ 1.7 1,156 1

Nested Loop (cost=40,392.13..51,032.27 rows=698 width=549) (actual time=1,015.787..1,021.512 rows=1,156 loops=1)

6. 0.271 1,016.361 ↑ 1.4 1,156 1

Unique (cost=40,391.71..40,399.63 rows=1,584 width=16) (actual time=1,015.766..1,016.361 rows=1,156 loops=1)

7. 44.134 1,016.090 ↑ 1.4 1,164 1

Sort (cost=40,391.71..40,395.67 rows=1,584 width=16) (actual time=1,015.765..1,016.090 rows=1,164 loops=1)

  • Sort Key: cr.id, t_3.priority DESC
  • Sort Method: quicksort Memory: 6559kB
8. 37.407 971.956 ↓ 47.0 74,385 1

Hash Join (cost=11,149.50..40,307.53 rows=1,584 width=16) (actual time=118.355..971.956 rows=74,385 loops=1)

  • Hash Cond: (p_1.f_data_source = t_3.id)
9. 68.163 934.536 ↓ 47.0 74,385 1

Hash Join (cost=11,148.39..40,284.64 rows=1,584 width=12) (actual time=118.332..934.536 rows=74,385 loops=1)

  • Hash Cond: ((p_2.cid)::numeric = t_2.catalog)
10. 49.417 866.042 ↓ 23.5 74,385 1

Nested Loop (cost=11,138.44..40,258.59 rows=3,169 width=20) (actual time=117.979..866.042 rows=74,385 loops=1)

11. 79.876 370.315 ↓ 8.1 74,385 1

Hash Join (cost=11,138.01..29,480.46 rows=9,136 width=20) (actual time=117.937..370.315 rows=74,385 loops=1)

  • Hash Cond: (cr.id = p_1.childreestr_id)
12. 172.641 172.641 ↓ 1.0 214,992 1

Seq Scan on m_childreestr cr (cost=0.00..16,103.14 rows=214,795 width=12) (actual time=0.091..172.641 rows=214,992 loops=1)

  • Filter: (f_uptodate AND (NOT deleted))
  • Rows Removed by Filter: 272122
13. 16.171 117.798 ↓ 3.6 74,385 1

Hash (cost=10,879.03..10,879.03 rows=20,719 width=12) (actual time=117.798..117.798 rows=74,385 loops=1)

  • Buckets: 131072 (originally 32768) Batches: 1 (originally 1) Memory Usage: 4511kB
14. 26.973 101.627 ↓ 3.6 74,385 1

Hash Join (cost=581.96..10,879.03 rows=20,719 width=12) (actual time=3.544..101.627 rows=74,385 loops=1)

  • Hash Cond: (p_1.orgreestr_id = t_4.id)
15. 71.128 71.128 ↑ 1.0 74,385 1

Seq Scan on m_person_education p_1 (cost=0.00..9,808.38 rows=74,991 width=16) (actual time=0.011..71.128 rows=74,385 loops=1)

  • Filter: (39 = ANY (learning_years))
  • Rows Removed by Filter: 210032
16. 0.127 3.526 ↓ 1.5 547 1

Hash (cost=577.32..577.32 rows=371 width=4) (actual time=3.526..3.526 rows=547 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
17. 0.234 3.399 ↓ 1.5 547 1

Hash Join (cost=94.17..577.32 rows=371 width=4) (actual time=0.727..3.399 rows=547 loops=1)

  • Hash Cond: (t_5.id = t_4.f_max_priority)
18. 2.462 2.462 ↑ 1.4 547 1

Seq Scan on m_organization t_5 (cost=0.00..476.58 rows=762 width=8) (actual time=0.015..2.462 rows=547 loops=1)

  • Filter: (f_uptodate AND (NOT deleted))
  • Rows Removed by Filter: 2211
19. 0.240 0.703 ↑ 1.0 1,341 1

Hash (cost=77.41..77.41 rows=1,341 width=12) (actual time=0.703..0.703 rows=1,341 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 79kB
20. 0.463 0.463 ↑ 1.0 1,341 1

Seq Scan on m_orgreestr t_4 (cost=0.00..77.41 rows=1,341 width=12) (actual time=0.003..0.463 rows=1,341 loops=1)

21. 446.310 446.310 ↑ 1.0 1 74,385

Index Scan using m_person_id_idx on m_person p_2 (cost=0.42..1.17 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=74,385)

  • Index Cond: (id = cr.f_max_priority)
  • Filter: (f_uptodate AND (NOT deleted))
22. 0.008 0.331 ↓ 3.8 23 1

Hash (cost=9.88..9.88 rows=6 width=5) (actual time=0.331..0.331 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
23. 0.017 0.323 ↓ 3.8 23 1

HashAggregate (cost=9.82..9.88 rows=6 width=5) (actual time=0.319..0.323 rows=23 loops=1)

  • Group Key: t_2.catalog
24. 0.008 0.306 ↓ 3.8 23 1

Nested Loop (cost=4.35..9.80 rows=6 width=5) (actual time=0.080..0.306 rows=23 loops=1)

25. 0.261 0.261 ↑ 1.0 1 1

Seq Scan on userroles t1_1 (cost=0.00..1.30 rows=1 width=5) (actual time=0.044..0.261 rows=1 loops=1)

  • Filter: (sysuser = (core.f_sys_get_config('sysuser'::text))::numeric)
  • Rows Removed by Filter: 14
26. 0.013 0.037 ↓ 3.8 23 1

Bitmap Heap Scan on urprivs t_2 (cost=4.35..8.44 rows=6 width=11) (actual time=0.031..0.037 rows=23 loops=1)

  • Recheck Cond: (((unitcode)::text = 'orgreestr'::text) AND (roleid = t1_1.roleid) AND (catalog IS NOT NULL))
  • Heap Blocks: exact=2
27. 0.024 0.024 ↓ 3.8 23 1

Bitmap Index Scan on i_urprivs_uc (cost=0.00..4.35 rows=6 width=0) (actual time=0.024..0.024 rows=23 loops=1)

  • Index Cond: (((unitcode)::text = 'orgreestr'::text) AND (roleid = t1_1.roleid) AND (catalog IS NOT NULL))
28. 0.003 0.013 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.013..0.013 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.010 0.010 ↑ 1.0 5 1

Seq Scan on m_dataresource t_3 (cost=0.00..1.05 rows=5 width=8) (actual time=0.008..0.010 rows=5 loops=1)

30. 4.624 4.624 ↑ 1.0 1 1,156

Index Scan using m_childreestr_id_idx on m_childreestr t_1 (cost=0.42..6.69 rows=1 width=533) (actual time=0.004..0.004 rows=1 loops=1,156)

  • Index Cond: (id = cr.id)
  • Filter: (f_uptodate AND (NOT deleted))
31. 4.624 4.624 ↓ 0.0 0 1,156

Index Scan using m_person_id_idx on m_person p (cost=0.42..7.73 rows=1 width=382) (actual time=0.004..0.004 rows=0 loops=1,156)

  • Index Cond: (id = t_1.f_max_priority)
  • Filter: ((f_personlastname)::text ~~ 'А%'::text)
  • Rows Removed by Filter: 1
32. 1.650 2.200 ↑ 1.0 1 50

Nested Loop (cost=0.42..1.11 rows=1 width=5) (actual time=0.044..0.044 rows=1 loops=50)

33. 0.250 0.250 ↑ 1.0 1 50

Index Scan using i_urprivs_cat on urprivs t (cost=0.28..0.30 rows=1 width=11) (actual time=0.005..0.005 rows=1 loops=50)

  • Index Cond: ((catalog = (p.cid)::numeric) AND (catalog IS NOT NULL))
  • Filter: ((unitcode)::text = 'orgreestr'::text)
34. 0.300 0.300 ↑ 1.0 1 50

Index Only Scan using uk_userroles on userroles t1 (cost=0.14..0.79 rows=1 width=5) (actual time=0.006..0.006 rows=1 loops=50)

  • Index Cond: ((roleid = t.roleid) AND (sysuser = (core.f_sys_get_config('sysuser'::text))::numeric))
  • Heap Fetches: 50
35.          

SubPlan (for Nested Loop Semi Join)

36. 0.050 0.850 ↑ 1.0 1 50

Limit (cost=0.98..17.06 rows=1 width=97) (actual time=0.017..0.017 rows=1 loops=50)

37. 0.036 0.800 ↑ 1.0 1 50

Nested Loop (cost=0.98..17.06 rows=1 width=97) (actual time=0.016..0.016 rows=1 loops=50)

38. 0.084 0.650 ↑ 1.0 1 50

Nested Loop (cost=0.84..16.89 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=50)

39. 0.300 0.300 ↑ 1.0 1 50

Index Scan using m_documentchild2child_f_child_idx on m_documentchild2child t_6 (cost=0.42..8.44 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=50)

  • Index Cond: (f_child = t_1.f_max_priority)
40. 0.266 0.266 ↑ 1.0 1 38

Index Scan using m_documentchild_id_idx on m_documentchild t_7 (cost=0.42..8.44 rows=1 width=16) (actual time=0.007..0.007 rows=1 loops=38)

  • Index Cond: (id = t_6.f_document)
  • Filter: (f_uptodate AND (NOT deleted))
41. 0.114 0.114 ↑ 1.0 1 38

Index Scan using m_doctypes_id_idx on m_doctypes t_8 (cost=0.14..0.16 rows=1 width=101) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: (id = t_7.f_doc_type)
42. 0.050 0.450 ↑ 1.0 1 50

Limit (cost=0.98..17.06 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=50)

43. 0.024 0.400 ↑ 1.0 1 50

Nested Loop (cost=0.98..17.06 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=50)

44. 0.036 0.300 ↑ 1.0 1 50

Nested Loop (cost=0.84..16.89 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=50)

45. 0.150 0.150 ↑ 1.0 1 50

Index Scan using m_documentchild2child_f_child_idx on m_documentchild2child t_9 (cost=0.42..8.44 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=50)

  • Index Cond: (f_child = t_1.f_max_priority)
46. 0.114 0.114 ↑ 1.0 1 38

Index Scan using m_documentchild_id_idx on m_documentchild t_10 (cost=0.42..8.44 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: (id = t_9.f_document)
  • Filter: (f_uptodate AND (NOT deleted))
47. 0.076 0.076 ↑ 1.0 1 38

Index Only Scan using m_doctypes_id_idx on m_doctypes t_11 (cost=0.14..0.16 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=38)

  • Index Cond: (id = t_10.f_doc_type)
  • Heap Fetches: 38
48. 0.000 0.300 ↑ 1.0 1 50

Limit (cost=0.84..16.89 rows=1 width=6) (actual time=0.006..0.006 rows=1 loops=50)

49. 0.086 0.300 ↑ 1.0 1 50

Nested Loop (cost=0.84..16.89 rows=1 width=6) (actual time=0.006..0.006 rows=1 loops=50)

50. 0.100 0.100 ↑ 1.0 1 50

Index Scan using m_documentchild2child_f_child_idx on m_documentchild2child t_12 (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=50)

  • Index Cond: (f_child = t_1.f_max_priority)
51. 0.114 0.114 ↑ 1.0 1 38

Index Scan using m_documentchild_id_idx on m_documentchild t_13 (cost=0.42..8.44 rows=1 width=14) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: (id = t_12.f_document)
  • Filter: (f_uptodate AND (NOT deleted))
52. 0.050 0.300 ↑ 1.0 1 50

Limit (cost=0.84..16.89 rows=1 width=7) (actual time=0.006..0.006 rows=1 loops=50)

53. 0.036 0.250 ↑ 1.0 1 50

Nested Loop (cost=0.84..16.89 rows=1 width=7) (actual time=0.005..0.005 rows=1 loops=50)

54. 0.100 0.100 ↑ 1.0 1 50

Index Scan using m_documentchild2child_f_child_idx on m_documentchild2child t_14 (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=50)

  • Index Cond: (f_child = t_1.f_max_priority)
55. 0.114 0.114 ↑ 1.0 1 38

Index Scan using m_documentchild_id_idx on m_documentchild t_15 (cost=0.42..8.44 rows=1 width=15) (actual time=0.003..0.003 rows=1 loops=38)

  • Index Cond: (id = t_14.f_document)
  • Filter: f_uptodate
56. 0.000 0.000 ↓ 0.0 0

Subquery Scan on data (cost=15.43..52.84 rows=1 width=32) (never executed)

57.          

Initplan (for Subquery Scan)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_16 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '3'::text)
59. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_17 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '1'::text)
60. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_18 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '2'::text)
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_19 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '3'::text)
62. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_20 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '0'::text)
63. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_21 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '1'::text)
64. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_22 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '2'::text)
65. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_23 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '3'::text)
66. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_24 (cost=0.00..1.07 rows=1 width=23) (never executed)

  • Filter: ((code)::text = '4'::text)
67. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=5.75..43.13 rows=1 width=40) (never executed)

  • Group Key: p_3.f_link2reestr
68. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.75..43.11 rows=1 width=10) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.62..42.94 rows=1 width=16) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.20..42.46 rows=1 width=16) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=4.78..18.38 rows=1 width=16) (never executed)

  • Join Filter: ((p_3.cid)::numeric = t_27.catalog)
72. 0.000 0.000 ↓ 0.0 0

Index Scan using m_person_f_link2reestr_idx on m_person p_3 (cost=0.42..8.44 rows=1 width=24) (never executed)

  • Index Cond: (f_link2reestr = t_1.id)
  • Filter: (f_uptodate AND (NOT deleted))
73. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.35..9.83 rows=6 width=5) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.35..9.80 rows=6 width=5) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on userroles t1_2 (cost=0.00..1.30 rows=1 width=5) (never executed)

  • Filter: (sysuser = (core.f_sys_get_config('sysuser'::text))::numeric)
76. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on urprivs t_27 (cost=4.35..8.44 rows=6 width=11) (never executed)

  • Recheck Cond: (((unitcode)::text = 'orgreestr'::text) AND (roleid = t1_2.roleid) AND (catalog IS NOT NULL))
77. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on i_urprivs_uc (cost=0.00..4.35 rows=6 width=0) (never executed)

  • Index Cond: (((unitcode)::text = 'orgreestr'::text) AND (roleid = t1_2.roleid) AND (catalog IS NOT NULL))
78. 0.000 0.000 ↓ 0.0 0

Index Scan using m_declaration2child_f_child_idx on m_declaration2child t_26 (cost=0.42..24.03 rows=5 width=16) (never executed)

  • Index Cond: (f_child = p_3.id)
79. 0.000 0.000 ↓ 0.0 0

Index Scan using m_declaration_id_idx on m_declaration t_25 (cost=0.42..0.47 rows=1 width=12) (never executed)

  • Index Cond: (id = t_26.f_decl)
  • Filter: (f_uptodate AND (NOT deleted))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using m_declarationtype_id_idx on m_declarationtype t_28 (cost=0.13..0.16 rows=1 width=6) (never executed)

  • Index Cond: (id = t_25.f_delc_type)
  • Filter: ((code)::text = ANY ('{0,1,2,3,4}'::text[]))
81. 0.000 0.000 ↓ 0.0 0

Subquery Scan on data_1 (cost=15.47..52.88 rows=1 width=32) (never executed)

82.          

Initplan (for Subquery Scan)

83. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_29 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '3'::text)
84. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_30 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '1'::text)
85. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_31 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '2'::text)
86. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_32 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '3'::text)
87. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_33 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '0'::text)
88. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_34 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '1'::text)
89. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_35 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '2'::text)
90. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_36 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '3'::text)
91. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_declarationtype t_37 (cost=0.00..1.08 rows=1 width=32) (never executed)

  • Filter: ((code)::text = '4'::text)
92. 0.000 0.000 ↓ 0.0 0

GroupAggregate (cost=5.75..43.13 rows=1 width=40) (never executed)

  • Group Key: p_4.f_link2reestr
93. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.75..43.11 rows=1 width=10) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.62..42.94 rows=1 width=16) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.20..42.46 rows=1 width=16) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=4.78..18.38 rows=1 width=16) (never executed)

  • Join Filter: ((p_4.cid)::numeric = t_40.catalog)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using m_person_f_link2reestr_idx on m_person p_4 (cost=0.42..8.44 rows=1 width=24) (never executed)

  • Index Cond: (f_link2reestr = t_1.id)
  • Filter: (f_uptodate AND (NOT deleted))
98. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.35..9.83 rows=6 width=5) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.35..9.80 rows=6 width=5) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Seq Scan on userroles t1_3 (cost=0.00..1.30 rows=1 width=5) (never executed)

  • Filter: (sysuser = (core.f_sys_get_config('sysuser'::text))::numeric)
101. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on urprivs t_40 (cost=4.35..8.44 rows=6 width=11) (never executed)

  • Recheck Cond: (((unitcode)::text = 'orgreestr'::text) AND (roleid = t1_3.roleid) AND (catalog IS NOT NULL))
102. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on i_urprivs_uc (cost=0.00..4.35 rows=6 width=0) (never executed)

  • Index Cond: (((unitcode)::text = 'orgreestr'::text) AND (roleid = t1_3.roleid) AND (catalog IS NOT NULL))
103. 0.000 0.000 ↓ 0.0 0

Index Scan using m_declaration2child_f_child_idx on m_declaration2child t_39 (cost=0.42..24.03 rows=5 width=16) (never executed)

  • Index Cond: (f_child = p_4.id)
104. 0.000 0.000 ↓ 0.0 0

Index Scan using m_declaration_id_idx on m_declaration t_38 (cost=0.42..0.47 rows=1 width=12) (never executed)

  • Index Cond: (id = t_39.f_decl)
  • Filter: (f_uptodate AND (NOT deleted))
105. 0.000 0.000 ↓ 0.0 0

Index Scan using m_declarationtype_id_idx on m_declarationtype t_41 (cost=0.13..0.16 rows=1 width=6) (never executed)

  • Index Cond: (id = t_38.f_delc_type)
  • Filter: ((code)::text = ANY ('{0,1,2,3,4}'::text[]))
Planning time : 17.365 ms
Execution time : 1,035.547 ms