explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wRcx

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.029 35,028.468 ↑ 14,050.8 5 1

Sort (cost=10,271,696,422.53..10,271,696,598.17 rows=70,254 width=1,007) (actual time=35,028.468..35,028.468 rows=5 loops=1)

  • Sort Key: "*SELECT* 1".created_on
  • Sort Method: quicksort Memory: 27kB
2. 0.039 35,028.439 ↑ 14,050.8 5 1

WindowAgg (cost=10,000,044,622.54..10,271,628,809.98 rows=70,254 width=1,007) (actual time=35,028.434..35,028.439 rows=5 loops=1)

3. 11.218 35,028.400 ↑ 14,050.8 5 1

Hash Join (cost=10,000,044,622.54..10,271,627,931.81 rows=70,254 width=1,007) (actual time=34,909.073..35,028.400 rows=5 loops=1)

  • Hash Cond: ("*SELECT* 1".task_id = ratg_rag.task_id)
4. 27.195 34,988.594 ↑ 1.3 110,385 1

Hash Left Join (cost=40,955.03..271,623,736.85 rows=140,508 width=1,007) (actual time=373.934..34,988.594 rows=110,385 loops=1)

  • Hash Cond: ("*SELECT* 1".good_id = mass_good.id)
5. 39.269 34,959.834 ↑ 1.3 110,385 1

Hash Left Join (cost=40,654.52..271,621,504.35 rows=140,508 width=933) (actual time=372.355..34,959.834 rows=110,385 loops=1)

  • Hash Cond: (equipment.good_id = unique_good.id)
6. 1,753.457 34,918.713 ↑ 1.3 110,385 1

Hash Left Join (cost=40,354.01..271,619,271.86 rows=140,508 width=863) (actual time=370.484..34,918.713 rows=110,385 loops=1)

  • Hash Cond: ("*SELECT* 1".task_id = rent_account_task.id)
7. 92.238 33,122.188 ↑ 1.3 110,385 1

Hash Left Join (cost=33,780.58..271,600,506.45 rows=140,508 width=159) (actual time=327.400..33,122.188 rows=110,385 loops=1)

  • Hash Cond: ("*SELECT* 1".equipment_id = equipment.id)
8. 25.592 32,976.259 ↑ 1.3 110,385 1

Hash Join (cost=26,541.08..271,583,968.42 rows=140,508 width=140) (actual time=273.686..32,976.259 rows=110,385 loops=1)

  • Hash Cond: ("*SELECT* 1".created_by = auth_user.id)
9. 7.854 32,950.521 ↑ 1.4 110,385 1

Append (cost=26,525.92..271,581,978.55 rows=151,901 width=135) (actual time=273.525..32,950.521 rows=110,385 loops=1)

10. 0.000 658.109 ↓ 1.7 100,627 1

Subquery Scan on *SELECT* 1 (cost=26,525.92..104,250,058.59 rows=58,614 width=130) (actual time=273.525..658.109 rows=100,627 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (("*SELECT* 1".equipment_id IS NULL) AND ("*SELECT* 1".good_id IS NULL) AND (SubPlan 3)))
11. 85.047 388.188 ↓ 1.3 100,627 1

Hash Left Join (cost=12,501.93..22,315.55 rows=77,528 width=156) (actual time=133.665..388.188 rows=100,627 loops=1)

  • Hash Cond: (eq.id = tgd.equipment_document_id)
12. 169.598 169.598 ↓ 1.3 100,627 1

Seq Scan on equipment_document eq (cost=0.00..4,722.43 rows=77,528 width=152) (actual time=0.018..169.598 rows=100,627 loops=1)

  • Filter: ((document IS NOT NULL) AND (((filename)::text ~~* '%.jpg'::text) OR ((filename)::text ~~* '%.jpeg'::text) OR ((filename)::text ~~* '%.png'::text)))
  • Rows Removed by Filter: 1904
13. 16.093 133.543 ↑ 1.0 100,279 1

Hash (cost=10,694.71..10,694.71 rows=103,938 width=12) (actual time=133.543..133.543 rows=100,279 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 548kB
14. 53.818 117.450 ↑ 1.0 100,279 1

Hash Left Join (cost=5,575.49..10,694.71 rows=103,938 width=12) (actual time=48.212..117.450 rows=100,279 loops=1)

  • Hash Cond: (tgd.task_good_id = tg.id)
15. 15.556 15.556 ↑ 1.0 100,279 1

Seq Scan on rent_account_task_good_document tgd (cost=0.00..1,683.38 rows=103,938 width=8) (actual time=0.020..15.556 rows=100,279 loops=1)

16. 26.100 48.076 ↑ 1.0 167,282 1

Hash (cost=2,749.44..2,749.44 rows=172,244 width=8) (actual time=48.076..48.076 rows=167,282 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 832kB
17. 21.976 21.976 ↑ 1.0 167,282 1

Seq Scan on rent_account_task_good tg (cost=0.00..2,749.44 rows=172,244 width=8) (actual time=0.007..21.976 rows=167,282 loops=1)

18.          

SubPlan (forSubquery Scan)

19. 112.115 208.344 ↓ 10.0 153,628 3

Hash Semi Join (cost=1,979.82..6,973.60 rows=15,358 width=4) (actual time=9.118..69.448 rows=153,628 loops=3)

  • Hash Cond: (equipment_1.administrator_id = subject_subject.id)
20. 68.940 68.940 ↓ 1.0 153,628 3

Seq Scan on equipment equipment_1 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.011..22.980 rows=153,628 loops=3)

21. 0.006 27.289 ↓ 11.0 11 1

Hash (cost=1,979.81..1,979.81 rows=1 width=4) (actual time=27.289..27.289 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
22. 27.283 27.283 ↓ 11.0 11 1

Seq Scan on subject_subject (cost=0.00..1,979.81 rows=1 width=4) (actual time=20.795..27.283 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 12644
23. 69.584 124.902 ↓ 10.0 153,628 2

Hash Semi Join (cost=1,979.82..6,973.60 rows=15,358 width=4) (actual time=10.337..62.451 rows=153,628 loops=2)

  • Hash Cond: (equipment_2.administrator_id = subject_subject_1.id)
24. 34.674 34.674 ↓ 1.0 153,628 2

Seq Scan on equipment equipment_2 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.006..17.337 rows=153,628 loops=2)

25. 0.006 20.644 ↓ 11.0 11 1

Hash (cost=1,979.81..1,979.81 rows=1 width=4) (actual time=20.644..20.644 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
26. 20.638 20.638 ↓ 11.0 11 1

Seq Scan on subject_subject subject_subject_1 (cost=0.00..1,979.81 rows=1 width=4) (actual time=18.799..20.638 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 12644
27. 14,035.668 14,045.640 ↑ 2.4 18,628 9,660

Materialize (cost=0.00..2,577.33 rows=44,419 width=4) (actual time=0.001..1.454 rows=18,628 loops=9,660)

28. 9.972 9.972 ↓ 1.0 44,902 1

Seq Scan on rent_account_task rent_account_task_1 (cost=0.00..2,181.24 rows=44,419 width=4) (actual time=0.023..9.972 rows=44,902 loops=1)

  • Filter: (id > 0)
29. 14,093.814 31,244.759 ↓ 1.7 9,660 1

Subquery Scan on *SELECT* 2 (cost=16,823.41..10,190,606.02 rows=5,675 width=161) (actual time=203.213..31,244.759 rows=9,660 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (("*SELECT* 2".equipment_id IS NULL) AND ("*SELECT* 2".good_id IS NULL) AND (SubPlan 3)))
30. 2,601.026 2,772.059 ↓ 1.3 9,660 1

Hash Join (cost=2,799.43..6,308.09 rows=7,566 width=187) (actual time=18.089..2,772.059 rows=9,660 loops=1)

  • Hash Cond: (td.task_id = t.id)
31. 153.113 153.113 ↓ 1.3 9,660 1

Seq Scan on rent_account_task_document td (cost=0.00..2,792.80 rows=7,566 width=187) (actual time=0.141..153.113 rows=9,660 loops=1)

  • Filter: ((document IS NOT NULL) AND (((filename)::text ~~* '%.jpg'::text) OR ((filename)::text ~~* '%.jpeg'::text) OR ((filename)::text ~~* '%.png'::text)))
  • Rows Removed by Filter: 46055
32. 7.292 17.920 ↓ 1.0 44,914 1

Hash (cost=2,070.19..2,070.19 rows=44,419 width=4) (actual time=17.920..17.920 rows=44,914 loops=1)

  • Buckets: 4096 Batches: 2 Memory Usage: 796kB
33. 10.628 10.628 ↓ 1.0 44,914 1

Seq Scan on rent_account_task t (cost=0.00..2,070.19 rows=44,419 width=4) (actual time=0.005..10.628 rows=44,914 loops=1)

34.          

SubPlan (forSubquery Scan)

35. 112.115 208.344 ↓ 10.0 153,628 3

Hash Semi Join (cost=1,979.82..6,973.60 rows=15,358 width=4) (actual time=9.118..69.448 rows=153,628 loops=3)

  • Hash Cond: (equipment_1.administrator_id = subject_subject.id)
36. 68.940 68.940 ↓ 1.0 153,628 3

Seq Scan on equipment equipment_1 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.011..22.980 rows=153,628 loops=3)

37. 0.006 27.289 ↓ 11.0 11 1

Hash (cost=1,979.81..1,979.81 rows=1 width=4) (actual time=27.289..27.289 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
38. 27.283 27.283 ↓ 11.0 11 1

Seq Scan on subject_subject (cost=0.00..1,979.81 rows=1 width=4) (actual time=20.795..27.283 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 12644
39. 69.584 124.902 ↓ 10.0 153,628 2

Hash Semi Join (cost=1,979.82..6,973.60 rows=15,358 width=4) (actual time=10.337..62.451 rows=153,628 loops=2)

  • Hash Cond: (equipment_2.administrator_id = subject_subject_1.id)
40. 34.674 34.674 ↓ 1.0 153,628 2

Seq Scan on equipment equipment_2 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.006..17.337 rows=153,628 loops=2)

41. 0.006 20.644 ↓ 11.0 11 1

Hash (cost=1,979.81..1,979.81 rows=1 width=4) (actual time=20.644..20.644 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
42. 20.638 20.638 ↓ 11.0 11 1

Seq Scan on subject_subject subject_subject_1 (cost=0.00..1,979.81 rows=1 width=4) (actual time=18.799..20.638 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 12644
43. 14,035.668 14,045.640 ↑ 2.4 18,628 9,660

Materialize (cost=0.00..2,577.33 rows=44,419 width=4) (actual time=0.001..1.454 rows=18,628 loops=9,660)

44. 9.972 9.972 ↓ 1.0 44,902 1

Seq Scan on rent_account_task rent_account_task_1 (cost=0.00..2,181.24 rows=44,419 width=4) (actual time=0.023..9.972 rows=44,902 loops=1)

  • Filter: (id > 0)
45. 0.000 1,039.799 ↑ 894.0 98 1

Subquery Scan on *SELECT* 3 (cost=23,823.83..157,141,313.94 rows=87,612 width=137) (actual time=963.193..1,039.799 rows=98 loops=1)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (("*SELECT* 3".equipment_id IS NULL) AND ("*SELECT* 3".good_id IS NULL) AND (SubPlan 3)))
46. 4.256 925.083 ↑ 1,192.0 98 1

Hash Join (cost=9,799.85..102,346.63 rows=116,816 width=159) (actual time=848.549..925.083 rows=98 loops=1)

  • Hash Cond: ("*SELECT* 1_1".inspection_id = gid.inspection_id)
47. 3.714 873.698 ↑ 4.1 54,175 1

Append (cost=1,520.23..86,159.45 rows=224,647 width=16) (actual time=767.830..873.698 rows=54,175 loops=1)

48. 0.002 8.220 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_1 (cost=1,520.23..6,515.95 rows=1 width=12) (actual time=8.220..8.220 rows=0 loops=1)

49. 0.044 8.218 ↓ 0.0 0 1

Hash Join (cost=1,520.23..6,515.94 rows=1 width=12) (actual time=8.218..8.218 rows=0 loops=1)

  • Hash Cond: (eq_1.id = gi.unique_equipment_id)
50. 0.029 0.029 ↑ 153,578.0 1 1

Seq Scan on equipment eq_1 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.029..0.029 rows=1 loops=1)

51. 0.001 8.145 ↓ 0.0 0 1

Hash (cost=1,520.22..1,520.22 rows=1 width=8) (actual time=8.145..8.145 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
52. 8.144 8.144 ↓ 0.0 0 1

Seq Scan on rent_account_task_good_inspection gi (cost=0.00..1,520.22 rows=1 width=8) (actual time=8.144..8.144 rows=0 loops=1)

  • Filter: (unique_equipment_id IS NOT NULL)
  • Rows Removed by Filter: 54176
53. 49.771 861.764 ↑ 4.1 54,175 1

GroupAggregate (cost=71,780.89..77,397.04 rows=224,646 width=16) (actual time=759.609..861.764 rows=54,175 loops=1)

54. 231.924 811.993 ↑ 1.0 218,740 1

Sort (cost=71,780.89..72,342.50 rows=224,646 width=16) (actual time=759.593..811.993 rows=218,740 loops=1)

  • Sort Key: ra.administrator_id, gi_1.id, eq_2.good_id
  • Sort Method: external merge Disk: 5568kB
55. 131.511 580.069 ↑ 1.0 218,740 1

Hash Join (cost=26,120.27..47,973.40 rows=224,646 width=16) (actual time=272.890..580.069 rows=218,740 loops=1)

  • Hash Cond: (ae.equipment_id = eq_2.id)
56. 124.030 394.893 ↑ 1.0 218,740 1

Hash Join (cost=19,180.76..34,027.78 rows=224,646 width=12) (actual time=219.050..394.893 rows=218,740 loops=1)

  • Hash Cond: (ae.account_good_id = ag.id)
57. 51.902 51.902 ↓ 1.0 415,854 1

Seq Scan on rent_account_equipment ae (cost=0.00..6,629.19 rows=405,019 width=8) (actual time=0.004..51.902 rows=415,854 loops=1)

58. 10.188 218.961 ↑ 1.0 54,709 1

Hash (cost=18,206.29..18,206.29 rows=56,038 width=16) (actual time=218.961..218.961 rows=54,709 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 652kB
59. 27.047 208.773 ↑ 1.0 54,709 1

Hash Join (cost=8,817.06..18,206.29 rows=56,038 width=16) (actual time=56.303..208.773 rows=54,709 loops=1)

  • Hash Cond: (ag.account_id = ra.id)
60. 41.553 175.686 ↑ 1.0 54,709 1

Hash Join (cost=7,909.72..16,038.09 rows=56,038 width=16) (actual time=50.245..175.686 rows=54,709 loops=1)

  • Hash Cond: (tg_2.rag_id = ag.id)
61. 60.708 101.490 ↑ 1.0 54,709 1

Hash Join (cost=2,433.49..8,608.11 rows=56,038 width=8) (actual time=17.507..101.490 rows=54,709 loops=1)

  • Hash Cond: (tg_2.ratg_id = gi_1.task_good_id)
62. 23.432 23.432 ↑ 1.0 167,771 1

Seq Scan on ratg_rag tg_2 (cost=0.00..2,995.99 rows=170,599 width=8) (actual time=0.007..23.432 rows=167,771 loops=1)

63. 8.313 17.350 ↑ 1.0 54,176 1

Hash (cost=1,520.22..1,520.22 rows=55,622 width=8) (actual time=17.350..17.350 rows=54,176 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 533kB
64. 9.037 9.037 ↑ 1.0 54,176 1

Seq Scan on rent_account_task_good_inspection gi_1 (cost=0.00..1,520.22 rows=55,622 width=8) (actual time=0.006..9.037 rows=54,176 loops=1)

  • Filter: (task_good_id IS NOT NULL)
65. 15.249 32.643 ↓ 1.0 101,858 1

Hash (cost=3,818.32..3,818.32 rows=101,032 width=8) (actual time=32.643..32.643 rows=101,858 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 1001kB
66. 17.394 17.394 ↓ 1.0 101,858 1

Seq Scan on rent_account_good ag (cost=0.00..3,818.32 rows=101,032 width=8) (actual time=0.007..17.394 rows=101,858 loops=1)

67. 2.643 6.040 ↓ 1.0 16,303 1

Hash (cost=704.93..704.93 rows=16,193 width=8) (actual time=6.040..6.040 rows=16,303 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 637kB
68. 3.397 3.397 ↓ 1.0 16,303 1

Seq Scan on rent_account ra (cost=0.00..704.93 rows=16,193 width=8) (actual time=0.006..3.397 rows=16,303 loops=1)

69. 26.086 53.665 ↓ 1.0 153,628 1

Hash (cost=4,419.78..4,419.78 rows=153,578 width=8) (actual time=53.665..53.665 rows=153,628 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 766kB
70. 27.579 27.579 ↓ 1.0 153,628 1

Seq Scan on equipment eq_2 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.007..27.579 rows=153,628 loops=1)

71. 0.049 47.129 ↑ 1.1 98 1

Hash (cost=8,278.32..8,278.32 rows=104 width=155) (actual time=47.129..47.129 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
72. 5.273 47.080 ↑ 1.1 98 1

Hash Join (cost=6,040.52..8,278.32 rows=104 width=155) (actual time=36.738..47.080 rows=98 loops=1)

  • Hash Cond: (t_1.id = tg_1.task_id)
73. 5.136 5.136 ↓ 1.0 44,914 1

Seq Scan on rent_account_task t_1 (cost=0.00..2,070.19 rows=44,419 width=4) (actual time=0.011..5.136 rows=44,914 loops=1)

74. 0.035 36.671 ↑ 1.1 98 1

Hash (cost=6,039.22..6,039.22 rows=104 width=155) (actual time=36.671..36.671 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
75. 13.296 36.636 ↑ 1.1 98 1

Hash Join (cost=2,642.82..6,039.22 rows=104 width=155) (actual time=14.530..36.636 rows=98 loops=1)

  • Hash Cond: (tg_1.id = tgi.task_good_id)
76. 13.117 13.117 ↑ 1.0 167,282 1

Seq Scan on rent_account_task_good tg_1 (cost=0.00..2,749.44 rows=172,244 width=8) (actual time=0.008..13.117 rows=167,282 loops=1)

77. 0.041 10.223 ↑ 1.1 98 1

Hash (cost=2,641.52..2,641.52 rows=104 width=151) (actual time=10.223..10.223 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
78. 4.488 10.182 ↑ 1.1 98 1

Hash Join (cost=7.82..2,641.52 rows=104 width=151) (actual time=0.769..10.182 rows=98 loops=1)

  • Hash Cond: (tgi.id = gid.inspection_id)
79. 5.507 5.507 ↑ 1.0 54,176 1

Seq Scan on rent_account_task_good_inspection tgi (cost=0.00..1,520.22 rows=55,622 width=8) (actual time=0.006..5.507 rows=54,176 loops=1)

80. 0.025 0.187 ↑ 1.1 98 1

Hash (cost=6.52..6.52 rows=104 width=143) (actual time=0.187..0.187 rows=98 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
81. 0.162 0.162 ↑ 1.1 98 1

Seq Scan on rent_account_task_good_inspection_document gid (cost=0.00..6.52 rows=104 width=143) (actual time=0.038..0.162 rows=98 loops=1)

  • Filter: ((document IS NOT NULL) AND (((filename)::text ~~* '%.jpg'::text) OR ((filename)::text ~~* '%.jpeg'::text) OR ((filename)::text ~~* '%.png'::text)))
82.          

SubPlan (forSubquery Scan)

83. 112.115 208.344 ↓ 10.0 153,628 3

Hash Semi Join (cost=1,979.82..6,973.60 rows=15,358 width=4) (actual time=9.118..69.448 rows=153,628 loops=3)

  • Hash Cond: (equipment_1.administrator_id = subject_subject.id)
84. 68.940 68.940 ↓ 1.0 153,628 3

Seq Scan on equipment equipment_1 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.011..22.980 rows=153,628 loops=3)

85. 0.006 27.289 ↓ 11.0 11 1

Hash (cost=1,979.81..1,979.81 rows=1 width=4) (actual time=27.289..27.289 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
86. 27.283 27.283 ↓ 11.0 11 1

Seq Scan on subject_subject (cost=0.00..1,979.81 rows=1 width=4) (actual time=20.795..27.283 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 12644
87. 69.584 124.902 ↓ 10.0 153,628 2

Hash Semi Join (cost=1,979.82..6,973.60 rows=15,358 width=4) (actual time=10.337..62.451 rows=153,628 loops=2)

  • Hash Cond: (equipment_2.administrator_id = subject_subject_1.id)
88. 34.674 34.674 ↓ 1.0 153,628 2

Seq Scan on equipment equipment_2 (cost=0.00..4,419.78 rows=153,578 width=8) (actual time=0.006..17.337 rows=153,628 loops=2)

89. 0.006 20.644 ↓ 11.0 11 1

Hash (cost=1,979.81..1,979.81 rows=1 width=4) (actual time=20.644..20.644 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
90. 20.638 20.638 ↓ 11.0 11 1

Seq Scan on subject_subject subject_subject_1 (cost=0.00..1,979.81 rows=1 width=4) (actual time=18.799..20.638 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 12644
91. 14,035.668 14,045.640 ↑ 2.4 18,628 9,660

Materialize (cost=0.00..2,577.33 rows=44,419 width=4) (actual time=0.001..1.454 rows=18,628 loops=9,660)

92. 9.972 9.972 ↓ 1.0 44,902 1

Seq Scan on rent_account_task rent_account_task_1 (cost=0.00..2,181.24 rows=44,419 width=4) (actual time=0.023..9.972 rows=44,902 loops=1)

  • Filter: (id > 0)
93. 0.050 0.146 ↑ 1.0 185 1

Hash (cost=12.85..12.85 rows=185 width=13) (actual time=0.146..0.146 rows=185 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
94. 0.096 0.096 ↑ 1.0 185 1

Seq Scan on auth_user (cost=0.00..12.85 rows=185 width=13) (actual time=0.008..0.096 rows=185 loops=1)

95. 26.852 53.691 ↓ 1.0 153,628 1

Hash (cost=4,419.78..4,419.78 rows=153,578 width=23) (actual time=53.691..53.691 rows=153,628 loops=1)

  • Buckets: 2048 Batches: 16 Memory Usage: 461kB
96. 26.839 26.839 ↓ 1.0 153,628 1

Seq Scan on equipment (cost=0.00..4,419.78 rows=153,578 width=23) (actual time=0.007..26.839 rows=153,628 loops=1)

97. 22.475 43.068 ↓ 1.0 44,914 1

Hash (cost=2,070.19..2,070.19 rows=44,419 width=704) (actual time=43.068..43.068 rows=44,914 loops=1)

  • Buckets: 1024 Batches: 32 Memory Usage: 266kB
98. 20.593 20.593 ↓ 1.0 44,914 1

Seq Scan on rent_account_task (cost=0.00..2,070.19 rows=44,419 width=704) (actual time=0.005..20.593 rows=44,914 loops=1)

99. 0.276 1.852 ↓ 1.0 1,127 1

Hash (cost=286.86..286.86 rows=1,092 width=78) (actual time=1.852..1.852 rows=1,127 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 128kB
100. 0.324 1.576 ↓ 1.0 1,127 1

Hash Right Join (cost=102.08..286.86 rows=1,092 width=78) (actual time=0.683..1.576 rows=1,127 loops=1)

  • Hash Cond: (good_unique.rid = unique_good.id)
101. 0.608 0.792 ↓ 1.4 1,028 1

Bitmap Heap Scan on translation_field good_unique (cost=45.51..220.29 rows=727 width=33) (actual time=0.210..0.792 rows=1,028 loops=1)

  • Recheck Cond: (language_id = 2)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text))
  • Rows Removed by Filter: 1236
102. 0.184 0.184 ↑ 1.0 2,266 1

Bitmap Index Scan on translation_field_language_id (cost=0.00..45.33 rows=2,273 width=0) (actual time=0.184..0.184 rows=2,266 loops=1)

  • Index Cond: (language_id = 2)
103. 0.254 0.460 ↓ 1.0 1,127 1

Hash (cost=42.92..42.92 rows=1,092 width=49) (actual time=0.460..0.460 rows=1,127 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
104. 0.206 0.206 ↓ 1.0 1,127 1

Seq Scan on good unique_good (cost=0.00..42.92 rows=1,092 width=49) (actual time=0.003..0.206 rows=1,127 loops=1)

105. 0.277 1.565 ↓ 1.0 1,127 1

Hash (cost=286.86..286.86 rows=1,092 width=78) (actual time=1.565..1.565 rows=1,127 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 128kB
106. 0.314 1.288 ↓ 1.0 1,127 1

Hash Right Join (cost=102.08..286.86 rows=1,092 width=78) (actual time=0.570..1.288 rows=1,127 loops=1)

  • Hash Cond: (translation_field.rid = mass_good.id)
107. 0.438 0.577 ↓ 1.4 1,028 1

Bitmap Heap Scan on translation_field (cost=45.51..220.29 rows=727 width=33) (actual time=0.161..0.577 rows=1,028 loops=1)

  • Recheck Cond: (language_id = 2)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text))
  • Rows Removed by Filter: 1236
108. 0.139 0.139 ↑ 1.0 2,266 1

Bitmap Index Scan on translation_field_language_id (cost=0.00..45.33 rows=2,273 width=0) (actual time=0.139..0.139 rows=2,266 loops=1)

  • Index Cond: (language_id = 2)
109. 0.238 0.397 ↓ 1.0 1,127 1

Hash (cost=42.92..42.92 rows=1,092 width=49) (actual time=0.397..0.397 rows=1,127 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 93kB
110. 0.159 0.159 ↓ 1.0 1,127 1

Seq Scan on good mass_good (cost=0.00..42.92 rows=1,092 width=49) (actual time=0.002..0.159 rows=1,127 loops=1)

111. 0.002 28.588 ↑ 6.0 2 1

Hash (cost=10,000,003,667.37..10,000,003,667.37 rows=12 width=4) (actual time=28.588..28.588 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
112. 0.008 28.586 ↑ 6.0 2 1

HashAggregate (cost=10,000,003,667.25..10,000,003,667.37 rows=12 width=4) (actual time=28.585..28.586 rows=2 loops=1)

113. 0.003 28.578 ↑ 6.0 2 1

Nested Loop (cost=10,000,000,023.19..10,000,003,667.22 rows=12 width=4) (actual time=25.363..28.578 rows=2 loops=1)

114. 13.628 28.541 ↑ 6.0 2 1

Hash Join (cost=22.90..3,658.76 rows=12 width=8) (actual time=25.328..28.541 rows=2 loops=1)

  • Hash Cond: (ratg_rag.rag_id = rent_account_good.id)
115. 14.893 14.893 ↑ 1.0 167,771 1

Seq Scan on ratg_rag (cost=0.00..2,995.99 rows=170,599 width=8) (actual time=0.006..14.893 rows=167,771 loops=1)

116. 0.001 0.020 ↑ 7.0 1 1

Hash (cost=22.82..22.82 rows=7 width=8) (actual time=0.020..0.020 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
117. 0.019 0.019 ↑ 7.0 1 1

Index Scan using rent_account_good_account_id on rent_account_good (cost=0.42..22.82 rows=7 width=8) (actual time=0.018..0.019 rows=1 loops=1)

  • Index Cond: (account_id = 15309)
118. 0.004 0.034 ↑ 1.0 1 2

Materialize (cost=0.29..8.31 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=2)

119. 0.030 0.030 ↑ 1.0 1 1

Index Only Scan using rent_account_pkey on rent_account (cost=0.29..8.30 rows=1 width=4) (actual time=0.030..0.030 rows=1 loops=1)

  • Index Cond: (id = 15309)
  • Heap Fetches: 0