API tools faq
paste
Guest User

Untitled

a guest
Sep 21st, 2022
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.53 KB | None | 0 0
raw download clone embed print report
  1. [
  2. {
  3. "Plan": {
  4. "Node Type": "Nested Loop",
  5. "Parallel Aware": false,
  6. "Async Capable": false,
  7. "Join Type": "Inner",
  8. "Startup Cost": 58.67,
  9. "Total Cost": 26783.54,
  10. "Plan Rows": 3550,
  11. "Plan Width": 178,
  12. "Actual Startup Time": 68.571,
  13. "Actual Total Time": 22767.543,
  14. "Actual Rows": 10000,
  15. "Actual Loops": 1,
  16. "Output": ["event.start_time", "event.event_id", "event.db2_station_code", "event.end_time", "event.panel_code", "event.duration_is_minutes", "event.date_of_transmission", "event.area_flags", "event.barb_content_id", "station.db2stationname", "panel.panelname", "(json_agg(json_build_object('d', category.category_description)))", "content.episode_name", "content.episode_number", "content.content_name"],
  17. "Inner Unique": false,
  18. "Shared Hit Blocks": 1790094,
  19. "Shared Read Blocks": 62806,
  20. "Shared Dirtied Blocks": 0,
  21. "Shared Written Blocks": 0,
  22. "Local Hit Blocks": 0,
  23. "Local Read Blocks": 0,
  24. "Local Dirtied Blocks": 0,
  25. "Local Written Blocks": 0,
  26. "Temp Read Blocks": 0,
  27. "Temp Written Blocks": 0,
  28. "I/O Read Time": 19759.779,
  29. "I/O Write Time": 0.000,
  30. "Plans": [
  31. {
  32. "Node Type": "Hash Join",
  33. "Parent Relationship": "Outer",
  34. "Parallel Aware": false,
  35. "Async Capable": false,
  36. "Join Type": "Inner",
  37. "Startup Cost": 58.38,
  38. "Total Cost": 25343.13,
  39. "Plan Rows": 3550,
  40. "Plan Width": 135,
  41. "Actual Startup Time": 68.550,
  42. "Actual Total Time": 22714.473,
  43. "Actual Rows": 10000,
  44. "Actual Loops": 1,
  45. "Output": ["event.start_time", "event.event_id", "event.db2_station_code", "event.end_time", "event.panel_code", "event.duration_is_minutes", "event.date_of_transmission", "event.area_flags", "event.barb_content_id", "(json_agg(json_build_object('d', category.category_description)))", "station.db2stationname", "panel.panelname"],
  46. "Inner Unique": false,
  47. "Hash Cond": "((event.db2_station_code)::numeric = station.db2stationcode)",
  48. "Shared Hit Blocks": 1760094,
  49. "Shared Read Blocks": 62806,
  50. "Shared Dirtied Blocks": 0,
  51. "Shared Written Blocks": 0,
  52. "Local Hit Blocks": 0,
  53. "Local Read Blocks": 0,
  54. "Local Dirtied Blocks": 0,
  55. "Local Written Blocks": 0,
  56. "Temp Read Blocks": 0,
  57. "Temp Written Blocks": 0,
  58. "I/O Read Time": 19759.779,
  59. "I/O Write Time": 0.000,
  60. "Plans": [
  61. {
  62. "Node Type": "Hash Join",
  63. "Parent Relationship": "Outer",
  64. "Parallel Aware": false,
  65. "Async Capable": false,
  66. "Join Type": "Inner",
  67. "Startup Cost": 35.68,
  68. "Total Cost": 25267.17,
  69. "Plan Rows": 3550,
  70. "Plan Width": 123,
  71. "Actual Startup Time": 68.314,
  72. "Actual Total Time": 22706.322,
  73. "Actual Rows": 10000,
  74. "Actual Loops": 1,
  75. "Output": ["event.start_time", "event.event_id", "event.db2_station_code", "event.end_time", "event.panel_code", "event.duration_is_minutes", "event.date_of_transmission", "event.area_flags", "event.barb_content_id", "(json_agg(json_build_object('d', category.category_description)))", "panel.panelname"],
  76. "Inner Unique": false,
  77. "Hash Cond": "((event.panel_code)::numeric = panel.panelcode)",
  78. "Shared Hit Blocks": 1760087,
  79. "Shared Read Blocks": 62806,
  80. "Shared Dirtied Blocks": 0,
  81. "Shared Written Blocks": 0,
  82. "Local Hit Blocks": 0,
  83. "Local Read Blocks": 0,
  84. "Local Dirtied Blocks": 0,
  85. "Local Written Blocks": 0,
  86. "Temp Read Blocks": 0,
  87. "Temp Written Blocks": 0,
  88. "I/O Read Time": 19759.779,
  89. "I/O Write Time": 0.000,
  90. "Plans": [
  91. {
  92. "Node Type": "Limit",
  93. "Parent Relationship": "Outer",
  94. "Parallel Aware": false,
  95. "Async Capable": false,
  96. "Startup Cost": 33.08,
  97. "Total Cost": 25079.07,
  98. "Plan Rows": 10000,
  99. "Plan Width": 103,
  100. "Actual Startup Time": 68.282,
  101. "Actual Total Time": 22696.606,
  102. "Actual Rows": 10000,
  103. "Actual Loops": 1,
  104. "Output": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id", "(json_agg(json_build_object('d', category.category_description)))"],
  105. "Shared Hit Blocks": 1760086,
  106. "Shared Read Blocks": 62806,
  107. "Shared Dirtied Blocks": 0,
  108. "Shared Written Blocks": 0,
  109. "Local Hit Blocks": 0,
  110. "Local Read Blocks": 0,
  111. "Local Dirtied Blocks": 0,
  112. "Local Written Blocks": 0,
  113. "Temp Read Blocks": 0,
  114. "Temp Written Blocks": 0,
  115. "I/O Read Time": 19759.779,
  116. "I/O Write Time": 0.000,
  117. "Plans": [
  118. {
  119. "Node Type": "Aggregate",
  120. "Strategy": "Sorted",
  121. "Partial Mode": "Simple",
  122. "Parent Relationship": "Outer",
  123. "Parallel Aware": false,
  124. "Async Capable": false,
  125. "Startup Cost": 33.08,
  126. "Total Cost": 1389058.93,
  127. "Plan Rows": 554590,
  128. "Plan Width": 103,
  129. "Actual Startup Time": 68.281,
  130. "Actual Total Time": 22694.339,
  131. "Actual Rows": 10000,
  132. "Actual Loops": 1,
  133. "Output": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id", "json_agg(json_build_object('d', category.category_description))"],
  134. "Group Key": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id"],
  135. "Shared Hit Blocks": 1760086,
  136. "Shared Read Blocks": 62806,
  137. "Shared Dirtied Blocks": 0,
  138. "Shared Written Blocks": 0,
  139. "Local Hit Blocks": 0,
  140. "Local Read Blocks": 0,
  141. "Local Dirtied Blocks": 0,
  142. "Local Written Blocks": 0,
  143. "Temp Read Blocks": 0,
  144. "Temp Written Blocks": 0,
  145. "I/O Read Time": 19759.779,
  146. "I/O Write Time": 0.000,
  147. "Plans": [
  148. {
  149. "Node Type": "Incremental Sort",
  150. "Parent Relationship": "Outer",
  151. "Parallel Aware": false,
  152. "Async Capable": false,
  153. "Startup Cost": 33.08,
  154. "Total Cost": 1327984.67,
  155. "Plan Rows": 1968796,
  156. "Plan Width": 83,
  157. "Actual Startup Time": 36.885,
  158. "Actual Total Time": 22137.778,
  159. "Actual Rows": 600001,
  160. "Actual Loops": 1,
  161. "Output": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id", "category.category_description"],
  162. "Sort Key": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id"],
  163. "Presorted Key": ["event.date_of_transmission", "event.event_id"],
  164. "Full-sort Groups": {
  165. "Group Count": 10001,
  166. "Sort Methods Used": ["quicksort"],
  167. "Sort Space Memory": {
  168. "Average Sort Space Used": 33,
  169. "Peak Sort Space Used": 33
  170. }
  171. },
  172. "Shared Hit Blocks": 1760086,
  173. "Shared Read Blocks": 62806,
  174. "Shared Dirtied Blocks": 0,
  175. "Shared Written Blocks": 0,
  176. "Local Hit Blocks": 0,
  177. "Local Read Blocks": 0,
  178. "Local Dirtied Blocks": 0,
  179. "Local Written Blocks": 0,
  180. "Temp Read Blocks": 0,
  181. "Temp Written Blocks": 0,
  182. "I/O Read Time": 19759.779,
  183. "I/O Write Time": 0.000,
  184. "Plans": [
  185. {
  186. "Node Type": "Nested Loop",
  187. "Parent Relationship": "Outer",
  188. "Parallel Aware": false,
  189. "Async Capable": false,
  190. "Join Type": "Inner",
  191. "Startup Cost": 0.57,
  192. "Total Cost": 1208474.16,
  193. "Plan Rows": 1968796,
  194. "Plan Width": 83,
  195. "Actual Startup Time": 2.765,
  196. "Actual Total Time": 21822.989,
  197. "Actual Rows": 600061,
  198. "Actual Loops": 1,
  199. "Output": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id", "category.category_description"],
  200. "Inner Unique": false,
  201. "Shared Hit Blocks": 1760086,
  202. "Shared Read Blocks": 62806,
  203. "Shared Dirtied Blocks": 0,
  204. "Shared Written Blocks": 0,
  205. "Local Hit Blocks": 0,
  206. "Local Read Blocks": 0,
  207. "Local Dirtied Blocks": 0,
  208. "Local Written Blocks": 0,
  209. "Temp Read Blocks": 0,
  210. "Temp Written Blocks": 0,
  211. "I/O Read Time": 19759.779,
  212. "I/O Write Time": 0.000,
  213. "Plans": [
  214. {
  215. "Node Type": "Custom Scan",
  216. "Parent Relationship": "Outer",
  217. "Custom Plan Provider": "ChunkAppend",
  218. "Parallel Aware": false,
  219. "Async Capable": false,
  220. "Relation Name": "fact_program_event_audience_v1",
  221. "Schema": "v1",
  222. "Alias": "event",
  223. "Startup Cost": 0.43,
  224. "Total Cost": 251802.42,
  225. "Plan Rows": 5545904,
  226. "Plan Width": 75,
  227. "Actual Startup Time": 2.081,
  228. "Actual Total Time": 20653.451,
  229. "Actual Rows": 622441,
  230. "Actual Loops": 1,
  231. "Output": ["event.date_of_transmission", "event.event_id", "event.start_time", "event.end_time", "event.db2_station_code", "event.panel_code", "event.duration_is_minutes", "event.area_flags", "event.barb_content_id", "event.audience_category_number"],
  232. "Order": ["event.date_of_transmission", "event.event_id"],
  233. "Startup Exclusion": false,
  234. "Runtime Exclusion": false,
  235. "Shared Hit Blocks": 559964,
  236. "Shared Read Blocks": 62806,
  237. "Shared Dirtied Blocks": 0,
  238. "Shared Written Blocks": 0,
  239. "Local Hit Blocks": 0,
  240. "Local Read Blocks": 0,
  241. "Local Dirtied Blocks": 0,
  242. "Local Written Blocks": 0,
  243. "Temp Read Blocks": 0,
  244. "Temp Written Blocks": 0,
  245. "I/O Read Time": 19759.779,
  246. "I/O Write Time": 0.000,
  247. "Plans": [
  248. {
  249. "Node Type": "Index Scan",
  250. "Parent Relationship": "children",
  251. "Parallel Aware": false,
  252. "Async Capable": false,
  253. "Scan Direction": "Forward",
  254. "Index Name": "_hyper_13_63_chunk_program_event_audience_v1_date_of_transmissi",
  255. "Relation Name": "_hyper_13_63_chunk",
  256. "Schema": "_timescaledb_internal",
  257. "Alias": "event_1",
  258. "Startup Cost": 0.43,
  259. "Total Cost": 121387.58,
  260. "Plan Rows": 2673096,
  261. "Plan Width": 75,
  262. "Actual Startup Time": 2.080,
  263. "Actual Total Time": 20584.884,
  264. "Actual Rows": 622441,
  265. "Actual Loops": 1,
  266. "Output": ["event_1.date_of_transmission", "event_1.event_id", "event_1.start_time", "event_1.end_time", "event_1.db2_station_code", "event_1.panel_code", "event_1.duration_is_minutes", "event_1.area_flags", "event_1.barb_content_id", "event_1.audience_category_number"],
  267. "Index Cond": "((event_1.date_of_transmission >= '2022-09-23'::date) AND (event_1.date_of_transmission <= '2022-09-24'::date))",
  268. "Rows Removed by Index Recheck": 0,
  269. "Shared Hit Blocks": 559964,
  270. "Shared Read Blocks": 62806,
  271. "Shared Dirtied Blocks": 0,
  272. "Shared Written Blocks": 0,
  273. "Local Hit Blocks": 0,
  274. "Local Read Blocks": 0,
  275. "Local Dirtied Blocks": 0,
  276. "Local Written Blocks": 0,
  277. "Temp Read Blocks": 0,
  278. "Temp Written Blocks": 0,
  279. "I/O Read Time": 19759.779,
  280. "I/O Write Time": 0.000
  281. },
  282. {
  283. "Node Type": "Index Scan",
  284. "Parent Relationship": "children",
  285. "Parallel Aware": false,
  286. "Async Capable": false,
  287. "Scan Direction": "Forward",
  288. "Index Name": "_hyper_13_64_chunk_program_event_audience_v1_date_of_transmissi",
  289. "Relation Name": "_hyper_13_64_chunk",
  290. "Schema": "_timescaledb_internal",
  291. "Alias": "event_2",
  292. "Startup Cost": 0.43,
  293. "Total Cost": 130414.84,
  294. "Plan Rows": 2872808,
  295. "Plan Width": 75,
  296. "Actual Startup Time": 0.000,
  297. "Actual Total Time": 0.000,
  298. "Actual Rows": 0,
  299. "Actual Loops": 0,
  300. "Output": ["event_2.date_of_transmission", "event_2.event_id", "event_2.start_time", "event_2.end_time", "event_2.db2_station_code", "event_2.panel_code", "event_2.duration_is_minutes", "event_2.area_flags", "event_2.barb_content_id", "event_2.audience_category_number"],
  301. "Index Cond": "((event_2.date_of_transmission >= '2022-09-23'::date) AND (event_2.date_of_transmission <= '2022-09-24'::date))",
  302. "Rows Removed by Index Recheck": 0,
  303. "Shared Hit Blocks": 0,
  304. "Shared Read Blocks": 0,
  305. "Shared Dirtied Blocks": 0,
  306. "Shared Written Blocks": 0,
  307. "Local Hit Blocks": 0,
  308. "Local Read Blocks": 0,
  309. "Local Dirtied Blocks": 0,
  310. "Local Written Blocks": 0,
  311. "Temp Read Blocks": 0,
  312. "Temp Written Blocks": 0,
  313. "I/O Read Time": 0.000,
  314. "I/O Write Time": 0.000
  315. }
  316. ]
  317. },
  318. {
  319. "Node Type": "Index Scan",
  320. "Parent Relationship": "Inner",
  321. "Parallel Aware": false,
  322. "Async Capable": false,
  323. "Scan Direction": "Forward",
  324. "Index Name": "dimension_audience_category_category_number",
  325. "Relation Name": "dimension_audience_category",
  326. "Schema": "v1",
  327. "Alias": "category",
  328. "Startup Cost": 0.14,
  329. "Total Cost": 0.16,
  330. "Plan Rows": 1,
  331. "Plan Width": 17,
  332. "Actual Startup Time": 0.001,
  333. "Actual Total Time": 0.001,
  334. "Actual Rows": 1,
  335. "Actual Loops": 622441,
  336. "Output": ["category.category_number", "category.barb_category_code", "category.category_description", "category.target_size_in_hundreds"],
  337. "Index Cond": "(category.category_number = (event.audience_category_number)::numeric)",
  338. "Rows Removed by Index Recheck": 0,
  339. "Shared Hit Blocks": 1200122,
  340. "Shared Read Blocks": 0,
  341. "Shared Dirtied Blocks": 0,
  342. "Shared Written Blocks": 0,
  343. "Local Hit Blocks": 0,
  344. "Local Read Blocks": 0,
  345. "Local Dirtied Blocks": 0,
  346. "Local Written Blocks": 0,
  347. "Temp Read Blocks": 0,
  348. "Temp Written Blocks": 0,
  349. "I/O Read Time": 0.000,
  350. "I/O Write Time": 0.000
  351. }
  352. ]
  353. }
  354. ]
  355. }
  356. ]
  357. }
  358. ]
  359. },
  360. {
  361. "Node Type": "Hash",
  362. "Parent Relationship": "Inner",
  363. "Parallel Aware": false,
  364. "Async Capable": false,
  365. "Startup Cost": 1.71,
  366. "Total Cost": 1.71,
  367. "Plan Rows": 71,
  368. "Plan Width": 25,
  369. "Actual Startup Time": 0.023,
  370. "Actual Total Time": 0.024,
  371. "Actual Rows": 71,
  372. "Actual Loops": 1,
  373. "Output": ["panel.panelname", "panel.panelcode"],
  374. "Hash Buckets": 1024,
  375. "Original Hash Buckets": 1024,
  376. "Hash Batches": 1,
  377. "Original Hash Batches": 1,
  378. "Peak Memory Usage": 13,
  379. "Shared Hit Blocks": 1,
  380. "Shared Read Blocks": 0,
  381. "Shared Dirtied Blocks": 0,
  382. "Shared Written Blocks": 0,
  383. "Local Hit Blocks": 0,
  384. "Local Read Blocks": 0,
  385. "Local Dirtied Blocks": 0,
  386. "Local Written Blocks": 0,
  387. "Temp Read Blocks": 0,
  388. "Temp Written Blocks": 0,
  389. "I/O Read Time": 0.000,
  390. "I/O Write Time": 0.000,
  391. "Plans": [
  392. {
  393. "Node Type": "Seq Scan",
  394. "Parent Relationship": "Outer",
  395. "Parallel Aware": false,
  396. "Async Capable": false,
  397. "Relation Name": "dimension_panel",
  398. "Schema": "v1",
  399. "Alias": "panel",
  400. "Startup Cost": 0.00,
  401. "Total Cost": 1.71,
  402. "Plan Rows": 71,
  403. "Plan Width": 25,
  404. "Actual Startup Time": 0.004,
  405. "Actual Total Time": 0.010,
  406. "Actual Rows": 71,
  407. "Actual Loops": 1,
  408. "Output": ["panel.panelname", "panel.panelcode"],
  409. "Shared Hit Blocks": 1,
  410. "Shared Read Blocks": 0,
  411. "Shared Dirtied Blocks": 0,
  412. "Shared Written Blocks": 0,
  413. "Local Hit Blocks": 0,
  414. "Local Read Blocks": 0,
  415. "Local Dirtied Blocks": 0,
  416. "Local Written Blocks": 0,
  417. "Temp Read Blocks": 0,
  418. "Temp Written Blocks": 0,
  419. "I/O Read Time": 0.000,
  420. "I/O Write Time": 0.000
  421. }
  422. ]
  423. }
  424. ]
  425. },
  426. {
  427. "Node Type": "Hash",
  428. "Parent Relationship": "Inner",
  429. "Parallel Aware": false,
  430. "Async Capable": false,
  431. "Startup Cost": 13.98,
  432. "Total Cost": 13.98,
  433. "Plan Rows": 698,
  434. "Plan Width": 17,
  435. "Actual Startup Time": 0.229,
  436. "Actual Total Time": 0.230,
  437. "Actual Rows": 698,
  438. "Actual Loops": 1,
  439. "Output": ["station.db2stationname", "station.db2stationcode"],
  440. "Hash Buckets": 1024,
  441. "Original Hash Buckets": 1024,
  442. "Hash Batches": 1,
  443. "Original Hash Batches": 1,
  444. "Peak Memory Usage": 42,
  445. "Shared Hit Blocks": 7,
  446. "Shared Read Blocks": 0,
  447. "Shared Dirtied Blocks": 0,
  448. "Shared Written Blocks": 0,
  449. "Local Hit Blocks": 0,
  450. "Local Read Blocks": 0,
  451. "Local Dirtied Blocks": 0,
  452. "Local Written Blocks": 0,
  453. "Temp Read Blocks": 0,
  454. "Temp Written Blocks": 0,
  455. "I/O Read Time": 0.000,
  456. "I/O Write Time": 0.000,
  457. "Plans": [
  458. {
  459. "Node Type": "Seq Scan",
  460. "Parent Relationship": "Outer",
  461. "Parallel Aware": false,
  462. "Async Capable": false,
  463. "Relation Name": "dimension_db2_station",
  464. "Schema": "v1",
  465. "Alias": "station",
  466. "Startup Cost": 0.00,
  467. "Total Cost": 13.98,
  468. "Plan Rows": 698,
  469. "Plan Width": 17,
  470. "Actual Startup Time": 0.006,
  471. "Actual Total Time": 0.106,
  472. "Actual Rows": 698,
  473. "Actual Loops": 1,
  474. "Output": ["station.db2stationname", "station.db2stationcode"],
  475. "Shared Hit Blocks": 7,
  476. "Shared Read Blocks": 0,
  477. "Shared Dirtied Blocks": 0,
  478. "Shared Written Blocks": 0,
  479. "Local Hit Blocks": 0,
  480. "Local Read Blocks": 0,
  481. "Local Dirtied Blocks": 0,
  482. "Local Written Blocks": 0,
  483. "Temp Read Blocks": 0,
  484. "Temp Written Blocks": 0,
  485. "I/O Read Time": 0.000,
  486. "I/O Write Time": 0.000
  487. }
  488. ]
  489. }
  490. ]
  491. },
  492. {
  493. "Node Type": "Index Scan",
  494. "Parent Relationship": "Inner",
  495. "Parallel Aware": false,
  496. "Async Capable": false,
  497. "Scan Direction": "Forward",
  498. "Index Name": "dimension_program_content_barb_content_id",
  499. "Relation Name": "dimension_program_content",
  500. "Schema": "v1",
  501. "Alias": "content",
  502. "Startup Cost": 0.29,
  503. "Total Cost": 0.40,
  504. "Plan Rows": 1,
  505. "Plan Width": 62,
  506. "Actual Startup Time": 0.004,
  507. "Actual Total Time": 0.005,
  508. "Actual Rows": 1,
  509. "Actual Loops": 10000,
  510. "Output": ["content.barb_content_id", "content.broadcaster_content_id", "content.metabroadcast_content_id", "content.content_name", "content.episode_number", "content.episode_name", "content.products"],
  511. "Index Cond": "(content.barb_content_id = event.barb_content_id)",
  512. "Rows Removed by Index Recheck": 0,
  513. "Shared Hit Blocks": 30000,
  514. "Shared Read Blocks": 0,
  515. "Shared Dirtied Blocks": 0,
  516. "Shared Written Blocks": 0,
  517. "Local Hit Blocks": 0,
  518. "Local Read Blocks": 0,
  519. "Local Dirtied Blocks": 0,
  520. "Local Written Blocks": 0,
  521. "Temp Read Blocks": 0,
  522. "Temp Written Blocks": 0,
  523. "I/O Read Time": 0.000,
  524. "I/O Write Time": 0.000
  525. }
  526. ]
  527. },
  528. "Query Identifier": -7774451985310094559,
  529. "Planning": {
  530. "Shared Hit Blocks": 29,
  531. "Shared Read Blocks": 0,
  532. "Shared Dirtied Blocks": 0,
  533. "Shared Written Blocks": 0,
  534. "Local Hit Blocks": 0,
  535. "Local Read Blocks": 0,
  536. "Local Dirtied Blocks": 0,
  537. "Local Written Blocks": 0,
  538. "Temp Read Blocks": 0,
  539. "Temp Written Blocks": 0,
  540. "I/O Read Time": 0.000,
  541. "I/O Write Time": 0.000
  542. },
  543. "Planning Time": 0.776,
  544. "Triggers": [
  545. ],
  546. "Execution Time": 22768.886
  547. }
  548. ]
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!