Advertisement
Guest User

postgresql out of memory

a guest
Mar 24th, 2011
540
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 85.14 KB | None | 0 0
  1. 2011-03-25 13:27:57 NZDT:[local]:lds_bde@bde_db:[2151]: CONTEXT: PL/pgSQL function "lds_maintainsimplifiedparcellayers" line 159 at SQL statement
  2. 2011-03-25 13:27:57 NZDT:[local]:lds_bde@bde_db:[2151]: STATEMENT: SELECT lds.LDS_MaintainSimplifiedParcelLayers(1);
  3. TopMemoryContext: 437040 total in 52 blocks; 10840 free (35 chunks); 426200 used
  4. PL/PgSQL function context: 24576 total in 2 blocks; 12224 free (3 chunks); 12352 used
  5. PL/PgSQL function context: 24576 total in 2 blocks; 17704 free (2 chunks); 6872 used
  6. PL/PgSQL function context: 24576 total in 2 blocks; 14048 free (2 chunks); 10528 used
  7. PL/PgSQL function context: 24576 total in 2 blocks; 14072 free (2 chunks); 10504 used
  8. PL/PgSQL function context: 24576 total in 2 blocks; 13640 free (3 chunks); 10936 used
  9. PL/PgSQL function context: 8192 total in 1 blocks; 3080 free (2 chunks); 5112 used
  10. PL/PgSQL function context: 57344 total in 3 blocks; 30448 free (3 chunks); 26896 used
  11. PL/PgSQL function context: 8192 total in 1 blocks; 5160 free (1 chunks); 3032 used
  12. PL/PgSQL function context: 24576 total in 2 blocks; 18072 free (7 chunks); 6504 used
  13. PostGIS PROJ4 Backend projPJ MemoryContext Hash: 8192 total in 1 blocks; 2576 free (0 chunks); 5616 used
  14. PL/PgSQL function context: 122880 total in 4 blocks; 48480 free (2 chunks); 74400 used
  15. PL/PgSQL function context: 122880 total in 4 blocks; 59224 free (4 chunks); 63656 used
  16. PL/PgSQL function context: 57344 total in 3 blocks; 34640 free (4 chunks); 22704 used
  17. PostGIS Prepared Geometry Backend MemoryContext Hash: 8192 total in 1 blocks; 1552 free (0 chunks); 6640 used
  18. PL/PgSQL function context: 24576 total in 2 blocks; 15232 free (2 chunks); 9344 used
  19. PL/PgSQL function context: 122880 total in 4 blocks; 69200 free (3 chunks); 53680 used
  20. Attopt cache: 8192 total in 1 blocks; 2704 free (0 chunks); 5488 used
  21. LocalBufferContext: 8388944 total in 7 blocks; 0 free (0 chunks); 8388944 used
  22. Local Buffer Lookup Table: 122880 total in 4 blocks; 66736 free (12 chunks); 56144 used
  23. Type information cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used
  24. TableSpace cache: 8192 total in 1 blocks; 3216 free (0 chunks); 4976 used
  25. Operator lookup cache: 24576 total in 2 blocks; 11888 free (5 chunks); 12688 used
  26. Record information cache: 24576 total in 2 blocks; 15984 free (5 chunks); 8592 used
  27. PL/PgSQL function context: 57344 total in 3 blocks; 20232 free (2 chunks); 37112 used
  28. PL/PgSQL function context: 253952 total in 5 blocks; 106448 free (4 chunks); 147504 used
  29. CFuncHash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  30. Rendezvous variable hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  31. PLpgSQL function cache: 24520 total in 2 blocks; 3744 free (0 chunks); 20776 used
  32. TopTransactionContext: 253952 total in 5 blocks; 44616 free (28 chunks); 209336 used
  33. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  34. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  35. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  36. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  37. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  38. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  39. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  40. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  41. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  42. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  43. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  44. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  45. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  46. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  47. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  48. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  49. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  50. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  51. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  52. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  53. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  54. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  55. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  56. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  57. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  58. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  59. CurTransactionContext: 8192 total in 1 blocks; 6080 free (0 chunks); 2112 used
  60. CurTransactionContext: 8192 total in 1 blocks; 4000 free (0 chunks); 4192 used
  61. Combo CIDs: 8192 total in 1 blocks; 1664 free (0 chunks); 6528 used
  62. ExecutorState: 1040384 total in 7 blocks; 481920 free (10 chunks); 558464 used
  63. ExprContext: 8192 total in 1 blocks; 8160 free (0 chunks); 32 used
  64. SPI Exec: 8192 total in 1 blocks; 8016 free (0 chunks); 176 used
  65. ExecutorState: 524352 total in 7 blocks; 178816 free (4 chunks); 345536 used
  66. SRF multi-call context: 310856 total in 3 blocks; 1096 free (5 chunks); 309760 used
  67. TupleSort: 236701376 total in 3074 blocks; 44764672 free (88664 chunks); 191936704 used
  68. TupleSort: 32816 total in 2 blocks; 7488 free (0 chunks); 25328 used
  69. TupleSort: 218161552 total in 34 blocks; 167715728 free (1617951 chunks); 50445824 used
  70. HashTableContext: 8192 total in 1 blocks; 8064 free (0 chunks); 128 used
  71. HashBatchContext: 2097200 total in 1 blocks; 0 free (0 chunks); 2097200 used
  72. TupleSort: 218260160 total in 33 blocks; 117368160 free (2271924 chunks); 100892000 used
  73. TupleSort: 37740592 total in 13 blocks; 865792 free (5 chunks); 36874800 used
  74. TupleSort: 218169808 total in 35 blocks; 167707600 free (1992301 chunks); 50462208 used
  75. TupleSort: 218194576 total in 41 blocks; 192865120 free (678527 chunks); 25329456 used
  76. TupleSort: 218194576 total in 41 blocks; 192865120 free (690422 chunks); 25329456 used
  77. TupleSort: 218194576 total in 41 blocks; 26304832 free (79602 chunks); 191889744 used
  78. TupleSort: 218161552 total in 34 blocks; 167715728 free (1975345 chunks); 50445824 used
  79. HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  80. HashBatchContext: 16384 total in 1 blocks; 7984 free (0 chunks); 8400 used
  81. HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  82. HashBatchContext: 16384 total in 1 blocks; 7360 free (0 chunks); 9024 used
  83. HashTableContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  84. HashBatchContext: 16384 total in 1 blocks; 6784 free (0 chunks); 9600 used
  85. TupleSort: 49200 total in 3 blocks; 22944 free (9 chunks); 26256 used
  86. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  87. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  88. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  89. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  90. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  91. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  92. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  93. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  94. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  95. ExprContext: 594528 total in 4 blocks; 24400 free (12 chunks); 570128 used
  96. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  97. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  98. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  99. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  100. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  101. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  102. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  103. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  104. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  105. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  106. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  107. AggContext: 100655104 total in 21 blocks; 735080 free (6 chunks); 99920024 used
  108. TupleHashTable: 109109296 total in 23 blocks; 8011984 free (62 chunks); 101097312 used
  109. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  110. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  111. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  112. Subplan HashTable Temp Context: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  113. Subplan HashTable Context: 24576 total in 2 blocks; 14832 free (0 chunks); 9744 used
  114. TupleHashTable: 8192 total in 1 blocks; 3696 free (0 chunks); 4496 used
  115. TupleHashTable: 24576 total in 2 blocks; 14896 free (2 chunks); 9680 used
  116. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  117. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  118. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  119. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  120. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  121. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  122. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  123. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  124. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  125. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  126. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  127. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  128. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  129. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  130. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  131. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  132. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  133. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  134. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  135. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  136. AggContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  137. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  138. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  139. ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
  140. SPI Proc: 65536 total in 3 blocks; 58640 free (13 chunks); 6896 used
  141. MessageContext: 24576 total in 2 blocks; 18224 free (5 chunks); 6352 used
  142. Operator class cache: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  143. smgr relation table: 57344 total in 3 blocks; 30208 free (10 chunks); 27136 used
  144. TransactionAbortContext: 32768 total in 1 blocks; 32736 free (0 chunks); 32 used
  145. Portal hash: 8192 total in 1 blocks; 1680 free (0 chunks); 6512 used
  146. PortalMemory: 8192 total in 1 blocks; 7888 free (1 chunks); 304 used
  147. PortalHeapMemory: 1024 total in 1 blocks; 824 free (0 chunks); 200 used
  148. ExecutorState: 24576 total in 2 blocks; 20600 free (7 chunks); 3976 used
  149. ExprContext: 24576 total in 2 blocks; 24512 free (12 chunks); 64 used
  150. Relcache by OID: 24576 total in 2 blocks; 8672 free (3 chunks); 15904 used
  151. CacheMemoryContext: 2390704 total in 22 blocks; 716672 free (7 chunks); 1674032 used
  152. pg_toast_899705_index: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  153. CachedPlan: 261120 total in 8 blocks; 52176 free (0 chunks); 208944 used
  154. CachedPlanSource: 48128 total in 8 blocks; 1520 free (0 chunks); 46608 used
  155. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  156. fk_ess_prp: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  157. pkey_crs_proprietor: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  158. fk_tle_ess: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  159. fk_ets_act_crt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  160. pkey_crs_estate_share: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  161. fk_ttl_ett: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  162. fk_ett_lgd: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  163. fk_ett_act_crt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  164. pkey_crs_title_estate: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  165. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  166. CachedPlanSource: 3072 total in 2 blocks; 968 free (0 chunks); 2104 used
  167. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  168. CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
  169. CachedPlanSource: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  170. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  171. CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
  172. CachedPlanSource: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  173. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  174. shx_str_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  175. strata_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  176. pg_toast_257825_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  177. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  178. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  179. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  180. CachedPlan: 5120 total in 2 blocks; 2304 free (2 chunks); 2816 used
  181. CachedPlanSource: 9216 total in 3 blocks; 3920 free (5 chunks); 5296 used
  182. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  183. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  184. CachedPlanSource: 3072 total in 2 blocks; 1328 free (0 chunks); 1744 used
  185. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  186. shx_non_pril_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  187. non_primary_linear_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  188. pg_toast_257813_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  189. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  190. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  191. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  192. CachedPlan: 5120 total in 2 blocks; 2304 free (2 chunks); 2816 used
  193. CachedPlanSource: 9216 total in 3 blocks; 3920 free (5 chunks); 5296 used
  194. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  195. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  196. CachedPlanSource: 3072 total in 2 blocks; 1312 free (0 chunks); 1760 used
  197. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  198. shx_non_prim_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  199. non_primary_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  200. pg_toast_257801_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  201. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  202. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  203. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  204. CachedPlan: 5120 total in 2 blocks; 2304 free (2 chunks); 2816 used
  205. CachedPlanSource: 9216 total in 3 blocks; 3920 free (5 chunks); 5296 used
  206. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  207. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  208. CachedPlanSource: 3072 total in 2 blocks; 1312 free (0 chunks); 1760 used
  209. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  210. shx_road_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  211. road_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  212. pg_toast_257789_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  213. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  214. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  215. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  216. CachedPlan: 5120 total in 2 blocks; 2304 free (2 chunks); 2816 used
  217. CachedPlanSource: 9216 total in 3 blocks; 3920 free (5 chunks); 5296 used
  218. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  219. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  220. CachedPlanSource: 3072 total in 2 blocks; 1328 free (0 chunks); 1744 used
  221. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  222. shx_hyd_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  223. hydro_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  224. pg_toast_257777_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  225. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  226. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  227. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  228. CachedPlan: 5120 total in 2 blocks; 2304 free (2 chunks); 2816 used
  229. CachedPlanSource: 9216 total in 3 blocks; 3920 free (5 chunks); 5296 used
  230. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  231. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  232. CachedPlanSource: 3072 total in 2 blocks; 1328 free (0 chunks); 1744 used
  233. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  234. shx_lnd_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  235. land_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  236. pg_toast_257765_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  237. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  238. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  239. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  240. CachedPlan: 5120 total in 2 blocks; 2304 free (2 chunks); 2816 used
  241. CachedPlanSource: 9216 total in 3 blocks; 3920 free (5 chunks); 5296 used
  242. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  243. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  244. CachedPlanSource: 3072 total in 2 blocks; 1328 free (0 chunks); 1744 used
  245. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  246. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  247. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  248. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  249. CachedPlan: 3072 total in 2 blocks; 640 free (0 chunks); 2432 used
  250. CachedPlanSource: 7168 total in 3 blocks; 3504 free (0 chunks); 3664 used
  251. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  252. CachedPlan: 3072 total in 2 blocks; 2000 free (1 chunks); 1072 used
  253. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  254. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  255. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  256. CachedPlanSource: 3072 total in 2 blocks; 1760 free (0 chunks); 1312 used
  257. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  258. shx_all_prim_par_shape: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  259. primary_parcels_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  260. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  261. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  262. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  263. CachedPlan: 3072 total in 2 blocks; 1576 free (0 chunks); 1496 used
  264. CachedPlanSource: 3072 total in 2 blocks; 776 free (0 chunks); 2296 used
  265. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  266. CachedPlan: 3072 total in 2 blocks; 1264 free (0 chunks); 1808 used
  267. CachedPlanSource: 3072 total in 2 blocks; 1136 free (0 chunks); 1936 used
  268. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  269. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  270. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  271. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  272. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  273. CachedPlanSource: 3072 total in 2 blocks; 720 free (0 chunks); 2352 used
  274. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  275. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  276. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  277. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  278. pg_toast_257753_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  279. top_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  280. pkey_crs_topology_class: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  281. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  282. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  283. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  284. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  285. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  286. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  287. CachedPlan: 3072 total in 2 blocks; 1224 free (0 chunks); 1848 used
  288. CachedPlanSource: 3072 total in 2 blocks; 40 free (0 chunks); 3032 used
  289. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  290. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  291. CachedPlanSource: 3072 total in 2 blocks; 1360 free (0 chunks); 1712 used
  292. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  293. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  294. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  295. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  296. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  297. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  298. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  299. CachedPlan: 3072 total in 2 blocks; 1952 free (0 chunks); 1120 used
  300. CachedPlanSource: 3072 total in 2 blocks; 1168 free (0 chunks); 1904 used
  301. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  302. CachedPlan: 3072 total in 2 blocks; 1776 free (0 chunks); 1296 used
  303. CachedPlanSource: 3072 total in 2 blocks; 608 free (0 chunks); 2464 used
  304. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  305. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  306. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  307. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  308. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  309. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  310. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  311. CachedPlan: 1024 total in 1 blocks; 32 free (0 chunks); 992 used
  312. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  313. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  314. CachedPlan: 7168 total in 3 blocks; 2808 free (0 chunks); 4360 used
  315. CachedPlanSource: 3072 total in 2 blocks; 592 free (0 chunks); 2480 used
  316. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  317. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  318. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  319. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  320. CachedPlan: 3072 total in 2 blocks; 1472 free (0 chunks); 1600 used
  321. CachedPlanSource: 3072 total in 2 blocks; 648 free (0 chunks); 2424 used
  322. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  323. CachedPlan: 7168 total in 3 blocks; 2688 free (0 chunks); 4480 used
  324. CachedPlanSource: 3072 total in 2 blocks; 872 free (0 chunks); 2200 used
  325. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  326. CachedPlan: 3072 total in 2 blocks; 2000 free (1 chunks); 1072 used
  327. CachedPlanSource: 3072 total in 2 blocks; 1280 free (0 chunks); 1792 used
  328. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  329. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  330. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  331. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  332. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  333. CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728 used
  334. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  335. CachedPlan: 7168 total in 3 blocks; 2408 free (0 chunks); 4760 used
  336. CachedPlanSource: 3072 total in 2 blocks; 208 free (0 chunks); 2864 used
  337. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  338. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  339. CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728 used
  340. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  341. CachedPlan: 3072 total in 2 blocks; 1472 free (0 chunks); 1600 used
  342. CachedPlanSource: 3072 total in 2 blocks; 712 free (0 chunks); 2360 used
  343. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  344. CachedPlan: 7168 total in 3 blocks; 1824 free (0 chunks); 5344 used
  345. CachedPlanSource: 7168 total in 3 blocks; 3928 free (2 chunks); 3240 used
  346. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  347. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  348. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  349. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  350. CachedPlan: 3072 total in 2 blocks; 2000 free (1 chunks); 1072 used
  351. CachedPlanSource: 3072 total in 2 blocks; 1280 free (0 chunks); 1792 used
  352. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  353. CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
  354. CachedPlanSource: 3072 total in 2 blocks; 440 free (0 chunks); 2632 used
  355. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  356. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  357. CachedPlanSource: 3072 total in 2 blocks; 1760 free (0 chunks); 1312 used
  358. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  359. CachedPlan: 3072 total in 2 blocks; 1680 free (0 chunks); 1392 used
  360. CachedPlanSource: 3072 total in 2 blocks; 784 free (0 chunks); 2288 used
  361. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  362. CachedPlan: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
  363. CachedPlanSource: 3072 total in 2 blocks; 1312 free (0 chunks); 1760 used
  364. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  365. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  366. CachedPlanSource: 3072 total in 2 blocks; 416 free (0 chunks); 2656 used
  367. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  368. CachedPlan: 3072 total in 2 blocks; 1280 free (2 chunks); 1792 used
  369. CachedPlanSource: 7168 total in 3 blocks; 3920 free (5 chunks); 3248 used
  370. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  371. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  372. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  373. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  374. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  375. CachedPlanSource: 3072 total in 2 blocks; 1704 free (0 chunks); 1368 used
  376. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  377. CachedPlan: 15360 total in 4 blocks; 6136 free (0 chunks); 9224 used
  378. CachedPlanSource: 7168 total in 3 blocks; 64 free (0 chunks); 7104 used
  379. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  380. CachedPlan: 3072 total in 2 blocks; 1968 free (1 chunks); 1104 used
  381. CachedPlanSource: 3072 total in 2 blocks; 1088 free (0 chunks); 1984 used
  382. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  383. CachedPlan: 3072 total in 2 blocks; 1808 free (0 chunks); 1264 used
  384. CachedPlanSource: 3072 total in 2 blocks; 1328 free (0 chunks); 1744 used
  385. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  386. pg_inherits_relid_seqno_index: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  387. pg_description_o_c_o_index: 2048 total in 1 blocks; 456 free (0 chunks); 1592 used
  388. CachedPlan: 1024 total in 1 blocks; 544 free (0 chunks); 480 used
  389. CachedPlanSource: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  390. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  391. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  392. CachedPlanSource: 3072 total in 2 blocks; 840 free (0 chunks); 2232 used
  393. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  394. CachedPlan: 3072 total in 2 blocks; 1848 free (1 chunks); 1224 used
  395. CachedPlanSource: 3072 total in 2 blocks; 1072 free (0 chunks); 2000 used
  396. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  397. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  398. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  399. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  400. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  401. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  402. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  403. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  404. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  405. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  406. CachedPlan: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
  407. CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728 used
  408. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  409. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  410. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  411. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  412. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  413. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  414. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  415. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  416. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  417. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  418. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  419. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  420. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  421. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  422. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  423. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  424. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  425. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  426. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  427. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  428. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  429. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  430. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  431. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  432. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  433. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  434. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  435. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  436. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  437. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  438. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  439. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  440. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  441. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  442. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  443. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  444. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  445. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  446. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  447. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  448. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  449. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  450. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  451. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  452. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  453. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  454. pg_toast_214467_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  455. CachedPlan: 3072 total in 2 blocks; 1816 free (0 chunks); 1256 used
  456. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  457. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  458. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  459. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  460. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  461. CachedPlan: 3072 total in 2 blocks; 1680 free (0 chunks); 1392 used
  462. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  463. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  464. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  465. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  466. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  467. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  468. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  469. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  470. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  471. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  472. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  473. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  474. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  475. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  476. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  477. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  478. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  479. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  480. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  481. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  482. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  483. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  484. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  485. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  486. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  487. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  488. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  489. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  490. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  491. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  492. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  493. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  494. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  495. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  496. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  497. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  498. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  499. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  500. CachedPlan: 3072 total in 2 blocks; 1848 free (1 chunks); 1224 used
  501. CachedPlanSource: 3072 total in 2 blocks; 1072 free (0 chunks); 2000 used
  502. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  503. CachedPlan: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
  504. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  505. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  506. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  507. CachedPlanSource: 3072 total in 2 blocks; 1000 free (0 chunks); 2072 used
  508. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  509. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  510. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  511. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  512. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  513. CachedPlanSource: 3072 total in 2 blocks; 720 free (0 chunks); 2352 used
  514. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  515. CachedPlan: 3072 total in 2 blocks; 1816 free (0 chunks); 1256 used
  516. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  517. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  518. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  519. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  520. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  521. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  522. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  523. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  524. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  525. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  526. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  527. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  528. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  529. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  530. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  531. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  532. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  533. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  534. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  535. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  536. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  537. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  538. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  539. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  540. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  541. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  542. CachedPlan: 3072 total in 2 blocks; 1480 free (0 chunks); 1592 used
  543. CachedPlanSource: 3072 total in 2 blocks; 616 free (0 chunks); 2456 used
  544. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  545. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  546. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  547. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  548. CachedPlan: 3072 total in 2 blocks; 1392 free (0 chunks); 1680 used
  549. CachedPlanSource: 3072 total in 2 blocks; 264 free (0 chunks); 2808 used
  550. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  551. CachedPlan: 1024 total in 1 blocks; 16 free (0 chunks); 1008 used
  552. CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728 used
  553. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  554. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  555. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  556. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  557. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  558. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  559. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  560. spatial_ref_sys_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  561. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  562. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  563. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  564. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  565. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  566. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  567. CachedPlan: 3072 total in 2 blocks; 1848 free (1 chunks); 1224 used
  568. CachedPlanSource: 3072 total in 2 blocks; 1072 free (0 chunks); 2000 used
  569. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  570. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  571. CachedPlanSource: 3072 total in 2 blocks; 1480 free (1 chunks); 1592 used
  572. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  573. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  574. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  575. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  576. CachedPlan: 1024 total in 1 blocks; 152 free (0 chunks); 872 used
  577. CachedPlanSource: 3072 total in 2 blocks; 1352 free (0 chunks); 1720 used
  578. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  579. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  580. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  581. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  582. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  583. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  584. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  585. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  586. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  587. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  588. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  589. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  590. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  591. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  592. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  593. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  594. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  595. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  596. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  597. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  598. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  599. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  600. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  601. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  602. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  603. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  604. CachedPlanSource: 3072 total in 2 blocks; 1424 free (0 chunks); 1648 used
  605. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  606. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  607. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  608. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  609. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  610. CachedPlanSource: 3072 total in 2 blocks; 1128 free (1 chunks); 1944 used
  611. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  612. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  613. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  614. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  615. CachedPlan: 3072 total in 2 blocks; 1816 free (0 chunks); 1256 used
  616. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  617. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  618. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  619. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  620. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  621. CachedPlan: 3072 total in 2 blocks; 1680 free (0 chunks); 1392 used
  622. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  623. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  624. CachedPlan: 3072 total in 2 blocks; 1920 free (0 chunks); 1152 used
  625. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  626. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  627. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  628. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  629. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  630. CachedPlan: 1024 total in 1 blocks; 64 free (0 chunks); 960 used
  631. CachedPlanSource: 3072 total in 2 blocks; 1304 free (1 chunks); 1768 used
  632. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  633. CachedPlan: 3072 total in 2 blocks; 1632 free (0 chunks); 1440 used
  634. CachedPlanSource: 3072 total in 2 blocks; 736 free (0 chunks); 2336 used
  635. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  636. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  637. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  638. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  639. CachedPlan: 3072 total in 2 blocks; 1920 free (0 chunks); 1152 used
  640. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  641. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  642. CachedPlan: 3072 total in 2 blocks; 1216 free (0 chunks); 1856 used
  643. CachedPlanSource: 3072 total in 2 blocks; 240 free (0 chunks); 2832 used
  644. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  645. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  646. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  647. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  648. CachedPlan: 3072 total in 2 blocks; 1872 free (0 chunks); 1200 used
  649. CachedPlanSource: 3072 total in 2 blocks; 1144 free (1 chunks); 1928 used
  650. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  651. CachedPlan: 1024 total in 1 blocks; 40 free (0 chunks); 984 used
  652. CachedPlanSource: 3072 total in 2 blocks; 1464 free (0 chunks); 1608 used
  653. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  654. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  655. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  656. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  657. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  658. CachedPlanSource: 3072 total in 2 blocks; 1408 free (0 chunks); 1664 used
  659. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  660. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  661. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  662. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  663. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  664. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  665. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  666. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  667. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  668. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  669. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  670. CachedPlanSource: 3072 total in 2 blocks; 1840 free (2 chunks); 1232 used
  671. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  672. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  673. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  674. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  675. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  676. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  677. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  678. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  679. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  680. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  681. CachedPlan: 1024 total in 1 blocks; 272 free (0 chunks); 752 used
  682. CachedPlanSource: 3072 total in 2 blocks; 1856 free (2 chunks); 1216 used
  683. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  684. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  685. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  686. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  687. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  688. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  689. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  690. CachedPlan: 7168 total in 3 blocks; 1920 free (0 chunks); 5248 used
  691. CachedPlanSource: 15360 total in 4 blocks; 4632 free (0 chunks); 10728 used
  692. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  693. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  694. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  695. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  696. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  697. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  698. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  699. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  700. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  701. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  702. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  703. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  704. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  705. CachedPlan: 31744 total in 5 blocks; 12144 free (0 chunks); 19600 used
  706. CachedPlanSource: 31744 total in 6 blocks; 1536 free (0 chunks); 30208 used
  707. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  708. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  709. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  710. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  711. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  712. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  713. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  714. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  715. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  716. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  717. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  718. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  719. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  720. CachedPlan: 3072 total in 2 blocks; 1848 free (1 chunks); 1224 used
  721. CachedPlanSource: 3072 total in 2 blocks; 1072 free (0 chunks); 2000 used
  722. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  723. CachedPlan: 3072 total in 2 blocks; 1584 free (0 chunks); 1488 used
  724. CachedPlanSource: 3072 total in 2 blocks; 864 free (0 chunks); 2208 used
  725. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  726. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  727. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  728. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  729. CachedPlan: 15360 total in 4 blocks; 5296 free (0 chunks); 10064 used
  730. CachedPlanSource: 7168 total in 3 blocks; 3024 free (0 chunks); 4144 used
  731. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  732. fk_app_par: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  733. fk_app_act_ext: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  734. fk_app_act_crt: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  735. fi_app_other: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  736. fi_app_maori: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  737. fi_app_general: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  738. app_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  739. pkey_crs_appellation: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  740. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  741. CachedPlanSource: 3072 total in 2 blocks; 1904 free (1 chunks); 1168 used
  742. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  743. CachedPlan: 130048 total in 7 blocks; 59480 free (0 chunks); 70568 used
  744. CachedPlanSource: 31744 total in 6 blocks; 6760 free (3 chunks); 24984 used
  745. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  746. fk_afp_sur: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  747. fk_afp_par: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  748. afp_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  749. pkey_crs_affected_parcl: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  750. loc_shape_index: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  751. loc_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  752. fk_loc_loc: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  753. pkey_crs_locality: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  754. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  755. CachedPlanSource: 3072 total in 2 blocks; 840 free (0 chunks); 2232 used
  756. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  757. CachedPlan: 1024 total in 1 blocks; 656 free (0 chunks); 368 used
  758. CachedPlanSource: 1024 total in 1 blocks; 448 free (2 chunks); 576 used
  759. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  760. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  761. CachedPlanSource: 3072 total in 2 blocks; 2016 free (3 chunks); 1056 used
  762. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  763. CachedPlan: 7168 total in 3 blocks; 2776 free (0 chunks); 4392 used
  764. CachedPlanSource: 3072 total in 2 blocks; 448 free (0 chunks); 2624 used
  765. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  766. CachedPlan: 3072 total in 2 blocks; 296 free (0 chunks); 2776 used
  767. CachedPlanSource: 7168 total in 3 blocks; 3928 free (2 chunks); 3240 used
  768. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  769. CachedPlan: 1024 total in 1 blocks; 656 free (0 chunks); 368 used
  770. CachedPlanSource: 1024 total in 1 blocks; 448 free (2 chunks); 576 used
  771. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  772. CachedPlan: 1024 total in 1 blocks; 216 free (0 chunks); 808 used
  773. CachedPlanSource: 3072 total in 2 blocks; 1992 free (1 chunks); 1080 used
  774. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  775. CachedPlan: 3072 total in 2 blocks; 1720 free (0 chunks); 1352 used
  776. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  777. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  778. CachedPlan: 7168 total in 3 blocks; 3728 free (0 chunks); 3440 used
  779. CachedPlanSource: 7168 total in 3 blocks; 3912 free (3 chunks); 3256 used
  780. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  781. ste_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  782. ak_ste_ak1: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  783. pkey_crs_statute: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  784. CachedPlan: 1024 total in 1 blocks; 288 free (0 chunks); 736 used
  785. CachedPlanSource: 3072 total in 2 blocks; 1728 free (1 chunks); 1344 used
  786. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  787. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  788. CachedPlanSource: 3072 total in 2 blocks; 1000 free (0 chunks); 2072 used
  789. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  790. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  791. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  792. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  793. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  794. CachedPlanSource: 3072 total in 2 blocks; 1760 free (0 chunks); 1312 used
  795. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  796. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  797. CachedPlanSource: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
  798. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  799. CachedPlan: 3072 total in 2 blocks; 1608 free (0 chunks); 1464 used
  800. CachedPlanSource: 3072 total in 2 blocks; 1000 free (0 chunks); 2072 used
  801. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  802. CachedPlan: 7168 total in 3 blocks; 1752 free (0 chunks); 5416 used
  803. CachedPlanSource: 7168 total in 3 blocks; 3936 free (3 chunks); 3232 used
  804. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  805. sur_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  806. fk_sur_usr_sol: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  807. fk_sur_usr_firm_sol: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  808. fk_sur_sig: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  809. fk_sur_pnx: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  810. fk_sur_ldt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  811. fk_sur_fhr: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  812. ak_sur_idx: 2048 total in 1 blocks; 440 free (0 chunks); 1608 used
  813. pkey_crs_survey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  814. CachedPlan: 3072 total in 2 blocks; 1728 free (0 chunks); 1344 used
  815. CachedPlanSource: 3072 total in 2 blocks; 1096 free (1 chunks); 1976 used
  816. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  817. CachedPlan: 1024 total in 1 blocks; 288 free (0 chunks); 736 used
  818. CachedPlanSource: 3072 total in 2 blocks; 1728 free (1 chunks); 1344 used
  819. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  820. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  821. CachedPlanSource: 3072 total in 2 blocks; 1664 free (0 chunks); 1408 used
  822. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  823. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  824. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  825. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  826. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  827. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  828. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  829. CachedPlan: 3072 total in 2 blocks; 1504 free (0 chunks); 1568 used
  830. CachedPlanSource: 3072 total in 2 blocks; 728 free (0 chunks); 2344 used
  831. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  832. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  833. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  834. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  835. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  836. CachedPlanSource: 3072 total in 2 blocks; 1696 free (0 chunks); 1376 used
  837. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  838. CachedPlan: 3072 total in 2 blocks; 1816 free (0 chunks); 1256 used
  839. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  840. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  841. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  842. CachedPlanSource: 3072 total in 2 blocks; 1664 free (0 chunks); 1408 used
  843. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  844. CachedPlan: 1024 total in 1 blocks; 304 free (0 chunks); 720 used
  845. CachedPlanSource: 3072 total in 2 blocks; 1744 free (0 chunks); 1328 used
  846. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  847. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  848. CachedPlanSource: 3072 total in 2 blocks; 1696 free (0 chunks); 1376 used
  849. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  850. CachedPlan: 1024 total in 1 blocks; 0 free (0 chunks); 1024 used
  851. CachedPlanSource: 3072 total in 2 blocks; 1344 free (0 chunks); 1728 used
  852. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  853. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  854. CachedPlanSource: 3072 total in 2 blocks; 1648 free (1 chunks); 1424 used
  855. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  856. CachedPlan: 3072 total in 2 blocks; 768 free (0 chunks); 2304 used
  857. CachedPlanSource: 7168 total in 3 blocks; 3256 free (0 chunks); 3912 used
  858. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  859. CachedPlan: 1024 total in 1 blocks; 280 free (0 chunks); 744 used
  860. CachedPlanSource: 3072 total in 2 blocks; 1880 free (2 chunks); 1192 used
  861. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  862. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  863. CachedPlanSource: 3072 total in 2 blocks; 1696 free (0 chunks); 1376 used
  864. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  865. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  866. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  867. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  868. CachedPlan: 15360 total in 4 blocks; 3136 free (0 chunks); 12224 used
  869. CachedPlanSource: 7168 total in 3 blocks; 296 free (0 chunks); 6872 used
  870. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  871. sta_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  872. fk_sta_sur: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  873. fk_sta_ste: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  874. pkey_crs_statute_action: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  875. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  876. CachedPlanSource: 3072 total in 2 blocks; 1696 free (0 chunks); 1376 used
  877. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  878. CachedPlan: 3072 total in 2 blocks; 1768 free (0 chunks); 1304 used
  879. CachedPlanSource: 3072 total in 2 blocks; 1016 free (0 chunks); 2056 used
  880. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  881. CachedPlan: 1024 total in 1 blocks; 256 free (0 chunks); 768 used
  882. CachedPlanSource: 3072 total in 2 blocks; 1664 free (0 chunks); 1408 used
  883. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  884. CachedPlan: 3072 total in 2 blocks; 1792 free (0 chunks); 1280 used
  885. CachedPlanSource: 3072 total in 2 blocks; 1136 free (0 chunks); 1936 used
  886. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  887. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  888. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  889. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  890. CachedPlan: 15360 total in 4 blocks; 2832 free (0 chunks); 12528 used
  891. CachedPlanSource: 15360 total in 4 blocks; 7312 free (2 chunks); 8048 used
  892. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  893. sco_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  894. fk_sco_scg: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  895. pkey_crs_sys_code: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  896. CachedPlan: 7168 total in 3 blocks; 1344 free (0 chunks); 5824 used
  897. CachedPlanSource: 7168 total in 3 blocks; 2352 free (0 chunks); 4816 used
  898. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  899. fk_sap_aud: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  900. pk_crs_stat_act_pa: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  901. fk_sap_sta: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  902. fk_sap_par: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  903. pkey_crs_stat_act_parcl: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  904. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  905. CachedPlanSource: 3072 total in 2 blocks; 840 free (0 chunks); 2232 used
  906. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  907. CachedPlan: 1024 total in 1 blocks; 656 free (0 chunks); 368 used
  908. CachedPlanSource: 1024 total in 1 blocks; 448 free (2 chunks); 576 used
  909. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  910. tmp_parcel_titles_pkey: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  911. CachedPlan: 1024 total in 1 blocks; 120 free (0 chunks); 904 used
  912. CachedPlanSource: 3072 total in 2 blocks; 1832 free (1 chunks); 1240 used
  913. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  914. CachedPlan: 64512 total in 6 blocks; 32656 free (0 chunks); 31856 used
  915. CachedPlanSource: 15360 total in 4 blocks; 5232 free (0 chunks); 10128 used
  916. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  917. lgd_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  918. fk_lgd_ttl: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  919. pkey_crs_legal_desc: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  920. lgp_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  921. fk_rap_rar: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  922. fk_rap_par: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  923. fk_lgp_sur: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  924. pkey_crs_legal_desc_prl: 2048 total in 1 blocks; 656 free (0 chunks); 1392 used
  925. par_shape_index: 2048 total in 1 blocks; 328 free (0 chunks); 1720 used
  926. par_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  927. fk_par_toc: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  928. fk_par_ldt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  929. fk_par_img: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  930. fk_par_fen: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  931. fk_par_alt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  932. pkey_crs_parcel: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  933. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  934. CachedPlanSource: 3072 total in 2 blocks; 840 free (0 chunks); 2232 used
  935. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  936. CachedPlan: 1024 total in 1 blocks; 656 free (0 chunks); 368 used
  937. CachedPlanSource: 1024 total in 1 blocks; 448 free (2 chunks); 576 used
  938. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  939. tmp_excluded_titles_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  940. pg_constraint_contypid_index: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  941. pg_constraint_conname_nsp_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  942. CachedPlan: 1024 total in 1 blocks; 208 free (0 chunks); 816 used
  943. CachedPlanSource: 3072 total in 2 blocks; 1984 free (1 chunks); 1088 used
  944. SPI Plan: 1024 total in 1 blocks; 832 free (10 chunks); 192 used
  945. pg_shdepend_depender_index: 2048 total in 1 blocks; 392 free (0 chunks); 1656 used
  946. pg_depend_depender_index: 2048 total in 1 blocks; 456 free (0 chunks); 1592 used
  947. pg_depend_reference_index: 2048 total in 1 blocks; 456 free (0 chunks); 1592 used
  948. pg_shdepend_reference_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  949. CachedPlan: 15360 total in 4 blocks; 328 free (0 chunks); 15032 used
  950. CachedPlanSource: 15360 total in 4 blocks; 7144 free (0 chunks); 8216 used
  951. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  952. pg_toast_2619_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  953. ttl_aud_id: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  954. fk_ttl_ped: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  955. fk_ttl_psd: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  956. fk_ttl_wrk: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  957. fk_ttl_ttl: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  958. fk_ttl_sur: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  959. fk_ttl_ste: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  960. fk_ttl_phy: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  961. fk_ttl_ldt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  962. fk_ttl_dlg: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  963. fk_ttl_alt: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  964. pkey_crs_title: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  965. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  966. CachedPlanSource: 3072 total in 2 blocks; 840 free (0 chunks); 2232 used
  967. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  968. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  969. CachedPlanSource: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  970. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  971. CachedPlan: 1024 total in 1 blocks; 96 free (0 chunks); 928 used
  972. CachedPlanSource: 3072 total in 2 blocks; 1488 free (0 chunks); 1584 used
  973. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  974. CachedPlan: 31744 total in 5 blocks; 3784 free (0 chunks); 27960 used
  975. CachedPlanSource: 15360 total in 4 blocks; 928 free (1 chunks); 14432 used
  976. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  977. upload_table_schema_name_table_name_key: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  978. upload_table_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  979. idx_sts_upl: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  980. idx_sts_tbl: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  981. upload_stats_pkey: 2048 total in 1 blocks; 752 free (0 chunks); 1296 used
  982. upload_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  983. pg_constraint_conrelid_index: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  984. CachedPlan: 3072 total in 2 blocks; 1264 free (0 chunks); 1808 used
  985. CachedPlanSource: 3072 total in 2 blocks; 1168 free (0 chunks); 1904 used
  986. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  987. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  988. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  989. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  990. CachedPlan: 3072 total in 2 blocks; 2000 free (1 chunks); 1072 used
  991. CachedPlanSource: 3072 total in 2 blocks; 1448 free (1 chunks); 1624 used
  992. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  993. CachedPlan: 3072 total in 2 blocks; 2000 free (1 chunks); 1072 used
  994. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  995. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  996. CachedPlan: 3072 total in 2 blocks; 1984 free (1 chunks); 1088 used
  997. CachedPlanSource: 3072 total in 2 blocks; 1416 free (1 chunks); 1656 used
  998. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  999. CachedPlan: 3072 total in 2 blocks; 2000 free (1 chunks); 1072 used
  1000. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  1001. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1002. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  1003. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  1004. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1005. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  1006. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  1007. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1008. CachedPlan: 3072 total in 2 blocks; 2008 free (2 chunks); 1064 used
  1009. CachedPlanSource: 3072 total in 2 blocks; 1456 free (0 chunks); 1616 used
  1010. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1011. CachedPlan: 3072 total in 2 blocks; 904 free (0 chunks); 2168 used
  1012. CachedPlanSource: 3072 total in 2 blocks; 720 free (0 chunks); 2352 used
  1013. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1014. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  1015. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  1016. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1017. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  1018. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  1019. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1020. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  1021. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  1022. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1023. CachedPlan: 1024 total in 1 blocks; 312 free (0 chunks); 712 used
  1024. CachedPlanSource: 3072 total in 2 blocks; 1520 free (0 chunks); 1552 used
  1025. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1026. CachedPlan: 15360 total in 4 blocks; 2584 free (0 chunks); 12776 used
  1027. CachedPlanSource: 15360 total in 4 blocks; 2056 free (0 chunks); 13304 used
  1028. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1029. idx_log_upl: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  1030. upload_log_pkey: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  1031. pg_index_indrelid_index: 2048 total in 1 blocks; 704 free (0 chunks); 1344 used
  1032. CachedPlan: 3072 total in 2 blocks; 1768 free (1 chunks); 1304 used
  1033. CachedPlanSource: 3072 total in 2 blocks; 840 free (0 chunks); 2232 used
  1034. SPI Plan: 1024 total in 1 blocks; 832 free (0 chunks); 192 used
  1035. pg_attrdef_adrelid_adnum_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  1036. pg_toast_1255_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  1037. pg_db_role_setting_databaseid_rol_index: 2048 total in 1 blocks; 608 free (0 chunks); 1440 used
  1038. pg_opclass_am_name_nsp_index: 3072 total in 2 blocks; 1448 free (4 chunks); 1624 used
  1039. pg_foreign_data_wrapper_name_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1040. pg_enum_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1041. pg_class_relname_nsp_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1042. pg_foreign_server_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1043. pg_statistic_relid_att_inh_index: 3072 total in 2 blocks; 1448 free (4 chunks); 1624 used
  1044. pg_cast_source_target_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1045. pg_language_name_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1046. pg_amop_fam_strat_index: 3072 total in 2 blocks; 1384 free (2 chunks); 1688 used
  1047. pg_index_indexrelid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1048. pg_ts_template_tmplname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1049. pg_ts_config_map_index: 3072 total in 2 blocks; 1496 free (4 chunks); 1576 used
  1050. pg_opclass_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1051. pg_foreign_data_wrapper_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1052. pg_ts_dict_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1053. pg_conversion_default_index: 3072 total in 2 blocks; 1432 free (3 chunks); 1640 used
  1054. pg_operator_oprname_l_r_n_index: 3072 total in 2 blocks; 1384 free (2 chunks); 1688 used
  1055. pg_trigger_tgrelid_tgname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1056. pg_enum_typid_label_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1057. pg_ts_config_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1058. pg_user_mapping_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1059. pg_opfamily_am_name_nsp_index: 3072 total in 2 blocks; 1496 free (4 chunks); 1576 used
  1060. pg_type_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1061. pg_aggregate_fnoid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1062. pg_constraint_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1063. pg_rewrite_rel_rulename_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1064. pg_ts_parser_prsname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1065. pg_ts_config_cfgname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1066. pg_ts_parser_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1067. pg_operator_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1068. pg_namespace_nspname_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1069. pg_ts_template_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1070. pg_amop_opr_fam_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1071. pg_default_acl_role_nsp_obj_index: 3072 total in 2 blocks; 1496 free (4 chunks); 1576 used
  1072. pg_ts_dict_dictname_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1073. pg_type_typname_nsp_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1074. pg_opfamily_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1075. pg_class_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1076. pg_proc_proname_args_nsp_index: 3072 total in 2 blocks; 1448 free (4 chunks); 1624 used
  1077. pg_attribute_relid_attnum_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1078. pg_proc_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1079. pg_language_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1080. pg_namespace_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1081. pg_amproc_fam_proc_index: 3072 total in 2 blocks; 1384 free (2 chunks); 1688 used
  1082. pg_foreign_server_name_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1083. pg_attribute_relid_attnam_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1084. pg_conversion_oid_index: 3072 total in 2 blocks; 1744 free (3 chunks); 1328 used
  1085. pg_user_mapping_user_server_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1086. pg_conversion_name_nsp_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1087. pg_authid_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1088. pg_auth_members_member_role_index: 3072 total in 2 blocks; 1600 free (2 chunks); 1472 used
  1089. pg_tablespace_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1090. pg_database_datname_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1091. pg_auth_members_role_member_index: 3072 total in 2 blocks; 1648 free (2 chunks); 1424 used
  1092. pg_database_oid_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1093. pg_authid_rolname_index: 3072 total in 2 blocks; 1696 free (2 chunks); 1376 used
  1094. MdSmgr: 8192 total in 1 blocks; 800 free (0 chunks); 7392 used
  1095. LOCALLOCK hash: 57344 total in 3 blocks; 21984 free (10 chunks); 35360 used
  1096. Timezones: 83472 total in 2 blocks; 3744 free (0 chunks); 79728 used
  1097. ErrorContext: 8192 total in 1 blocks; 8160 free (9 chunks); 32 used
  1098. 2011-03-25 13:57:53 NZDT:[local]:lds_bde@bde_db:[2178]: ERROR: out of memory
  1099. 2011-03-25 13:57:53 NZDT:[local]:lds_bde@bde_db:[2178]: DETAIL: Failed on request of size 524288.
  1100. 2011-03-25 13:57:53 NZDT:[local]:lds_bde@bde_db:[2178]: CONTEXT: SQL statement "CREATE TEMP TABLE tmp_titles AS
  1101. SELECT
  1102. TTL.audit_id AS id,
  1103. TTL.title_no,
  1104. TTL.status,
  1105. TTLT.char_value AS type,
  1106. LOC.name AS land_district,
  1107. TTL.issue_date,
  1108. TTLG.char_value AS guarantee_status,
  1109. -- string_agg(
  1110. -- DISTINCT(
  1111. -- ETTT.char_value || ', ' ||
  1112. -- ETT.share || COALESCE(', ' || LGD.legal_desc_text, '') ||
  1113. -- COALESCE(', ' || to_char(ROUND(LGD.total_area, 0), 'FM9G999G999G999G999') || ' m2', '')
  1114. -- ),
  1115. -- E'\r\n'
  1116. -- ) AS estate_description,
  1117. -- string_agg(
  1118. -- DISTINCT
  1119. -- CASE PRP.type
  1120. -- WHEN 'CORP' THEN PRP.corporate_name
  1121. -- WHEN 'PERS' THEN COALESCE(PRP.prime_other_names || ' ', '') || PRP.prime_surname
  1122. -- END,
  1123. -- ', '
  1124. -- ) AS owners,
  1125. array_to_string(
  1126. array_accum(
  1127. DISTINCT(
  1128. ETTT.char_value || ', ' ||
  1129. ETT.share || COALESCE(', ' || LGD.legal_desc_text, '') ||
  1130. COALESCE(', ' || to_char(ROUND(LGD.total_area, 0), 'FM9G999G999G999G999') || ' m2', '')
  1131. )
  1132. ),
  1133. E'\r\n'
  1134. ) as estate_description,
  1135. array_to_string(
  1136. array_accum(
  1137. DISTINCT
  1138. CASE PRP.type
  1139. WHEN 'CORP' THEN PRP.corporate_name
  1140. WHEN 'PERS' THEN COALESCE(PRP.prime_other_names || ' ', '') || PRP.prime_surname
  1141. END
  1142. ),
  1143. ', '
  1144. ) AS owners,
  1145. count(
  1146. DISTINCT
  1147. CASE PRP.type
  1148. WHEN 'CORP' THEN PRP.corporate_name
  1149. WHEN 'PERS' THEN COALESCE(PRP.prime_other_names || ' ', '') || PRP.prime_surname
  1150. END
  1151. ) AS number_owners,
  1152. TPA.title_no IS NOT NULL AS part_share,
  1153. ST_Multi(ST_Collect(PAR.shape)) AS shape
  1154. FROM
  1155. crs_title TTL
  1156. LEFT JOIN crs_title_estate ETT ON TTL.title_no = ETT.ttl_title_no AND ETT.status = 'REGD'
  1157. LEFT JOIN crs_estate_share ETS ON ETT.id = ETS.ett_id AND ETT.status = 'REGD'
  1158. LEFT JOIN crs_proprietor PRP ON ETS.id = PRP.ets_id AND PRP.status = 'REGD'
  1159. LEFT JOIN crs_legal_desc LGD ON ETT.lgd_id = LGD.id AND LGD.type = 'ETT' AND LGD.status = 'REGD'
  1160. LEFT JOIN crs_legal_desc_prl LGP ON LGD.id = LGP.lgd_id
  1161. LEFT JOIN (
  1162. SELECT
  1163. title_no
  1164. FROM
  1165. tmp_parcel_titles
  1166. GROUP BY
  1167. title_no
  1168. HAVING
  1169. count(*) > 1
  1170. ) TPA ON TTL.title_no = TPA.title_no
  1171. LEFT JOIN (
  1172. SELECT
  1173. id,
  1174. (ST_Dump(shape)).geom AS shape
  1175. FROM
  1176. crs_parcel
  1177. WHERE
  1178. status = 'CURR' AND
  1179. ST_GeometryType(shape) IN ('ST_MultiPolygon', 'ST_Polygon')
  1180. ) PAR ON LGP.par_id = PAR.id
  1181. JOIN crs_locality LOC ON TTL.ldt_loc_id = LOC.id
  1182. JOIN crs_sys_code TTLG ON TTL.guarantee_status = TTLG.code AND TTLG.scg_code = 'TTLG'
  1183. JOIN crs_sys_code TTLT ON TTL.type = TTLT.code AND TTLT.scg_code = 'TTLT'
  1184. LEFT JOIN crs_sys_code ETTT ON ETT.type = ETTT.code AND ETTT.scg_code = 'ETTT'
  1185. WHERE
  1186. TTL.status IN ('LIVE', 'PRTC') AND
  1187. TTL.title_no NOT IN (SELECT title_no FROM tmp_excluded_titles)
  1188. GROUP BY
  1189. TTL.audit_id,
  1190. TTL.title_no,
  1191. TTL.status,
  1192. TTLT.char_value,
  1193. LOC.name,
  1194. TTL.issue_date,
  1195. TTLG.char_value,
  1196. TPA.title_no"
  1197. PL/pgSQL function "lds_maintainsimplifiedparcellayers" line 561 at SQL statement
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement