explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hXxp

Settings
# exclusive inclusive rows x rows loops node
1. 2.887 76,931.958 ↓ 1,554.0 1,554 1

Sort (cost=5,068.72..5,068.73 rows=1 width=73) (actual time=76,931.830..76,931.958 rows=1,554 loops=1)

  • Sort Key: tp.syscol_rownumber
  • Sort Method: quicksort Memory: 170kB
2.          

CTE tp

3. 1.593 71.555 ↓ 1,554.0 1,554 1

WindowAgg (cost=4,996.16..4,996.19 rows=1 width=284) (actual time=69.559..71.555 rows=1,554 loops=1)

4. 2.636 69.962 ↓ 1,554.0 1,554 1

Sort (cost=4,996.16..4,996.16 rows=1 width=280) (actual time=69.548..69.962 rows=1,554 loops=1)

  • Sort Key: t_1.id
  • Sort Method: quicksort Memory: 382kB
5. 2.388 67.326 ↓ 1,554.0 1,554 1

Hash Left Join (cost=4,425.24..4,996.15 rows=1 width=280) (actual time=42.370..67.326 rows=1,554 loops=1)

  • Hash Cond: (t18.id_order = p.itemid)
  • Filter: ((COALESCE(((7 | p.allowed) & (~ (0 | p.denied))), 7) & 1) = 1)
6. 1.513 30.505 ↓ 310.8 1,554 1

Nested Loop Left Join (cost=95.90..663.47 rows=5 width=176) (actual time=7.884..30.505 rows=1,554 loops=1)

7. 0.492 24.330 ↓ 310.8 1,554 1

Nested Loop Left Join (cost=95.62..661.37 rows=5 width=176) (actual time=7.876..24.330 rows=1,554 loops=1)

8. 1.613 17.622 ↓ 310.8 1,554 1

Hash Join (cost=95.33..659.29 rows=5 width=176) (actual time=7.864..17.622 rows=1,554 loops=1)

  • Hash Cond: (t_1.id_order_vehicle = t8_1.id)
9. 6.736 8.280 ↑ 1.0 5,698 1

Hash Left Join (cost=1.56..544.10 rows=5,698 width=128) (actual time=0.058..8.280 rows=5,698 loops=1)

  • Hash Cond: (t_1.editor = (t1_1.login)::text)
10. 1.512 1.512 ↑ 1.0 5,698 1

Seq Scan on ord_order_vehicle_calc_supp t_1 (cost=0.00..496.98 rows=5,698 width=325) (actual time=0.015..1.512 rows=5,698 loops=1)

11. 0.017 0.032 ↑ 1.0 25 1

Hash (cost=1.25..1.25 rows=25 width=32) (actual time=0.032..0.032 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
12. 0.015 0.015 ↑ 1.0 25 1

Seq Scan on profile t1_1 (cost=0.00..1.25 rows=25 width=32) (actual time=0.009..0.015 rows=25 loops=1)

13. 0.672 7.729 ↓ 519.0 1,557 1

Hash (cost=93.73..93.73 rows=3 width=64) (actual time=7.729..7.729 rows=1,557 loops=1)

  • Buckets: 2048 (originally 1024) Batches: 1 (originally 1) Memory Usage: 162kB
14. 0.423 7.057 ↓ 519.0 1,557 1

Nested Loop (cost=4.78..93.73 rows=3 width=64) (actual time=3.844..7.057 rows=1,557 loops=1)

15. 0.081 5.581 ↓ 81.0 81 1

Nested Loop Left Join (cost=4.50..93.02 rows=1 width=48) (actual time=3.834..5.581 rows=81 loops=1)

16. 0.039 5.338 ↓ 81.0 81 1

Nested Loop (cost=4.36..92.85 rows=1 width=48) (actual time=3.826..5.338 rows=81 loops=1)

17. 5.211 5.211 ↑ 1.0 1 1

Seq Scan on crm_agent t10 (cost=0.00..61.17 rows=1 width=16) (actual time=3.779..5.211 rows=1 loops=1)

  • Filter: (name ~~* '%модуль%'::text)
  • Rows Removed by Filter: 1213
18. 0.061 0.088 ↓ 8.1 81 1

Bitmap Heap Scan on ord_order t9_1 (cost=4.36..31.57 rows=10 width=80) (actual time=0.038..0.088 rows=81 loops=1)

  • Recheck Cond: (id_agent = t10.id)
  • Heap Blocks: exact=20
19. 0.027 0.027 ↓ 8.1 81 1

Bitmap Index Scan on ix_ord_order_id_agent (cost=0.00..4.35 rows=10 width=0) (actual time=0.027..0.027 rows=81 loops=1)

  • Index Cond: (id_agent = t10.id)
20. 0.162 0.162 ↑ 1.0 1 81

Index Scan using pk_com_employee on com_employee t13_1 (cost=0.14..0.17 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=81)

  • Index Cond: (id = t9_1.id_responsible)
21. 1.053 1.053 ↓ 6.3 19 81

Index Scan using ix_ord_order_vehicle_id_order on ord_order_vehicle t8_1 (cost=0.28..0.68 rows=3 width=48) (actual time=0.004..0.013 rows=19 loops=81)

  • Index Cond: (id_order = t9_1.id)
22. 6.216 6.216 ↑ 1.0 1 1,554

Index Scan using pk_ord_order_vehicle_oper on ord_order_vehicle_oper t16 (cost=0.28..0.41 rows=1 width=48) (actual time=0.003..0.004 rows=1 loops=1,554)

  • Index Cond: (id = t_1.id_order_vehicle_oper)
23. 4.662 4.662 ↑ 1.0 1 1,554

Index Scan using pk_ord_order_vehicle on ord_order_vehicle t18 (cost=0.28..0.41 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=1,554)

  • Index Cond: (id = t16.id_order_vehicle)
24. 0.554 34.433 ↑ 2.5 1,881 1

Hash (cost=4,271.57..4,271.57 rows=4,622 width=24) (actual time=34.433..34.433 rows=1,881 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 167kB
25. 0.309 33.879 ↑ 2.5 1,881 1

Subquery Scan on p (cost=4,179.13..4,271.57 rows=4,622 width=24) (actual time=33.052..33.879 rows=1,881 loops=1)

26. 2.498 33.570 ↑ 2.5 1,881 1

HashAggregate (cost=4,179.13..4,225.35 rows=4,622 width=24) (actual time=33.050..33.570 rows=1,881 loops=1)

  • Group Key: p_1.itemid
27. 1.174 31.072 ↑ 8.0 2,886 1

Merge Join (cost=3,417.24..3,889.94 rows=23,135 width=32) (actual time=29.344..31.072 rows=2,886 loops=1)

  • Merge Cond: ((lower((s.id)::text)) = (lower((p_1.accountid)::text)))
28. 1.698 4.910 ↑ 5.2 191 1

Sort (cost=60.08..62.58 rows=1,000 width=40) (actual time=4.875..4.910 rows=191 loops=1)

  • Sort Key: (lower((s.id)::text))
  • Sort Method: quicksort Memory: 64kB
29. 3.212 3.212 ↑ 5.2 191 1

Function Scan on sessionaccount s (cost=0.25..10.25 rows=1,000 width=40) (actual time=2.319..3.212 rows=191 loops=1)

30. 7.859 24.988 ↑ 1.6 2,889 1

Sort (cost=3,357.16..3,368.73 rows=4,627 width=46) (actual time=24.461..24.988 rows=2,889 loops=1)

  • Sort Key: (lower((p_1.accountid)::text))
  • Sort Method: quicksort Memory: 838kB
31. 16.093 17.129 ↑ 1.0 4,588 1

Bitmap Heap Scan on itempermission p_1 (cost=252.28..3,075.47 rows=4,627 width=46) (actual time=1.363..17.129 rows=4,588 loops=1)

  • Recheck Cond: (entityname = 'trlog.ord_order'::text)
  • Heap Blocks: exact=1405
32. 1.036 1.036 ↑ 1.0 4,588 1

Bitmap Index Scan on pk_itempermission (cost=0.00..251.12 rows=4,627 width=0) (actual time=1.036..1.036 rows=4,588 loops=1)

  • Index Cond: (entityname = 'trlog.ord_order'::text)
33.          

CTE t2

34. 0.116 8.805 ↓ 112.0 112 1

Group (cost=8.33..8.34 rows=1 width=16) (actual time=8.565..8.805 rows=112 loops=1)

  • Group Key: t2_1.id
35. 0.737 8.689 ↓ 921.0 921 1

Sort (cost=8.33..8.34 rows=1 width=16) (actual time=8.564..8.689 rows=921 loops=1)

  • Sort Key: t2_1.id
  • Sort Method: quicksort Memory: 68kB
36. 0.865 7.952 ↓ 921.0 921 1

Nested Loop (cost=0.28..8.32 rows=1 width=16) (actual time=0.028..7.952 rows=921 loops=1)

37. 3.979 3.979 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_1 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..3.979 rows=1,554 loops=1)

38. 3.108 3.108 ↑ 1.0 1 1,554

Index Only Scan using pk_act_supp on act_supp t2_1 (cost=0.28..8.29 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,554)

  • Index Cond: (id = tp_1.id_act_supp_prep)
  • Heap Fetches: 921
39.          

CTE t4

40. 0.084 1.327 ↑ 1.0 1 1

Group (cost=1.26..1.27 rows=1 width=16) (actual time=1.144..1.327 rows=1 loops=1)

  • Group Key: t4_1.id
41. 0.348 1.243 ↓ 915.0 915 1

Sort (cost=1.26..1.26 rows=1 width=16) (actual time=1.143..1.243 rows=915 loops=1)

  • Sort Key: t4_1.id
  • Sort Method: quicksort Memory: 67kB
42. 0.190 0.895 ↓ 915.0 915 1

Hash Join (cost=0.03..1.25 rows=1 width=16) (actual time=0.720..0.895 rows=915 loops=1)

  • Hash Cond: (t4_1.id = tp_2.id_fin_report_f)
43. 0.015 0.015 ↑ 1.0 15 1

Seq Scan on ord_fin_report t4_1 (cost=0.00..1.15 rows=15 width=16) (actual time=0.012..0.015 rows=15 loops=1)

44. 0.261 0.690 ↓ 915.0 915 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.690..0.690 rows=915 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
45. 0.429 0.429 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.429 rows=1,554 loops=1)

46.          

CTE t5

47. 0.083 1.303 ↑ 1.0 1 1

Group (cost=1.26..1.27 rows=1 width=16) (actual time=1.120..1.303 rows=1 loops=1)

  • Group Key: t5_1.id
48. 0.349 1.220 ↓ 919.0 919 1

Sort (cost=1.26..1.26 rows=1 width=16) (actual time=1.119..1.220 rows=919 loops=1)

  • Sort Key: t5_1.id
  • Sort Method: quicksort Memory: 68kB
49. 0.190 0.871 ↓ 919.0 919 1

Hash Join (cost=0.03..1.25 rows=1 width=16) (actual time=0.694..0.871 rows=919 loops=1)

  • Hash Cond: (t5_1.id = tp_3.id_fin_report_p)
50. 0.011 0.011 ↑ 1.0 15 1

Seq Scan on ord_fin_report t5_1 (cost=0.00..1.15 rows=15 width=16) (actual time=0.008..0.011 rows=15 loops=1)

51. 0.263 0.670 ↓ 919.0 919 1

Hash (cost=0.02..0.02 rows=1 width=16) (actual time=0.669..0.670 rows=919 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 52kB
52. 0.407 0.407 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_3 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.407 rows=1,554 loops=1)

53.          

CTE t6

54. 0.123 4.795 ↓ 176.0 176 1

Group (cost=8.33..8.34 rows=1 width=16) (actual time=4.564..4.795 rows=176 loops=1)

  • Group Key: t6_1.id
55. 0.705 4.672 ↓ 921.0 921 1

Sort (cost=8.33..8.34 rows=1 width=16) (actual time=4.563..4.672 rows=921 loops=1)

  • Sort Key: t6_1.id
  • Sort Method: quicksort Memory: 68kB
56. 0.516 3.967 ↓ 921.0 921 1

Nested Loop (cost=0.28..8.32 rows=1 width=16) (actual time=0.018..3.967 rows=921 loops=1)

57. 0.343 0.343 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_4 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.343 rows=1,554 loops=1)

58. 3.108 3.108 ↑ 1.0 1 1,554

Index Only Scan using pk_inv_cust on inv_cust t6_1 (cost=0.28..8.29 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,554)

  • Index Cond: (id = tp_4.id_inv_cust)
  • Heap Fetches: 921
59.          

CTE t7

60. 0.264 5.374 ↓ 915.0 915 1

Group (cost=8.34..8.35 rows=1 width=16) (actual time=4.954..5.374 rows=915 loops=1)

  • Group Key: t7_1.id
61. 0.757 5.110 ↓ 915.0 915 1

Sort (cost=8.34..8.35 rows=1 width=16) (actual time=4.953..5.110 rows=915 loops=1)

  • Sort Key: t7_1.id
  • Sort Method: quicksort Memory: 67kB
62. 0.886 4.353 ↓ 915.0 915 1

Nested Loop (cost=0.28..8.33 rows=1 width=16) (actual time=0.014..4.353 rows=915 loops=1)

63. 0.359 0.359 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_5 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.359 rows=1,554 loops=1)

64. 3.108 3.108 ↑ 1.0 1 1,554

Index Only Scan using pk_ord_order_vehicle_calc_cust on ord_order_vehicle_calc_cust t7_1 (cost=0.28..8.30 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,554)

  • Index Cond: (id = tp_5.id_ord_order_vehicle_calc_cust)
  • Heap Fetches: 915
65.          

CTE t8

66. 0.529 8.688 ↓ 1,554.0 1,554 1

Group (cost=8.34..8.34 rows=1 width=48) (actual time=7.747..8.688 rows=1,554 loops=1)

  • Group Key: t8_2.id
67. 1.697 8.159 ↓ 1,554.0 1,554 1

Sort (cost=8.34..8.34 rows=1 width=48) (actual time=7.746..8.159 rows=1,554 loops=1)

  • Sort Key: t8_2.id
  • Sort Method: quicksort Memory: 170kB
68. 1.434 6.462 ↓ 1,554.0 1,554 1

Nested Loop (cost=0.28..8.33 rows=1 width=48) (actual time=0.011..6.462 rows=1,554 loops=1)

69. 0.366 0.366 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_6 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.366 rows=1,554 loops=1)

70. 4.662 4.662 ↑ 1.0 1 1,554

Index Scan using pk_ord_order_vehicle on ord_order_vehicle t8_2 (cost=0.28..8.30 rows=1 width=48) (actual time=0.003..0.003 rows=1 loops=1,554)

  • Index Cond: (id = tp_6.id_order_vehicle)
71.          

CTE t9

72. 0.168 7.806 ↓ 78.0 78 1

Group (cost=8.33..8.34 rows=1 width=80) (actual time=7.452..7.806 rows=78 loops=1)

  • Group Key: t9_2.id
73. 1.401 7.638 ↓ 1,554.0 1,554 1

Sort (cost=8.33..8.34 rows=1 width=80) (actual time=7.450..7.638 rows=1,554 loops=1)

  • Sort Key: t9_2.id
  • Sort Method: quicksort Memory: 267kB
74. 1.219 6.237 ↓ 1,554.0 1,554 1

Nested Loop (cost=0.28..8.32 rows=1 width=80) (actual time=0.011..6.237 rows=1,554 loops=1)

75. 0.356 0.356 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_7 (cost=0.00..0.02 rows=1 width=16) (actual time=0.000..0.356 rows=1,554 loops=1)

76. 4.662 4.662 ↑ 1.0 1 1,554

Index Scan using pk_ord_order on ord_order t9_2 (cost=0.28..8.29 rows=1 width=80) (actual time=0.003..0.003 rows=1 loops=1,554)

  • Index Cond: (id = tp_7.id_order)
77.          

CTE t12

78. 0.117 6.914 ↓ 2.0 2 1

Group (cost=8.33..8.34 rows=1 width=16) (actual time=6.651..6.914 rows=2 loops=1)

  • Group Key: t12_1.id
79. 0.952 6.797 ↓ 1,554.0 1,554 1

Sort (cost=8.33..8.34 rows=1 width=16) (actual time=6.650..6.797 rows=1,554 loops=1)

  • Sort Key: t12_1.id
  • Sort Method: quicksort Memory: 121kB
80. 0.829 5.845 ↓ 1,554.0 1,554 1

Nested Loop (cost=0.28..8.32 rows=1 width=16) (actual time=0.016..5.845 rows=1,554 loops=1)

81. 0.354 0.354 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_8 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.354 rows=1,554 loops=1)

82. 4.662 4.662 ↑ 1.0 1 1,554

Index Only Scan using pk_crm_contract on crm_contract t12_1 (cost=0.28..8.29 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,554)

  • Index Cond: (id = tp_8.id_contract)
  • Heap Fetches: 1554
83.          

CTE t14

84. 0.118 6.286 ↓ 2.0 2 1

Group (cost=8.33..8.34 rows=1 width=16) (actual time=6.024..6.286 rows=2 loops=1)

  • Group Key: t14_1.id
85. 0.834 6.168 ↓ 1,554.0 1,554 1

Sort (cost=8.33..8.34 rows=1 width=16) (actual time=6.023..6.168 rows=1,554 loops=1)

  • Sort Key: t14_1.id
  • Sort Method: quicksort Memory: 121kB
86. 0.331 5.334 ↓ 1,554.0 1,554 1

Nested Loop (cost=0.28..8.32 rows=1 width=16) (actual time=0.014..5.334 rows=1,554 loops=1)

87. 0.341 0.341 ↓ 1,554.0 1,554 1

CTE Scan on tp tp_9 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.341 rows=1,554 loops=1)

88. 4.662 4.662 ↑ 1.0 1 1,554

Index Only Scan using pk_crm_contact on crm_contact t14_1 (cost=0.28..8.29 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=1,554)

  • Index Cond: (id = tp_9.id_contact)
  • Heap Fetches: 1554
89. 1.752 76,929.071 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.35..11.59 rows=1 width=73) (actual time=129.257..76,929.071 rows=1,554 loops=1)

  • Join Filter: (t14.id = t13.id_contact)
  • Rows Removed by Join Filter: 1554
90. 0.927 76,921.103 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.35..11.56 rows=1 width=89) (actual time=123.226..76,921.103 rows=1,554 loops=1)

  • Join Filter: (t12.id = t9.id_contract_1)
  • Rows Removed by Join Filter: 1554
91. 112.882 76,912.406 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.35..11.52 rows=1 width=105) (actual time=116.568..76,912.406 rows=1,554 loops=1)

  • Join Filter: (t7.id = t.id_ord_order_vehicle_calc_cust)
  • Rows Removed by Join Filter: 1420995
92. 211.434 76,668.988 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.35..11.49 rows=1 width=121) (actual time=110.773..76,668.988 rows=1,554 loops=1)

  • Join Filter: (t8.id = t.id_order_vehicle)
  • Rows Removed by Join Filter: 2413362
93. 22.120 221.422 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.31..9.83 rows=1 width=105) (actual time=86.004..221.422 rows=1,554 loops=1)

  • Join Filter: (t6.id = t.id_inv_cust)
  • Rows Removed by Join Filter: 272583
94. 0.976 169.776 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.31..9.79 rows=1 width=121) (actual time=81.123..169.776 rows=1,554 loops=1)

  • Join Filter: (t5.id = t.id_fin_report_p)
  • Rows Removed by Join Filter: 635
95. 1.249 167.246 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.31..9.76 rows=1 width=137) (actual time=79.814..167.246 rows=1,554 loops=1)

  • Join Filter: (t4.id = t.id_fin_report_f)
  • Rows Removed by Join Filter: 639
96. 15.244 164.443 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.31..9.73 rows=1 width=153) (actual time=78.482..164.443 rows=1,554 loops=1)

  • Join Filter: (t2.id = t.id_act_supp_prep)
  • Rows Removed by Join Filter: 173127
97. 10.407 124.335 ↓ 1,554.0 1,554 1

Nested Loop Left Join (cost=8.31..9.70 rows=1 width=169) (actual time=69.623..124.335 rows=1,554 loops=1)

98. 70.416 70.416 ↓ 1,554.0 1,554 1

CTE Scan on tp (cost=0.00..0.02 rows=1 width=60) (actual time=69.562..70.416 rows=1,554 loops=1)

99. 20.202 43.512 ↑ 1.0 1 1,554

Hash Right Join (cost=8.31..9.67 rows=1 width=141) (actual time=0.024..0.028 rows=1 loops=1,554)

  • Hash Cond: ((t1.login)::text = t.editor)
100. 4.662 4.662 ↑ 1.0 25 1,554

Seq Scan on profile t1 (cost=0.00..1.25 rows=25 width=32) (actual time=0.002..0.003 rows=25 loops=1,554)

101. 6.216 18.648 ↑ 1.0 1 1,554

Hash (cost=8.30..8.30 rows=1 width=354) (actual time=0.012..0.012 rows=1 loops=1,554)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
102. 12.432 12.432 ↑ 1.0 1 1,554

Index Scan using pk_ord_order_vehicle_calc_supp on ord_order_vehicle_calc_supp t (cost=0.28..8.30 rows=1 width=354) (actual time=0.008..0.008 rows=1 loops=1,554)

  • Index Cond: (id = tp.id)
103. 24.864 24.864 ↓ 112.0 112 1,554

CTE Scan on t2 (cost=0.00..0.02 rows=1 width=16) (actual time=0.006..0.016 rows=112 loops=1,554)

104. 1.554 1.554 ↑ 1.0 1 1,554

CTE Scan on t4 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1,554)

105. 1.554 1.554 ↑ 1.0 1 1,554

CTE Scan on t5 (cost=0.00..0.02 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=1,554)

106. 29.526 29.526 ↓ 176.0 176 1,554

CTE Scan on t6 (cost=0.00..0.02 rows=1 width=16) (actual time=0.003..0.019 rows=176 loops=1,554)

107. 20,327.874 76,236.132 ↓ 1,554.0 1,554 1,554

Nested Loop Left Join (cost=0.03..1.65 rows=1 width=48) (actual time=0.025..49.058 rows=1,554 loops=1,554)

  • Join Filter: (t9.id = t8.id_order_1)
  • Rows Removed by Join Filter: 119658
108. 365.190 365.190 ↓ 1,554.0 1,554 1,554

CTE Scan on t8 (cost=0.00..0.02 rows=1 width=48) (actual time=0.005..0.235 rows=1,554 loops=1,554)

109. 48,290.422 55,543.068 ↓ 78.0 78 2,414,916

Hash Right Join (cost=0.03..1.62 rows=1 width=48) (actual time=0.002..0.023 rows=78 loops=2,414,916)

  • Hash Cond: (t13.id = t9.id_responsible)
110. 7,244.748 7,244.748 ↑ 1.0 42 2,414,916

Seq Scan on com_employee t13 (cost=0.00..1.42 rows=42 width=32) (actual time=0.001..0.003 rows=42 loops=2,414,916)

111. 0.037 7.898 ↓ 78.0 78 1

Hash (cost=0.02..0.02 rows=1 width=80) (actual time=7.898..7.898 rows=78 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
112. 7.861 7.861 ↓ 78.0 78 1

CTE Scan on t9 (cost=0.00..0.02 rows=1 width=80) (actual time=7.453..7.861 rows=78 loops=1)

113. 130.536 130.536 ↓ 915.0 915 1,554

CTE Scan on t7 (cost=0.00..0.02 rows=1 width=16) (actual time=0.003..0.084 rows=915 loops=1,554)

114. 7.770 7.770 ↓ 2.0 2 1,554

CTE Scan on t12 (cost=0.00..0.02 rows=1 width=16) (actual time=0.004..0.005 rows=2 loops=1,554)

115. 6.216 6.216 ↓ 2.0 2 1,554

CTE Scan on t14 (cost=0.00..0.02 rows=1 width=16) (actual time=0.004..0.004 rows=2 loops=1,554)