explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AJhZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=56,328.29..61,089.84 rows=30 width=3,360) (actual rows= loops=)

2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0

Aggregate (cost=25.75..25.77 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on auth_user (cost=0.00..25.71 rows=15 width=4) (actual rows= loops=)

  • Filter: ((data_level)::text = 'all'::text)
5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=56,302.52..61,064.07 rows=30 width=3,360) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=56,302.52..61,063.70 rows=30 width=3,352) (actual rows= loops=)

  • Hash Cond: (client.id = view_ro_list.client_id)
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=25,142.59..29,572.92 rows=11,499 width=238) (actual rows= loops=)

  • Hash Cond: (sa.subject_id = sa_1.subject_id)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=17,561.35..21,799.96 rows=12,778 width=210) (actual rows= loops=)

  • Hash Cond: (sccs.crm_client_status_id = ccs.id)
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=17,560.15..21,749.41 rows=12,778 width=214) (actual rows= loops=)

  • Hash Cond: ((sa.administrator_subject_id = sccs.subject_id) AND (client.client_status_id = sccs.crm_client_status_id))
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=17,556.45..21,266.54 rows=12,778 width=212) (actual rows= loops=)

  • Hash Cond: (client.id = invoice_2.client_id)
11. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,808.69..16,485.22 rows=12,778 width=180) (actual rows= loops=)

  • Hash Cond: ((client.credit_score_id = subject_crm_credit_score.crm_credit_score_id) AND (sa.administrator_subject_id = subject_crm_credit_score.subject_id))
12. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,806.34..16,384.67 rows=12,778 width=124) (actual rows= loops=)

  • Hash Cond: (client.id = sa.subject_id)
13. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=12,448.83..15,828.39 rows=14,199 width=116) (actual rows= loops=)

  • Hash Cond: (client.id = invoice_1.client_id)
14. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,144.77..11,487.05 rows=14,199 width=55) (actual rows= loops=)

  • Hash Cond: (client.id = invoice.client_id)
15. 0.000 0.000 ↓ 0.0

Seq Scan on subject_subject client (cost=0.00..3,304.99 rows=14,199 width=23) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash (cost=8,142.27..8,142.27 rows=200 width=36) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7,902.15..8,140.27 rows=200 width=36) (actual rows= loops=)

  • Group Key: invoice.client_id
18. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7,902.15..8,054.61 rows=5,544 width=44) (actual rows= loops=)

  • Group Key: client_2.id, invoice.id
19. 0.000 0.000 ↓ 0.0

Sort (cost=7,902.15..7,916.01 rows=5,544 width=25) (actual rows= loops=)

  • Sort Key: client_2.id, invoice.id
20. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,482.48..7,557.41 rows=5,544 width=25) (actual rows= loops=)

  • Hash Cond: (invoice.client_id = client_2.id)
  • Join Filter: ((invoice.pay_until + ('1 day'::interval day * (client_2.block_transfer_after_payment_delay_duration)::double precision)) < (now())::date)
21. 0.000 0.000 ↓ 0.0

Seq Scan on invoice (cost=0.00..4,031.27 rows=16,631 width=25) (actual rows= loops=)

  • Filter: (((status)::text = 'confirmed'::text) AND ((type)::text = 'debit'::text) AND ((financial_status)::text = 'unpaid'::text))
22. 0.000 0.000 ↓ 0.0

Hash (cost=3,304.99..3,304.99 rows=14,199 width=8) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on subject_subject client_2 (cost=0.00..3,304.99 rows=14,199 width=8) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Hash (cost=4,265.17..4,265.17 rows=3,111 width=36) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,195.17..4,234.06 rows=3,111 width=36) (actual rows= loops=)

  • Group Key: invoice_1.client_id
26. 0.000 0.000 ↓ 0.0

Seq Scan on invoice invoice_1 (cost=0.00..3,879.80 rows=31,537 width=17) (actual rows= loops=)

  • Filter: (((type)::text = 'debit'::text) AND ((status)::text = 'confirmed'::text))
27. 0.000 0.000 ↓ 0.0

Hash (cost=197.78..197.78 rows=12,778 width=8) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on subject_administrator sa (cost=0.00..197.78 rows=12,778 width=8) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Hash (cost=1.54..1.54 rows=54 width=48) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Seq Scan on subject_crm_credit_score (cost=0.00..1.54 rows=54 width=48) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Hash (cost=4,708.87..4,708.87 rows=3,111 width=36) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,638.88..4,677.76 rows=3,111 width=36) (actual rows= loops=)

  • Group Key: invoice_2.client_id
33. 0.000 0.000 ↓ 0.0

Seq Scan on invoice invoice_2 (cost=0.00..4,334.21 rows=30,467 width=17) (actual rows= loops=)

  • Filter: (((type)::text = 'debit'::text) AND ((status)::text = 'confirmed'::text) AND (pay_until < (now())::date))
34. 0.000 0.000 ↓ 0.0

Hash (cost=2.08..2.08 rows=108 width=10) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on subject_crm_client_status sccs (cost=0.00..2.08 rows=108 width=10) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=4) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Seq Scan on crm_client_status ccs (cost=0.00..1.09 rows=9 width=4) (actual rows= loops=)

38. 0.000 0.000 ↓ 0.0

Hash (cost=7,421.51..7,421.51 rows=12,778 width=40) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,964.95..7,421.51 rows=12,778 width=40) (actual rows= loops=)

  • Hash Cond: (sa_1.administrator_subject_id = administrator.id)
40. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,482.48..3,713.81 rows=12,778 width=34) (actual rows= loops=)

  • Hash Cond: (sa_1.subject_id = client_1.id)
41. 0.000 0.000 ↓ 0.0

Seq Scan on subject_administrator sa_1 (cost=0.00..197.78 rows=12,778 width=8) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Hash (cost=3,304.99..3,304.99 rows=14,199 width=26) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Seq Scan on subject_subject client_1 (cost=0.00..3,304.99 rows=14,199 width=26) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash (cost=3,304.99..3,304.99 rows=14,199 width=45) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Seq Scan on subject_subject administrator (cost=0.00..3,304.99 rows=14,199 width=45) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Hash (cost=31,159.56..31,159.56 rows=30 width=3,114) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=29,760.27..31,159.56 rows=30 width=3,114) (actual rows= loops=)

  • Hash Cond: (c.id = view_ro_list.contact_id)
  • Filter: (139 = ANY ((array_cat(array_cat(array_cat((array_remove(array_agg(DISTINCT cpm_1.user_id), NULL::integer)), (array_remove(array_agg(DISTINCT COALESCE(ssru.manager_id, ssru.project_manager_id)), NULL::integer))), (array_remove(array_agg(DISTINCT uua.user_id), NULL::integer))), $0))))
48. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=10,035.52..11,235.20 rows=49,593 width=36) (actual rows= loops=)

  • Hash Cond: (c.id = c_1.id)
49. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=2,946.39..3,643.93 rows=49,593 width=68) (actual rows= loops=)

  • Hash Cond: (cpm.contact_id = c.id)
50. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=251.45..859.56 rows=34,062 width=68) (actual rows= loops=)

  • Hash Cond: (cpm.user_id = au_1.id)
51. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=27.83..551.78 rows=31,396 width=40) (actual rows= loops=)

  • Hash Cond: (cpm.user_id = au.id)
52. 0.000 0.000 ↓ 0.0

Seq Scan on contact_project_manager cpm (cost=0.00..446.38 rows=28,938 width=8) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Hash (cost=25.11..25.11 rows=217 width=36) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

HashAggregate (cost=20.23..22.94 rows=217 width=36) (actual rows= loops=)

  • Group Key: au.id, array_remove(array_agg(DISTINCT COALESCE(ssru.manager_id, ssru.project_manager_id)), NULL::integer)
55. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2.84..19.15 rows=217 width=36) (actual rows= loops=)

  • Group Key: au.id
56. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=2.84..14.81 rows=217 width=12) (actual rows= loops=)

  • Merge Cond: (au.id = (COALESCE(sru.manager_id, sru.project_manager_id)))
57. 0.000 0.000 ↓ 0.0

Index Only Scan using auth_user_pkey on auth_user au (cost=0.14..11.40 rows=217 width=4) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Sort (cost=2.70..2.73 rows=11 width=16) (actual rows= loops=)

  • Sort Key: (COALESCE(sru.manager_id, sru.project_manager_id))
59. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=1.25..2.51 rows=11 width=16) (actual rows= loops=)

  • Hash Cond: (sru.region_id = ssru.region_id)
60. 0.000 0.000 ↓ 0.0

Seq Scan on subject_region_user sru (cost=0.00..1.11 rows=11 width=12) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=12) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Seq Scan on subject_region_user ssru (cost=0.00..1.11 rows=11 width=12) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Hash (cost=220.91..220.91 rows=217 width=36) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

HashAggregate (cost=216.03..218.74 rows=217 width=36) (actual rows= loops=)

  • Group Key: au_1.id, array_remove(array_agg(DISTINCT uua.user_id), NULL::integer)
65. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=195.58..214.94 rows=217 width=36) (actual rows= loops=)

  • Group Key: au_1.id
66. 0.000 0.000 ↓ 0.0

Sort (cost=195.58..200.95 rows=2,147 width=8) (actual rows= loops=)

  • Sort Key: au_1.id
67. 0.000 0.000 ↓ 0.0

Hash Join (cost=45.85..76.77 rows=2,147 width=8) (actual rows= loops=)

  • Hash Cond: (ua.subject_id = uua.subject_id)
68. 0.000 0.000 ↓ 0.0

Hash Join (cost=14.11..18.50 rows=188 width=8) (actual rows= loops=)

  • Hash Cond: (ua.user_id = au_1.id)
69. 0.000 0.000 ↓ 0.0

Seq Scan on user_administrator ua (cost=0.00..3.88 rows=188 width=8) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Hash (cost=11.40..11.40 rows=217 width=4) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Index Only Scan using auth_user_pkey on auth_user au_1 (cost=0.14..11.40 rows=217 width=4) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=30.97..30.97 rows=61 width=8) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Hash Join (cost=26.59..30.97 rows=61 width=8) (actual rows= loops=)

  • Hash Cond: (uua.user_id = aau.id)
74. 0.000 0.000 ↓ 0.0

Seq Scan on user_administrator uua (cost=0.00..3.88 rows=188 width=8) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash (cost=25.71..25.71 rows=70 width=4) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on auth_user aau (cost=0.00..25.71 rows=70 width=4) (actual rows= loops=)

  • Filter: ((data_level)::text = 'company'::text)
77. 0.000 0.000 ↓ 0.0

Hash (cost=2,168.28..2,168.28 rows=42,133 width=4) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Index Only Scan using contact_contact_pkey on contact_contact c (cost=0.29..2,168.28 rows=42,133 width=4) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash (cost=6,562.46..6,562.46 rows=42,133 width=36) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,591.09..6,141.13 rows=42,133 width=36) (actual rows= loops=)

  • Group Key: c_1.id
81. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=2,591.09..5,298.47 rows=42,133 width=8) (actual rows= loops=)

  • Merge Cond: (c_1.id = cpm_1.contact_id)
82. 0.000 0.000 ↓ 0.0

Index Only Scan using contact_contact_pkey on contact_contact c_1 (cost=0.29..2,168.28 rows=42,133 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Sort (cost=2,590.78..2,663.13 rows=28,938 width=8) (actual rows= loops=)

  • Sort Key: cpm_1.contact_id
84. 0.000 0.000 ↓ 0.0

Seq Scan on contact_project_manager cpm_1 (cost=0.00..446.38 rows=28,938 width=8) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Hash (cost=19,718.32..19,718.32 rows=515 width=3,114) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Subquery Scan on view_ro_list (cost=19,711.88..19,718.32 rows=515 width=3,114) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Sort (cost=19,711.88..19,713.17 rows=515 width=3,114) (actual rows= loops=)

  • Sort Key: ro.deadline_date, (to_char((ro.deadline_time)::interval, 'HH24:MI'::text)), ro.id
88. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,568.40..19,688.68 rows=515 width=3,114) (actual rows= loops=)

  • Hash Cond: (ro.warehouse_id = warehouse.id)
89. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,566.75..19,667.45 rows=515 width=1,943) (actual rows= loops=)

  • Hash Cond: (ro.created_by = creator.id)
90. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,538.87..19,638.19 rows=515 width=1,937) (actual rows= loops=)

  • Hash Cond: (ro.project_manager_id = pm.id)
91. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,510.98..19,608.94 rows=515 width=1,927) (actual rows= loops=)

  • Hash Cond: (ro.object_id = so.id)
92. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=13,104.36..19,200.96 rows=515 width=1,899) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,104.07..15,898.60 rows=515 width=1,867) (actual rows= loops=)

  • Hash Cond: (ro.administrator_id = administrator_1.id)
94. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=13,095.75..15,883.20 rows=515 width=1,848) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=13,095.47..13,247.41 rows=515 width=1,829) (actual rows= loops=)

  • Hash Cond: (ro.project_manager_id = COALESCE(sru_1.manager_id, sru_1.project_manager_id))
96. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=13,082.05..13,228.52 rows=515 width=1,309) (actual rows= loops=)

  • Merge Cond: (ro.id = ro_3.id)
97. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=12,807.11..12,922.19 rows=515 width=1,277) (actual rows= loops=)

  • Merge Cond: (ro.id = ro_2.id)
98. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=12,777.05..12,890.58 rows=515 width=1,245) (actual rows= loops=)

  • Merge Cond: (ro.id = ro_1.id)
99. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=12,707.30..12,801.38 rows=515 width=1,213) (actual rows= loops=)

  • Merge Cond: (ro.id = rog_1.rent_order_id)
100. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=7,567.79..7,611.36 rows=515 width=1,181) (actual rows= loops=)

  • Merge Cond: (ro.id = rog.rent_order_id)
101. 0.000 0.000 ↓ 0.0

Sort (cost=81.25..82.54 rows=515 width=1,149) (actual rows= loops=)

  • Sort Key: ro.id
102. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.31..58.05 rows=515 width=1,149) (actual rows= loops=)

  • Hash Cond: (ro.currency_id = currency_currency.id)
103. 0.000 0.000 ↓ 0.0

Hash Join (cost=2.16..54.72 rows=515 width=1,133) (actual rows= loops=)

  • Hash Cond: ((ro.type)::text = (rotc.type)::text)
104. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.11..46.59 rows=515 width=617) (actual rows= loops=)

  • Hash Cond: ((ro.status)::text = (rosc.status)::text)
105. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order ro (cost=0.00..38.40 rows=515 width=101) (actual rows= loops=)

  • Filter: ((id > 0) AND (administrator_id = 14))
106. 0.000 0.000 ↓ 0.0

Hash (cost=1.05..1.05 rows=5 width=1,032) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_status_color rosc (cost=0.00..1.05 rows=5 width=1,032) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=2 width=1,032) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_type_color rotc (cost=0.00..1.02 rows=2 width=1,032) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Hash (cost=1.07..1.07 rows=7 width=20) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Seq Scan on currency_currency (cost=0.00..1.07 rows=7 width=20) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7,486.54..7,516.49 rows=509 width=36) (actual rows= loops=)

  • Group Key: rog.rent_order_id
113. 0.000 0.000 ↓ 0.0

Sort (cost=7,486.54..7,492.43 rows=2,359 width=16) (actual rows= loops=)

  • Sort Key: rog.rent_order_id
114. 0.000 0.000 ↓ 0.0

Gather (cost=1,105.00..7,354.39 rows=2,359 width=16) (actual rows= loops=)

  • Workers Planned: 2
115. 0.000 0.000 ↓ 0.0

Nested Loop (cost=105.00..6,118.49 rows=983 width=16) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

Hash Join (cost=104.72..5,781.52 rows=983 width=8) (actual rows= loops=)

  • Hash Cond: (rograg.rog_id = rog.id)
117. 0.000 0.000 ↓ 0.0

Hash Join (cost=69.08..5,743.29 rows=983 width=8) (actual rows= loops=)

  • Hash Cond: (rag.id = rograg.rag_id)
118. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on rent_account_good rag (cost=0.00..5,096.14 rows=45,514 width=8) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash (cost=39.59..39.59 rows=2,359 width=8) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_good_rag rograg (cost=0.00..39.59 rows=2,359 width=8) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Hash (cost=21.95..21.95 rows=1,095 width=8) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_good rog (cost=0.00..21.95 rows=1,095 width=8) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Index Scan using rent_account_pkey on rent_account ra (cost=0.29..0.34 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id = rag.account_id)
124. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,139.52..5,177.69 rows=509 width=36) (actual rows= loops=)

  • Group Key: rog_1.rent_order_id
125. 0.000 0.000 ↓ 0.0

Sort (cost=5,139.52..5,144.06 rows=1,818 width=38) (actual rows= loops=)

  • Sort Key: rog_1.rent_order_id
126. 0.000 0.000 ↓ 0.0

Gather (cost=1,132.89..5,041.09 rows=1,818 width=38) (actual rows= loops=)

  • Workers Planned: 1
127. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=132.89..3,859.29 rows=1,069 width=38) (actual rows= loops=)

  • Hash Cond: (rat.assigned_user_id = au_2.id)
128. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=105.01..3,828.54 rows=1,069 width=32) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Hash Join (cost=104.72..3,369.79 rows=1,069 width=8) (actual rows= loops=)

  • Hash Cond: (rograg_1.rog_id = rog_1.id)
130. 0.000 0.000 ↓ 0.0

Hash Join (cost=69.08..3,331.33 rows=1,069 width=8) (actual rows= loops=)

  • Hash Cond: (rr.rag_id = rograg_1.rag_id)
131. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on ratg_rag rr (cost=0.00..2,638.63 rows=49,034 width=8) (actual rows= loops=)

  • Filter: ((task_type)::text = 'return'::text)
132. 0.000 0.000 ↓ 0.0

Hash (cost=39.59..39.59 rows=2,359 width=8) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_good_rag rograg_1 (cost=0.00..39.59 rows=2,359 width=8) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Hash (cost=21.95..21.95 rows=1,095 width=8) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_good rog_1 (cost=0.00..21.95 rows=1,095 width=8) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Index Scan using rent_account_task_pkey on rent_account_task rat (cost=0.29..0.43 rows=1 width=28) (actual rows= loops=)

  • Index Cond: (id = rr.task_id)
137. 0.000 0.000 ↓ 0.0

Hash (cost=25.17..25.17 rows=217 width=14) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Seq Scan on auth_user au_2 (cost=0.00..25.17 rows=217 width=14) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=69.75..78.99 rows=411 width=36) (actual rows= loops=)

  • Group Key: ro_1.id
140. 0.000 0.000 ↓ 0.0

Sort (cost=69.75..70.77 rows=411 width=21) (actual rows= loops=)

  • Sort Key: ro_1.id
141. 0.000 0.000 ↓ 0.0

Hash Join (cost=42.60..51.90 rows=411 width=21) (actual rows= loops=)

  • Hash Cond: (ros.rent_order_id = ro_1.id)
142. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_service ros (cost=0.00..8.21 rows=411 width=21) (actual rows= loops=)

  • Filter: ((type)::text = 'transport'::text)
143. 0.000 0.000 ↓ 0.0

Hash (cost=35.60..35.60 rows=560 width=4) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order ro_1 (cost=0.00..35.60 rows=560 width=4) (actual rows= loops=)

145. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=30.06..30.19 rows=6 width=36) (actual rows= loops=)

  • Group Key: ro_2.id
146. 0.000 0.000 ↓ 0.0

Sort (cost=30.06..30.07 rows=6 width=21) (actual rows= loops=)

  • Sort Key: ro_2.id
147. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.28..29.98 rows=6 width=21) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_service ros_1 (cost=0.00..8.21 rows=6 width=21) (actual rows= loops=)

  • Filter: ((type)::text = 'operating'::text)
149. 0.000 0.000 ↓ 0.0

Index Only Scan using rent_order_pkey on rent_order ro_2 (cost=0.28..3.63 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = ros_1.rent_order_id)
150. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=274.94..292.89 rows=560 width=36) (actual rows= loops=)

  • Group Key: ro_3.id
151. 0.000 0.000 ↓ 0.0

Sort (cost=274.94..277.68 rows=1,095 width=41) (actual rows= loops=)

  • Sort Key: ro_3.id
152. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=189.02..219.66 rows=1,095 width=41) (actual rows= loops=)

  • Hash Cond: (rog_2.technology_id = t.id)
153. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=177.18..204.90 rows=1,095 width=32) (actual rows= loops=)

  • Hash Cond: (rog_2.good_id = g.id)
154. 0.000 0.000 ↓ 0.0

Hash Join (cost=42.60..67.45 rows=1,095 width=23) (actual rows= loops=)

  • Hash Cond: (rog_2.rent_order_id = ro_3.id)
155. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order_good rog_2 (cost=0.00..21.95 rows=1,095 width=23) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Hash (cost=35.60..35.60 rows=560 width=4) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Seq Scan on rent_order ro_3 (cost=0.00..35.60 rows=560 width=4) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Hash (cost=120.37..120.37 rows=1,137 width=13) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Seq Scan on good g (cost=0.00..120.37 rows=1,137 width=13) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Hash (cost=9.15..9.15 rows=215 width=13) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Seq Scan on technology t (cost=0.00..9.15 rows=215 width=13) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Hash (cost=13.28..13.28 rows=11 width=528) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1.25..13.28 rows=11 width=528) (actual rows= loops=)

  • Hash Cond: (sr.id = sru_1.region_id)
164. 0.000 0.000 ↓ 0.0

Seq Scan on subject_region sr (cost=0.00..11.40 rows=140 width=520) (actual rows= loops=)

165. 0.000 0.000 ↓ 0.0

Hash (cost=1.11..1.11 rows=11 width=12) (actual rows= loops=)

166. 0.000 0.000 ↓ 0.0

Seq Scan on subject_region_user sru_1 (cost=0.00..1.11 rows=11 width=12) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Index Scan using subject_subject_pkey on subject_subject client_3 (cost=0.29..5.12 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id = ro.client_id)
168. 0.000 0.000 ↓ 0.0

Hash (cost=8.30..8.30 rows=1 width=23) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Index Scan using subject_subject_pkey on subject_subject administrator_1 (cost=0.29..8.30 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (id = 14)
170. 0.000 0.000 ↓ 0.0

Index Scan using contact_contact_pkey on contact_contact cc (cost=0.29..6.41 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (id = ro.contact_id)
171. 0.000 0.000 ↓ 0.0

Hash (cost=267.39..267.39 rows=11,139 width=32) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Seq Scan on subject_object so (cost=0.00..267.39 rows=11,139 width=32) (actual rows= loops=)

173. 0.000 0.000 ↓ 0.0

Hash (cost=25.17..25.17 rows=217 width=14) (actual rows= loops=)

174. 0.000 0.000 ↓ 0.0

Seq Scan on auth_user pm (cost=0.00..25.17 rows=217 width=14) (actual rows= loops=)

175. 0.000 0.000 ↓ 0.0

Hash (cost=25.17..25.17 rows=217 width=14) (actual rows= loops=)

176. 0.000 0.000 ↓ 0.0

Seq Scan on auth_user creator (cost=0.00..25.17 rows=217 width=14) (actual rows= loops=)

177. 0.000 0.000 ↓ 0.0

Hash (cost=1.29..1.29 rows=29 width=1,036) (actual rows= loops=)

178. 0.000 0.000 ↓ 0.0

Seq Scan on warehouse (cost=0.00..1.29 rows=29 width=1,036) (actual rows= loops=)