API tools faq
paste
Guest User

Untitled

a guest
Apr 22nd, 2025
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.21 KB | None | 0 0
raw download clone embed print report
  1. [
  2. {
  3. "Plan": {
  4. "Node Type": "Aggregate",
  5. "Strategy": "Hashed",
  6. "Partial Mode": "Simple",
  7. "Parallel Aware": false,
  8. "Async Capable": false,
  9. "Startup Cost": 179.56,
  10. "Total Cost": 180.07,
  11. "Plan Rows": 51,
  12. "Plan Width": 57,
  13. "Actual Startup Time": 39.554,
  14. "Actual Total Time": 39.564,
  15. "Actual Rows": 3,
  16. "Actual Loops": 1,
  17. "Group Key": ["prompt_sets_conversation.prompt_set_id", "prompts_evaluation.ai_model", "prompt_sets_promptset.name"],
  18. "Planned Partitions": 0,
  19. "HashAgg Batches": 1,
  20. "Peak Memory Usage": 24,
  21. "Disk Usage": 0,
  22. "Plans": [
  23. {
  24. "Node Type": "Nested Loop",
  25. "Parent Relationship": "Outer",
  26. "Parallel Aware": false,
  27. "Async Capable": false,
  28. "Join Type": "Left",
  29. "Startup Cost": 143.51,
  30. "Total Cost": 178.07,
  31. "Plan Rows": 85,
  32. "Plan Width": 34,
  33. "Actual Startup Time": 8.952,
  34. "Actual Total Time": 28.547,
  35. "Actual Rows": 26491,
  36. "Actual Loops": 1,
  37. "Inner Unique": false,
  38. "Plans": [
  39. {
  40. "Node Type": "Nested Loop",
  41. "Parent Relationship": "Outer",
  42. "Parallel Aware": false,
  43. "Async Capable": false,
  44. "Join Type": "Inner",
  45. "Startup Cost": 135.86,
  46. "Total Cost": 162.62,
  47. "Plan Rows": 2,
  48. "Plan Width": 33,
  49. "Actual Startup Time": 8.862,
  50. "Actual Total Time": 11.426,
  51. "Actual Rows": 339,
  52. "Actual Loops": 1,
  53. "Inner Unique": true,
  54. "Join Filter": "((prompts_evaluation.datetime = temp.max) AND ((prompts_evaluation.ai_model)::text = (temp.ai_model)::text))",
  55. "Rows Removed by Join Filter": 564,
  56. "Plans": [
  57. {
  58. "Node Type": "Nested Loop",
  59. "Parent Relationship": "Outer",
  60. "Parallel Aware": false,
  61. "Async Capable": false,
  62. "Join Type": "Inner",
  63. "Startup Cost": 135.57,
  64. "Total Cost": 147.42,
  65. "Plan Rows": 2,
  66. "Plan Width": 41,
  67. "Actual Startup Time": 8.851,
  68. "Actual Total Time": 9.958,
  69. "Actual Rows": 339,
  70. "Actual Loops": 1,
  71. "Inner Unique": false,
  72. "Plans": [
  73. {
  74. "Node Type": "Nested Loop",
  75. "Parent Relationship": "Outer",
  76. "Parallel Aware": false,
  77. "Async Capable": false,
  78. "Join Type": "Inner",
  79. "Startup Cost": 135.43,
  80. "Total Cost": 146.96,
  81. "Plan Rows": 1,
  82. "Plan Width": 41,
  83. "Actual Startup Time": 8.844,
  84. "Actual Total Time": 9.172,
  85. "Actual Rows": 117,
  86. "Actual Loops": 1,
  87. "Inner Unique": false,
  88. "Plans": [
  89. {
  90. "Node Type": "Nested Loop",
  91. "Parent Relationship": "Outer",
  92. "Parallel Aware": false,
  93. "Async Capable": false,
  94. "Join Type": "Inner",
  95. "Startup Cost": 135.27,
  96. "Total Cost": 138.78,
  97. "Plan Rows": 1,
  98. "Plan Width": 49,
  99. "Actual Startup Time": 8.828,
  100. "Actual Total Time": 8.950,
  101. "Actual Rows": 117,
  102. "Actual Loops": 1,
  103. "Inner Unique": false,
  104. "Join Filter": "(prompt_sets_conversation.prompt_set_id = prompt_sets_promptset.id)",
  105. "Rows Removed by Join Filter": 345,
  106. "Plans": [
  107. {
  108. "Node Type": "Merge Join",
  109. "Parent Relationship": "Outer",
  110. "Parallel Aware": false,
  111. "Async Capable": false,
  112. "Join Type": "Inner",
  113. "Startup Cost": 135.27,
  114. "Total Cost": 135.31,
  115. "Plan Rows": 1,
  116. "Plan Width": 49,
  117. "Actual Startup Time": 8.799,
  118. "Actual Total Time": 8.815,
  119. "Actual Rows": 3,
  120. "Actual Loops": 1,
  121. "Inner Unique": false,
  122. "Merge Cond": "(prompt_sets_promptset.id = temp.id)",
  123. "Plans": [
  124. {
  125. "Node Type": "Sort",
  126. "Parent Relationship": "Outer",
  127. "Parallel Aware": false,
  128. "Async Capable": false,
  129. "Startup Cost": 1.31,
  130. "Total Cost": 1.31,
  131. "Plan Rows": 1,
  132. "Plan Width": 25,
  133. "Actual Startup Time": 0.027,
  134. "Actual Total Time": 0.028,
  135. "Actual Rows": 1,
  136. "Actual Loops": 1,
  137. "Sort Key": ["prompt_sets_promptset.id"],
  138. "Sort Method": "quicksort",
  139. "Sort Space Used": 25,
  140. "Sort Space Type": "Memory",
  141. "Plans": [
  142. {
  143. "Node Type": "Seq Scan",
  144. "Parent Relationship": "Outer",
  145. "Parallel Aware": false,
  146. "Async Capable": false,
  147. "Relation Name": "prompt_sets_promptset",
  148. "Alias": "prompt_sets_promptset",
  149. "Startup Cost": 0.00,
  150. "Total Cost": 1.30,
  151. "Plan Rows": 1,
  152. "Plan Width": 25,
  153. "Actual Startup Time": 0.019,
  154. "Actual Total Time": 0.022,
  155. "Actual Rows": 1,
  156. "Actual Loops": 1,
  157. "Filter": "(project_id = 17)",
  158. "Rows Removed by Filter": 29
  159. }
  160. ]
  161. },
  162. {
  163. "Node Type": "Sort",
  164. "Parent Relationship": "Inner",
  165. "Parallel Aware": false,
  166. "Async Capable": false,
  167. "Startup Cost": 133.96,
  168. "Total Cost": 133.97,
  169. "Plan Rows": 3,
  170. "Plan Width": 24,
  171. "Actual Startup Time": 8.767,
  172. "Actual Total Time": 8.775,
  173. "Actual Rows": 3,
  174. "Actual Loops": 1,
  175. "Sort Key": ["temp.id"],
  176. "Sort Method": "quicksort",
  177. "Sort Space Used": 25,
  178. "Sort Space Type": "Memory",
  179. "Plans": [
  180. {
  181. "Node Type": "Subquery Scan",
  182. "Parent Relationship": "Outer",
  183. "Parallel Aware": false,
  184. "Async Capable": false,
  185. "Alias": "temp",
  186. "Startup Cost": 133.88,
  187. "Total Cost": 133.94,
  188. "Plan Rows": 3,
  189. "Plan Width": 24,
  190. "Actual Startup Time": 8.759,
  191. "Actual Total Time": 8.766,
  192. "Actual Rows": 3,
  193. "Actual Loops": 1,
  194. "Plans": [
  195. {
  196. "Node Type": "Aggregate",
  197. "Strategy": "Hashed",
  198. "Partial Mode": "Simple",
  199. "Parent Relationship": "Subquery",
  200. "Parallel Aware": false,
  201. "Async Capable": false,
  202. "Startup Cost": 133.88,
  203. "Total Cost": 133.91,
  204. "Plan Rows": 3,
  205. "Plan Width": 24,
  206. "Actual Startup Time": 8.759,
  207. "Actual Total Time": 8.764,
  208. "Actual Rows": 3,
  209. "Actual Loops": 1,
  210. "Group Key": ["prompt_sets_promptset_1.id", "prompts_evaluation_1.ai_model"],
  211. "Planned Partitions": 0,
  212. "HashAgg Batches": 1,
  213. "Peak Memory Usage": 24,
  214. "Disk Usage": 0,
  215. "Plans": [
  216. {
  217. "Node Type": "Nested Loop",
  218. "Parent Relationship": "Outer",
  219. "Parallel Aware": false,
  220. "Async Capable": false,
  221. "Join Type": "Inner",
  222. "Startup Cost": 9.93,
  223. "Total Cost": 122.19,
  224. "Plan Rows": 1559,
  225. "Plan Width": 24,
  226. "Actual Startup Time": 0.058,
  227. "Actual Total Time": 5.403,
  228. "Actual Rows": 11639,
  229. "Actual Loops": 1,
  230. "Inner Unique": false,
  231. "Plans": [
  232. {
  233. "Node Type": "Nested Loop",
  234. "Parent Relationship": "Outer",
  235. "Parallel Aware": false,
  236. "Async Capable": false,
  237. "Join Type": "Inner",
  238. "Startup Cost": 9.64,
  239. "Total Cost": 15.72,
  240. "Plan Rows": 15,
  241. "Plan Width": 16,
  242. "Actual Startup Time": 0.050,
  243. "Actual Total Time": 0.169,
  244. "Actual Rows": 113,
  245. "Actual Loops": 1,
  246. "Inner Unique": false,
  247. "Plans": [
  248. {
  249. "Node Type": "Nested Loop",
  250. "Parent Relationship": "Outer",
  251. "Parallel Aware": false,
  252. "Async Capable": false,
  253. "Join Type": "Inner",
  254. "Startup Cost": 9.49,
  255. "Total Cost": 12.98,
  256. "Plan Rows": 6,
  257. "Plan Width": 16,
  258. "Actual Startup Time": 0.044,
  259. "Actual Total Time": 0.067,
  260. "Actual Rows": 39,
  261. "Actual Loops": 1,
  262. "Inner Unique": false,
  263. "Join Filter": "(prompt_sets_conversation_1.prompt_set_id = prompt_sets_promptset_1.id)",
  264. "Rows Removed by Join Filter": 115,
  265. "Plans": [
  266. {
  267. "Node Type": "Limit",
  268. "Parent Relationship": "Outer",
  269. "Parallel Aware": false,
  270. "Async Capable": false,
  271. "Startup Cost": 9.49,
  272. "Total Cost": 9.50,
  273. "Plan Rows": 1,
  274. "Plan Width": 49,
  275. "Actual Startup Time": 0.023,
  276. "Actual Total Time": 0.027,
  277. "Actual Rows": 1,
  278. "Actual Loops": 1,
  279. "Plans": [
  280. {
  281. "Node Type": "Sort",
  282. "Parent Relationship": "Outer",
  283. "Parallel Aware": false,
  284. "Async Capable": false,
  285. "Startup Cost": 9.49,
  286. "Total Cost": 9.50,
  287. "Plan Rows": 1,
  288. "Plan Width": 49,
  289. "Actual Startup Time": 0.023,
  290. "Actual Total Time": 0.025,
  291. "Actual Rows": 1,
  292. "Actual Loops": 1,
  293. "Sort Key": ["prompt_sets_promptset_1.id"],
  294. "Sort Method": "quicksort",
  295. "Sort Space Used": 25,
  296. "Sort Space Type": "Memory",
  297. "Plans": [
  298. {
  299. "Node Type": "Nested Loop",
  300. "Parent Relationship": "Outer",
  301. "Parallel Aware": false,
  302. "Async Capable": false,
  303. "Join Type": "Inner",
  304. "Startup Cost": 0.15,
  305. "Total Cost": 9.48,
  306. "Plan Rows": 1,
  307. "Plan Width": 49,
  308. "Actual Startup Time": 0.015,
  309. "Actual Total Time": 0.020,
  310. "Actual Rows": 1,
  311. "Actual Loops": 1,
  312. "Inner Unique": false,
  313. "Plans": [
  314. {
  315. "Node Type": "Seq Scan",
  316. "Parent Relationship": "Outer",
  317. "Parallel Aware": false,
  318. "Async Capable": false,
  319. "Relation Name": "prompt_sets_promptset",
  320. "Alias": "prompt_sets_promptset_1",
  321. "Startup Cost": 0.00,
  322. "Total Cost": 1.30,
  323. "Plan Rows": 1,
  324. "Plan Width": 16,
  325. "Actual Startup Time": 0.003,
  326. "Actual Total Time": 0.006,
  327. "Actual Rows": 1,
  328. "Actual Loops": 1,
  329. "Filter": "(project_id = 17)",
  330. "Rows Removed by Filter": 29
  331. },
  332. {
  333. "Node Type": "Index Only Scan",
  334. "Parent Relationship": "Inner",
  335. "Parallel Aware": false,
  336. "Async Capable": false,
  337. "Scan Direction": "Forward",
  338. "Index Name": "projects_project_pkey",
  339. "Relation Name": "projects_project",
  340. "Alias": "projects_project_1",
  341. "Startup Cost": 0.15,
  342. "Total Cost": 8.17,
  343. "Plan Rows": 1,
  344. "Plan Width": 8,
  345. "Actual Startup Time": 0.010,
  346. "Actual Total Time": 0.011,
  347. "Actual Rows": 1,
  348. "Actual Loops": 1,
  349. "Index Cond": "(id = 17)",
  350. "Rows Removed by Index Recheck": 0,
  351. "Heap Fetches": 1
  352. }
  353. ]
  354. }
  355. ]
  356. }
  357. ]
  358. },
  359. {
  360. "Node Type": "Seq Scan",
  361. "Parent Relationship": "Inner",
  362. "Parallel Aware": false,
  363. "Async Capable": false,
  364. "Relation Name": "prompt_sets_conversation",
  365. "Alias": "prompt_sets_conversation_1",
  366. "Startup Cost": 0.00,
  367. "Total Cost": 2.10,
  368. "Plan Rows": 110,
  369. "Plan Width": 16,
  370. "Actual Startup Time": 0.006,
  371. "Actual Total Time": 0.019,
  372. "Actual Rows": 154,
  373. "Actual Loops": 1
  374. }
  375. ]
  376. },
  377. {
  378. "Node Type": "Index Scan",
  379. "Parent Relationship": "Inner",
  380. "Parallel Aware": false,
  381. "Async Capable": false,
  382. "Scan Direction": "Forward",
  383. "Index Name": "prompts_prompt_conversation_id_62eb4525",
  384. "Relation Name": "prompts_prompt",
  385. "Alias": "prompts_prompt_1",
  386. "Startup Cost": 0.15,
  387. "Total Cost": 0.44,
  388. "Plan Rows": 2,
  389. "Plan Width": 16,
  390. "Actual Startup Time": 0.001,
  391. "Actual Total Time": 0.002,
  392. "Actual Rows": 3,
  393. "Actual Loops": 39,
  394. "Index Cond": "(conversation_id = prompt_sets_conversation_1.id)",
  395. "Rows Removed by Index Recheck": 0
  396. }
  397. ]
  398. },
  399. {
  400. "Node Type": "Index Scan",
  401. "Parent Relationship": "Inner",
  402. "Parallel Aware": false,
  403. "Async Capable": false,
  404. "Scan Direction": "Forward",
  405. "Index Name": "prompts_evaluation_prompt_id_ad202430",
  406. "Relation Name": "prompts_evaluation",
  407. "Alias": "prompts_evaluation_1",
  408. "Startup Cost": 0.29,
  409. "Total Cost": 6.10,
  410. "Plan Rows": 100,
  411. "Plan Width": 24,
  412. "Actual Startup Time": 0.004,
  413. "Actual Total Time": 0.035,
  414. "Actual Rows": 103,
  415. "Actual Loops": 113,
  416. "Index Cond": "(prompt_id = prompts_prompt_1.id)",
  417. "Rows Removed by Index Recheck": 0
  418. }
  419. ]
  420. }
  421. ]
  422. }
  423. ]
  424. }
  425. ]
  426. }
  427. ]
  428. },
  429. {
  430. "Node Type": "Seq Scan",
  431. "Parent Relationship": "Inner",
  432. "Parallel Aware": false,
  433. "Async Capable": false,
  434. "Relation Name": "prompt_sets_conversation",
  435. "Alias": "prompt_sets_conversation",
  436. "Startup Cost": 0.00,
  437. "Total Cost": 2.10,
  438. "Plan Rows": 110,
  439. "Plan Width": 16,
  440. "Actual Startup Time": 0.008,
  441. "Actual Total Time": 0.021,
  442. "Actual Rows": 154,
  443. "Actual Loops": 3
  444. }
  445. ]
  446. },
  447. {
  448. "Node Type": "Index Scan",
  449. "Parent Relationship": "Inner",
  450. "Parallel Aware": false,
  451. "Async Capable": false,
  452. "Scan Direction": "Forward",
  453. "Index Name": "projects_project_pkey",
  454. "Relation Name": "projects_project",
  455. "Alias": "projects_project",
  456. "Startup Cost": 0.15,
  457. "Total Cost": 8.17,
  458. "Plan Rows": 1,
  459. "Plan Width": 8,
  460. "Actual Startup Time": 0.001,
  461. "Actual Total Time": 0.002,
  462. "Actual Rows": 1,
  463. "Actual Loops": 117,
  464. "Index Cond": "(id = 17)",
  465. "Rows Removed by Index Recheck": 0,
  466. "Filter": "(user_id = 15)",
  467. "Rows Removed by Filter": 0
  468. }
  469. ]
  470. },
  471. {
  472. "Node Type": "Index Scan",
  473. "Parent Relationship": "Inner",
  474. "Parallel Aware": false,
  475. "Async Capable": false,
  476. "Scan Direction": "Forward",
  477. "Index Name": "prompts_prompt_conversation_id_62eb4525",
  478. "Relation Name": "prompts_prompt",
  479. "Alias": "prompts_prompt",
  480. "Startup Cost": 0.15,
  481. "Total Cost": 0.44,
  482. "Plan Rows": 2,
  483. "Plan Width": 16,
  484. "Actual Startup Time": 0.001,
  485. "Actual Total Time": 0.002,
  486. "Actual Rows": 3,
  487. "Actual Loops": 117,
  488. "Index Cond": "(conversation_id = prompt_sets_conversation.id)",
  489. "Rows Removed by Index Recheck": 0
  490. }
  491. ]
  492. },
  493. {
  494. "Node Type": "Index Scan",
  495. "Parent Relationship": "Inner",
  496. "Parallel Aware": false,
  497. "Async Capable": false,
  498. "Scan Direction": "Forward",
  499. "Index Name": "prompts_evaluation_prompt_id_ad202430",
  500. "Relation Name": "prompts_evaluation",
  501. "Alias": "prompts_evaluation",
  502. "Startup Cost": 0.29,
  503. "Total Cost": 6.10,
  504. "Plan Rows": 100,
  505. "Plan Width": 32,
  506. "Actual Startup Time": 0.003,
  507. "Actual Total Time": 0.004,
  508. "Actual Rows": 3,
  509. "Actual Loops": 339,
  510. "Index Cond": "(prompt_id = prompts_prompt.id)",
  511. "Rows Removed by Index Recheck": 0
  512. }
  513. ]
  514. },
  515. {
  516. "Node Type": "Hash Join",
  517. "Parent Relationship": "Inner",
  518. "Parallel Aware": false,
  519. "Async Capable": false,
  520. "Join Type": "Left",
  521. "Startup Cost": 7.65,
  522. "Total Cost": 10.72,
  523. "Plan Rows": 83,
  524. "Plan Width": 17,
  525. "Actual Startup Time": 0.004,
  526. "Actual Total Time": 0.041,
  527. "Actual Rows": 78,
  528. "Actual Loops": 339,
  529. "Inner Unique": true,
  530. "Hash Cond": "(prompts_evaluationcount.brand_id = projects_brand.id)",
  531. "Plans": [
  532. {
  533. "Node Type": "Index Scan",
  534. "Parent Relationship": "Outer",
  535. "Parallel Aware": false,
  536. "Async Capable": false,
  537. "Scan Direction": "Forward",
  538. "Index Name": "prompts_evaluationcount_evaluation_id_81fb29cd",
  539. "Relation Name": "prompts_evaluationcount",
  540. "Alias": "prompts_evaluationcount",
  541. "Startup Cost": 0.43,
  542. "Total Cost": 3.27,
  543. "Plan Rows": 83,
  544. "Plan Width": 24,
  545. "Actual Startup Time": 0.003,
  546. "Actual Total Time": 0.021,
  547. "Actual Rows": 78,
  548. "Actual Loops": 339,
  549. "Index Cond": "(evaluation_id = prompts_evaluation.id)",
  550. "Rows Removed by Index Recheck": 0
  551. },
  552. {
  553. "Node Type": "Hash",
  554. "Parent Relationship": "Inner",
  555. "Parallel Aware": false,
  556. "Async Capable": false,
  557. "Startup Cost": 5.43,
  558. "Total Cost": 5.43,
  559. "Plan Rows": 143,
  560. "Plan Width": 9,
  561. "Actual Startup Time": 0.060,
  562. "Actual Total Time": 0.061,
  563. "Actual Rows": 143,
  564. "Actual Loops": 1,
  565. "Hash Buckets": 1024,
  566. "Original Hash Buckets": 1024,
  567. "Hash Batches": 1,
  568. "Original Hash Batches": 1,
  569. "Peak Memory Usage": 15,
  570. "Plans": [
  571. {
  572. "Node Type": "Seq Scan",
  573. "Parent Relationship": "Outer",
  574. "Parallel Aware": false,
  575. "Async Capable": false,
  576. "Relation Name": "projects_brand",
  577. "Alias": "projects_brand",
  578. "Startup Cost": 0.00,
  579. "Total Cost": 5.43,
  580. "Plan Rows": 143,
  581. "Plan Width": 9,
  582. "Actual Startup Time": 0.007,
  583. "Actual Total Time": 0.034,
  584. "Actual Rows": 143,
  585. "Actual Loops": 1
  586. }
  587. ]
  588. }
  589. ]
  590. }
  591. ]
  592. }
  593. ]
  594. },
  595. "Planning Time": 4.859,
  596. "Triggers": [
  597. ],
  598. "Execution Time": 39.719
  599. }
  600. ]
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!