explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DrJj

Settings
# exclusive inclusive rows x rows loops node
1. 0.105 2,465.229 ↓ 50.0 50 1

Limit (cost=104,862.31..104,862.39 rows=1 width=2,844) (actual time=2,464.892..2,465.229 rows=50 loops=1)

2. 0.504 2,465.124 ↓ 50.0 50 1

WindowAgg (cost=104,862.31..104,862.39 rows=1 width=2,844) (actual time=2,464.890..2,465.124 rows=50 loops=1)

3. 2.296 2,464.620 ↓ 77.0 77 1

GroupAggregate (cost=104,862.31..104,862.36 rows=1 width=2,804) (actual time=2,462.413..2,464.620 rows=77 loops=1)

  • Group 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)), ((1)::bigint)
4. 0.535 2,462.324 ↓ 78.0 78 1

Sort (cost=104,862.31..104,862.32 rows=1 width=2,983) (actual time=2,462.309..2,462.324 rows=78 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)), ((1)::bigint)
  • Sort Method: quicksort Memory: 162kB
5. 0.243 2,461.789 ↓ 78.0 78 1

Nested Loop Semi Join (cost=12,637.09..104,862.30 rows=1 width=2,983) (actual time=1,254.724..2,461.789 rows=78 loops=1)

6. 0.713 2,458.348 ↓ 78.0 78 1

Nested Loop (cost=12,634.68..104,853.63 rows=1 width=2,984) (actual time=1,254.667..2,458.348 rows=78 loops=1)

  • Join Filter: (equipment.warehouse_id = warehouse.id)
  • Rows Removed by Join Filter: 2737
7. 0.045 0.045 ↓ 5.0 5 1

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

  • Filter: ((administrator_id = 14) AND ((state)::text = 'active'::text))
  • Rows Removed by Filter: 23
8. 49.400 2,457.590 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,634.68..104,852.16 rows=4 width=2,988) (actual time=246.073..491.518 rows=563 loops=5)

  • Join Filter: (inspection_user.id = rent_account_task_good_inspection.inspection_confirmed_user_id)
  • Rows Removed by Join Filter: 111474
9. 30.210 2,380.040 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,634.68..104,819.80 rows=4 width=2,155) (actual time=245.995..476.008 rows=563 loops=5)

  • Join Filter: (task_user.id = rent_account_task_good_inspection.task_confirmed_user_id)
  • Rows Removed by Join Filter: 56418
10. 8.710 2,335.755 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,634.68..104,787.45 rows=4 width=1,322) (actual time=245.982..467.151 rows=563 loops=5)

11. 4.720 2,256.670 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,625.34..104,733.99 rows=4 width=1,326) (actual time=245.940..451.334 rows=563 loops=5)

12. 5.470 2,181.575 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,625.06..104,729.71 rows=4 width=1,297) (actual time=245.919..436.315 rows=563 loops=5)

  • Join Filter: (address_country.id = address_address.country_id)
  • Rows Removed by Join Filter: 2810
13. 3.105 2,176.105 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,625.06..104,727.62 rows=4 width=1,297) (actual time=245.914..435.221 rows=563 loops=5)

14. 3.350 2,164.555 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,624.77..104,726.25 rows=4 width=1,297) (actual time=245.907..432.911 rows=563 loops=5)

15. 3.190 2,152.760 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,624.49..104,724.86 rows=4 width=1,297) (actual time=245.901..430.552 rows=563 loops=5)

16. 5.155 2,141.125 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,624.20..104,722.16 rows=4 width=1,282) (actual time=245.895..428.225 rows=563 loops=5)

17. 3.030 2,124.710 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,623.92..104,720.87 rows=4 width=1,041) (actual time=245.882..424.942 rows=563 loops=5)

18. 3.760 2,110.420 ↓ 140.8 563 5

Nested Loop Left Join (cost=12,623.50..104,718.91 rows=4 width=1,041) (actual time=245.872..422.084 rows=563 loops=5)

19. 5.365 2,095.420 ↓ 140.5 562 5

Nested Loop Left Join (cost=12,623.08..104,716.97 rows=4 width=1,041) (actual time=245.861..419.084 rows=562 loops=5)

20. 2.425 2,081.625 ↓ 140.5 562 5

Nested Loop Left Join (cost=12,622.79..104,715.60 rows=4 width=345) (actual time=245.851..416.325 rows=562 loops=5)

21. 4.695 2,067.960 ↓ 140.5 562 5

Nested Loop (cost=12,622.37..104,681.85 rows=4 width=337) (actual time=245.838..413.592 rows=562 loops=5)

22. 679.975 2,057.645 ↓ 140.5 562 5

Nested Loop (cost=12,622.08..104,680.53 rows=4 width=322) (actual time=245.823..411.529 rows=562 loops=5)

  • Join Filter: (equipment.good_id = good.id)
  • Rows Removed by Join Filter: 669904
23. 5.720 5.720 ↑ 1.0 1,193 5

Index Scan using good_pkey on good (cost=0.28..156.61 rows=1,193 width=186) (actual time=0.013..1.144 rows=1,193 loops=5)

24. 144.050 1,371.950 ↓ 140.5 562 5,965

Materialize (cost=12,621.81..104,452.34 rows=4 width=140) (actual time=0.185..0.230 rows=562 loops=5,965)

25. 0.238 1,227.900 ↓ 140.5 562 1

Nested Loop (cost=12,621.81..104,452.32 rows=4 width=140) (actual time=1,102.937..1,227.900 rows=562 loops=1)

26. 7.024 1,225.976 ↓ 140.5 562 1

Hash Join (cost=12,621.39..104,450.40 rows=4 width=126) (actual time=1,102.909..1,225.976 rows=562 loops=1)

  • Hash Cond: ("*SELECT* 1".inspection_id = rent_account_task_good_inspection.id)
27. 4.314 1,006.115 ↑ 4.3 67,087 1

Append (cost=0.71..88,195.92 rows=287,822 width=24) (actual time=884.376..1,006.115 rows=67,087 loops=1)

28. 0.001 0.092 ↓ 0.0 0 1

Subquery Scan on *SELECT* 1 (cost=0.71..24.78 rows=1 width=24) (actual time=0.092..0.092 rows=0 loops=1)

29. 0.000 0.091 ↓ 0.0 0 1

Nested Loop (cost=0.71..24.77 rows=1 width=20) (actual time=0.091..0.091 rows=0 loops=1)

30. 0.091 0.091 ↓ 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.091..0.091 rows=0 loops=1)

  • Index Cond: (unique_equipment_id IS NOT NULL)
31. 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)
32. 68.168 1,001.709 ↑ 4.3 67,087 1

GroupAggregate (cost=78,097.41..85,292.94 rows=287,821 width=24) (actual time=884.283..1,001.709 rows=67,087 loops=1)

  • Group Key: ra.administrator_id, gi_1.id, eq_1.good_id
33. 260.346 933.541 ↑ 1.0 279,511 1

Sort (cost=78,097.41..78,816.96 rows=287,821 width=16) (actual time=884.275..933.541 rows=279,511 loops=1)

  • Sort Key: ra.administrator_id, gi_1.id, eq_1.good_id
  • Sort Method: external merge Disk: 7128kB
34. 154.876 673.195 ↑ 1.0 279,511 1

Hash Join (cost=24,817.19..47,078.51 rows=287,821 width=16) (actual time=282.676..673.195 rows=279,511 loops=1)

  • Hash Cond: (ae.equipment_id = eq_1.id)
35. 154.513 458.457 ↑ 1.0 279,511 1

Hash Join (cost=17,503.72..35,514.49 rows=287,821 width=12) (actual time=222.340..458.457 rows=279,511 loops=1)

  • Hash Cond: (ae.account_good_id = ag.id)
36. 82.024 82.024 ↓ 1.0 548,873 1

Seq Scan on rent_account_equipment ae (cost=0.00..8,455.41 rows=548,841 width=8) (actual time=0.009..82.024 rows=548,873 loops=1)

37. 16.890 221.920 ↑ 1.0 67,738 1

Hash (cost=16,325.64..16,325.64 rows=67,766 width=16) (actual time=221.920..221.920 rows=67,738 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 2625kB
38. 18.951 205.030 ↑ 1.0 67,738 1

Hash Join (cost=10,269.09..16,325.64 rows=67,766 width=16) (actual time=128.554..205.030 rows=67,738 loops=1)

  • Hash Cond: (ag.account_id = ra.id)
39. 42.523 177.976 ↑ 1.0 67,738 1

Hash Join (cost=9,259.78..15,138.41 rows=67,766 width=16) (actual time=120.344..177.976 rows=67,738 loops=1)

  • Hash Cond: (ag.id = tg.rag_id)
40. 15.516 15.516 ↓ 1.0 129,234 1

Seq Scan on rent_account_good ag (cost=0.00..3,747.22 rows=129,222 width=8) (actual time=0.008..15.516 rows=129,234 loops=1)

41. 16.084 119.937 ↑ 1.0 67,738 1

Hash (cost=8,412.70..8,412.70 rows=67,766 width=8) (actual time=119.937..119.937 rows=67,738 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3671kB
42. 58.942 103.853 ↑ 1.0 67,738 1

Hash Join (cost=2,566.50..8,412.70 rows=67,766 width=8) (actual time=26.939..103.853 rows=67,738 loops=1)

  • Hash Cond: (tg.ratg_id = gi_1.task_good_id)
43. 18.394 18.394 ↓ 1.0 211,667 1

Seq Scan on ratg_rag tg (cost=0.00..3,581.31 rows=211,631 width=8) (actual time=0.007..18.394 rows=211,667 loops=1)

44. 14.124 26.517 ↑ 1.0 67,089 1

Hash (cost=1,727.89..1,727.89 rows=67,089 width=8) (actual time=26.517..26.517 rows=67,089 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3645kB
45. 12.393 12.393 ↑ 1.0 67,089 1

Seq Scan on rent_account_task_good_inspection gi_1 (cost=0.00..1,727.89 rows=67,089 width=8) (actual time=0.006..12.393 rows=67,089 loops=1)

  • Filter: (task_good_id IS NOT NULL)
46. 3.852 8.103 ↑ 1.0 20,814 1

Hash (cost=749.14..749.14 rows=20,814 width=8) (actual time=8.103..8.103 rows=20,814 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1070kB
47. 4.251 4.251 ↑ 1.0 20,814 1

Seq Scan on rent_account ra (cost=0.00..749.14 rows=20,814 width=8) (actual time=0.004..4.251 rows=20,814 loops=1)

48. 31.113 59.862 ↑ 1.0 174,732 1

Hash (cost=4,446.32..4,446.32 rows=174,732 width=8) (actual time=59.862..59.862 rows=174,732 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2740kB
49. 28.749 28.749 ↑ 1.0 174,732 1

Seq Scan on equipment eq_1 (cost=0.00..4,446.32 rows=174,732 width=8) (actual time=0.014..28.749 rows=174,732 loops=1)

50. 0.220 212.837 ↓ 562.0 562 1

Hash (cost=12,620.66..12,620.66 rows=1 width=106) (actual time=212.837..212.837 rows=562 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 84kB
51. 88.314 212.617 ↓ 562.0 562 1

Seq Scan on rent_account_task_good_inspection (cost=10,389.60..12,620.66 rows=1 width=106) (actual time=145.914..212.617 rows=562 loops=1)

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

SubPlan (forSeq Scan)

53. 29.038 124.303 ↓ 2.0 67,086 1

Hash Join (cost=5,390.34..10,307.43 rows=32,868 width=4) (actual time=41.878..124.303 rows=67,086 loops=1)

  • Hash Cond: (rent_account_task_good_2.id = rent_account_task_good_inspection_2.task_good_id)
54. 38.070 71.558 ↑ 1.1 95,663 1

Hash Join (cost=2,656.12..6,468.51 rows=103,469 width=4) (actual time=17.761..71.558 rows=95,663 loops=1)

  • Hash Cond: (rent_account_task_good_2.task_id = rent_account_task_2.id)
55. 15.878 15.878 ↑ 1.0 211,030 1

Seq Scan on rent_account_task_good rent_account_task_good_2 (cost=0.00..3,257.96 rows=211,196 width=8) (actual time=0.010..15.878 rows=211,030 loops=1)

56. 4.782 17.610 ↓ 1.0 27,635 1

Hash (cost=2,311.06..2,311.06 rows=27,605 width=4) (actual time=17.609..17.610 rows=27,635 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1228kB
57. 12.828 12.828 ↓ 1.0 27,635 1

Seq Scan on rent_account_task rent_account_task_2 (cost=0.00..2,311.06 rows=27,605 width=4) (actual time=0.006..12.828 rows=27,635 loops=1)

  • Filter: (((status)::text <> 'not_done'::text) AND ((status)::text = 'completed'::text) AND ((type)::text = 'return'::text))
  • Rows Removed by Filter: 28712
58. 11.538 23.707 ↑ 1.0 67,089 1

Hash (cost=1,895.61..1,895.61 rows=67,089 width=8) (actual time=23.707..23.707 rows=67,089 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3645kB
59. 12.169 12.169 ↑ 1.0 67,089 1

Seq Scan on rent_account_task_good_inspection rent_account_task_good_inspection_2 (cost=0.00..1,895.61 rows=67,089 width=8) (actual time=0.005..12.169 rows=67,089 loops=1)

  • Filter: (task_good_id > 0)
60. 1.686 1.686 ↑ 1.0 1 562

Index Scan using equipment_pkey on equipment (cost=0.42..0.48 rows=1 width=22) (actual time=0.003..0.003 rows=1 loops=562)

  • Index Cond: (id = "*SELECT* 1".equipment_id)
61. 5.620 5.620 ↑ 1.0 1 2,810

Index Scan using subject_subject_pkey on subject_subject administrator (cost=0.29..0.33 rows=1 width=23) (actual time=0.002..0.002 rows=1 loops=2,810)

  • Index Cond: (id = "*SELECT* 1".administrator_id)
62. 11.240 11.240 ↑ 1.0 1 2,810

Index Scan using rent_account_task_good_pkey on rent_account_task_good (cost=0.42..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2,810)

  • Index Cond: (id = rent_account_task_good_inspection.task_good_id)
63. 8.430 8.430 ↑ 1.0 1 2,810

Index Scan using rent_account_task_pkey on rent_account_task (cost=0.29..0.34 rows=1 width=700) (actual time=0.003..0.003 rows=1 loops=2,810)

  • 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))
64. 11.240 11.240 ↑ 1.0 1 2,810

Index Scan using ratg_rag_ratg_id on ratg_rag (cost=0.42..0.48 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2,810)

  • Index Cond: (ratg_id = rent_account_task_good.id)
65. 11.260 11.260 ↑ 1.0 1 2,815

Index Scan using rent_account_good_pkey on rent_account_good (cost=0.42..0.49 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=2,815)

  • Index Cond: (id = ratg_rag.rag_id)
66. 11.260 11.260 ↑ 1.0 1 2,815

Index Scan using rent_account_pkey on rent_account (cost=0.29..0.32 rows=1 width=249) (actual time=0.004..0.004 rows=1 loops=2,815)

  • Index Cond: (id = rent_account_good.account_id)
67. 8.445 8.445 ↑ 1.0 1 2,815

Index Scan using subject_subject_pkey on subject_subject client (cost=0.29..0.68 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=2,815)

  • Index Cond: (id = rent_account.client_id)
68. 8.445 8.445 ↑ 1.0 1 2,815

Index Scan using subject_object_pkey on subject_object (cost=0.29..0.35 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=2,815)

  • Index Cond: (id = rent_account.object_id)
69. 8.445 8.445 ↑ 1.0 1 2,815

Index Scan using address_address_pkey on address_address (cost=0.29..0.34 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=2,815)

  • Index Cond: (id = subject_object.address_id)
70. 0.000 0.000 ↑ 2.5 6 2,815

Materialize (cost=0.00..1.22 rows=15 width=4) (actual time=0.000..0.000 rows=6 loops=2,815)

71. 0.014 0.014 ↑ 1.2 12 1

Seq Scan on address_country (cost=0.00..1.15 rows=15 width=4) (actual time=0.011..0.014 rows=12 loops=1)

72. 70.375 70.375 ↑ 1.0 1 2,815

Index Scan using translation_field_rid on translation_field (cost=0.29..1.06 rows=1 width=33) (actual time=0.007..0.025 rows=1 loops=2,815)

  • Index Cond: (rid = good.id)
  • Filter: (((tablename)::text = 'good'::text) AND ((fieldname)::text = 'title'::text) AND (language_id = 1))
  • Rows Removed by Filter: 51
73. 16.890 70.375 ↑ 1.0 1 2,815

Bitmap Heap Scan on translation_field address_country_aliased (cost=9.34..13.36 rows=1 width=4) (actual time=0.022..0.025 rows=1 loops=2,815)

  • 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
  • Heap Blocks: exact=12050
74. 8.445 53.485 ↓ 0.0 0 2,815

BitmapAnd (cost=9.34..9.34 rows=1 width=0) (actual time=0.019..0.019 rows=0 loops=2,815)

75. 19.705 19.705 ↓ 12.0 108 2,815

Bitmap Index Scan on translation_field_rid (cost=0.00..3.82 rows=9 width=0) (actual time=0.007..0.007 rows=108 loops=2,815)

  • Index Cond: (rid = address_country.id)
76. 25.335 25.335 ↑ 1.0 130 2,815

Bitmap Index Scan on translation_field_tablename (cost=0.00..5.26 rows=130 width=0) (actual time=0.009..0.009 rows=130 loops=2,815)

  • Index Cond: ((tablename)::text = 'address_country'::text)
77. 13.978 14.075 ↑ 2.0 101 2,815

Materialize (cost=0.00..20.97 rows=198 width=833) (actual time=0.000..0.005 rows=101 loops=2,815)

78. 0.097 0.097 ↑ 1.0 195 1

Seq Scan on auth_user task_user (cost=0.00..19.98 rows=198 width=833) (actual time=0.005..0.097 rows=195 loops=1)

79. 28.044 28.150 ↑ 1.0 198 2,815

Materialize (cost=0.00..20.97 rows=198 width=833) (actual time=0.000..0.010 rows=198 loops=2,815)

80. 0.106 0.106 ↑ 1.0 198 1

Seq Scan on auth_user inspection_user (cost=0.00..19.98 rows=198 width=833) (actual time=0.003..0.106 rows=198 loops=1)

81. 0.156 3.198 ↑ 1.0 1 78

Nested Loop Semi Join (cost=2.41..8.67 rows=1 width=4) (actual time=0.041..0.041 rows=1 loops=78)

82. 0.156 1.326 ↑ 1.0 1 78

Nested Loop (cost=1.00..1.20 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=78)

83. 0.312 0.936 ↑ 1.0 1 78

Nested Loop (cost=0.71..0.87 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=78)

84. 0.390 0.390 ↑ 1.0 1 78

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.005..0.005 rows=1 loops=78)

  • Index Cond: (id = "*SELECT* 1".inspection_id)
85. 0.234 0.234 ↑ 1.0 1 78

Index Scan using rent_account_task_good_pkey on rent_account_task_good rent_account_task_good_1 (cost=0.42..0.54 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=78)

  • Index Cond: (id = rent_account_task_good_inspection_1.task_good_id)
86. 0.234 0.234 ↑ 1.0 1 78

Index Only Scan using rent_account_task_pkey on rent_account_task rent_account_task_1 (cost=0.29..0.34 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=78)

  • Index Cond: (id = rent_account_task_good_1.task_id)
  • Heap Fetches: 78
87. 0.234 1.716 ↑ 6.0 1 78

Nested Loop Semi Join (cost=1.41..7.45 rows=6 width=4) (actual time=0.022..0.022 rows=1 loops=78)

88. 0.156 1.170 ↑ 6.0 1 78

Nested Loop (cost=1.12..5.43 rows=6 width=8) (actual time=0.015..0.015 rows=1 loops=78)

89. 0.234 0.858 ↑ 6.0 1 78

Nested Loop (cost=0.84..3.49 rows=6 width=8) (actual time=0.011..0.011 rows=1 loops=78)

90. 0.390 0.390 ↑ 6.0 1 78

Index Scan using ratg_rag_task_id on ratg_rag ratg_rag_1 (cost=0.42..0.56 rows=6 width=8) (actual time=0.005..0.005 rows=1 loops=78)

  • Index Cond: (task_id = rent_account_task_good_1.task_id)
91. 0.234 0.234 ↑ 1.0 1 78

Index Scan using rent_account_good_pkey on rent_account_good rent_account_good_1 (cost=0.42..0.49 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=78)

  • Index Cond: (id = ratg_rag_1.rag_id)
92. 0.156 0.156 ↑ 1.0 1 78

Index Scan using rent_account_pkey on rent_account rent_account_1 (cost=0.29..0.32 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=78)

  • Index Cond: (id = rent_account_good_1.account_id)
93. 0.312 0.312 ↑ 1.0 1 78

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

  • Index Cond: (subject_id = rent_account_1.client_id)
  • Filter: (administrator_subject_id = 14)
Planning time : 16.021 ms
Execution time : 2,469.077 ms