API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 17th, 2019
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.73 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "considered_execution_plans": [
  3. {
  4. "cardinality": 4687.5,
  5. "fraction_output_for_nest": 0.0011
  6. },
  7. {
  8. "plan_prefix": [],
  9. "table": "t1",
  10. "best_access_path": {
  11. "considered_access_paths": [
  12. {
  13. "access_type": "scan",
  14. "resulting_rows": 4.6875,
  15. "cost": 21.282,
  16. "chosen": true
  17. }
  18. ]
  19. },
  20. "rows_for_plan": 4.6875,
  21. "cost_for_plan": 22.22,
  22. "rest_of_plan": [
  23. {
  24. "plan_prefix": ["t1"],
  25. "table": "t2",
  26. "best_access_path": {
  27. "considered_access_paths": [
  28. {
  29. "access_type": "ref",
  30. "index": "idx2",
  31. "used_range_estimates": false,
  32. "cause": "not better than ref estimates",
  33. "rows": 1,
  34. "cost": 9.375,
  35. "chosen": true
  36. },
  37. {
  38. "access_type": "scan",
  39. "resulting_rows": 20,
  40. "cost": 18.624,
  41. "chosen": false
  42. }
  43. ]
  44. },
  45. "rows_for_plan": 4.6875,
  46. "cost_for_plan": 32.532,
  47. "cost_of_sorting": 0.7277,
  48. "rest_of_plan": [
  49. {
  50. "original_record_count": 4.6875,
  51. "record_count_after_limit_applied": 0.005
  52. },
  53. {
  54. "plan_prefix": ["t1", "t2"],
  55. "table": "t3",
  56. "sort-nest": ["t1", "t2"],
  57. "best_access_path": {
  58. "considered_access_paths": [
  59. {
  60. "access_type": "scan",
  61. "resulting_rows": 1000,
  62. "cost": 0.021,
  63. "chosen": true
  64. }
  65. ]
  66. },
  67. "rows_for_plan": 5,
  68. "cost_for_plan": 34.281
  69. }
  70. ],
  71. "rest_of_plan": [
  72. {
  73. "plan_prefix": ["t1", "t2"],
  74. "table": "t3",
  75. "best_access_path": {
  76. "considered_access_paths": [
  77. {
  78. "access_type": "scan",
  79. "resulting_rows": 1000,
  80. "cost": 4.1973,
  81. "chosen": true
  82. }
  83. ]
  84. },
  85. "rows_for_plan": 4687.5,
  86. "cost_for_plan": 974.96,
  87. "pruned_by_cost": true
  88. }
  89. ]
  90. },
  91. {
  92. "plan_prefix": ["t1"],
  93. "table": "t3",
  94. "best_access_path": {
  95. "considered_access_paths": [
  96. {
  97. "access_type": "scan",
  98. "resulting_rows": 1000,
  99. "cost": 4.1973,
  100. "chosen": true
  101. }
  102. ]
  103. },
  104. "rows_for_plan": 4687.5,
  105. "cost_for_plan": 963.92,
  106. "pruned_by_cost": true
  107. }
  108. ]
  109. },
  110. {
  111. "plan_prefix": [],
  112. "table": "t2",
  113. "best_access_path": {
  114. "considered_access_paths": [
  115. {
  116. "access_type": "scan",
  117. "resulting_rows": 20,
  118. "cost": 18.624,
  119. "chosen": true
  120. }
  121. ]
  122. },
  123. "rows_for_plan": 20,
  124. "cost_for_plan": 22.624,
  125. "cost_of_sorting": 2.7788,
  126. "rest_of_plan": [
  127. {
  128. "original_record_count": 20,
  129. "record_count_after_limit_applied": 0.0213
  130. },
  131. {
  132. "plan_prefix": ["t2"],
  133. "table": "t1",
  134. "sort-nest": ["t2"],
  135. "best_access_path": {
  136. "considered_access_paths": [
  137. {
  138. "access_type": "scan",
  139. "resulting_rows": 4.6875,
  140. "cost": 0.454,
  141. "chosen": true
  142. }
  143. ]
  144. },
  145. "rows_for_plan": 0.1,
  146. "cost_for_plan": 25.877,
  147. "rest_of_plan": [
  148. {
  149. "plan_prefix": ["t2", "t1"],
  150. "table": "t3",
  151. "sort-nest": ["t2"],
  152. "best_access_path": {
  153. "considered_access_paths": [
  154. {
  155. "access_type": "scan",
  156. "resulting_rows": 1000,
  157. "cost": 0.4197,
  158. "chosen": true
  159. }
  160. ]
  161. },
  162. "rows_for_plan": 100,
  163. "cost_for_plan": 46.297,
  164. "pruned_by_cost": true
  165. }
  166. ]
  167. },
  168. {
  169. "plan_prefix": ["t2"],
  170. "table": "t3",
  171. "sort-nest": ["t2"],
  172. "best_access_path": {
  173. "considered_access_paths": [
  174. {
  175. "access_type": "scan",
  176. "resulting_rows": 1000,
  177. "cost": 0.0895,
  178. "chosen": true
  179. }
  180. ]
  181. },
  182. "rows_for_plan": 21.333,
  183. "cost_for_plan": 29.759,
  184. "rest_of_plan": [
  185. {
  186. "plan_prefix": ["t2", "t3"],
  187. "table": "t1",
  188. "sort-nest": ["t2"],
  189. "best_access_path": {
  190. "considered_access_paths": [
  191. {
  192. "access_type": "ref",
  193. "index": "idx1",
  194. "used_range_estimates": false,
  195. "cause": "not available",
  196. "rows": 1,
  197. "cost": 42.667,
  198. "chosen": true
  199. },
  200. {
  201. "access_type": "scan",
  202. "resulting_rows": 4.6875,
  203. "cost": 454.02,
  204. "chosen": false
  205. }
  206. ]
  207. },
  208. "rows_for_plan": 21.333,
  209. "cost_for_plan": 76.692,
  210. "pruned_by_cost": true
  211. }
  212. ]
  213. }
  214. ],
  215. "rest_of_plan": [
  216. {
  217. "plan_prefix": ["t2"],
  218. "table": "t1",
  219. "best_access_path": {
  220. "considered_access_paths": [
  221. {
  222. "access_type": "scan",
  223. "resulting_rows": 4.6875,
  224. "cost": 21.282,
  225. "chosen": true
  226. }
  227. ]
  228. },
  229. "rows_for_plan": 93.75,
  230. "cost_for_plan": 65.435,
  231. "pruned_by_cost": true
  232. },
  233. {
  234. "plan_prefix": ["t2"],
  235. "table": "t3",
  236. "best_access_path": {
  237. "considered_access_paths": [
  238. {
  239. "access_type": "scan",
  240. "resulting_rows": 1000,
  241. "cost": 4.1973,
  242. "chosen": true
  243. }
  244. ]
  245. },
  246. "rows_for_plan": 20000,
  247. "cost_for_plan": 4029.6,
  248. "pruned_by_cost": true
  249. }
  250. ]
  251. },
  252. {
  253. "plan_prefix": [],
  254. "table": "t3",
  255. "best_access_path": {
  256. "considered_access_paths": [
  257. {
  258. "access_type": "scan",
  259. "resulting_rows": 1000,
  260. "cost": 4.1973,
  261. "chosen": true
  262. }
  263. ]
  264. },
  265. "rows_for_plan": 1000,
  266. "cost_for_plan": 204.2,
  267. "pruned_by_cost": true
  268. }
  269. ]
  270. },
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!