API tools faq
paste
Advertisement
twn08

Untitled

twn08
Feb 6th, 2013
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 62.33 KB | None | 0 0
raw download clone embed print report
  1. <explain xmlns="http://www.postgresql.org/2009/explain">
  2. <Query>
  3. <Plan>
  4. <Node-Type>Nested Loop</Node-Type>
  5. <Join-Type>Left</Join-Type>
  6. <Output>
  7. <Item>dd.id_databox_data</Item>
  8. <Item>dd.recipient_id</Item>
  9. <Item>dd.sender_id</Item>
  10. <Item>lp.business_name</Item>
  11. <Item>fa.repayment_identification</Item>
  12. <Item>act.perform_time</Item>
  13. <Item>dd.subject</Item>
  14. <Item>communication_act.subject</Item>
  15. <Item>d.unique_name</Item>
  16. <Item>s.name</Item>
  17. <Item>s.long_name</Item>
  18. <Item>lld.legal_template</Item>
  19. <Item>lld.issue_date</Item>
  20. <Item>act.perform_time</Item>
  21. <Item>dd.id_recipient_document_ident</Item>
  22. <Item>dd.id_sender_document_ident</Item>
  23. <Item>dci1.ref_number</Item>
  24. <Item>dci2.ref_number</Item>
  25. </Output>
  26. <Plans>
  27. <Plan>
  28. <Node-Type>Nested Loop</Node-Type>
  29. <Parent-Relationship>Outer</Parent-Relationship>
  30. <Join-Type>Left</Join-Type>
  31. <Output>
  32. <Item>dd.id_databox_data</Item>
  33. <Item>dd.recipient_id</Item>
  34. <Item>dd.sender_id</Item>
  35. <Item>dd.subject</Item>
  36. <Item>dd.id_recipient_document_ident</Item>
  37. <Item>dd.id_sender_document_ident</Item>
  38. <Item>d.unique_name</Item>
  39. <Item>lld.legal_template</Item>
  40. <Item>lld.issue_date</Item>
  41. <Item>communication_act.subject</Item>
  42. <Item>act.perform_time</Item>
  43. <Item>s.name</Item>
  44. <Item>s.long_name</Item>
  45. <Item>fa.repayment_identification</Item>
  46. <Item>lp.business_name</Item>
  47. <Item>dci1.ref_number</Item>
  48. </Output>
  49. <Plans>
  50. <Plan>
  51. <Node-Type>Nested Loop</Node-Type>
  52. <Parent-Relationship>Outer</Parent-Relationship>
  53. <Join-Type>Inner</Join-Type>
  54. <Output>
  55. <Item>dd.id_databox_data</Item>
  56. <Item>dd.recipient_id</Item>
  57. <Item>dd.sender_id</Item>
  58. <Item>dd.subject</Item>
  59. <Item>dd.id_recipient_document_ident</Item>
  60. <Item>dd.id_sender_document_ident</Item>
  61. <Item>d.unique_name</Item>
  62. <Item>lld.legal_template</Item>
  63. <Item>lld.issue_date</Item>
  64. <Item>communication_act.subject</Item>
  65. <Item>act.perform_time</Item>
  66. <Item>s.name</Item>
  67. <Item>s.long_name</Item>
  68. <Item>fa.repayment_identification</Item>
  69. <Item>lp.business_name</Item>
  70. </Output>
  71. <Plans>
  72. <Plan>
  73. <Node-Type>Nested Loop</Node-Type>
  74. <Parent-Relationship>Outer</Parent-Relationship>
  75. <Join-Type>Inner</Join-Type>
  76. <Output>
  77. <Item>dd.id_databox_data</Item>
  78. <Item>dd.recipient_id</Item>
  79. <Item>dd.sender_id</Item>
  80. <Item>dd.subject</Item>
  81. <Item>dd.id_recipient_document_ident</Item>
  82. <Item>dd.id_sender_document_ident</Item>
  83. <Item>d.unique_name</Item>
  84. <Item>lld.legal_template</Item>
  85. <Item>lld.issue_date</Item>
  86. <Item>communication_act.subject</Item>
  87. <Item>act.perform_time</Item>
  88. <Item>s.name</Item>
  89. <Item>s.long_name</Item>
  90. <Item>pr.id_source</Item>
  91. <Item>fa.repayment_identification</Item>
  92. </Output>
  93. <Join-Filter>(flight.id_portfolio = p.id_portfolio)</Join-Filter>
  94. <Plans>
  95. <Plan>
  96. <Node-Type>Nested Loop</Node-Type>
  97. <Parent-Relationship>Outer</Parent-Relationship>
  98. <Join-Type>Inner</Join-Type>
  99. <Output>
  100. <Item>dd.id_databox_data</Item>
  101. <Item>dd.recipient_id</Item>
  102. <Item>dd.sender_id</Item>
  103. <Item>dd.subject</Item>
  104. <Item>dd.id_recipient_document_ident</Item>
  105. <Item>dd.id_sender_document_ident</Item>
  106. <Item>d.unique_name</Item>
  107. <Item>lld.legal_template</Item>
  108. <Item>lld.issue_date</Item>
  109. <Item>communication_act.subject</Item>
  110. <Item>act.perform_time</Item>
  111. <Item>s.name</Item>
  112. <Item>s.long_name</Item>
  113. <Item>pr.id_source</Item>
  114. <Item>fa.repayment_identification</Item>
  115. <Item>flight.id_portfolio</Item>
  116. </Output>
  117. <Plans>
  118. <Plan>
  119. <Node-Type>Nested Loop</Node-Type>
  120. <Parent-Relationship>Outer</Parent-Relationship>
  121. <Join-Type>Inner</Join-Type>
  122. <Output>
  123. <Item>dd.id_databox_data</Item>
  124. <Item>dd.recipient_id</Item>
  125. <Item>dd.sender_id</Item>
  126. <Item>dd.subject</Item>
  127. <Item>dd.id_recipient_document_ident</Item>
  128. <Item>dd.id_sender_document_ident</Item>
  129. <Item>d.unique_name</Item>
  130. <Item>lld.legal_template</Item>
  131. <Item>lld.issue_date</Item>
  132. <Item>communication_act.subject</Item>
  133. <Item>act.perform_time</Item>
  134. <Item>s.name</Item>
  135. <Item>s.long_name</Item>
  136. <Item>pr.id_source</Item>
  137. <Item>fa.repayment_identification</Item>
  138. <Item>fa.id_flight</Item>
  139. </Output>
  140. <Plans>
  141. <Plan>
  142. <Node-Type>Nested Loop</Node-Type>
  143. <Parent-Relationship>Outer</Parent-Relationship>
  144. <Join-Type>Left</Join-Type>
  145. <Output>
  146. <Item>dd.id_databox_data</Item>
  147. <Item>dd.recipient_id</Item>
  148. <Item>dd.sender_id</Item>
  149. <Item>dd.subject</Item>
  150. <Item>dd.id_recipient_document_ident</Item>
  151. <Item>dd.id_sender_document_ident</Item>
  152. <Item>d.unique_name</Item>
  153. <Item>lld.legal_template</Item>
  154. <Item>lld.issue_date</Item>
  155. <Item>communication_act.subject</Item>
  156. <Item>act.perform_time</Item>
  157. <Item>s.name</Item>
  158. <Item>s.long_name</Item>
  159. <Item>r.id_accountability</Item>
  160. <Item>pr.id_source</Item>
  161. </Output>
  162. <Join-Filter>((dd.recipient_id)::text = (party.data_box_id)::text)</Join-Filter>
  163. <Plans>
  164. <Plan>
  165. <Node-Type>Nested Loop</Node-Type>
  166. <Parent-Relationship>Outer</Parent-Relationship>
  167. <Join-Type>Inner</Join-Type>
  168. <Output>
  169. <Item>dd.id_databox_data</Item>
  170. <Item>dd.recipient_id</Item>
  171. <Item>dd.sender_id</Item>
  172. <Item>dd.subject</Item>
  173. <Item>dd.id_recipient_document_ident</Item>
  174. <Item>dd.id_sender_document_ident</Item>
  175. <Item>d.unique_name</Item>
  176. <Item>lld.legal_template</Item>
  177. <Item>lld.issue_date</Item>
  178. <Item>communication_act.subject</Item>
  179. <Item>act.perform_time</Item>
  180. <Item>s.name</Item>
  181. <Item>s.long_name</Item>
  182. <Item>r.id_accountability</Item>
  183. <Item>pr.id_source</Item>
  184. </Output>
  185. <Plans>
  186. <Plan>
  187. <Node-Type>Nested Loop</Node-Type>
  188. <Parent-Relationship>Outer</Parent-Relationship>
  189. <Join-Type>Inner</Join-Type>
  190. <Output>
  191. <Item>dd.id_databox_data</Item>
  192. <Item>dd.recipient_id</Item>
  193. <Item>dd.sender_id</Item>
  194. <Item>dd.subject</Item>
  195. <Item>dd.id_recipient_document_ident</Item>
  196. <Item>dd.id_sender_document_ident</Item>
  197. <Item>d.unique_name</Item>
  198. <Item>lld.legal_template</Item>
  199. <Item>lld.issue_date</Item>
  200. <Item>communication_act.subject</Item>
  201. <Item>act.perform_time</Item>
  202. <Item>s.name</Item>
  203. <Item>s.long_name</Item>
  204. <Item>r.id_responsible</Item>
  205. <Item>r.id_accountability</Item>
  206. </Output>
  207. <Plans>
  208. <Plan>
  209. <Node-Type>Nested Loop</Node-Type>
  210. <Parent-Relationship>Outer</Parent-Relationship>
  211. <Join-Type>Inner</Join-Type>
  212. <Output>
  213. <Item>dd.id_databox_data</Item>
  214. <Item>dd.recipient_id</Item>
  215. <Item>dd.sender_id</Item>
  216. <Item>dd.subject</Item>
  217. <Item>dd.id_recipient_document_ident</Item>
  218. <Item>dd.id_sender_document_ident</Item>
  219. <Item>d.unique_name</Item>
  220. <Item>lld.legal_template</Item>
  221. <Item>lld.issue_date</Item>
  222. <Item>communication_act.subject</Item>
  223. <Item>act.perform_time</Item>
  224. <Item>party_act.id_related_responsibility</Item>
  225. <Item>s.name</Item>
  226. <Item>s.long_name</Item>
  227. </Output>
  228. <Plans>
  229. <Plan>
  230. <Node-Type>Nested Loop</Node-Type>
  231. <Parent-Relationship>Outer</Parent-Relationship>
  232. <Join-Type>Inner</Join-Type>
  233. <Output>
  234. <Item>dd.id_databox_data</Item>
  235. <Item>dd.recipient_id</Item>
  236. <Item>dd.sender_id</Item>
  237. <Item>dd.subject</Item>
  238. <Item>dd.id_recipient_document_ident</Item>
  239. <Item>dd.id_sender_document_ident</Item>
  240. <Item>d.unique_name</Item>
  241. <Item>lld.legal_template</Item>
  242. <Item>lld.issue_date</Item>
  243. <Item>communication_act.subject</Item>
  244. <Item>act.perform_time</Item>
  245. <Item>act.id_solver</Item>
  246. <Item>party_act.id_related_responsibility</Item>
  247. </Output>
  248. <Plans>
  249. <Plan>
  250. <Node-Type>Hash Join</Node-Type>
  251. <Parent-Relationship>Outer</Parent-Relationship>
  252. <Join-Type>Inner</Join-Type>
  253. <Output>
  254. <Item>dd.id_databox_data</Item>
  255. <Item>dd.recipient_id</Item>
  256. <Item>dd.sender_id</Item>
  257. <Item>dd.subject</Item>
  258. <Item>dd.id_recipient_document_ident</Item>
  259. <Item>dd.id_sender_document_ident</Item>
  260. <Item>d.unique_name</Item>
  261. <Item>lld.legal_template</Item>
  262. <Item>lld.issue_date</Item>
  263. <Item>communication_act.subject</Item>
  264. <Item>communication_act.id_act</Item>
  265. <Item>act.perform_time</Item>
  266. <Item>act.id_act</Item>
  267. <Item>act.id_solver</Item>
  268. </Output>
  269. <Hash-Cond>(ld.id_letter_data = communication_act.id_letter_data)</Hash-Cond>
  270. <Plans>
  271. <Plan>
  272. <Node-Type>Hash Join</Node-Type>
  273. <Parent-Relationship>Outer</Parent-Relationship>
  274. <Join-Type>Inner</Join-Type>
  275. <Output>
  276. <Item>dd.id_databox_data</Item>
  277. <Item>dd.recipient_id</Item>
  278. <Item>dd.sender_id</Item>
  279. <Item>dd.subject</Item>
  280. <Item>dd.id_recipient_document_ident</Item>
  281. <Item>dd.id_sender_document_ident</Item>
  282. <Item>d.unique_name</Item>
  283. <Item>fld.id_letter_data</Item>
  284. <Item>ld.id_letter_data</Item>
  285. <Item>lld.legal_template</Item>
  286. <Item>lld.issue_date</Item>
  287. <Item>lld.id_letter_data</Item>
  288. </Output>
  289. <Hash-Cond>(dda.id_databox_data = dd.id_databox_data)</Hash-Cond>
  290. <Plans>
  291. <Plan>
  292. <Node-Type>Hash Join</Node-Type>
  293. <Parent-Relationship>Outer</Parent-Relationship>
  294. <Join-Type>Inner</Join-Type>
  295. <Output>
  296. <Item>dda.id_databox_data</Item>
  297. <Item>d.unique_name</Item>
  298. <Item>fld.id_letter_data</Item>
  299. <Item>ld.id_letter_data</Item>
  300. <Item>lld.legal_template</Item>
  301. <Item>lld.issue_date</Item>
  302. <Item>lld.id_letter_data</Item>
  303. </Output>
  304. <Hash-Cond>(da.id_databox_attachment = dda.id_databox_attachment)</Hash-Cond>
  305. <Plans>
  306. <Plan>
  307. <Node-Type>Hash Join</Node-Type>
  308. <Parent-Relationship>Outer</Parent-Relationship>
  309. <Join-Type>Inner</Join-Type>
  310. <Output>
  311. <Item>da.id_databox_attachment</Item>
  312. <Item>d.unique_name</Item>
  313. <Item>fld.id_letter_data</Item>
  314. <Item>ld.id_letter_data</Item>
  315. <Item>lld.legal_template</Item>
  316. <Item>lld.issue_date</Item>
  317. <Item>lld.id_letter_data</Item>
  318. </Output>
  319. <Hash-Cond>(lld.id_legal_instrument = li.id_legal_instrument)</Hash-Cond>
  320. <Plans>
  321. <Plan>
  322. <Node-Type>Hash Join</Node-Type>
  323. <Parent-Relationship>Outer</Parent-Relationship>
  324. <Join-Type>Inner</Join-Type>
  325. <Output>
  326. <Item>da.id_databox_attachment</Item>
  327. <Item>d.unique_name</Item>
  328. <Item>fld.id_letter_data</Item>
  329. <Item>ld.id_letter_data</Item>
  330. <Item>lld.legal_template</Item>
  331. <Item>lld.issue_date</Item>
  332. <Item>lld.id_letter_data</Item>
  333. <Item>lld.id_legal_instrument</Item>
  334. </Output>
  335. <Hash-Cond>(ld.id_letter_data = fld.id_letter_data)</Hash-Cond>
  336. <Plans>
  337. <Plan>
  338. <Node-Type>Seq Scan</Node-Type>
  339. <Parent-Relationship>Outer</Parent-Relationship>
  340. <Relation-Name>letter_data</Relation-Name>
  341. <Schema>public</Schema>
  342. <Alias>ld</Alias>
  343. <Output>
  344. <Item>ld.id_letter_data</Item>
  345. </Output>
  346. </Plan>
  347. <Plan>
  348. <Node-Type>Hash</Node-Type>
  349. <Parent-Relationship>Inner</Parent-Relationship>
  350. <Output>
  351. <Item>da.id_databox_attachment</Item>
  352. <Item>d.unique_name</Item>
  353. <Item>fld.id_letter_data</Item>
  354. <Item>lld.legal_template</Item>
  355. <Item>lld.issue_date</Item>
  356. <Item>lld.id_letter_data</Item>
  357. <Item>lld.id_legal_instrument</Item>
  358. </Output>
  359. <Plans>
  360. <Plan>
  361. <Node-Type>Hash Join</Node-Type>
  362. <Parent-Relationship>Outer</Parent-Relationship>
  363. <Join-Type>Inner</Join-Type>
  364. <Output>
  365. <Item>da.id_databox_attachment</Item>
  366. <Item>d.unique_name</Item>
  367. <Item>fld.id_letter_data</Item>
  368. <Item>lld.legal_template</Item>
  369. <Item>lld.issue_date</Item>
  370. <Item>lld.id_letter_data</Item>
  371. <Item>lld.id_legal_instrument</Item>
  372. </Output>
  373. <Hash-Cond>(lld.id_letter_data = fld.id_letter_data)</Hash-Cond>
  374. <Plans>
  375. <Plan>
  376. <Node-Type>Seq Scan</Node-Type>
  377. <Parent-Relationship>Outer</Parent-Relationship>
  378. <Relation-Name>legal_letter_data</Relation-Name>
  379. <Schema>public</Schema>
  380. <Alias>lld</Alias>
  381. <Output>
  382. <Item>lld.legal_template</Item>
  383. <Item>lld.issue_date</Item>
  384. <Item>lld.id_letter_data</Item>
  385. <Item>lld.id_legal_instrument</Item>
  386. </Output>
  387. </Plan>
  388. <Plan>
  389. <Node-Type>Hash</Node-Type>
  390. <Parent-Relationship>Inner</Parent-Relationship>
  391. <Output>
  392. <Item>da.id_databox_attachment</Item>
  393. <Item>d.unique_name</Item>
  394. <Item>fld.id_letter_data</Item>
  395. </Output>
  396. <Plans>
  397. <Plan>
  398. <Node-Type>Hash Join</Node-Type>
  399. <Parent-Relationship>Outer</Parent-Relationship>
  400. <Join-Type>Inner</Join-Type>
  401. <Output>
  402. <Item>da.id_databox_attachment</Item>
  403. <Item>d.unique_name</Item>
  404. <Item>fld.id_letter_data</Item>
  405. </Output>
  406. <Hash-Cond>(fld.id_document = d.id_document)</Hash-Cond>
  407. <Plans>
  408. <Plan>
  409. <Node-Type>Seq Scan</Node-Type>
  410. <Parent-Relationship>Outer</Parent-Relationship>
  411. <Relation-Name>external_file_letter_data</Relation-Name>
  412. <Schema>public</Schema>
  413. <Alias>fld</Alias>
  414. <Output>
  415. <Item>fld.id_document</Item>
  416. <Item>fld.id_letter_data</Item>
  417. </Output>
  418. </Plan>
  419. <Plan>
  420. <Node-Type>Hash</Node-Type>
  421. <Parent-Relationship>Inner</Parent-Relationship>
  422. <Output>
  423. <Item>da.id_databox_attachment</Item>
  424. <Item>da.id_document</Item>
  425. <Item>d.unique_name</Item>
  426. <Item>d.id_document</Item>
  427. </Output>
  428. <Plans>
  429. <Plan>
  430. <Node-Type>Hash Join</Node-Type>
  431. <Parent-Relationship>Outer</Parent-Relationship>
  432. <Join-Type>Inner</Join-Type>
  433. <Output>
  434. <Item>da.id_databox_attachment</Item>
  435. <Item>da.id_document</Item>
  436. <Item>d.unique_name</Item>
  437. <Item>d.id_document</Item>
  438. </Output>
  439. <Hash-Cond>(da.id_document = d.id_document)</Hash-Cond>
  440. <Plans>
  441. <Plan>
  442. <Node-Type>Seq Scan</Node-Type>
  443. <Parent-Relationship>Outer</Parent-Relationship>
  444. <Relation-Name>databox_attachment</Relation-Name>
  445. <Schema>public</Schema>
  446. <Alias>da</Alias>
  447. <Output>
  448. <Item>da.id_databox_attachment</Item>
  449. <Item>da.id_document</Item>
  450. </Output>
  451. </Plan>
  452. <Plan>
  453. <Node-Type>Hash</Node-Type>
  454. <Parent-Relationship>Inner</Parent-Relationship>
  455. <Output>
  456. <Item>d.unique_name</Item>
  457. <Item>d.id_document</Item>
  458. </Output>
  459. <Plans>
  460. <Plan>
  461. <Node-Type>Seq Scan</Node-Type>
  462. <Parent-Relationship>Outer</Parent-Relationship>
  463. <Relation-Name>document</Relation-Name>
  464. <Schema>public</Schema>
  465. <Alias>d</Alias>
  466. <Output>
  467. <Item>d.unique_name</Item>
  468. <Item>d.id_document</Item>
  469. </Output>
  470. </Plan>
  471. </Plans>
  472. </Plan>
  473. </Plans>
  474. </Plan>
  475. </Plans>
  476. </Plan>
  477. </Plans>
  478. </Plan>
  479. </Plans>
  480. </Plan>
  481. </Plans>
  482. </Plan>
  483. </Plans>
  484. </Plan>
  485. </Plans>
  486. </Plan>
  487. <Plan>
  488. <Node-Type>Hash</Node-Type>
  489. <Parent-Relationship>Inner</Parent-Relationship>
  490. <Output>
  491. <Item>li.id_legal_instrument</Item>
  492. </Output>
  493. <Plans>
  494. <Plan>
  495. <Node-Type>Seq Scan</Node-Type>
  496. <Parent-Relationship>Outer</Parent-Relationship>
  497. <Relation-Name>legal_instrument</Relation-Name>
  498. <Schema>public</Schema>
  499. <Alias>li</Alias>
  500. <Output>
  501. <Item>li.id_legal_instrument</Item>
  502. </Output>
  503. </Plan>
  504. </Plans>
  505. </Plan>
  506. </Plans>
  507. </Plan>
  508. <Plan>
  509. <Node-Type>Hash</Node-Type>
  510. <Parent-Relationship>Inner</Parent-Relationship>
  511. <Output>
  512. <Item>dda.id_databox_data</Item>
  513. <Item>dda.id_databox_attachment</Item>
  514. </Output>
  515. <Plans>
  516. <Plan>
  517. <Node-Type>Seq Scan</Node-Type>
  518. <Parent-Relationship>Outer</Parent-Relationship>
  519. <Relation-Name>databox_data_attachments</Relation-Name>
  520. <Schema>public</Schema>
  521. <Alias>dda</Alias>
  522. <Output>
  523. <Item>dda.id_databox_data</Item>
  524. <Item>dda.id_databox_attachment</Item>
  525. </Output>
  526. </Plan>
  527. </Plans>
  528. </Plan>
  529. </Plans>
  530. </Plan>
  531. <Plan>
  532. <Node-Type>Hash</Node-Type>
  533. <Parent-Relationship>Inner</Parent-Relationship>
  534. <Output>
  535. <Item>dd.id_databox_data</Item>
  536. <Item>dd.recipient_id</Item>
  537. <Item>dd.sender_id</Item>
  538. <Item>dd.subject</Item>
  539. <Item>dd.id_recipient_document_ident</Item>
  540. <Item>dd.id_sender_document_ident</Item>
  541. </Output>
  542. <Plans>
  543. <Plan>
  544. <Node-Type>Seq Scan</Node-Type>
  545. <Parent-Relationship>Outer</Parent-Relationship>
  546. <Relation-Name>databox_data</Relation-Name>
  547. <Schema>public</Schema>
  548. <Alias>dd</Alias>
  549. <Output>
  550. <Item>dd.id_databox_data</Item>
  551. <Item>dd.recipient_id</Item>
  552. <Item>dd.sender_id</Item>
  553. <Item>dd.subject</Item>
  554. <Item>dd.id_recipient_document_ident</Item>
  555. <Item>dd.id_sender_document_ident</Item>
  556. </Output>
  557. </Plan>
  558. </Plans>
  559. </Plan>
  560. </Plans>
  561. </Plan>
  562. <Plan>
  563. <Node-Type>Hash</Node-Type>
  564. <Parent-Relationship>Inner</Parent-Relationship>
  565. <Output>
  566. <Item>communication_act.subject</Item>
  567. <Item>communication_act.id_act</Item>
  568. <Item>communication_act.id_letter_data</Item>
  569. <Item>act.perform_time</Item>
  570. <Item>act.id_act</Item>
  571. <Item>act.id_solver</Item>
  572. </Output>
  573. <Plans>
  574. <Plan>
  575. <Node-Type>Nested Loop</Node-Type>
  576. <Parent-Relationship>Outer</Parent-Relationship>
  577. <Join-Type>Inner</Join-Type>
  578. <Output>
  579. <Item>communication_act.subject</Item>
  580. <Item>communication_act.id_act</Item>
  581. <Item>communication_act.id_letter_data</Item>
  582. <Item>act.perform_time</Item>
  583. <Item>act.id_act</Item>
  584. <Item>act.id_solver</Item>
  585. </Output>
  586. <Plans>
  587. <Plan>
  588. <Node-Type>Bitmap Heap Scan</Node-Type>
  589. <Parent-Relationship>Outer</Parent-Relationship>
  590. <Relation-Name>act</Relation-Name>
  591. <Schema>public</Schema>
  592. <Alias>act</Alias>
  593. <Output>
  594. <Item>act.id_act</Item>
  595. <Item>act.perform_time</Item>
  596. <Item>act.id_solved_task</Item>
  597. <Item>act.id_solver</Item>
  598. </Output>
  599. <Recheck-Cond>(act.id_solver = 41)</Recheck-Cond>
  600. <Filter>(act.perform_time &gt; ((now())::date - 1))</Filter>
  601. <Plans>
  602. <Plan>
  603. <Node-Type>Bitmap Index Scan</Node-Type>
  604. <Parent-Relationship>Outer</Parent-Relationship>
  605. <Index-Name>idx_act_id_solver</Index-Name>
  606. <Index-Cond>(act.id_solver = 41)</Index-Cond>
  607. </Plan>
  608. </Plans>
  609. </Plan>
  610. <Plan>
  611. <Node-Type>Index Scan</Node-Type>
  612. <Parent-Relationship>Inner</Parent-Relationship>
  613. <Scan-Direction>NoMovement</Scan-Direction>
  614. <Index-Name>communication_act_pkey</Index-Name>
  615. <Relation-Name>communication_act</Relation-Name>
  616. <Schema>public</Schema>
  617. <Alias>communication_act</Alias>
  618. <Output>
  619. <Item>communication_act.id_act</Item>
  620. <Item>communication_act.channel</Item>
  621. <Item>communication_act.direction</Item>
  622. <Item>communication_act.is_rpc</Item>
  623. <Item>communication_act.id_used_contact_entry</Item>
  624. <Item>communication_act.id_letter_data</Item>
  625. <Item>communication_act.id_returned_mail_notification</Item>
  626. <Item>communication_act.subject</Item>
  627. <Item>communication_act.id_erased_act</Item>
  628. </Output>
  629. <Index-Cond>(communication_act.id_act = act.id_act)</Index-Cond>
  630. </Plan>
  631. </Plans>
  632. </Plan>
  633. </Plans>
  634. </Plan>
  635. </Plans>
  636. </Plan>
  637. <Plan>
  638. <Node-Type>Index Scan</Node-Type>
  639. <Parent-Relationship>Inner</Parent-Relationship>
  640. <Scan-Direction>NoMovement</Scan-Direction>
  641. <Index-Name>party_act_pkey</Index-Name>
  642. <Relation-Name>party_act</Relation-Name>
  643. <Schema>public</Schema>
  644. <Alias>party_act</Alias>
  645. <Output>
  646. <Item>party_act.id_act</Item>
  647. <Item>party_act.id_party</Item>
  648. <Item>party_act.id_related_responsibility</Item>
  649. </Output>
  650. <Index-Cond>(party_act.id_act = communication_act.id_act)</Index-Cond>
  651. </Plan>
  652. </Plans>
  653. </Plan>
  654. <Plan>
  655. <Node-Type>Seq Scan</Node-Type>
  656. <Parent-Relationship>Inner</Parent-Relationship>
  657. <Relation-Name>solver</Relation-Name>
  658. <Schema>public</Schema>
  659. <Alias>s</Alias>
  660. <Output>
  661. <Item>s.id_solver</Item>
  662. <Item>s.name</Item>
  663. <Item>s.long_name</Item>
  664. </Output>
  665. <Filter>(s.id_solver = 41)</Filter>
  666. </Plan>
  667. </Plans>
  668. </Plan>
  669. <Plan>
  670. <Node-Type>Index Scan</Node-Type>
  671. <Parent-Relationship>Inner</Parent-Relationship>
  672. <Scan-Direction>NoMovement</Scan-Direction>
  673. <Index-Name>responsibility_pkey</Index-Name>
  674. <Relation-Name>responsibility</Relation-Name>
  675. <Schema>public</Schema>
  676. <Alias>r</Alias>
  677. <Output>
  678. <Item>r.id_responsibility</Item>
  679. <Item>r.id_accountability</Item>
  680. <Item>r.id_responsible</Item>
  681. </Output>
  682. <Index-Cond>(r.id_responsibility = party_act.id_related_responsibility)</Index-Cond>
  683. </Plan>
  684. </Plans>
  685. </Plan>
  686. <Plan>
  687. <Node-Type>Index Scan</Node-Type>
  688. <Parent-Relationship>Inner</Parent-Relationship>
  689. <Scan-Direction>NoMovement</Scan-Direction>
  690. <Index-Name>party_pkey</Index-Name>
  691. <Relation-Name>party</Relation-Name>
  692. <Schema>public</Schema>
  693. <Alias>pr</Alias>
  694. <Output>
  695. <Item>pr.id_party</Item>
  696. <Item>pr.id_mailing_address</Item>
  697. <Item>pr.id_residential_address</Item>
  698. <Item>pr.id_source</Item>
  699. <Item>pr.external_id</Item>
  700. <Item>pr.id_jurisdiction_country</Item>
  701. <Item>pr.data_box_id</Item>
  702. </Output>
  703. <Index-Cond>(pr.id_party = r.id_responsible)</Index-Cond>
  704. </Plan>
  705. </Plans>
  706. </Plan>
  707. <Plan>
  708. <Node-Type>Nested Loop</Node-Type>
  709. <Parent-Relationship>Inner</Parent-Relationship>
  710. <Join-Type>Inner</Join-Type>
  711. <Output>
  712. <Item>party.data_box_id</Item>
  713. </Output>
  714. <Plans>
  715. <Plan>
  716. <Node-Type>Seq Scan</Node-Type>
  717. <Parent-Relationship>Outer</Parent-Relationship>
  718. <Relation-Name>authority</Relation-Name>
  719. <Schema>public</Schema>
  720. <Alias>authority</Alias>
  721. <Output>
  722. <Item>authority.id_party</Item>
  723. <Item>authority.id_bank_account</Item>
  724. <Item>authority.name</Item>
  725. </Output>
  726. </Plan>
  727. <Plan>
  728. <Node-Type>Index Scan</Node-Type>
  729. <Parent-Relationship>Inner</Parent-Relationship>
  730. <Scan-Direction>NoMovement</Scan-Direction>
  731. <Index-Name>party_pkey</Index-Name>
  732. <Relation-Name>party</Relation-Name>
  733. <Schema>public</Schema>
  734. <Alias>party</Alias>
  735. <Output>
  736. <Item>party.id_party</Item>
  737. <Item>party.id_mailing_address</Item>
  738. <Item>party.id_residential_address</Item>
  739. <Item>party.id_source</Item>
  740. <Item>party.external_id</Item>
  741. <Item>party.id_jurisdiction_country</Item>
  742. <Item>party.data_box_id</Item>
  743. </Output>
  744. <Index-Cond>(party.id_party = authority.id_party)</Index-Cond>
  745. </Plan>
  746. </Plans>
  747. </Plan>
  748. </Plans>
  749. </Plan>
  750. <Plan>
  751. <Node-Type>Index Scan</Node-Type>
  752. <Parent-Relationship>Inner</Parent-Relationship>
  753. <Scan-Direction>NoMovement</Scan-Direction>
  754. <Index-Name>financial_accountability_pkey</Index-Name>
  755. <Relation-Name>financial_accountability</Relation-Name>
  756. <Schema>public</Schema>
  757. <Alias>fa</Alias>
  758. <Output>
  759. <Item>fa.id_accountability</Item>
  760. <Item>fa.id_current_promise</Item>
  761. <Item>fa.repayment_identification</Item>
  762. <Item>fa.id_repayment_account</Item>
  763. <Item>fa.exists_unknown_manual_suit</Item>
  764. <Item>fa.id_flight</Item>
  765. <Item>fa.id_installment_agreement</Item>
  766. <Item>fa.is_written_off</Item>
  767. </Output>
  768. <Index-Cond>(fa.id_accountability = r.id_accountability)</Index-Cond>
  769. </Plan>
  770. </Plans>
  771. </Plan>
  772. <Plan>
  773. <Node-Type>Index Scan</Node-Type>
  774. <Parent-Relationship>Inner</Parent-Relationship>
  775. <Scan-Direction>NoMovement</Scan-Direction>
  776. <Index-Name>flight_pkey</Index-Name>
  777. <Relation-Name>flight</Relation-Name>
  778. <Schema>public</Schema>
  779. <Alias>flight</Alias>
  780. <Output>
  781. <Item>flight.id_flight</Item>
  782. <Item>flight.purchase_date</Item>
  783. <Item>flight.project_code</Item>
  784. <Item>flight.id_portfolio</Item>
  785. <Item>flight.id_attorney</Item>
  786. </Output>
  787. <Index-Cond>(flight.id_flight = fa.id_flight)</Index-Cond>
  788. </Plan>
  789. </Plans>
  790. </Plan>
  791. <Plan>
  792. <Node-Type>Seq Scan</Node-Type>
  793. <Parent-Relationship>Inner</Parent-Relationship>
  794. <Relation-Name>portfolio</Relation-Name>
  795. <Schema>public</Schema>
  796. <Alias>p</Alias>
  797. <Output>
  798. <Item>p.id_portfolio</Item>
  799. <Item>p.code</Item>
  800. <Item>p.name</Item>
  801. </Output>
  802. </Plan>
  803. </Plans>
  804. </Plan>
  805. <Plan>
  806. <Node-Type>Index Scan</Node-Type>
  807. <Parent-Relationship>Inner</Parent-Relationship>
  808. <Scan-Direction>NoMovement</Scan-Direction>
  809. <Index-Name>legal_person_pkey</Index-Name>
  810. <Relation-Name>legal_person</Relation-Name>
  811. <Schema>public</Schema>
  812. <Alias>lp</Alias>
  813. <Output>
  814. <Item>lp.id_party</Item>
  815. <Item>lp.business_name</Item>
  816. <Item>lp.registration_number</Item>
  817. </Output>
  818. <Index-Cond>(lp.id_party = pr.id_source)</Index-Cond>
  819. </Plan>
  820. </Plans>
  821. </Plan>
  822. <Plan>
  823. <Node-Type>Index Scan</Node-Type>
  824. <Parent-Relationship>Inner</Parent-Relationship>
  825. <Scan-Direction>NoMovement</Scan-Direction>
  826. <Index-Name>databox_document_ident_pkey</Index-Name>
  827. <Relation-Name>databox_document_ident</Relation-Name>
  828. <Schema>public</Schema>
  829. <Alias>dci1</Alias>
  830. <Output>
  831. <Item>dci1.id_databox_document_ident</Item>
  832. <Item>dci1.ident</Item>
  833. <Item>dci1.ref_number</Item>
  834. </Output>
  835. <Index-Cond>(dd.id_recipient_document_ident = dci1.id_databox_document_ident)</Index-Cond>
  836. </Plan>
  837. </Plans>
  838. </Plan>
  839. <Plan>
  840. <Node-Type>Index Scan</Node-Type>
  841. <Parent-Relationship>Inner</Parent-Relationship>
  842. <Scan-Direction>NoMovement</Scan-Direction>
  843. <Index-Name>databox_document_ident_pkey</Index-Name>
  844. <Relation-Name>databox_document_ident</Relation-Name>
  845. <Schema>public</Schema>
  846. <Alias>dci2</Alias>
  847. <Output>
  848. <Item>dci2.id_databox_document_ident</Item>
  849. <Item>dci2.ident</Item>
  850. <Item>dci2.ref_number</Item>
  851. </Output>
  852. <Index-Cond>(dd.id_recipient_document_ident = dci2.id_databox_document_ident)</Index-Cond>
  853. </Plan>
  854. </Plans>
  855. </Plan>
  856. </Query>
  857. </explain>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!