explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Dlu

Settings
# exclusive inclusive rows x rows loops node
1. 43.822 1,756.843 ↓ 1.0 9,523 1

Sort (cost=106,039.24..106,063.04 rows=9,520 width=588) (actual time=1,756.011..1,756.843 rows=9,523 loops=1)

  • Sort Key: ro.deadline_date, (to_char((ro.deadline_time)::interval, 'HH24:MI'::text)), ro.id
  • Sort Method: quicksort Memory: 10,937kB
  • Buffers: shared hit=275,571
2. 38.389 1,713.021 ↓ 1.0 9,523 1

Hash Join (cost=99,677.16..105,410.13 rows=9,520 width=588) (actual time=1,599.672..1,713.021 rows=9,523 loops=1)

  • Buffers: shared hit=275,565
3. 5.206 1,674.603 ↓ 1.0 9,523 1

Hash Join (cost=99,675.28..105,023.55 rows=9,520 width=444) (actual time=1,599.457..1,674.603 rows=9,523 loops=1)

  • Buffers: shared hit=275,564
4. 5.204 1,669.259 ↓ 1.0 9,523 1

Hash Join (cost=99,639.37..104,962.3 rows=9,520 width=438) (actual time=1,599.308..1,669.259 rows=9,523 loops=1)

  • Buffers: shared hit=275,535
5. 5.068 1,663.866 ↓ 1.0 9,523 1

Hash Join (cost=99,603.47..104,901.06 rows=9,520 width=428) (actual time=1,599.113..1,663.866 rows=9,523 loops=1)

  • Buffers: shared hit=275,506
6. 4.844 1,658.785 ↓ 1.0 9,523 1

Hash Join (cost=99,602.24..104,864.26 rows=9,520 width=415) (actual time=1,599.093..1,658.785 rows=9,523 loops=1)

  • Buffers: shared hit=275,505
7. 7.002 1,653.916 ↓ 1.0 9,523 1

Hash Join (cost=99,600.79..104,791.19 rows=9,520 width=411) (actual time=1,599.051..1,653.916 rows=9,523 loops=1)

  • Buffers: shared hit=275,504
8. 6.180 1,627.781 ↓ 1.0 9,523 1

Hash Join (cost=97,825.89..102,991.3 rows=9,520 width=383) (actual time=1,579.629..1,627.781 rows=9,523 loops=1)

  • Buffers: shared hit=274,549
9. 6.393 1,598.168 ↓ 1.0 9,523 1

Hash Join (cost=92,414.83..97,555.24 rows=9,520 width=363) (actual time=1,556.031..1,598.168 rows=9,523 loops=1)

  • Buffers: shared hit=269,604
10. 9.383 1,488.700 ↓ 1.0 9,523 1

Hash Join (cost=87,290.87..92,406.28 rows=9,520 width=331) (actual time=1,452.838..1,488.7 rows=9,523 loops=1)

  • Buffers: shared hit=267,181
11. 3.917 1,292.197 ↓ 1.0 9,523 1

Hash Join (cost=84,834.14..89,924.56 rows=9,520 width=299) (actual time=1,265.635..1,292.197 rows=9,523 loops=1)

  • Buffers: shared hit=266,743
12. 9.405 1,287.299 ↓ 1.0 9,523 1

Merge Join (cost=84,614.41..89,679.82 rows=9,520 width=267) (actual time=1,264.646..1,287.299 rows=9,523 loops=1)

  • Buffers: shared hit=266,599
13. 3.425 3.425 ↑ 3.7 5,531 1

Index Scan using subject_subject_pkey on subject_subject administrator (cost=0.29..18,394.05 rows=20,714 width=24) (actual time=0.019..3.425 rows=5,531 loops=1)

  • Buffers: shared hit=4,342
14. 21.986 1,274.469 ↓ 1.0 9,523 1

Sort (cost=84,612.34..84,636.14 rows=9,520 width=247) (actual time=1,264.619..1,274.469 rows=9,523 loops=1)

  • Sort Key: ro.administrator_id
  • Sort Method: quicksort Memory: 9,076kB
  • Buffers: shared hit=262,257
15. 5.314 1,252.483 ↓ 1.0 9,523 1

Hash Join (cost=80,269.68..83,983.22 rows=9,520 width=247) (actual time=622.294..1,252.483 rows=9,523 loops=1)

  • Buffers: shared hit=262,257
16. 5.703 1,247.152 ↓ 1.0 9,523 1

Hash Join (cost=80,268.64..83,851.28 rows=9,520 width=239) (actual time=622.259..1,247.152 rows=9,523 loops=1)

  • Buffers: shared hit=262,256
17. 5.125 1,241.437 ↓ 1.0 9,523 1

Hash Join (cost=80,267.52..83,719.26 rows=9,520 width=231) (actual time=622.232..1,241.437 rows=9,523 loops=1)

  • Buffers: shared hit=262,255
18. 4.839 1,236.302 ↓ 1.0 9,523 1

Merge Join (cost=80,266.37..83,677.99 rows=9,520 width=227) (actual time=622.208..1,236.302 rows=9,523 loops=1)

  • Buffers: shared hit=262,254
19. 6.348 1,202.167 ↓ 1.0 9,523 1

Merge Join (cost=79,997.63..82,876.26 rows=9,520 width=195) (actual time=620.756..1,202.167 rows=9,523 loops=1)

  • Buffers: shared hit=261,453
20. 5.797 810.248 ↓ 1.0 9,523 1

Merge Join (cost=55,359.09..57,389.59 rows=9,520 width=163) (actual time=471.79..810.248 rows=9,523 loops=1)

  • Buffers: shared hit=133,718
21. 5.880 467.469 ↓ 1.0 9,523 1

Merge Join (cost=31,776.78..32,999.25 rows=9,520 width=131) (actual time=333.974..467.469 rows=9,523 loops=1)

  • Buffers: shared hit=26,526
22. 10.938 10.938 ↓ 1.0 9,523 1

Index Scan using rent_order_pkey on rent_order ro (cost=0.29..572.85 rows=9,520 width=99) (actual time=0.016..10.938 rows=9,523 loops=1)

  • Buffers: shared hit=7,835
23. 113.168 450.651 ↑ 1.0 8,879 1

GroupAggregate (cost=31,776.49..32,196.41 rows=9,164 width=36) (actual time=333.953..450.651 rows=8,879 loops=1)

  • Group Key: rog.rent_order_id
  • Buffers: shared hit=18,691
24. 13.348 337.483 ↑ 1.0 30,376 1

Sort (cost=31,776.49..31,852.84 rows=30,537 width=16) (actual time=333.833..337.483 rows=30,376 loops=1)

  • Sort Key: rog.rent_order_id
  • Sort Method: quicksort Memory: 3,078kB
  • Buffers: shared hit=18,683
25. 10.512 324.135 ↑ 1.0 30,376 1

Hash Join (cost=28,758.87..29,501.75 rows=30,537 width=16) (actual time=283.904..324.135 rows=30,376 loops=1)

  • Buffers: shared hit=18,683
26. 17.498 273.552 ↑ 1.0 30,376 1

Hash Join (cost=24,158.76..24,821.47 rows=30,537 width=8) (actual time=243.542..273.552 rows=30,376 loops=1)

  • Buffers: shared hit=15,456
27. 11.683 21.048 ↑ 1.0 30,537 1

Hash Join (cost=462.52..1,045.07 rows=30,537 width=8) (actual time=6.023..21.048 rows=30,537 loops=1)

  • Buffers: shared hit=328
28. 3.441 3.441 ↑ 1.0 30,537 1

Seq Scan on rent_order_good_rag rograg (cost=0..502.37 rows=30,537 width=8) (actual time=0.013..3.441 rows=30,537 loops=1)

  • Buffers: shared hit=197
29. 2.666 5.924 ↑ 1.0 14,733 1

Hash (cost=278.34..278.34 rows=14,734 width=8) (actual time=5.924..5.924 rows=14,733 loops=1)

  • Buffers: shared hit=131
30. 3.258 3.258 ↑ 1.0 14,733 1

Seq Scan on rent_order_good rog (cost=0..278.34 rows=14,734 width=8) (actual time=0.005..3.258 rows=14,733 loops=1)

  • Buffers: shared hit=131
31. 98.072 235.006 ↑ 1.0 380,811 1

Hash (cost=18,936.11..18,936.11 rows=380,811 width=8) (actual time=235.006..235.006 rows=380,811 loops=1)

  • Buffers: shared hit=15,128
32. 136.934 136.934 ↑ 1.0 380,811 1

Seq Scan on rent_account_good rag (cost=0..18,936.11 rows=380,811 width=8) (actual time=0.015..136.934 rows=380,811 loops=1)

  • Buffers: shared hit=15,128
33. 14.833 40.071 ↓ 1.0 61,031 1

Hash (cost=3,837.27..3,837.27 rows=61,027 width=12) (actual time=40.071..40.071 rows=61,031 loops=1)

  • Buffers: shared hit=3,227
34. 25.238 25.238 ↓ 1.0 61,031 1

Seq Scan on rent_account ra_1 (cost=0..3,837.27 rows=61,027 width=12) (actual time=0.014..25.238 rows=61,031 loops=1)

  • Buffers: shared hit=3,227
35. 195.256 336.982 ↑ 1.2 7,624 1

GroupAggregate (cost=23,582.31..24,160.34 rows=9,164 width=36) (actual time=137.81..336.982 rows=7,624 loops=1)

  • Group Key: rog_1.rent_order_id
  • Buffers: shared hit=107,192
36. 14.214 141.726 ↑ 1.0 25,235 1

Sort (cost=23,582.31..23,648.52 rows=26,485 width=38) (actual time=137.749..141.726 rows=25,235 loops=1)

  • Sort Key: rog_1.rent_order_id
  • Sort Method: quicksort Memory: 2,825kB
  • Buffers: shared hit=107,192
37. 12.179 127.512 ↑ 1.0 25,235 1

Gather (cost=2,382.93..21,636.6 rows=26,485 width=38) (actual time=24.596..127.512 rows=25,235 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=107,192
38. 3.019 115.333 ↑ 1.3 8,412 3 / 3

Hash Join (cost=1,382.93..17,988.1 rows=11,035 width=38) (actual time=36.374..115.333 rows=8,412 loops=3)

  • Buffers: shared hit=107,192
39. 9.371 112.033 ↑ 1.3 8,412 3 / 3

Nested Loop (cost=1,347.02..17,922.83 rows=11,035 width=32) (actual time=36.074..112.033 rows=8,412 loops=3)

  • Buffers: shared hit=107,105
40. 3.614 85.839 ↑ 1.3 8,412 3 / 3

Hash Join (cost=1,346.6..12,344.01 rows=11,035 width=8) (actual time=36.024..85.839 rows=8,412 loops=3)

  • Buffers: shared hit=6,154
41. 22.382 75.601 ↑ 1.3 8,412 3 / 3

Hash Join (cost=884.08..11,852.52 rows=11,035 width=8) (actual time=29.219..75.601 rows=8,412 loops=3)

  • Buffers: shared hit=5,673
42. 41.198 41.198 ↑ 1.2 103,245 3 / 3

Seq Scan on ratg_rag rr (cost=0..8,442.33 rows=128,840 width=8) (actual time=0.027..41.198 rows=103,245 loops=3)

  • Filter: ((task_type)::text = 'return'::text)
  • Buffers: shared hit=5,082
43. 5.770 12.021 ↑ 1.0 30,376 3 / 3

Hash (cost=502.37..502.37 rows=30,537 width=8) (actual time=12.021..12.021 rows=30,376 loops=3)

  • Buffers: shared hit=591
44. 6.251 6.251 ↑ 1.0 30,537 3 / 3

Seq Scan on rent_order_good_rag rograg_1 (cost=0..502.37 rows=30,537 width=8) (actual time=0.019..6.251 rows=30,537 loops=3)

  • Buffers: shared hit=591
45. 3.004 6.624 ↑ 1.0 14,733 3 / 3

Hash (cost=278.34..278.34 rows=14,734 width=8) (actual time=6.624..6.624 rows=14,733 loops=3)

  • Buffers: shared hit=393
46. 3.620 3.620 ↑ 1.0 14,733 3 / 3

Seq Scan on rent_order_good rog_1 (cost=0..278.34 rows=14,734 width=8) (actual time=0.018..3.62 rows=14,733 loops=3)

  • Buffers: shared hit=393
47. 16.823 16.823 ↑ 1.0 1 25,235 / 3

Index Scan using rent_account_task_pkey on rent_account_task rat (cost=0.42..0.51 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=25,235)

  • Index Cond: (id = rr.task_id)
  • Buffers: shared hit=100,951
48. 0.079 0.281 ↓ 1.0 311 3 / 3

Hash (cost=32.07..32.07 rows=307 width=14) (actual time=0.281..0.281 rows=311 loops=3)

  • Buffers: shared hit=87
49. 0.202 0.202 ↓ 1.0 311 3 / 3

Seq Scan on auth_user au (cost=0..32.07 rows=307 width=14) (actual time=0.027..0.202 rows=311 loops=3)

  • Buffers: shared hit=87
50. 231.902 385.571 ↑ 1.0 8,878 1

GroupAggregate (cost=24,638.54..25,256.69 rows=9,164 width=36) (actual time=148.96..385.571 rows=8,878 loops=1)

  • Group Key: rog_2.rent_order_id
  • Buffers: shared hit=127,735
51. 18.082 153.669 ↓ 1.1 30,366 1

Sort (cost=24,638.54..24,710.48 rows=28,777 width=38) (actual time=148.902..153.669 rows=30,366 loops=1)

  • Sort Key: rog_2.rent_order_id
  • Sort Method: quicksort Memory: 3,708kB
  • Buffers: shared hit=127,735
52. 14.547 135.587 ↓ 1.1 30,366 1

Gather (cost=2,382.93..22,507.22 rows=28,777 width=38) (actual time=41.315..135.587 rows=30,366 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=127,735
53. 3.537 121.040 ↑ 1.2 10,122 3 / 3

Hash Join (cost=1,382.93..18,629.52 rows=11,990 width=38) (actual time=32.626..121.04 rows=10,122 loops=3)

  • Buffers: shared hit=127,735
54. 1.804 117.245 ↑ 1.2 10,122 3 / 3

Nested Loop (cost=1,347.02..18,561.71 rows=11,990 width=32) (actual time=32.348..117.245 rows=10,122 loops=3)

  • Buffers: shared hit=127,648
55. 4.225 85.075 ↑ 1.2 10,122 3 / 3

Hash Join (cost=1,346.6..12,565.07 rows=11,990 width=8) (actual time=32.299..85.075 rows=10,122 loops=3)

  • Buffers: shared hit=6,154
56. 22.940 74.224 ↑ 1.2 10,122 3 / 3

Hash Join (cost=884.08..12,071.07 rows=11,990 width=8) (actual time=25.481..74.224 rows=10,122 loops=3)

  • Buffers: shared hit=5,673
57. 39.744 39.744 ↑ 1.3 111,939 3 / 3

Seq Scan on ratg_rag rr_1 (cost=0..8,442.33 rows=139,987 width=8) (actual time=0.014..39.744 rows=111,939 loops=3)

  • Filter: ((task_type)::text = 'transfer'::text)
  • Buffers: shared hit=5,082
58. 5.600 11.540 ↑ 1.0 30,376 3 / 3

Hash (cost=502.37..502.37 rows=30,537 width=8) (actual time=11.54..11.54 rows=30,376 loops=3)

  • Buffers: shared hit=591
59. 5.940 5.940 ↑ 1.0 30,537 3 / 3

Seq Scan on rent_order_good_rag rograg_2 (cost=0..502.37 rows=30,537 width=8) (actual time=0.017..5.94 rows=30,537 loops=3)

  • Buffers: shared hit=591
60. 2.996 6.626 ↑ 1.0 14,733 3 / 3

Hash (cost=278.34..278.34 rows=14,734 width=8) (actual time=6.626..6.626 rows=14,733 loops=3)

  • Buffers: shared hit=393
61. 3.630 3.630 ↑ 1.0 14,733 3 / 3

Seq Scan on rent_order_good rog_2 (cost=0..278.34 rows=14,734 width=8) (actual time=0.02..3.63 rows=14,733 loops=3)

  • Buffers: shared hit=393
62. 30.366 30.366 ↑ 1.0 1 30,366 / 3

Index Scan using rent_account_task_pkey on rent_account_task rat_1 (cost=0.42..0.5 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=30,366)

  • Index Cond: (id = rr_1.task_id)
  • Buffers: shared hit=121,494
63. 0.079 0.258 ↓ 1.0 311 3 / 3

Hash (cost=32.07..32.07 rows=307 width=14) (actual time=0.258..0.258 rows=311 loops=3)

  • Buffers: shared hit=87
64. 0.179 0.179 ↓ 1.0 311 3 / 3

Seq Scan on auth_user au_1 (cost=0..32.07 rows=307 width=14) (actual time=0.019..0.179 rows=311 loops=3)

  • Buffers: shared hit=87
65. 22.896 29.296 ↓ 1.0 3,437 1

GroupAggregate (cost=268.74..700.61 rows=3,436 width=36) (actual time=1.448..29.296 rows=3,437 loops=1)

  • Group Key: ro_1.id
  • Buffers: shared hit=801
66. 2.356 6.400 ↓ 1.0 3,437 1

Merge Join (cost=268.74..631.89 rows=3,436 width=21) (actual time=1.43..6.4 rows=3,437 loops=1)

  • Buffers: shared hit=801
67. 2.259 2.259 ↓ 1.0 9,521 1

Index Only Scan using rent_order_pkey on rent_order ro_1 (cost=0.29..288.39 rows=9,520 width=4) (actual time=0.049..2.259 rows=9,521 loops=1)

  • Heap Fetches: 1,225
  • Buffers: shared hit=778
68. 1.069 1.785 ↓ 1.0 3,437 1

Sort (cost=268.46..277.05 rows=3,436 width=21) (actual time=1.377..1.785 rows=3,437 loops=1)

  • Sort Key: ros.rent_order_id
  • Sort Method: quicksort Memory: 262kB
  • Buffers: shared hit=23
69. 0.716 0.716 ↓ 1.0 3,437 1

Seq Scan on rent_order_service ros (cost=0..66.65 rows=3,436 width=21) (actual time=0.015..0.716 rows=3,437 loops=1)

  • Filter: ((type)::text = 'transport'::text)
  • Buffers: shared hit=23
70. 0.004 0.010 ↑ 1.0 7 1

Hash (cost=1.07..1.07 rows=7 width=8) (actual time=0.01..0.01 rows=7 loops=1)

  • Buffers: shared hit=1
71. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on currency_currency currency_currency (cost=0..1.07 rows=7 width=8) (actual time=0.005..0.006 rows=7 loops=1)

  • Buffers: shared hit=1
72. 0.006 0.012 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=16) (actual time=0.012..0.012 rows=5 loops=1)

  • Buffers: shared hit=1
73. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on rent_order_status_color rosc (cost=0..1.05 rows=5 width=16) (actual time=0.005..0.006 rows=5 loops=1)

  • Buffers: shared hit=1
74. 0.007 0.017 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=16) (actual time=0.016..0.017 rows=2 loops=1)

  • Buffers: shared hit=1
75. 0.010 0.010 ↑ 1.0 2 1

Seq Scan on rent_order_type_color rotc (cost=0..1.02 rows=2 width=16) (actual time=0.01..0.01 rows=2 loops=1)

  • Buffers: shared hit=1
76. 0.028 0.981 ↑ 1.0 56 1

Hash (cost=219.04..219.04 rows=56 width=36) (actual time=0.981..0.981 rows=56 loops=1)

  • Buffers: shared hit=144
77. 0.010 0.953 ↑ 1.0 56 1

Subquery Scan on ro_operating (cost=217.22..219.04 rows=56 width=36) (actual time=0.603..0.953 rows=56 loops=1)

  • Buffers: shared hit=144
78. 0.375 0.943 ↑ 1.0 56 1

GroupAggregate (cost=217.22..218.48 rows=56 width=36) (actual time=0.602..0.943 rows=56 loops=1)

  • Group Key: ro_1_1.id
  • Buffers: shared hit=144
79. 0.019 0.568 ↑ 1.0 56 1

Sort (cost=217.22..217.36 rows=56 width=21) (actual time=0.564..0.568 rows=56 loops=1)

  • Sort Key: ro_1_1.id
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=144
80. 0.046 0.549 ↑ 1.0 56 1

Nested Loop (cost=0.29..215.59 rows=56 width=21) (actual time=0.041..0.549 rows=56 loops=1)

  • Buffers: shared hit=144
81. 0.391 0.391 ↑ 1.0 56 1

Seq Scan on rent_order_service ros_1 (cost=0..66.65 rows=56 width=21) (actual time=0.022..0.391 rows=56 loops=1)

  • Filter: ((type)::text = 'operating'::text)
  • Buffers: shared hit=23
82. 0.112 0.112 ↑ 1.0 1 56

Index Only Scan using rent_order_pkey on rent_order ro_1_1 (cost=0.29..2.66 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=56)

  • Index Cond: (id = ros_1.rent_order_id)
  • Heap Fetches: 8
  • Buffers: shared hit=121
83. 4.190 187.120 ↑ 1.0 9,165 1

Hash (cost=2,337.73..2,337.73 rows=9,520 width=36) (actual time=187.12..187.12 rows=9,165 loops=1)

  • Buffers: shared hit=438
84. 1.523 182.930 ↑ 1.0 9,165 1

Subquery Scan on ro_good (cost=1,976.19..2,337.73 rows=9,520 width=36) (actual time=27.359..182.93 rows=9,165 loops=1)

  • Buffers: shared hit=438
85. 151.334 181.407 ↑ 1.0 9,165 1

GroupAggregate (cost=1,976.19..2,242.53 rows=9,520 width=36) (actual time=27.358..181.407 rows=9,165 loops=1)

  • Group Key: ro_1_2.id
  • Buffers: shared hit=438
86. 8.591 30.073 ↑ 1.0 14,733 1

Sort (cost=1,976.19..2,013.02 rows=14,734 width=42) (actual time=27.318..30.073 rows=14,733 loops=1)

  • Sort Key: ro_1_2.id
  • Sort Method: quicksort Memory: 1,536kB
  • Buffers: shared hit=438
87. 3.576 21.482 ↑ 1.0 14,733 1

Hash Join (cost=561.47..956.09 rows=14,734 width=42) (actual time=4.491..21.482 rows=14,733 loops=1)

  • Buffers: shared hit=438
88. 4.533 17.772 ↑ 1.0 14,733 1

Hash Join (cost=545.01..900.8 rows=14,734 width=33) (actual time=4.344..17.772 rows=14,733 loops=1)

  • Buffers: shared hit=427
89. 4.943 12.339 ↑ 1.0 14,733 1

Hash Join (cost=397.2..714.24 rows=14,734 width=24) (actual time=3.424..12.339 rows=14,733 loops=1)

  • Buffers: shared hit=314
90. 4.059 4.059 ↑ 1.0 14,733 1

Seq Scan on rent_order_good rog_3 (cost=0..278.34 rows=14,734 width=24) (actual time=0.006..4.059 rows=14,733 loops=1)

  • Buffers: shared hit=131
91. 1.717 3.337 ↓ 1.0 9,523 1

Hash (cost=278.2..278.2 rows=9,520 width=4) (actual time=3.337..3.337 rows=9,523 loops=1)

  • Buffers: shared hit=183
92. 1.620 1.620 ↓ 1.0 9,523 1

Seq Scan on rent_order ro_1_2 (cost=0..278.2 rows=9,520 width=4) (actual time=0.005..1.62 rows=9,523 loops=1)

  • Buffers: shared hit=183
93. 0.339 0.900 ↓ 1.0 1,552 1

Hash (cost=128.47..128.47 rows=1,547 width=13) (actual time=0.9..0.9 rows=1,552 loops=1)

  • Buffers: shared hit=113
94. 0.561 0.561 ↓ 1.0 1,552 1

Seq Scan on good g (cost=0..128.47 rows=1,547 width=13) (actual time=0.014..0.561 rows=1,552 loops=1)

  • Buffers: shared hit=113
95. 0.056 0.134 ↑ 1.0 243 1

Hash (cost=13.43..13.43 rows=243 width=13) (actual time=0.134..0.134 rows=243 loops=1)

  • Buffers: shared hit=11
96. 0.078 0.078 ↑ 1.0 243 1

Seq Scan on technology t (cost=0..13.43 rows=243 width=13) (actual time=0.01..0.078 rows=243 loops=1)

  • Buffers: shared hit=11
97. 2.755 103.075 ↓ 1.0 8,879 1

Hash (cost=5,013.08..5,013.08 rows=8,870 width=36) (actual time=103.075..103.075 rows=8,879 loops=1)

  • Buffers: shared hit=2,423
98. 1.527 100.320 ↓ 1.0 8,879 1

Subquery Scan on cc (cost=4,724.27..5,013.08 rows=8,870 width=36) (actual time=43.01..100.32 rows=8,879 loops=1)

  • Buffers: shared hit=2,423
99. 55.106 98.793 ↓ 1.0 8,879 1

GroupAggregate (cost=4,724.27..4,924.38 rows=8,870 width=36) (actual time=43.009..98.793 rows=8,879 loops=1)

  • Group Key: roc.ro_id
  • Buffers: shared hit=2,423
100. 3.792 43.687 ↓ 1.0 8,932 1

Sort (cost=4,724.27..4,746.58 rows=8,923 width=33) (actual time=42.929..43.687 rows=8,932 loops=1)

  • Sort Key: roc.ro_id
  • Sort Method: quicksort Memory: 1,083kB
  • Buffers: shared hit=2,423
101. 3.905 39.895 ↓ 1.0 8,932 1

Hash Join (cost=3,977.12..4,138.78 rows=8,923 width=33) (actual time=35.698..39.895 rows=8,932 loops=1)

  • Buffers: shared hit=2,423
102. 0.946 0.946 ↓ 1.0 8,932 1

Seq Scan on rent_order_contact roc (cost=0..138.23 rows=8,923 width=8) (actual time=0.015..0.946 rows=8,932 loops=1)

  • Buffers: shared hit=49
103. 15.974 35.044 ↑ 1.3 56,063 1

Hash (cost=3,086.5..3,086.5 rows=71,250 width=29) (actual time=35.044..35.044 rows=56,063 loops=1)

  • Buffers: shared hit=2,374
104. 19.070 19.070 ↑ 1.3 56,063 1

Seq Scan on contact_contact contact_contact (cost=0..3,086.5 rows=71,250 width=29) (actual time=0.014..19.07 rows=56,063 loops=1)

  • Buffers: shared hit=2,374
105. 5.487 23.433 ↓ 1.0 20,722 1

Hash (cost=5,152.14..5,152.14 rows=20,714 width=24) (actual time=23.433..23.433 rows=20,722 loops=1)

  • Buffers: shared hit=4,945
106. 17.946 17.946 ↓ 1.0 20,722 1

Seq Scan on subject_subject client (cost=0..5,152.14 rows=20,714 width=24) (actual time=0.015..17.946 rows=20,722 loops=1)

  • Buffers: shared hit=4,945
107. 8.406 19.133 ↓ 1.0 36,453 1

Hash (cost=1,319.4..1,319.4 rows=36,440 width=32) (actual time=19.133..19.133 rows=36,453 loops=1)

  • Buffers: shared hit=955
108. 10.727 10.727 ↓ 1.0 36,453 1

Seq Scan on subject_object so (cost=0..1,319.4 rows=36,440 width=32) (actual time=0.013..10.727 rows=36,453 loops=1)

  • Buffers: shared hit=955
109. 0.009 0.025 ↑ 1.0 20 1

Hash (cost=1.2..1.2 rows=20 width=12) (actual time=0.025..0.025 rows=20 loops=1)

  • Buffers: shared hit=1
110. 0.016 0.016 ↑ 1.0 20 1

Seq Scan on subject_region_user sru (cost=0..1.2 rows=20 width=12) (actual time=0.013..0.016 rows=20 loops=1)

  • Buffers: shared hit=1
111. 0.006 0.013 ↑ 1.0 10 1

Hash (cost=1.1..1.1 rows=10 width=17) (actual time=0.013..0.013 rows=10 loops=1)

  • Buffers: shared hit=1
112. 0.007 0.007 ↑ 1.0 10 1

Seq Scan on subject_region sr (cost=0..1.1 rows=10 width=17) (actual time=0.006..0.007 rows=10 loops=1)

  • Buffers: shared hit=1
113. 0.075 0.189 ↓ 1.0 311 1

Hash (cost=32.07..32.07 rows=307 width=14) (actual time=0.189..0.189 rows=311 loops=1)

  • Buffers: shared hit=29
114. 0.114 0.114 ↓ 1.0 311 1

Seq Scan on auth_user pm (cost=0..32.07 rows=307 width=14) (actual time=0.004..0.114 rows=311 loops=1)

  • Buffers: shared hit=29
115. 0.070 0.138 ↓ 1.0 311 1

Hash (cost=32.07..32.07 rows=307 width=14) (actual time=0.138..0.138 rows=311 loops=1)

  • Buffers: shared hit=29
116. 0.068 0.068 ↓ 1.0 311 1

Seq Scan on auth_user creator (cost=0..32.07 rows=307 width=14) (actual time=0.002..0.068 rows=311 loops=1)

  • Buffers: shared hit=29
117. 0.012 0.029 ↑ 1.0 39 1

Hash (cost=1.39..1.39 rows=39 width=40) (actual time=0.029..0.029 rows=39 loops=1)

  • Buffers: shared hit=1
118. 0.017 0.017 ↑ 1.0 39 1

Seq Scan on warehouse warehouse (cost=0..1.39 rows=39 width=40) (actual time=0.01..0.017 rows=39 loops=1)

  • Buffers: shared hit=1
Planning time : 20.247 ms
Execution time : 1,760.29 ms