API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 11th, 2019
91
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.57 KB | None | 0 0
raw download clone embed print report
  1. Nested Loop (cost=20070.14..29089.05 rows=133512430 width=53)
  2. -> HashAggregate (cost=20070.00..20072.00 rows=200 width=4)
  3. Group Key: max(u0.id)
  4. -> HashAggregate (cost=19696.14..19862.30 rows=16616 width=8)
  5. Group Key: u0.spider_item_id
  6. -> Result (cost=0.12..19613.06 rows=16616 width=8)
  7. -> Append (cost=0.12..19446.90 rows=16616 width=8)
  8. -> Index Scan using item_daily_data_1_2col_uni_idx on item_daily_data_1 u0 (cost=0.12..2.38 rows=1 width=8)
  9. Filter: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  10. -> Index Scan using item_daily_data_2_spider_item_id_idx on item_daily_data_2 u0_1 (cost=0.42..690.80 rows=584 width=8)
  11. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  12. Filter: (region_id IS NULL)
  13. -> Index Scan using item_daily_data_3_spider_item_id_idx on item_daily_data_3 u0_2 (cost=0.43..948.51 rows=814 width=8)
  14. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  15. Filter: (region_id IS NULL)
  16. -> Index Scan using item_daily_data_4_spider_item_id_idx on item_daily_data_4 u0_3 (cost=0.43..895.68 rows=775 width=8)
  17. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  18. Filter: (region_id IS NULL)
  19. -> Index Scan using item_daily_data_5_spider_item_id_idx on item_daily_data_5 u0_4 (cost=0.43..761.02 rows=682 width=8)
  20. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  21. Filter: (region_id IS NULL)
  22. -> Index Scan using item_daily_data_6_spider_item_id_idx on item_daily_data_6 u0_5 (cost=0.43..752.12 rows=634 width=8)
  23. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  24. Filter: (region_id IS NULL)
  25. -> Index Scan using item_daily_data_7_spider_item_id_idx on item_daily_data_7 u0_6 (cost=0.43..793.46 rows=671 width=8)
  26. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  27. Filter: (region_id IS NULL)
  28. -> Index Scan using item_daily_data_8_spider_item_id_idx on item_daily_data_8 u0_7 (cost=0.43..821.58 rows=705 width=8)
  29. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  30. Filter: (region_id IS NULL)
  31. -> Index Scan using item_daily_data_9_spider_item_id_idx on item_daily_data_9 u0_8 (cost=0.43..806.44 rows=685 width=8)
  32. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  33. Filter: (region_id IS NULL)
  34. -> Index Scan using item_daily_data_10_spider_item_id_idx on item_daily_data_10 u0_9 (cost=0.43..850.23 rows=726 width=8)
  35. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  36. Filter: (region_id IS NULL)
  37. -> Index Scan using item_daily_data_11_spider_item_id_idx on item_daily_data_11 u0_10 (cost=0.43..913.38 rows=786 width=8)
  38. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  39. Filter: (region_id IS NULL)
  40. -> Index Scan using item_daily_data_12_spider_item_id_idx on item_daily_data_12 u0_11 (cost=0.43..871.33 rows=744 width=8)
  41. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  42. Filter: (region_id IS NULL)
  43. -> Index Scan using item_daily_data_13_spider_item_id_idx on item_daily_data_13 u0_12 (cost=0.43..887.89 rows=756 width=8)
  44. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  45. Filter: (region_id IS NULL)
  46. -> Index Scan using item_daily_data_14_spider_item_id_idx on item_daily_data_14 u0_13 (cost=0.43..840.49 rows=714 width=8)
  47. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  48. Filter: (region_id IS NULL)
  49. -> Index Scan using item_daily_data_15_spider_item_id_idx on item_daily_data_15 u0_14 (cost=0.43..843.82 rows=731 width=8)
  50. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  51. Filter: (region_id IS NULL)
  52. -> Index Scan using item_daily_data_16_spider_item_id_idx on item_daily_data_16 u0_15 (cost=0.43..837.95 rows=710 width=8)
  53. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  54. Filter: (region_id IS NULL)
  55. -> Index Scan using item_daily_data_17_spider_item_id_idx on item_daily_data_17 u0_16 (cost=0.43..889.58 rows=756 width=8)
  56. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  57. Filter: (region_id IS NULL)
  58. -> Index Scan using item_daily_data_18_spider_item_id_idx on item_daily_data_18 u0_17 (cost=0.44..965.00 rows=827 width=8)
  59. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  60. Filter: (region_id IS NULL)
  61. -> Index Scan using item_daily_data_19_spider_item_id_idx on item_daily_data_19 u0_18 (cost=0.44..1008.59 rows=870 width=8)
  62. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  63. Filter: (region_id IS NULL)
  64. -> Index Scan using item_daily_data_20_spider_item_id_idx on item_daily_data_20 u0_19 (cost=0.44..945.29 rows=809 width=8)
  65. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  66. Filter: (region_id IS NULL)
  67. -> Index Scan using item_daily_data_21_spider_item_id_idx on item_daily_data_21 u0_20 (cost=0.44..852.80 rows=724 width=8)
  68. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  69. Filter: (region_id IS NULL)
  70. -> Index Scan using item_daily_data_22_spider_item_id_idx on item_daily_data_22 u0_21 (cost=0.44..930.02 rows=795 width=8)
  71. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  72. Filter: (region_id IS NULL)
  73. -> Index Scan using item_daily_data_23_spider_item_id_idx on item_daily_data_23 u0_22 (cost=0.44..959.87 rows=819 width=8)
  74. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  75. Filter: (region_id IS NULL)
  76. -> Index Scan using item_daily_data_24_spider_item_id_idx on item_daily_data_24 u0_23 (cost=0.43..378.68 rows=298 width=8)
  77. Index Cond: (spider_item_id = ANY ('{3628761,2557363,3782261,2434536,2024322,1781851,2340554,3164542,567992,2463372,1260902,684161,3880622,3169011,3642913,3604629,2115432,922103,1298911,2360299,4110207,4060001,1534326,2776461,2171112,2836979,2916566,3673254,845625,2013249}'::integer[]))
  78. Filter: (region_id IS NULL)
  79. -> Append (cost=0.14..53.83 rows=24 width=57)
  80. -> Index Scan using item_daily_data_1_pkey on item_daily_data_1 (cost=0.14..0.16 rows=1 width=459)
  81. Index Cond: (id = (max(u0.id)))
  82. Filter: (region_id IS NULL)
  83. -> Index Scan using item_daily_data_2_pkey on item_daily_data_2 (cost=0.42..1.83 rows=1 width=56)
  84. Index Cond: (id = (max(u0.id)))
  85. Filter: (region_id IS NULL)
  86. -> Index Scan using item_daily_data_3_pkey on item_daily_data_3 (cost=0.43..2.04 rows=1 width=52)
  87. Index Cond: (id = (max(u0.id)))
  88. Filter: (region_id IS NULL)
  89. -> Index Scan using item_daily_data_4_pkey on item_daily_data_4 (cost=0.43..2.10 rows=1 width=55)
  90. Index Cond: (id = (max(u0.id)))
  91. Filter: (region_id IS NULL)
  92. -> Index Scan using item_daily_data_5_pkey on item_daily_data_5 (cost=0.43..2.22 rows=1 width=56)
  93. Index Cond: (id = (max(u0.id)))
  94. Filter: (region_id IS NULL)
  95. -> Index Scan using item_daily_data_6_pkey on item_daily_data_6 (cost=0.43..2.28 rows=1 width=56)
  96. Index Cond: (id = (max(u0.id)))
  97. Filter: (region_id IS NULL)
  98. -> Index Scan using item_daily_data_7_pkey on item_daily_data_7 (cost=0.43..2.32 rows=1 width=57)
  99. Index Cond: (id = (max(u0.id)))
  100. Filter: (region_id IS NULL)
  101. -> Index Scan using item_daily_data_8_pkey on item_daily_data_8 (cost=0.43..2.04 rows=1 width=57)
  102. Index Cond: (id = (max(u0.id)))
  103. Filter: (region_id IS NULL)
  104. -> Index Scan using item_daily_data_9_pkey on item_daily_data_9 (cost=0.43..2.09 rows=1 width=57)
  105. Index Cond: (id = (max(u0.id)))
  106. Filter: (region_id IS NULL)
  107. -> Index Scan using item_daily_data_10_pkey on item_daily_data_10 (cost=0.43..2.39 rows=1 width=57)
  108. Index Cond: (id = (max(u0.id)))
  109. Filter: (region_id IS NULL)
  110. -> Index Scan using item_daily_data_11_pkey on item_daily_data_11 (cost=0.43..2.46 rows=1 width=57)
  111. Index Cond: (id = (max(u0.id)))
  112. Filter: (region_id IS NULL)
  113. -> Index Scan using item_daily_data_12_pkey on item_daily_data_12 (cost=0.43..2.46 rows=1 width=57)
  114. Index Cond: (id = (max(u0.id)))
  115. Filter: (region_id IS NULL)
  116. -> Index Scan using item_daily_data_13_pkey on item_daily_data_13 (cost=0.43..2.32 rows=1 width=57)
  117. Index Cond: (id = (max(u0.id)))
  118. Filter: (region_id IS NULL)
  119. -> Index Scan using item_daily_data_14_pkey on item_daily_data_14 (cost=0.43..2.32 rows=1 width=57)
  120. Index Cond: (id = (max(u0.id)))
  121. Filter: (region_id IS NULL)
  122. -> Index Scan using item_daily_data_15_pkey on item_daily_data_15 (cost=0.43..2.42 rows=1 width=57)
  123. Index Cond: (id = (max(u0.id)))
  124. Filter: (region_id IS NULL)
  125. -> Index Scan using item_daily_data_16_pkey on item_daily_data_16 (cost=0.43..2.44 rows=1 width=57)
  126. Index Cond: (id = (max(u0.id)))
  127. Filter: (region_id IS NULL)
  128. -> Index Scan using item_daily_data_17_pkey on item_daily_data_17 (cost=0.43..2.45 rows=1 width=57)
  129. Index Cond: (id = (max(u0.id)))
  130. Filter: (region_id IS NULL)
  131. -> Index Scan using item_daily_data_18_pkey on item_daily_data_18 (cost=0.44..2.47 rows=1 width=57)
  132. Index Cond: (id = (max(u0.id)))
  133. Filter: (region_id IS NULL)
  134. -> Index Scan using item_daily_data_19_pkey on item_daily_data_19 (cost=0.44..2.49 rows=1 width=57)
  135. Index Cond: (id = (max(u0.id)))
  136. Filter: (region_id IS NULL)
  137. -> Index Scan using item_daily_data_20_pkey on item_daily_data_20 (cost=0.44..2.51 rows=1 width=57)
  138. Index Cond: (id = (max(u0.id)))
  139. Filter: (region_id IS NULL)
  140. -> Index Scan using item_daily_data_21_pkey on item_daily_data_21 (cost=0.44..2.52 rows=1 width=57)
  141. Index Cond: (id = (max(u0.id)))
  142. Filter: (region_id IS NULL)
  143. -> Index Scan using item_daily_data_22_pkey on item_daily_data_22 (cost=0.44..2.54 rows=1 width=57)
  144. Index Cond: (id = (max(u0.id)))
  145. Filter: (region_id IS NULL)
  146. -> Index Scan using item_daily_data_23_pkey on item_daily_data_23 (cost=0.44..2.55 rows=1 width=57)
  147. Index Cond: (id = (max(u0.id)))
  148. Filter: (region_id IS NULL)
  149. -> Index Scan using item_daily_data_24_pkey on item_daily_data_24 (cost=0.43..2.41 rows=1 width=57)
  150. Index Cond: (id = (max(u0.id)))
  151. Filter: (region_id IS NULL)
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!