explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RkNs

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 19,325.374 ↓ 4.5 50 1

Limit (cost=327,066,111.57..327,066,112.51 rows=11 width=2,983) (actual time=19,325.270..19,325.374 rows=50 loops=1)

2. 0.328 19,325.370 ↓ 4.5 50 1

WindowAgg (cost=327,066,111.57..327,066,112.51 rows=11 width=2,983) (actual time=19,325.269..19,325.370 rows=50 loops=1)

3. 2.585 19,325.042 ↓ 8.4 92 1

GroupAggregate (cost=327,066,111.57..327,066,112.23 rows=11 width=2,983) (actual time=19,322.659..19,325.042 rows=92 loops=1)

4. 0.940 19,322.457 ↓ 8.5 93 1

Sort (cost=327,066,111.57..327,066,111.60 rows=11 width=2,983) (actual time=19,322.445..19,322.457 rows=93 loops=1)

  • Sort Key: rent_account_task_good_inspection.id, rent_account_task.id, good.id, task_user.id, inspection_user.id, equipment.serial_no, (COALESCE(translation_field.value, (good.title)::text)), rent_account_task_good_inspection_helper.equipment_quantity
  • Sort Method: quicksort Memory: 194kB
5. 0.367 19,321.517 ↓ 8.5 93 1

Nested Loop Semi Join (cost=6,304.50..327,066,111.38 rows=11 width=2,983) (actual time=3,001.778..19,321.517 rows=93 loops=1)

6. 1.020 19,314.361 ↓ 4.2 93 1

Nested Loop Semi Join (cost=6,302.09..327,065,922.11 rows=22 width=2,987) (actual time=3,001.611..19,314.361 rows=93 loops=1)

  • Join Filter: (equipment.warehouse_id = warehouse.id)
  • Rows Removed by Join Filter: 2756
7. 13.240 19,312.736 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,302.09..327,065,901.58 rows=1,274 width=2,991) (actual time=1,356.599..19,312.736 rows=605 loops=1)

  • Join Filter: (inspection_user.id = rent_account_task_good_inspection.inspection_confirmed_user_id)
  • Rows Removed by Join Filter: 120395
8. 14.453 19,289.816 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,302.09..327,062,111.45 rows=1,274 width=2,157) (actual time=1,356.326..19,289.816 rows=605 loops=1)

  • Join Filter: (task_user.id = rent_account_task_good_inspection.task_confirmed_user_id)
  • Rows Removed by Join Filter: 119790
9. 3.987 19,265.683 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,302.09..327,058,321.31 rows=1,274 width=1,323) (actual time=1,356.151..19,265.683 rows=605 loops=1)

10. 1.477 19,222.371 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,292.50..327,040,977.99 rows=1,274 width=1,327) (actual time=1,356.058..19,222.371 rows=605 loops=1)

11. 2.149 19,183.989 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,292.22..327,039,506.14 rows=1,274 width=1,298) (actual time=1,355.969..19,183.989 rows=605 loops=1)

  • Join Filter: (address_country.id = address_address.country_id)
  • Rows Removed by Join Filter: 8470
12. 752.115 19,181.235 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,292.22..327,039,237.43 rows=1,274 width=1,298) (actual time=1,355.952..19,181.235 rows=605 loops=1)

  • Join Filter: (address_address.id = subject_object.address_id)
  • Rows Removed by Join Filter: 8378645
13. 759.010 17,978.395 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,292.22..326,768,064.60 rows=1,274 width=1,298) (actual time=1,355.797..17,978.395 rows=605 loops=1)

  • Join Filter: (subject_object.id = rent_account.object_id)
  • Rows Removed by Join Filter: 8305440
14. 1.733 16,776.525 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,292.22..326,502,946.35 rows=1,274 width=1,298) (actual time=1,354.013..16,776.525 rows=605 loops=1)

15. 1,218.306 16,767.532 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,291.93..326,501,293.68 rows=1,274 width=1,283) (actual time=1,353.961..16,767.532 rows=605 loops=1)

  • Join Filter: (rent_account.id = rent_account_good.account_id)
  • Rows Removed by Join Filter: 12714680
16. 1.615 13,732.411 ↑ 2.1 605 1

Nested Loop Left Join (cost=6,291.93..325,182,889.59 rows=1,274 width=1,042) (actual time=1,352.719..13,732.411 rows=605 loops=1)

17. 1.509 13,724.141 ↑ 2.1 605 1

Nested Loop (cost=6,291.51..325,182,241.40 rows=1,274 width=1,042) (actual time=1,352.668..13,724.141 rows=605 loops=1)

18. 72.840 13,719.002 ↑ 2.1 605 1

Nested Loop (cost=6,291.23..325,181,748.37 rows=1,274 width=1,027) (actual time=1,352.638..13,719.002 rows=605 loops=1)

  • Join Filter: (equipment.good_id = good.id)
  • Rows Removed by Join Filter: 726000
19. 1.732 13,583.847 ↑ 2.1 605 1

Nested Loop (cost=6,291.23..325,158,957.60 rows=1,274 width=845) (actual time=1,351.787..13,583.847 rows=605 loops=1)

20. 3,732.193 13,574.855 ↑ 2.1 605 1

Nested Loop (cost=6,290.81..325,158,297.68 rows=1,274 width=831) (actual time=1,351.743..13,574.855 rows=605 loops=1)

  • Join Filter: (rent_account_task_good_inspection.id = rent_account_task_good_inspection_helper.inspection_id)
  • Rows Removed by Join Filter: 41132740
21. 2.137 4,734.647 ↓ 2.0 605 1

Nested Loop Left Join (cost=6,290.10..323,249,019.08 rows=301 width=811) (actual time=226.902..4,734.647 rows=605 loops=1)

22. 2,011.452 4,707.746 ↓ 2.0 604 1

Index Scan using rent_account_task_good_inspection_pkey on rent_account_task_good_inspection (cost=6,288.97..323,246,581.37 rows=300 width=106) (actual time=226.786..4,707.746 rows=604 loops=1)

  • Filter: (((status)::text <> 'new'::text) AND ((status)::text ~~* '%confirmed\_for\_inspection%'::text) AND ((unique_equipment_id IS NOT NULL) OR (SubPlan 1)))
  • Rows Removed by Filter: 67382
23.          

SubPlan (forIndex Scan)

24. 2,397.596 2,696.294 ↓ 1.1 35,949 607

Materialize (cost=6,288.68..15,710.56 rows=33,282 width=4) (actual time=0.956..4.442 rows=35,949 loops=607)

25. 37.437 298.698 ↓ 2.0 67,973 1

Hash Join (cost=6,288.68..15,413.15 rows=33,282 width=4) (actual time=140.887..298.698 rows=67,973 loops=1)

  • Hash Cond: (rent_account_task_good_2.task_id = rent_account_task_2.id)
26. 90.560 147.031 ↑ 1.0 67,986 1

Hash Join (cost=3,220.32..10,946.90 rows=68,013 width=8) (actual time=26.604..147.031 rows=67,986 loops=1)

  • Hash Cond: (rent_account_task_good_2.id = rent_account_task_good_inspection_2.task_good_id)
27. 30.023 30.023 ↑ 1.0 213,459 1

Seq Scan on rent_account_task_good rent_account_task_good_2 (cost=0.00..3,504.97 rows=213,797 width=8) (actual time=0.006..30.023 rows=213,459 loops=1)

28. 11.945 26.448 ↑ 1.0 67,986 1

Hash (cost=2,104.16..2,104.16 rows=68,013 width=8) (actual time=26.448..26.448 rows=67,986 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 670kB
29. 14.503 14.503 ↑ 1.0 67,986 1

Seq Scan on rent_account_task_good_inspection rent_account_task_good_inspection_2 (cost=0.00..2,104.16 rows=68,013 width=8) (actual time=0.015..14.503 rows=67,986 loops=1)

  • Filter: (task_good_id > 0)
30. 86.888 114.230 ↓ 1.0 27,905 1

Hash (cost=2,614.75..2,614.75 rows=27,648 width=4) (actual time=114.230..114.230 rows=27,905 loops=1)

  • Buckets: 4096 Batches: 2 Memory Usage: 497kB
31. 27.342 27.342 ↓ 1.0 27,905 1

Seq Scan on rent_account_task rent_account_task_2 (cost=0.00..2,614.75 rows=27,648 width=4) (actual time=0.022..27.342 rows=27,905 loops=1)

  • Filter: (((status)::text <> 'not_done'::text) AND ((status)::text = 'completed'::text) AND ((type)::text = 'return'::text))
  • Rows Removed by Filter: 29019
32. 1.208 24.764 ↑ 1.0 1 604

Nested Loop Left Join (cost=1.13..8.12 rows=1 width=709) (actual time=0.036..0.041 rows=1 loops=604)

33. 2.416 16.912 ↑ 1.0 1 604

Nested Loop Left Join (cost=0.71..7.63 rows=1 width=705) (actual time=0.026..0.028 rows=1 loops=604)

34. 8.456 8.456 ↑ 1.0 1 604

Index Scan using rent_account_task_good_pkey on rent_account_task_good (cost=0.42..7.26 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=604)

  • Index Cond: (id = rent_account_task_good_inspection.task_good_id)
35. 6.040 6.040 ↑ 1.0 1 604

Index Scan using rent_account_task_pkey on rent_account_task (cost=0.29..0.35 rows=1 width=701) (actual time=0.009..0.010 rows=1 loops=604)

  • Index Cond: (id = rent_account_task_good.task_id)
  • Filter: (((status)::text <> 'not_done'::text) AND ((status)::text = 'completed'::text) AND ((type)::text = 'return'::text))
36. 6.644 6.644 ↑ 1.0 1 604

Index Scan using ratg_rag_ratg_id on ratg_rag (cost=0.42..0.48 rows=1 width=8) (actual time=0.008..0.011 rows=1 loops=604)

  • Index Cond: (ratg_id = rent_account_task_good.id)
37. 3,846.832 5,108.015 ↑ 4.2 67,989 605

Materialize (cost=0.71..106,795.86 rows=287,420 width=20) (actual time=1.829..8.443 rows=67,989 loops=605)

38. 7.007 1,261.183 ↑ 4.2 67,989 1

Subquery Scan on rent_account_task_good_inspection_helper (cost=0.71..103,673.76 rows=287,420 width=20) (actual time=1,104.913..1,261.183 rows=67,989 loops=1)

39. 5.125 1,254.176 ↑ 4.2 67,989 1

Append (cost=0.71..100,799.56 rows=287,420 width=16) (actual time=1,104.912..1,254.176 rows=67,989 loops=1)

40. 0.001 0.007 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=0.71..16.77 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=1)

41. 0.001 0.006 ↓ 0.0 0 1

Nested Loop (cost=0.71..16.76 rows=1 width=12) (actual time=0.006..0.006 rows=0 loops=1)

42. 0.005 0.005 ↓ 0.0 0 1

Index Scan using rent_account_task_good_inspection_unique_equipment_id on rent_account_task_good_inspection gi (cost=0.29..8.31 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: (unique_equipment_id IS NOT NULL)
43. 0.000 0.000 ↓ 0.0 0

Index Scan using equipment_pkey on equipment eq (cost=0.42..8.44 rows=1 width=8) (never executed)

  • Index Cond: (id = gi.unique_equipment_id)
44. 70.152 1,249.044 ↑ 4.2 67,989 1

GroupAggregate (cost=90,723.12..97,908.60 rows=287,419 width=16) (actual time=1,104.902..1,249.044 rows=67,989 loops=1)

45. 372.398 1,178.892 ↓ 1.0 288,352 1

Sort (cost=90,723.12..91,441.67 rows=287,419 width=16) (actual time=1,104.886..1,178.892 rows=288,352 loops=1)

  • Sort Key: ra.administrator_id, gi_1.id, eq_1.good_id
  • Sort Method: external merge Disk: 7320kB
46. 191.877 806.494 ↓ 1.0 288,352 1

Hash Join (cost=31,705.00..59,750.57 rows=287,419 width=16) (actual time=352.964..806.494 rows=288,352 loops=1)

  • Hash Cond: (ae.equipment_id = eq_1.id)
47. 187.908 550.092 ↓ 1.0 288,352 1

Hash Join (cost=23,173.11..42,337.58 rows=287,419 width=12) (actual time=288.279..550.092 rows=288,352 loops=1)

  • Hash Cond: (ae.account_good_id = ag.id)
48. 74.012 74.012 ↓ 1.0 556,382 1

Seq Scan on rent_account_equipment ae (cost=0.00..8,923.52 rows=548,752 width=8) (actual time=0.006..74.012 rows=556,382 loops=1)

49. 13.635 288.172 ↓ 1.0 68,671 1

Hash (cost=21,981.69..21,981.69 rows=68,513 width=16) (actual time=288.172..288.172 rows=68,671 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 818kB
50. 33.509 274.537 ↓ 1.0 68,671 1

Hash Join (cost=10,368.26..21,981.69 rows=68,513 width=16) (actual time=74.716..274.537 rows=68,671 loops=1)

  • Hash Cond: (ag.account_id = ra.id)
51. 49.769 233.373 ↓ 1.0 68,671 1

Hash Join (cost=9,318.47..19,647.28 rows=68,513 width=16) (actual time=67.038..233.373 rows=68,671 loops=1)

  • Hash Cond: (tg.rag_id = ag.id)
52. 86.569 140.283 ↓ 1.0 68,671 1

Hash Join (cost=3,050.29..11,133.12 rows=68,513 width=8) (actual time=23.431..140.283 rows=68,671 loops=1)

  • Hash Cond: (tg.ratg_id = gi_1.task_good_id)
53. 30.443 30.443 ↑ 1.0 214,114 1

Seq Scan on ratg_rag tg (cost=0.00..3,842.83 rows=214,783 width=8) (actual time=0.005..30.443 rows=214,114 loops=1)

54. 11.421 23.271 ↑ 1.0 67,986 1

Hash (cost=1,934.13..1,934.13 rows=68,013 width=8) (actual time=23.271..23.271 rows=67,986 loops=1)

  • Buckets: 4096 Batches: 4 Memory Usage: 670kB
55. 11.850 11.850 ↑ 1.0 67,986 1

Seq Scan on rent_account_task_good_inspection gi_1 (cost=0.00..1,934.13 rows=68,013 width=8) (actual time=0.004..11.850 rows=67,986 loops=1)

  • Filter: (task_good_id IS NOT NULL)
56. 21.511 43.321 ↑ 1.0 130,653 1

Hash (cost=4,122.08..4,122.08 rows=130,808 width=8) (actual time=43.321..43.321 rows=130,653 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 645kB
57. 21.810 21.810 ↑ 1.0 130,653 1

Seq Scan on rent_account_good ag (cost=0.00..4,122.08 rows=130,808 width=8) (actual time=0.005..21.810 rows=130,653 loops=1)

58. 3.450 7.655 ↓ 1.0 21,017 1

Hash (cost=787.13..787.13 rows=21,013 width=8) (actual time=7.655..7.655 rows=21,017 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 821kB
59. 4.205 4.205 ↓ 1.0 21,017 1

Seq Scan on rent_account ra (cost=0.00..787.13 rows=21,013 width=8) (actual time=0.004..4.205 rows=21,017 loops=1)

60. 30.549 64.525 ↑ 1.0 174,884 1

Hash (cost=5,661.84..5,661.84 rows=174,884 width=8) (actual time=64.525..64.525 rows=174,884 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 871kB
61. 33.976 33.976 ↑ 1.0 174,884 1

Seq Scan on equipment eq_1 (cost=0.00..5,661.84 rows=174,884 width=8) (actual time=0.012..33.976 rows=174,884 loops=1)

62. 7.260 7.260 ↑ 1.0 1 605

Index Scan using equipment_pkey on equipment (cost=0.42..0.51 rows=1 width=22) (actual time=0.010..0.012 rows=1 loops=605)

  • Index Cond: (id = rent_account_task_good_inspection_helper.equipment_id)
63. 61.904 62.315 ↓ 1.0 1,201 605

Materialize (cost=0.00..52.85 rows=1,190 width=186) (actual time=0.000..0.103 rows=1,201 loops=605)

64. 0.411 0.411 ↓ 1.0 1,201 1

Seq Scan on good (cost=0.00..46.90 rows=1,190 width=186) (actual time=0.008..0.411 rows=1,201 loops=1)

65. 3.630 3.630 ↑ 1.0 1 605

Index Scan using subject_subject_pkey on subject_subject administrator (cost=0.29..0.38 rows=1 width=23) (actual time=0.005..0.006 rows=1 loops=605)

  • Index Cond: (id = rent_account_task_good_inspection_helper.administrator_id)
66. 6.655 6.655 ↑ 1.0 1 605

Index Scan using rent_account_good_pkey on rent_account_good (cost=0.42..0.50 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=605)

  • Index Cond: (id = ratg_rag.rag_id)
67. 1,810.813 1,816.815 ↓ 1.0 21,017 605

Materialize (cost=0.00..1,611.19 rows=21,013 width=249) (actual time=0.003..3.003 rows=21,017 loops=605)

68. 6.002 6.002 ↓ 1.0 21,017 1

Seq Scan on rent_account (cost=0.00..787.13 rows=21,013 width=249) (actual time=0.016..6.002 rows=21,017 loops=1)

69. 7.260 7.260 ↑ 1.0 1 605

Index Scan using subject_subject_pkey on subject_subject client (cost=0.29..1.29 rows=1 width=23) (actual time=0.010..0.012 rows=1 loops=605)

  • Index Cond: (id = rent_account.client_id)
70. 440.152 442.860 ↑ 1.0 13,729 605

Materialize (cost=0.00..536.71 rows=13,847 width=8) (actual time=0.000..0.732 rows=13,729 loops=605)

71. 2.708 2.708 ↑ 1.0 13,729 1

Seq Scan on subject_object (cost=0.00..467.47 rows=13,847 width=8) (actual time=0.012..2.708 rows=13,729 loops=1)

72. 448.621 450.725 ↑ 1.0 13,850 605

Materialize (cost=0.00..419.55 rows=14,170 width=8) (actual time=0.000..0.745 rows=13,850 loops=605)

73. 2.104 2.104 ↑ 1.0 13,850 1

Seq Scan on address_address (cost=0.00..348.70 rows=14,170 width=8) (actual time=0.005..2.104 rows=13,850 loops=1)

74. 0.600 0.605 ↓ 1.1 15 605

Materialize (cost=0.00..1.21 rows=14 width=4) (actual time=0.000..0.001 rows=15 loops=605)

75. 0.005 0.005 ↓ 1.1 15 1

Seq Scan on address_country (cost=0.00..1.14 rows=14 width=4) (actual time=0.004..0.005 rows=15 loops=1)

76. 36.905 36.905 ↑ 1.0 1 605

Index Scan using translation_field_rid on translation_field (cost=0.29..1.15 rows=1 width=33) (actual time=0.028..0.061 rows=1 loops=605)

  • Index Cond: (rid = good.id)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text) AND (language_id = 1))
  • Rows Removed by Filter: 50
77. 7.260 39.325 ↑ 1.0 1 605

Bitmap Heap Scan on translation_field address_country_aliased (cost=9.58..13.60 rows=1 width=4) (actual time=0.061..0.065 rows=1 loops=605)

  • Recheck Cond: ((rid = address_country.id) AND ((tablename)::text = 'address_country'::text))
  • Filter: (((fieldname)::text = 'title'::text) AND (language_id = 1))
  • Rows Removed by Filter: 10
78. 3.630 32.065 ↓ 0.0 0 605

BitmapAnd (cost=9.58..9.58 rows=1 width=0) (actual time=0.053..0.053 rows=0 loops=605)

79. 9.680 9.680 ↓ 12.0 108 605

Bitmap Index Scan on translation_field_rid (cost=0.00..4.07 rows=9 width=0) (actual time=0.016..0.016 rows=108 loops=605)

  • Index Cond: (rid = address_country.id)
80. 18.755 18.755 ↑ 1.0 130 605

Bitmap Index Scan on translation_field_tablename (cost=0.00..5.26 rows=130 width=0) (actual time=0.031..0.031 rows=130 loops=605)

  • Index Cond: ((tablename)::text = 'address_country'::text)
81. 9.567 9.680 ↓ 1.0 199 605

Materialize (cost=0.00..25.95 rows=197 width=834) (actual time=0.000..0.016 rows=199 loops=605)

82. 0.113 0.113 ↓ 1.0 199 1

Seq Scan on auth_user task_user (cost=0.00..24.97 rows=197 width=834) (actual time=0.008..0.113 rows=199 loops=1)

83. 9.579 9.680 ↓ 1.0 199 605

Materialize (cost=0.00..25.95 rows=197 width=834) (actual time=0.000..0.016 rows=199 loops=605)

84. 0.101 0.101 ↓ 1.0 199 1

Seq Scan on auth_user inspection_user (cost=0.00..24.97 rows=197 width=834) (actual time=0.003..0.101 rows=199 loops=1)

85. 0.590 0.605 ↓ 5.0 5 605

Materialize (cost=0.00..1.42 rows=1 width=4) (actual time=0.000..0.001 rows=5 loops=605)

86. 0.015 0.015 ↓ 5.0 5 1

Seq Scan on warehouse (cost=0.00..1.42 rows=1 width=4) (actual time=0.012..0.015 rows=5 loops=1)

  • Filter: ((administrator_id = 14) AND ((state)::text = 'active'::text))
  • Rows Removed by Filter: 23
87. 0.186 6.789 ↑ 1.0 1 93

Nested Loop Semi Join (cost=2.41..8.98 rows=1 width=4) (actual time=0.073..0.073 rows=1 loops=93)

88. 0.186 2.418 ↑ 1.0 1 93

Nested Loop (cost=1.00..1.24 rows=1 width=12) (actual time=0.026..0.026 rows=1 loops=93)

89. 0.372 1.674 ↑ 1.0 1 93

Nested Loop (cost=0.71..0.90 rows=1 width=8) (actual time=0.018..0.018 rows=1 loops=93)

90. 0.744 0.744 ↑ 1.0 1 93

Index Scan using rent_account_task_good_inspection_pkey on rent_account_task_good_inspection rent_account_task_good_inspection_1 (cost=0.29..0.33 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=93)

  • Index Cond: (id = rent_account_task_good_inspection_helper.inspection_id)
91. 0.558 0.558 ↑ 1.0 1 93

Index Scan using rent_account_task_good_pkey on rent_account_task_good rent_account_task_good_1 (cost=0.42..0.56 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=93)

  • Index Cond: (id = rent_account_task_good_inspection_1.task_good_id)
92. 0.558 0.558 ↑ 1.0 1 93

Index Only Scan using rent_account_task_pkey on rent_account_task rent_account_task_1 (cost=0.29..0.33 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=93)

  • Index Cond: (id = rent_account_task_good_1.task_id)
  • Heap Fetches: 78
93. 0.279 4.185 ↑ 6.0 1 93

Nested Loop Semi Join (cost=1.41..7.74 rows=6 width=4) (actual time=0.045..0.045 rows=1 loops=93)

94. 0.279 3.069 ↑ 6.0 1 93

Nested Loop (cost=1.12..5.67 rows=6 width=8) (actual time=0.033..0.033 rows=1 loops=93)

95. 0.279 1.953 ↑ 6.0 1 93

Nested Loop (cost=0.84..3.65 rows=6 width=8) (actual time=0.021..0.021 rows=1 loops=93)

96. 1.116 1.116 ↑ 6.0 1 93

Index Scan using ratg_rag_task_id on ratg_rag ratg_rag_1 (cost=0.42..0.58 rows=6 width=8) (actual time=0.012..0.012 rows=1 loops=93)

  • Index Cond: (task_id = rent_account_task_good_1.task_id)
97. 0.558 0.558 ↑ 1.0 1 93

Index Scan using rent_account_good_pkey on rent_account_good rent_account_good_1 (cost=0.42..0.50 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=93)

  • Index Cond: (id = ratg_rag_1.rag_id)
98. 0.837 0.837 ↑ 1.0 1 93

Index Scan using rent_account_pkey on rent_account rent_account_1 (cost=0.29..0.33 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=93)

  • Index Cond: (id = rent_account_good_1.account_id)
99. 0.837 0.837 ↑ 1.0 1 93

Index Scan using subject_administrator_subject_id on subject_administrator (cost=0.29..0.33 rows=1 width=4) (actual time=0.009..0.009 rows=1 loops=93)

  • Index Cond: (subject_id = rent_account_1.client_id)
  • Filter: (administrator_subject_id = 14)