explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qu6O

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 1,875.593 ↑ 3,128.4 5 1

Sort (cost=156,399.96..156,439.07 rows=15,642 width=1,013) (actual time=1,875.593..1,875.593 rows=5 loops=1)

  • Sort Key: "*SELECT* 1".created_on
  • Sort Method: quicksort Memory: 27kB
2. 0.025 1,875.559 ↑ 3,128.4 5 1

WindowAgg (cost=33,772.16..141,408.25 rows=15,642 width=1,013) (actual time=1,875.556..1,875.559 rows=5 loops=1)

3. 5.587 1,875.534 ↑ 3,128.4 5 1

Hash Join (cost=33,772.16..141,212.73 rows=15,642 width=1,013) (actual time=1,834.764..1,875.534 rows=5 loops=1)

  • Hash Cond: ("*SELECT* 1".task_id = ratg_rag.task_id)
4. 15.298 1,838.241 ↓ 2.3 70,479 1

Hash Left Join (cost=28,924.18..136,247.29 rows=31,285 width=1,013) (actual time=449.648..1,838.241 rows=70,479 loops=1)

  • Hash Cond: ("*SELECT* 1".good_id = mass_good.id)
5. 22.215 1,820.964 ↓ 2.3 70,479 1

Hash Left Join (cost=28,658.30..135,551.25 rows=31,285 width=938) (actual time=447.659..1,820.964 rows=70,479 loops=1)

  • Hash Cond: (equipment.good_id = unique_good.id)
6. 82.178 1,797.282 ↓ 2.3 70,479 1

Hash Left Join (cost=28,392.43..134,855.20 rows=31,285 width=867) (actual time=446.167..1,797.282 rows=70,479 loops=1)

  • Hash Cond: ("*SELECT* 1".task_id = rent_account_task.id)
7. 62.380 1,688.852 ↓ 2.3 70,479 1

Hash Left Join (cost=24,067.65..125,839.26 rows=31,285 width=159) (actual time=398.900..1,688.852 rows=70,479 loops=1)

  • Hash Cond: ("*SELECT* 1".equipment_id = equipment.id)
8. 17.235 1,586.058 ↓ 2.3 70,479 1

Hash Join (cost=18,665.85..117,720.54 rows=31,285 width=140) (actual time=279.059..1,586.058 rows=70,479 loops=1)

  • Hash Cond: ("*SELECT* 1".created_by = auth_user.id)
9. 4.461 1,568.762 ↓ 1.7 70,479 1

Append (cost=18,649.43..117,236.90 rows=41,165 width=135) (actual time=278.974..1,568.762 rows=70,479 loops=1)

10. 0.000 491.521 ↓ 1.8 65,541 1

Subquery Scan on *SELECT* 1 (cost=18,649.43..25,240.45 rows=37,410 width=126) (actual time=278.974..491.521 rows=65,541 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 (hashed SubPlan 3)))
11. 60.375 283.804 ↓ 1.3 65,541 1

Hash Right Join (cost=8,474.58..14,200.21 rows=49,451 width=150) (actual time=175.758..283.804 rows=65,541 loops=1)

  • Hash Cond: (tgd.equipment_document_id = eq.id)
12. 39.585 83.606 ↑ 1.0 65,318 1

Hash Left Join (cost=3,860.18..6,996.43 rows=65,318 width=12) (actual time=35.813..83.606 rows=65,318 loops=1)

  • Hash Cond: (tgd.task_good_id = tg.id)
13. 8.380 8.380 ↑ 1.0 65,318 1

Seq Scan on rent_account_task_good_document tgd (cost=0.00..1,007.18 rows=65,318 width=8) (actual time=0.011..8.380 rows=65,318 loops=1)

14. 20.161 35.641 ↑ 1.0 121,208 1

Hash (cost=1,871.08..1,871.08 rows=121,208 width=8) (actual time=35.641..35.641 rows=121,208 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 601kB
15. 15.480 15.480 ↑ 1.0 121,208 1

Seq Scan on rent_account_task_good tg (cost=0.00..1,871.08 rows=121,208 width=8) (actual time=0.005..15.480 rows=121,208 loops=1)

16. 27.503 139.823 ↓ 1.3 65,541 1

Hash (cost=2,933.26..2,933.26 rows=49,451 width=146) (actual time=139.823..139.823 rows=65,541 loops=1)

  • Buckets: 1024 Batches: 16 Memory Usage: 745kB
17. 112.320 112.320 ↓ 1.3 65,541 1

Seq Scan on equipment_document eq (cost=0.00..2,933.26 rows=49,451 width=146) (actual time=0.015..112.320 rows=65,541 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: 1731
18.          

SubPlan (forSubquery Scan)

19. 88.327 137.418 ↓ 10.0 124,258 3

Hash Semi Join (cost=856.60..4,440.60 rows=12,426 width=4) (actual time=5.944..45.806 rows=124,258 loops=3)

  • Hash Cond: (equipment_1.administrator_id = subject_subject.id)
20. 31.293 31.293 ↑ 1.0 124,258 3

Seq Scan on equipment equipment_1 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.004..10.431 rows=124,258 loops=3)

21. 0.003 17.798 ↓ 11.0 11 1

Hash (cost=856.59..856.59 rows=1 width=4) (actual time=17.798..17.798 rows=11 loops=1)

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

Seq Scan on subject_subject (cost=0.00..856.59 rows=1 width=4) (actual time=0.012..17.795 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 11895
23. 55.734 94.494 ↓ 10.0 124,258 2

Hash Semi Join (cost=856.60..4,440.60 rows=12,426 width=4) (actual time=9.497..47.247 rows=124,258 loops=2)

  • Hash Cond: (equipment_2.administrator_id = subject_subject_1.id)
24. 19.800 19.800 ↑ 1.0 124,258 2

Seq Scan on equipment equipment_2 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.003..9.900 rows=124,258 loops=2)

25. 0.003 18.960 ↓ 11.0 11 1

Hash (cost=856.59..856.59 rows=1 width=4) (actual time=18.960..18.960 rows=11 loops=1)

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

Seq Scan on subject_subject subject_subject_1 (cost=0.00..856.59 rows=1 width=4) (actual time=0.014..18.957 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 11895
27. 6.037 6.037 ↑ 1.0 31,768 1

Seq Scan on rent_account_task rent_account_task_1 (cost=0.00..1,152.10 rows=31,768 width=4) (actual time=0.009..6.037 rows=31,768 loops=1)

  • Filter: (id > 0)
28. 0.000 284.332 ↓ 1.5 4,896 1

Subquery Scan on *SELECT* 2 (cost=11,769.63..14,012.23 rows=3,161 width=162) (actual time=168.667..284.332 rows=4,896 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 (hashed SubPlan 3)))
29. 5.439 121.779 ↓ 1.2 4,896 1

Hash Join (cost=1,594.78..3,763.62 rows=4,215 width=188) (actual time=9.100..121.779 rows=4,896 loops=1)

  • Hash Cond: (td.task_id = t.id)
30. 107.397 107.397 ↓ 1.2 4,896 1

Seq Scan on rent_account_task_document td (cost=0.00..1,746.07 rows=4,215 width=188) (actual time=0.132..107.397 rows=4,896 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: 31856
31. 4.841 8.943 ↑ 1.0 31,768 1

Hash (cost=1,072.68..1,072.68 rows=31,768 width=4) (actual time=8.943..8.943 rows=31,768 loops=1)

  • Buckets: 4096 Batches: 2 Memory Usage: 564kB
32. 4.102 4.102 ↑ 1.0 31,768 1

Seq Scan on rent_account_task t (cost=0.00..1,072.68 rows=31,768 width=4) (actual time=0.002..4.102 rows=31,768 loops=1)

33.          

SubPlan (forSubquery Scan)

34. 88.327 137.418 ↓ 10.0 124,258 3

Hash Semi Join (cost=856.60..4,440.60 rows=12,426 width=4) (actual time=5.944..45.806 rows=124,258 loops=3)

  • Hash Cond: (equipment_1.administrator_id = subject_subject.id)
35. 31.293 31.293 ↑ 1.0 124,258 3

Seq Scan on equipment equipment_1 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.004..10.431 rows=124,258 loops=3)

36. 0.003 17.798 ↓ 11.0 11 1

Hash (cost=856.59..856.59 rows=1 width=4) (actual time=17.798..17.798 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
37. 17.795 17.795 ↓ 11.0 11 1

Seq Scan on subject_subject (cost=0.00..856.59 rows=1 width=4) (actual time=0.012..17.795 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 11895
38. 55.734 94.494 ↓ 10.0 124,258 2

Hash Semi Join (cost=856.60..4,440.60 rows=12,426 width=4) (actual time=9.497..47.247 rows=124,258 loops=2)

  • Hash Cond: (equipment_2.administrator_id = subject_subject_1.id)
39. 19.800 19.800 ↑ 1.0 124,258 2

Seq Scan on equipment equipment_2 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.003..9.900 rows=124,258 loops=2)

40. 0.003 18.960 ↓ 11.0 11 1

Hash (cost=856.59..856.59 rows=1 width=4) (actual time=18.960..18.960 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
41. 18.957 18.957 ↓ 11.0 11 1

Seq Scan on subject_subject subject_subject_1 (cost=0.00..856.59 rows=1 width=4) (actual time=0.014..18.957 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 11895
42. 6.037 6.037 ↑ 1.0 31,768 1

Seq Scan on rent_account_task rent_account_task_1 (cost=0.00..1,152.10 rows=31,768 width=4) (actual time=0.009..6.037 rows=31,768 loops=1)

  • Filter: (id > 0)
43. 0.000 788.448 ↑ 14.1 42 1

Subquery Scan on *SELECT* 3 (cost=15,898.01..77,984.22 rows=594 width=544) (actual time=735.602..788.448 rows=42 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 (hashed SubPlan 3)))
44. 2.898 705.959 ↑ 18.9 42 1

Hash Join (cost=5,723.16..67,795.52 rows=792 width=1,064) (actual time=653.162..705.959 rows=42 loops=1)

  • Hash Cond: ("*SELECT* 1_1".inspection_id = gid.inspection_id)
45. 2.209 672.176 ↑ 3.9 40,205 1

Append (cost=1,026.08..60,911.35 rows=158,485 width=16) (actual time=593.318..672.176 rows=40,205 loops=1)

46. 0.001 3.341 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1_1 (cost=1,026.08..4,611.65 rows=1 width=12) (actual time=3.341..3.341 rows=0 loops=1)

47. 0.047 3.340 ↓ 0.0 0 1

Hash Join (cost=1,026.08..4,611.64 rows=1 width=12) (actual time=3.340..3.340 rows=0 loops=1)

  • Hash Cond: (eq_1.id = gi.unique_equipment_id)
48. 0.023 0.023 ↑ 124,258.0 1 1

Seq Scan on equipment eq_1 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.023..0.023 rows=1 loops=1)

49. 0.000 3.270 ↓ 0.0 0 1

Hash (cost=1,026.07..1,026.07 rows=1 width=8) (actual time=3.270..3.270 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 0kB
50. 3.270 3.270 ↓ 0.0 0 1

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

  • Filter: (unique_equipment_id IS NOT NULL)
  • Rows Removed by Filter: 40207
51. 34.815 666.626 ↑ 3.9 40,205 1

GroupAggregate (cost=50,752.76..54,714.86 rows=158,484 width=16) (actual time=589.974..666.626 rows=40,205 loops=1)

52. 181.246 631.811 ↓ 1.0 160,868 1

Sort (cost=50,752.76..51,148.97 rows=158,484 width=16) (actual time=589.969..631.811 rows=160,868 loops=1)

  • Sort Key: ra.administrator_id, gi_1.id, eq_2.good_id
  • Sort Method: external merge Disk: 4072kB
53. 110.352 450.565 ↓ 1.0 160,868 1

Hash Join (cost=19,515.25..34,355.51 rows=158,484 width=16) (actual time=200.727..450.565 rows=160,868 loops=1)

  • Hash Cond: (ae.equipment_id = eq_2.id)
54. 101.689 302.508 ↓ 1.0 160,868 1

Hash Join (cost=14,356.44..24,389.24 rows=158,484 width=12) (actual time=162.939..302.508 rows=160,868 loops=1)

  • Hash Cond: (ae.account_good_id = ag.id)
55. 37.985 37.985 ↑ 1.0 292,330 1

Seq Scan on rent_account_equipment ae (cost=0.00..4,504.30 rows=292,330 width=8) (actual time=0.004..37.985 rows=292,330 loops=1)

56. 7.886 162.834 ↓ 1.0 40,480 1

Hash (cost=13,653.27..13,653.27 rows=40,414 width=16) (actual time=162.834..162.834 rows=40,480 loops=1)

  • Buckets: 4096 Batches: 2 Memory Usage: 954kB
57. 19.491 154.948 ↓ 1.0 40,480 1

Hash Join (cost=5,633.80..13,653.27 rows=40,414 width=16) (actual time=36.741..154.948 rows=40,480 loops=1)

  • Hash Cond: (ag.account_id = ra.id)
58. 31.684 132.018 ↓ 1.0 40,480 1

Hash Join (cost=5,059.92..12,271.11 rows=40,414 width=16) (actual time=33.289..132.018 rows=40,480 loops=1)

  • Hash Cond: (tg_2.rag_id = ag.id)
59. 52.405 79.418 ↓ 1.0 40,480 1

Hash Join (cost=1,686.66..7,532.08 rows=40,414 width=8) (actual time=12.280..79.418 rows=40,480 loops=1)

  • Hash Cond: (tg_2.ratg_id = gi_1.task_good_id)
60. 14.838 14.838 ↑ 1.0 121,436 1

Seq Scan on ratg_rag tg_2 (cost=0.00..2,056.36 rows=121,436 width=8) (actual time=0.003..14.838 rows=121,436 loops=1)

61. 6.317 12.175 ↑ 1.0 40,207 1

Hash (cost=1,026.07..1,026.07 rows=40,207 width=8) (actual time=12.175..12.175 rows=40,207 loops=1)

  • Buckets: 4096 Batches: 2 Memory Usage: 793kB
62. 5.858 5.858 ↑ 1.0 40,207 1

Seq Scan on rent_account_task_good_inspection gi_1 (cost=0.00..1,026.07 rows=40,207 width=8) (actual time=0.003..5.858 rows=40,207 loops=1)

  • Filter: (task_good_id IS NOT NULL)
63. 11.197 20.916 ↑ 1.0 74,545 1

Hash (cost=2,149.45..2,149.45 rows=74,545 width=8) (actual time=20.916..20.916 rows=74,545 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 733kB
64. 9.719 9.719 ↑ 1.0 74,545 1

Seq Scan on rent_account_good ag (cost=0.00..2,149.45 rows=74,545 width=8) (actual time=0.003..9.719 rows=74,545 loops=1)

65. 1.786 3.439 ↑ 1.0 11,817 1

Hash (cost=426.17..426.17 rows=11,817 width=8) (actual time=3.439..3.439 rows=11,817 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 462kB
66. 1.653 1.653 ↑ 1.0 11,817 1

Seq Scan on rent_account ra (cost=0.00..426.17 rows=11,817 width=8) (actual time=0.002..1.653 rows=11,817 loops=1)

67. 20.862 37.705 ↑ 1.0 124,258 1

Hash (cost=3,119.58..3,119.58 rows=124,258 width=8) (actual time=37.705..37.705 rows=124,258 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 619kB
68. 16.843 16.843 ↑ 1.0 124,258 1

Seq Scan on equipment eq_2 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.003..16.843 rows=124,258 loops=1)

69. 0.015 30.885 ↓ 42.0 42 1

Hash (cost=4,697.07..4,697.07 rows=1 width=1,060) (actual time=30.885..30.885 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
70. 2.698 30.870 ↓ 42.0 42 1

Hash Join (cost=3,505.25..4,697.07 rows=1 width=1,060) (actual time=25.675..30.870 rows=42 loops=1)

  • Hash Cond: (t_1.id = tg_1.task_id)
71. 2.999 2.999 ↑ 1.0 31,768 1

Seq Scan on rent_account_task t_1 (cost=0.00..1,072.68 rows=31,768 width=4) (actual time=0.017..2.999 rows=31,768 loops=1)

72. 0.020 25.173 ↓ 42.0 42 1

Hash (cost=3,505.24..3,505.24 rows=1 width=1,060) (actual time=25.173..25.173 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
73. 10.032 25.153 ↓ 42.0 42 1

Hash Join (cost=1,179.62..3,505.24 rows=1 width=1,060) (actual time=10.849..25.153 rows=42 loops=1)

  • Hash Cond: (tg_1.id = tgi.task_good_id)
74. 8.190 8.190 ↑ 1.0 121,208 1

Seq Scan on rent_account_task_good tg_1 (cost=0.00..1,871.08 rows=121,208 width=8) (actual time=0.003..8.190 rows=121,208 loops=1)

75. 0.011 6.931 ↓ 42.0 42 1

Hash (cost=1,179.60..1,179.60 rows=1 width=1,056) (actual time=6.931..6.931 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
76. 3.376 6.920 ↓ 42.0 42 1

Hash Join (cost=2.75..1,179.60 rows=1 width=1,056) (actual time=0.546..6.920 rows=42 loops=1)

  • Hash Cond: (tgi.id = gid.inspection_id)
77. 3.478 3.478 ↑ 1.0 40,207 1

Seq Scan on rent_account_task_good_inspection tgi (cost=0.00..1,026.07 rows=40,207 width=8) (actual time=0.003..3.478 rows=40,207 loops=1)

78. 0.009 0.066 ↓ 42.0 42 1

Hash (cost=2.74..2.74 rows=1 width=1,048) (actual time=0.066..0.066 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
79. 0.057 0.057 ↓ 42.0 42 1

Seq Scan on rent_account_task_good_inspection_document gid (cost=0.00..2.74 rows=1 width=1,048) (actual time=0.011..0.057 rows=42 loops=1)

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

SubPlan (forSubquery Scan)

81. 88.327 137.418 ↓ 10.0 124,258 3

Hash Semi Join (cost=856.60..4,440.60 rows=12,426 width=4) (actual time=5.944..45.806 rows=124,258 loops=3)

  • Hash Cond: (equipment_1.administrator_id = subject_subject.id)
82. 31.293 31.293 ↑ 1.0 124,258 3

Seq Scan on equipment equipment_1 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.004..10.431 rows=124,258 loops=3)

83. 0.003 17.798 ↓ 11.0 11 1

Hash (cost=856.59..856.59 rows=1 width=4) (actual time=17.798..17.798 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
84. 17.795 17.795 ↓ 11.0 11 1

Seq Scan on subject_subject (cost=0.00..856.59 rows=1 width=4) (actual time=0.012..17.795 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 11895
85. 55.734 94.494 ↓ 10.0 124,258 2

Hash Semi Join (cost=856.60..4,440.60 rows=12,426 width=4) (actual time=9.497..47.247 rows=124,258 loops=2)

  • Hash Cond: (equipment_2.administrator_id = subject_subject_1.id)
86. 19.800 19.800 ↑ 1.0 124,258 2

Seq Scan on equipment equipment_2 (cost=0.00..3,119.58 rows=124,258 width=8) (actual time=0.003..9.900 rows=124,258 loops=2)

87. 0.003 18.960 ↓ 11.0 11 1

Hash (cost=856.59..856.59 rows=1 width=4) (actual time=18.960..18.960 rows=11 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
88. 18.957 18.957 ↓ 11.0 11 1

Seq Scan on subject_subject subject_subject_1 (cost=0.00..856.59 rows=1 width=4) (actual time=0.014..18.957 rows=11 loops=1)

  • Filter: ((classes ~~* '%|parent\_company|%'::text) OR (classes ~~* '%|partner|%'::text))
  • Rows Removed by Filter: 11895
89. 6.037 6.037 ↑ 1.0 31,768 1

Seq Scan on rent_account_task rent_account_task_1 (cost=0.00..1,152.10 rows=31,768 width=4) (actual time=0.009..6.037 rows=31,768 loops=1)

  • Filter: (id > 0)
90. 0.027 0.061 ↑ 1.0 152 1

Hash (cost=14.52..14.52 rows=152 width=13) (actual time=0.061..0.061 rows=152 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 7kB
91. 0.034 0.034 ↑ 1.0 152 1

Seq Scan on auth_user (cost=0.00..14.52 rows=152 width=13) (actual time=0.004..0.034 rows=152 loops=1)

92. 22.135 40.414 ↑ 1.0 124,258 1

Hash (cost=3,119.58..3,119.58 rows=124,258 width=23) (actual time=40.414..40.414 rows=124,258 loops=1)

  • Buckets: 2048 Batches: 8 Memory Usage: 743kB
93. 18.279 18.279 ↑ 1.0 124,258 1

Seq Scan on equipment (cost=0.00..3,119.58 rows=124,258 width=23) (actual time=0.003..18.279 rows=124,258 loops=1)

94. 15.492 26.252 ↑ 1.0 31,768 1

Hash (cost=1,072.68..1,072.68 rows=31,768 width=708) (actual time=26.252..26.252 rows=31,768 loops=1)

  • Buckets: 1024 Batches: 32 Memory Usage: 192kB
95. 10.760 10.760 ↑ 1.0 31,768 1

Seq Scan on rent_account_task (cost=0.00..1,072.68 rows=31,768 width=708) (actual time=0.008..10.760 rows=31,768 loops=1)

96. 0.260 1.467 ↑ 1.0 995 1

Hash (cost=253.44..253.44 rows=995 width=79) (actual time=1.467..1.467 rows=995 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 113kB
97. 0.270 1.207 ↑ 1.0 995 1

Hash Right Join (cost=94.71..253.44 rows=995 width=79) (actual time=0.522..1.207 rows=995 loops=1)

  • Hash Cond: (good_unique.rid = unique_good.id)
98. 0.447 0.581 ↓ 1.3 896 1

Bitmap Heap Scan on translation_field good_unique (cost=44.32..193.34 rows=707 width=34) (actual time=0.158..0.581 rows=896 loops=1)

  • Recheck Cond: (language_id = 2)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text))
  • Rows Removed by Filter: 1219
99. 0.134 0.134 ↑ 1.0 2,115 1

Bitmap Index Scan on translation_field_language_id (cost=0.00..44.15 rows=2,115 width=0) (actual time=0.134..0.134 rows=2,115 loops=1)

  • Index Cond: (language_id = 2)
100. 0.223 0.356 ↑ 1.0 995 1

Hash (cost=37.95..37.95 rows=995 width=49) (actual time=0.356..0.356 rows=995 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
101. 0.133 0.133 ↑ 1.0 995 1

Seq Scan on good unique_good (cost=0.00..37.95 rows=995 width=49) (actual time=0.002..0.133 rows=995 loops=1)

102. 0.340 1.979 ↑ 1.0 995 1

Hash (cost=253.44..253.44 rows=995 width=79) (actual time=1.979..1.979 rows=995 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 113kB
103. 0.425 1.639 ↑ 1.0 995 1

Hash Right Join (cost=94.71..253.44 rows=995 width=79) (actual time=0.699..1.639 rows=995 loops=1)

  • Hash Cond: (translation_field.rid = mass_good.id)
104. 0.572 0.729 ↓ 1.3 896 1

Bitmap Heap Scan on translation_field (cost=44.32..193.34 rows=707 width=34) (actual time=0.199..0.729 rows=896 loops=1)

  • Recheck Cond: (language_id = 2)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text))
  • Rows Removed by Filter: 1219
105. 0.157 0.157 ↑ 1.0 2,115 1

Bitmap Index Scan on translation_field_language_id (cost=0.00..44.15 rows=2,115 width=0) (actual time=0.157..0.157 rows=2,115 loops=1)

  • Index Cond: (language_id = 2)
106. 0.273 0.485 ↑ 1.0 995 1

Hash (cost=37.95..37.95 rows=995 width=49) (actual time=0.485..0.485 rows=995 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 82kB
107. 0.212 0.212 ↑ 1.0 995 1

Seq Scan on good mass_good (cost=0.00..37.95 rows=995 width=49) (actual time=0.002..0.212 rows=995 loops=1)

108. 0.003 31.706 ↑ 5.0 2 1

Hash (cost=4,847.86..4,847.86 rows=10 width=4) (actual time=31.706..31.706 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
109. 0.006 31.703 ↑ 5.0 2 1

HashAggregate (cost=4,847.76..4,847.86 rows=10 width=4) (actual time=31.703..31.703 rows=2 loops=1)

110. 11.736 31.697 ↓ 1.5 15 1

Hash Join (cost=2,335.89..4,847.73 rows=10 width=4) (actual time=31.672..31.697 rows=15 loops=1)

  • Hash Cond: (ratg_rag.rag_id = rent_account_good.id)
111. 10.993 10.993 ↑ 1.0 121,436 1

Seq Scan on ratg_rag (cost=0.00..2,056.36 rows=121,436 width=8) (actual time=0.007..10.993 rows=121,436 loops=1)

112. 0.011 8.968 ↓ 2.5 15 1

Hash (cost=2,335.81..2,335.81 rows=6 width=4) (actual time=8.968..8.968 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
113. 8.957 8.957 ↓ 2.5 15 1

Seq Scan on rent_account_good (cost=0.00..2,335.81 rows=6 width=4) (actual time=1.463..8.957 rows=15 loops=1)

  • Filter: (account_id = 12700)
  • Rows Removed by Filter: 74530