API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 29th, 2020
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.76 KB | None | 0 0
raw download clone embed print report
  1. Thanks to everyone, post the information you requested, tell me if I did something wrong.
  2. Table definition and indexes:
  3. =# \d production.spr_items_item
  4. Tabella "production.spr_items_item"
  5. Colonna | Tipo | Ordinamento | Può essere null | Default
  6. --------------+--------------------------+-------------+-----------------+-------------------------------------------------------
  7. id | integer | | not null | nextval('production.spr_items_item_id_seq'::regclass)
  8. code | character varying(32) | | not null |
  9. phases | jsonb | | not null |
  10. attrs | jsonb | | not null |
  11. stats | jsonb | | not null |
  12. is_valid | boolean | | not null |
  13. err_desc | character varying(256) | | |
  14. created | timestamp with time zone | | not null |
  15. edited | timestamp with time zone | | not null |
  16. item_type_id | integer | | not null |
  17. barcode | character varying(128) | | |
  18. quantity | integer | | not null |
  19. need_refresh | boolean | | not null |
  20. Indici:
  21. "spr_items_item_pkey" PRIMARY KEY, btree (id)
  22. "index_barcode" hash (barcode)
  23. "index_stats" gin (stats)
  24. "spr_items_item_item_type_id_b1c28cbd" btree (item_type_id)
  25. Vincoli di integrità referenziale
  26. "spr_items_item_item_type_id_b1c28cbd_fk_spr_items_itemtype_id" FOREIGN KEY (item_type_id) REFERENCES production.spr_items_itemtype(id) DEFERRABLE INITIALLY DEFERRED
  27. Referenziato da:
  28. TABLE "production.spr_waste_wasteitem" CONSTRAINT "spr_waste_wasteitem_item_id_463f78c6_fk_spr_items_item_id" FOREIGN KEY (item_id) REFERENCES production.spr_items_item(id) DEFERRABLE INITIALLY DEFERRED
  29.  
  30. Explain analyze:
  31. "Nested Loop (cost=0.00..598896.25 rows=348726 width=1539) (actual time=4912.401..29000.204 rows=13141 loops=1)"
  32. " Join Filter: (spr_items_item.item_type_id = spr_items_itemtype.id)"
  33. " -> Seq Scan on spr_items_itemtype (cost=0.00..1.01 rows=1 width=4) (actual time=2.883..2.883 rows=1 loops=1)"
  34. " Filter: ((code)::text = 'pannello'::text)"
  35. " -> Seq Scan on spr_items_item (cost=0.00..594536.16 rows=348726 width=1539) (actual time=4909.511..28986.387 rows=13141 loops=1)"
  36. " Filter: (((stats -> 'production_date'::text) IS NOT NULL) AND ((stats -> 'shift_array'::text) IS NOT NULL) AND ((upper((stats ->> 'shift_array'::text)) ~~ '%1349%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1350%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1351%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1352%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1353%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1354%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1355%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1356%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1357%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1358%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1359%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1360%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1361%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1362%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1363%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1364%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1365%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1366%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1367%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1368%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1369%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1370%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1371%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1372%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1373%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1374%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1375%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1376%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1377%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1378%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1379%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1380%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1381%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1382%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1383%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1384%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1385%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1386%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1387%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1388%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1389%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1390%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1391%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1392%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1393%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1394%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1395%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1396%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1397%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1398%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1399%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1400%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1401%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1402%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1403%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1404%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1405%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1406%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1407%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1408%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1409%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1410%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1411%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1412%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1413%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1414%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1415%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1416%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1417%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1418%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1419%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1420%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1421%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1422%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1423%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1424%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1425%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1426%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1427%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1428%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1429%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1430%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1431%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1432%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1455%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1456%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1457%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1458%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1459%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1460%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1461%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1462%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1463%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1464%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1465%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1466%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1467%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1468%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1631%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1633%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1634%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1635%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1636%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1637%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1638%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1639%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1640%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1641%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1642%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1643%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1644%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1645%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1646%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1647%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1648%'::text) OR (upper((stats ->> 'shift_array'::text)) ~~ '%1649%'::text)))"
  37. " Rows Removed by Filter: 567988"
  38. "Planning time: 1.638 ms"
  39. "Execution time: 29002.602 ms"
  40.  
  41. Full query:
  42. SELECT production.spr_items_item.id,
  43. production.spr_items_item.item_type_id,
  44. production.spr_items_item.code,
  45. production.spr_items_item.barcode,
  46. production.spr_items_item.phases,
  47. production.spr_items_item.attrs,
  48. production.spr_items_item.stats,
  49. production.spr_items_item.quantity,
  50. production.spr_items_item.is_valid,
  51. production.spr_items_item.need_refresh,
  52. production.spr_items_item.err_desc,
  53. production.spr_items_item.created,
  54. production.spr_items_item.edited
  55. FROM production.spr_items_item
  56. INNER JOIN production.spr_items_itemtype ON (production.spr_items_item.item_type_id = production.spr_items_itemtype.id)
  57. WHERE (production.spr_items_itemtype.code = 'pannello'
  58. AND (production.spr_items_item.stats -> 'production_date') IS NOT NULL
  59. AND (production.spr_items_item.stats -> 'shift_array') IS NOT NULL
  60. AND (UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1349%')
  61. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1350%')
  62. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1351%')
  63. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1352%')
  64. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1353%')
  65. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1354%')
  66. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1355%')
  67. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1356%')
  68. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1357%')
  69. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1358%')
  70. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1359%')
  71. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1360%')
  72. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1361%')
  73. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1362%')
  74. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1363%')
  75. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1364%')
  76. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1365%')
  77. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1366%')
  78. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1367%')
  79. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1368%')
  80. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1369%')
  81. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1370%')
  82. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1371%')
  83. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1372%')
  84. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1373%')
  85. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1374%')
  86. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1375%')
  87. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1376%')
  88. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1377%')
  89. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1378%')
  90. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1379%')
  91. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1380%')
  92. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1381%')
  93. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1382%')
  94. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1383%')
  95. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1384%')
  96. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1385%')
  97. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1386%')
  98. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1387%')
  99. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1388%')
  100. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1389%')
  101. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1390%')
  102. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1391%')
  103. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1392%')
  104. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1393%')
  105. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1394%')
  106. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1395%')
  107. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1396%')
  108. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1397%')
  109. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1398%')
  110. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1399%')
  111. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1400%')
  112. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1401%')
  113. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1402%')
  114. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1403%')
  115. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1404%')
  116. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1405%')
  117. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1406%')
  118. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1407%')
  119. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1408%')
  120. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1409%')
  121. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1410%')
  122. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1411%')
  123. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1412%')
  124. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1413%')
  125. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1414%')
  126. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1415%')
  127. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1416%')
  128. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1417%')
  129. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1418%')
  130. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1419%')
  131. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1420%')
  132. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1421%')
  133. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1422%')
  134. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1423%')
  135. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1424%')
  136. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1425%')
  137. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1426%')
  138. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1427%')
  139. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1428%')
  140. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1429%')
  141. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1430%')
  142. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1431%')
  143. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1432%')
  144. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1455%')
  145. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1456%')
  146. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1457%')
  147. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1458%')
  148. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1459%')
  149. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1460%')
  150. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1461%')
  151. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1462%')
  152. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1463%')
  153. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1464%')
  154. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1465%')
  155. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1466%')
  156. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1467%')
  157. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1468%')
  158. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1631%')
  159. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1633%')
  160. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1634%')
  161. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1635%')
  162. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1636%')
  163. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1637%')
  164. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1638%')
  165. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1639%')
  166. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1640%')
  167. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1641%')
  168. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1642%')
  169. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1643%')
  170. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1644%')
  171. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1645%')
  172. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1646%')
  173. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1647%')
  174. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1648%')
  175. OR UPPER((production.spr_items_item.stats ->> 'shift_array')::text) LIKE UPPER('%1649%')))
  176.  
  177. Explain link:
  178. https://explain.depesz.com/s/c97P
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!