API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 19th, 2018
73
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.13 KB | None | 0 0
raw download clone embed print report
  1. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 10499);
  2. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  3. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  4. 10499 | l | 204 | 0 | 32 | 8192 | 804 | 15612 | 15614 | 0 | 1
  5. (1 row)
  6.  
  7. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15612);
  8. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  9. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  10. 15612 | l | 204 | 0 | 32 | 8192 | 804 | 15611 | 15613 | 0 | 1
  11. (1 row)
  12.  
  13. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15611);
  14. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  15. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  16. 15611 | l | 204 | 0 | 32 | 8192 | 804 | 15610 | 15612 | 0 | 1
  17. (1 row)
  18.  
  19. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15610);
  20. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  21. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  22. 15610 | l | 204 | 0 | 32 | 8192 | 804 | 15609 | 15611 | 0 | 1
  23. (1 row)
  24.  
  25. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15609);
  26. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  27. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  28. 15609 | l | 204 | 0 | 32 | 8192 | 804 | 15608 | 15610 | 0 | 1
  29. (1 row)
  30.  
  31. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15608);
  32. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  33. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  34. 15608 | l | 204 | 0 | 32 | 8192 | 804 | 15607 | 15609 | 0 | 1
  35. (1 row)
  36.  
  37. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15607);
  38. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  39. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  40. 15607 | l | 204 | 0 | 32 | 8192 | 804 | 15606 | 15608 | 0 | 1
  41. (1 row)
  42.  
  43. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15606);
  44. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  45. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  46. 15606 | l | 204 | 0 | 32 | 8192 | 804 | 15605 | 15607 | 0 | 1
  47. (1 row)
  48.  
  49. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15605);
  50. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  51. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  52. 15605 | l | 204 | 0 | 32 | 8192 | 804 | 15604 | 15606 | 0 | 1
  53. (1 row)
  54.  
  55. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15604);
  56. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  57. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  58. 15604 | l | 204 | 0 | 32 | 8192 | 804 | 15603 | 15605 | 0 | 1
  59. (1 row)
  60.  
  61. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15603);
  62. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  63. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  64. 15603 | l | 204 | 0 | 32 | 8192 | 804 | 15602 | 15604 | 0 | 1
  65. (1 row)
  66.  
  67. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15602);
  68. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  69. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  70. 15602 | l | 204 | 0 | 32 | 8192 | 804 | 15601 | 15603 | 0 | 1
  71. (1 row)
  72.  
  73. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15601);
  74. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  75. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  76. 15601 | l | 204 | 0 | 32 | 8192 | 804 | 15600 | 15602 | 0 | 1
  77. (1 row)
  78.  
  79. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15600);
  80. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  81. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  82. 15600 | l | 204 | 0 | 32 | 8192 | 804 | 15599 | 15601 | 0 | 1
  83. (1 row)
  84.  
  85. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15599);
  86. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  87. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  88. 15599 | l | 204 | 0 | 32 | 8192 | 804 | 15598 | 15600 | 0 | 1
  89. (1 row)
  90.  
  91. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15598);
  92. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  93. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  94. 15598 | l | 204 | 0 | 32 | 8192 | 804 | 15597 | 15599 | 0 | 1
  95. (1 row)
  96.  
  97. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15597);
  98. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  99. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  100. 15597 | l | 204 | 0 | 32 | 8192 | 804 | 15596 | 15598 | 0 | 1
  101. (1 row)
  102.  
  103. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15596);
  104. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  105. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  106. 15596 | l | 204 | 0 | 32 | 8192 | 804 | 15595 | 15597 | 0 | 1
  107. (1 row)
  108.  
  109. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15595);
  110. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  111. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  112. 15595 | l | 204 | 0 | 32 | 8192 | 804 | 15594 | 15596 | 0 | 1
  113. (1 row)
  114.  
  115. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15594);
  116. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  117. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  118. 15594 | l | 204 | 0 | 32 | 8192 | 804 | 15593 | 15595 | 0 | 1
  119. (1 row)
  120.  
  121. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15593);
  122. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  123. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  124. 15593 | l | 204 | 0 | 32 | 8192 | 804 | 15592 | 15594 | 0 | 1
  125. (1 row)
  126.  
  127. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15592);
  128. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  129. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  130. 15592 | l | 204 | 0 | 32 | 8192 | 804 | 15591 | 15593 | 0 | 1
  131. (1 row)
  132.  
  133. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15591);
  134. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  135. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  136. 15591 | l | 204 | 0 | 32 | 8192 | 804 | 15590 | 15592 | 0 | 1
  137. (1 row)
  138.  
  139. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15590);
  140. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  141. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  142. 15590 | l | 204 | 0 | 32 | 8192 | 804 | 15589 | 15591 | 0 | 1
  143. (1 row)
  144.  
  145. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15589);
  146. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  147. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  148. 15589 | l | 204 | 0 | 32 | 8192 | 804 | 15588 | 15590 | 0 | 1
  149. (1 row)
  150.  
  151. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15588);
  152. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  153. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  154. 15588 | l | 204 | 0 | 32 | 8192 | 804 | 15586 | 15589 | 0 | 1
  155. (1 row)
  156.  
  157. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15586);
  158. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  159. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  160. 15586 | l | 204 | 0 | 32 | 8192 | 804 | 15585 | 15588 | 0 | 1
  161. (1 row)
  162.  
  163. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15585);
  164. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  165. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  166. 15585 | l | 204 | 0 | 32 | 8192 | 804 | 15584 | 15586 | 0 | 1
  167. (1 row)
  168.  
  169. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15584);
  170. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  171. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  172. 15584 | l | 204 | 0 | 32 | 8192 | 804 | 15583 | 15585 | 0 | 1
  173. (1 row)
  174.  
  175. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15583);
  176. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  177. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  178. 15583 | l | 204 | 0 | 32 | 8192 | 804 | 15582 | 15584 | 0 | 1
  179. (1 row)
  180.  
  181. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15582);
  182. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  183. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  184. 15582 | l | 204 | 0 | 32 | 8192 | 804 | 15581 | 15583 | 0 | 1
  185. (1 row)
  186.  
  187. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15581);
  188. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  189. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  190. 15581 | l | 204 | 0 | 32 | 8192 | 804 | 15580 | 15582 | 0 | 1
  191. (1 row)
  192.  
  193. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15580);
  194. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  195. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  196. 15580 | l | 204 | 0 | 32 | 8192 | 804 | 15579 | 15581 | 0 | 1
  197. (1 row)
  198.  
  199. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15579);
  200. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  201. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  202. 15579 | l | 204 | 0 | 32 | 8192 | 804 | 15578 | 15580 | 0 | 1
  203. (1 row)
  204.  
  205. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15578);
  206. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  207. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  208. 15578 | l | 204 | 0 | 32 | 8192 | 804 | 15577 | 15579 | 0 | 1
  209. (1 row)
  210.  
  211. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15577);
  212. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  213. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  214. 15577 | l | 204 | 0 | 32 | 8192 | 804 | 15576 | 15578 | 0 | 1
  215. (1 row)
  216.  
  217. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15576);
  218. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  219. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  220. 15576 | l | 204 | 0 | 32 | 8192 | 804 | 15575 | 15577 | 0 | 1
  221. (1 row)
  222.  
  223. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15575);
  224. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  225. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  226. 15575 | l | 204 | 0 | 32 | 8192 | 804 | 15574 | 15576 | 0 | 1
  227. (1 row)
  228.  
  229. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15574);
  230. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  231. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  232. 15574 | l | 204 | 0 | 32 | 8192 | 804 | 15573 | 15575 | 0 | 1
  233. (1 row)
  234.  
  235. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15573);
  236. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  237. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  238. 15573 | l | 204 | 0 | 32 | 8192 | 804 | 15572 | 15574 | 0 | 1
  239. (1 row)
  240.  
  241. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15572);
  242. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  243. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  244. 15572 | l | 204 | 0 | 32 | 8192 | 804 | 15571 | 15573 | 0 | 1
  245. (1 row)
  246.  
  247. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15571);
  248. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  249. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  250. 15571 | l | 204 | 0 | 32 | 8192 | 804 | 15570 | 15572 | 0 | 1
  251. (1 row)
  252.  
  253. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15570);
  254. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  255. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  256. 15570 | l | 204 | 0 | 32 | 8192 | 804 | 15569 | 15571 | 0 | 1
  257. (1 row)
  258.  
  259. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15569);
  260. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  261. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  262. 15569 | l | 204 | 0 | 32 | 8192 | 804 | 15568 | 15570 | 0 | 1
  263. (1 row)
  264.  
  265. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15568);
  266. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  267. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  268. 15568 | l | 204 | 0 | 32 | 8192 | 804 | 15567 | 15569 | 0 | 1
  269. (1 row)
  270.  
  271. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15567);
  272. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  273. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  274. 15567 | l | 204 | 0 | 32 | 8192 | 804 | 15566 | 15568 | 0 | 1
  275. (1 row)
  276.  
  277. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15566);
  278. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  279. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  280. 15566 | l | 204 | 0 | 32 | 8192 | 804 | 15565 | 15567 | 0 | 1
  281. (1 row)
  282.  
  283. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15565);
  284. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  285. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  286. 15565 | l | 204 | 0 | 32 | 8192 | 804 | 15564 | 15566 | 0 | 1
  287. (1 row)
  288.  
  289. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15564);
  290. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  291. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  292. 15564 | l | 204 | 0 | 32 | 8192 | 804 | 15563 | 15565 | 0 | 1
  293. (1 row)
  294.  
  295. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15563);
  296. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  297. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  298. 15563 | l | 204 | 0 | 32 | 8192 | 804 | 15562 | 15564 | 0 | 1
  299. (1 row)
  300.  
  301. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15562);
  302. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  303. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  304. 15562 | l | 204 | 0 | 32 | 8192 | 804 | 15561 | 15563 | 0 | 1
  305. (1 row)
  306.  
  307. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15561);
  308. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  309. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  310. 15561 | l | 204 | 0 | 32 | 8192 | 804 | 15560 | 15562 | 0 | 1
  311. (1 row)
  312.  
  313. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15560);
  314. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  315. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  316. 15560 | l | 204 | 0 | 32 | 8192 | 804 | 15559 | 15561 | 0 | 1
  317. (1 row)
  318.  
  319. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15559);
  320. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  321. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  322. 15559 | l | 204 | 0 | 32 | 8192 | 804 | 15558 | 15560 | 0 | 1
  323. (1 row)
  324.  
  325. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15558);
  326. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  327. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  328. 15558 | l | 204 | 0 | 32 | 8192 | 804 | 15557 | 15559 | 0 | 1
  329. (1 row)
  330.  
  331. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15557);
  332. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  333. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  334. 15557 | l | 204 | 0 | 32 | 8192 | 804 | 15556 | 15558 | 0 | 1
  335. (1 row)
  336.  
  337. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15556);
  338. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  339. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  340. 15556 | l | 204 | 0 | 32 | 8192 | 804 | 15555 | 15557 | 0 | 1
  341. (1 row)
  342.  
  343. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15555);
  344. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  345. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  346. 15555 | l | 204 | 0 | 32 | 8192 | 804 | 15554 | 15556 | 0 | 1
  347. (1 row)
  348.  
  349. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15554);
  350. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  351. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  352. 15554 | l | 204 | 0 | 32 | 8192 | 804 | 15553 | 15555 | 0 | 1
  353. (1 row)
  354.  
  355. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15553);
  356. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  357. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  358. 15553 | l | 204 | 0 | 32 | 8192 | 804 | 15552 | 15554 | 0 | 1
  359. (1 row)
  360.  
  361. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15552);
  362. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  363. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  364. 15552 | l | 204 | 0 | 32 | 8192 | 804 | 15551 | 15553 | 0 | 1
  365. (1 row)
  366.  
  367. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15551);
  368. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  369. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  370. 15551 | l | 204 | 0 | 32 | 8192 | 804 | 15550 | 15552 | 0 | 1
  371. (1 row)
  372.  
  373. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15550);
  374. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  375. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  376. 15550 | l | 204 | 0 | 32 | 8192 | 804 | 15549 | 15551 | 0 | 1
  377. (1 row)
  378.  
  379. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15549);
  380. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  381. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  382. 15549 | l | 204 | 0 | 32 | 8192 | 804 | 15548 | 15550 | 0 | 1
  383. (1 row)
  384.  
  385. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15548);
  386. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  387. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  388. 15548 | l | 204 | 0 | 32 | 8192 | 804 | 15547 | 15549 | 0 | 1
  389. (1 row)
  390. ^
  391. xxxxx=# select * from bt_page_stats ('caeindrbb_001', 15547);
  392. blkno | type | live_items | dead_items | avg_item_size | page_size | free_size | btpo_prev | btpo_next | btpo | btpo_flags
  393. -------+------+------------+------------+---------------+-----------+-----------+-----------+-----------+------+------------
  394. 15547 | l | 204 | 0 | 32 | 8192 | 804 | 15546 | 15548 | 0 | 1
  395. (1 row)
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!